Campaign Files
The import template below is found in the Global Templates section in the Import + Export feature. These templates are to be used as a starting point for building the final imports. Partners may want to add or remove the already mapped fields based on the need for them. Each template may require additional set up which are noted in the notes section in the tables below.
Student Journey Responder
74 rows
| Name | Calculated Field? | Element451 Slug Name | Notes | Row |
|---|---|---|---|---|
| latest_sj_survey_when_plan_to_apply | No | This question is “When do you think you will apply”. If you choose to map this field into your instance, here are the options that EAB could send: Options next term future term this year future term next year not sure | 19 | |
| latest_sj_survey_response_date | No | 28 | ||
| eab_mailing_zip5 | No | user-address-home-zip | 10 | |
| partner_sis_student_id | No | user-identities-schoolid | 36 | |
| highest_lsat_score | No | 47 | ||
| latest_any_sj_form_preferred_program | No | 20 | ||
| eab_mailing_addr_1 | No | user-address-home-street1 | 6 | |
| suppress_email_category | No | 59 | ||
| latest_appily_area_study | No | EAB Value - Area of Study AGRICULTURAL/ANIMAL/PLANT/VETERINARY SCIENCE AND RELATED FIELDS NATURAL RESOURCES AND CONSERVATION ARCHITECTURE AND RELATED SERVICES AREA, ETHNIC, CULTURAL, GENDER, AND GROUP STUDIES COMMUNICATION, JOURNALISM, AND RELATED PROGRAMS COMMUNICATIONS TECHNOLOGIES/TECHNICIANS AND SUPPORT SERVICES COMPUTER AND INFORMATION SCIENCES AND SUPPORT SERVICES CULINARY, ENTERTAINMENT, AND PERSONAL SERVICES EDUCATION ENGINEERING ENGINEERING/ENGINEERING-RELATED TECHNOLOGIES/TECHNICIANS FOREIGN LANGUAGES, LITERATURES, AND LINGUISTICS FAMILY AND CONSUMER SCIENCES/HUMAN SCIENCES RESERVED LEGAL PROFESSIONS AND STUDIES ENGLISH LANGUAGE AND LITERATURE/LETTERS LIBERAL ARTS AND SCIENCES, GENERAL STUDIES AND HUMANITIES LIBRARY SCIENCE BIOLOGICAL AND BIOMEDICAL SCIENCES MATHEMATICS AND STATISTICS MILITARY SCIENCE, LEADERSHIP AND OPERATIONAL ART MILITARY TECHNOLOGIES AND APPLIED SCIENCES MULTI/INTERDISCIPLINARY STUDIES PARKS, RECREATION, LEISURE, FITNESS, AND KINESIOLOGY BASIC SKILLS AND DEVELOPMENTAL/REMEDIAL EDUCATION CITIZENSHIP ACTIVITIES HEALTH-RELATED KNOWLEDGE AND SKILLS INTERPERSONAL AND SOCIAL SKILLS LEISURE AND RECREATIONAL ACTIVITIES PERSONAL AWARENESS AND SELF-IMPROVEMENT PHILOSOPHY AND RELIGIOUS STUDIES THEOLOGY AND RELIGIOUS VOCATIONS PHYSICAL SCIENCES SCIENCE TECHNOLOGIES/TECHNICIANS PSYCHOLOGY HOMELAND SECURITY, LAW ENFORCEMENT, FIREFIGHTING AND RELATED PROTECTIVE SERVICES PUBLIC ADMINISTRATION AND SOCIAL SERVICE PROFESSIONS SOCIAL SCIENCES CONSTRUCTION TRADES MECHANIC AND REPAIR TECHNOLOGIES/TECHNICIANS PRECISION PRODUCTION TRANSPORTATION AND MATERIALS MOVING VISUAL AND PERFORMING ARTS HEALTH PROFESSIONS AND RELATED PROGRAMS BUSINESS, MANAGEMENT, MARKETING, AND RELATED SUPPORT SERVICES HIGH SCHOOL/SECONDARY DIPLOMAS AND CERTIFICATES HISTORY RESERVED HEALTH PROFESSIONS RESIDENCY/FELLOWSHIP PROGRAMS MEDICAL RESIDENCY/FELLOWSHIP PROGRAMS | 56 | |
| partner_crm_student_id | No | 35 | ||
| first_name | No | user-first-name | 3 | |
| Race | Yes | user-race-categories | For this formula, simply insert your race codes when prompted through out the formula. EAB sends the race in separate columns so this formula glues all the columns together. CONCAT( IF([C39]="American Indian/Alaska Native","insert race code", IF([C39]="Asian","insert race code", IF([C39]="Black/African American","insert race code", IF([C39]="Middle Eastern","insert race code", IF([C39]="Multiracial","insert race code", IF([C39]="Native Hawaiian/Pacific Islander","insert race code", IF([C39]="Other","insert race code", IF([C39]="Prefer Not to Respond","insert race code", IF([C39]="Unknown","insert race code", IF([C39]="Unmapped Value","insert race code", IF([C39]="White","insert race code",""))))))))))), ",", IF([C40]="American Indian/Alaska Native","insert race code", IF([C40]="Asian","insert race code", IF([C40]="Black/African American","insert race code", IF([C40]="Middle Eastern","insert race code", IF([C40]="Multiracial","insert race code", IF([C40]="Native Hawaiian/Pacific Islander","insert race code", IF([C40]="Other","insert race code", IF([C40]="Prefer Not to Respond","insert race code", IF([C40]="Unknown","insert race code", IF([C40]="Unmapped Value","insert race code", IF([C40]="White","insert race code",""))))))))))), ",", IF([C41]="American Indian/Alaska Native","insert race code", IF([C41]="Asian","insert race code", IF([C41]="Black/African American","insert race code", IF([C41]="Middle Eastern","insert race code", IF([C41]="Multiracial","insert race code", IF([C41]="Native Hawaiian/Pacific Islander","insert race code", IF([C41]="Other","insert race code", IF([C41]="Prefer Not to Respond","insert race code", IF([C41]="Unknown","insert race code", IF([C41]="Unmapped Value","insert race code", IF([C41]="White","insert race code",""))))))))))), ",", IF([C42]="American Indian/Alaska Native","insert race code", IF([C42]="Asian","insert race code", IF([C42]="Black/African American","insert race code", IF([C42]="Middle Eastern","insert race code", IF([C42]="Multiracial","insert race code", IF([C42]="Native Hawaiian/Pacific Islander","insert race code", IF([C42]="Other","insert race code", IF([C42]="Prefer Not to Respond","insert race code", IF([C42]="Unknown","insert race code", IF([C42]="Unmapped Value","insert race code", IF([C42]="White","insert race code",""))))))))))), ",", IF([C43]="American Indian/Alaska Native","insert race code", IF([C43]="Asian","insert race code", IF([C43]="Black/African American","insert race code", IF([C43]="Middle Eastern","insert race code", IF([C43]="Multiracial","insert race code", IF([C43]="Native Hawaiian/Pacific Islander","insert race code", IF([C43]="Other","insert race code", IF([C43]="Prefer Not to Respond","insert race code", IF([C43]="Unknown","insert race code", IF([C43]="Unmapped Value","insert race code", IF([C43]="White","insert race code","")))))))))))) | 74 |
| first_sj_engagement_date | No | 27 | ||
| latest_any_sj_form_preferred_contact_method | No | The values for this field are: Value Phone Text Message Email | 26 | |
| latest_appily_modality | No | EAB Value - Area of Study In-Person Online Hybrid Part-Time Full-Time | 57 | |
| eab_mailing_zip4 | No | 11 | ||
| college_grad_year | No | 45 | ||
| latest_any_sj_form_degree_why | No | This question is “Why are you considering a degree?”. If you choose to map this field into your instance, here are the options that EAB could send: Options Advance my career Change my career Change the world Enhance my current skill set Earn a higher salary Finish what I started Achieve a personal/academic goal Apply legal knowledge to other industries Secure a well-paying position in my field Other | 21 | |
| latest_sj_survey_latest_poc_opt_in_ind | No | This is Permission to Contact. The value that comes over will be Y | 25 | |
| eab_mailing_city | No | user-address-home-city | 8 | |
| student_cappex_id | No | 37 | ||
| latest_list_source_modality_of_interest | No | EAB Value - Modality Online Hybrid In Person Unknown | 50 | |
| latest_sj_olg_response_date | No | 66 | ||
| latest_sj_not_ready_response_date | No | 65 | ||
| gmat_score_range | No | 48 | ||
| eab_race_list | No | 58 | ||
| middle_name | No | user-middle-name | 4 | |
| last_name | No | user-last-name | 5 | |
| contact_key | No | user-identities-eabid | 2 | |
| mobile_phone_number | No | user-phone-cell-number | 16 | |
| latest_list_source_program_of_interest | No | 49 | ||
| eab_race_4 | No | This field is addressed as a calculated field at the bottom of the template. EAB Value - Race American Indian/Alaska Native Asian Black/African American Multiracial Native Hawaiian/Pacific Islander Prefer Not to Respond Unknown Unmapped Value White | 42 | |
| eab_race_2 | No | This field is addressed as a calculated field at the bottom of the template. EAB Value - Race American Indian/Alaska Native Asian Black/African American Multiracial Native Hawaiian/Pacific Islander Prefer Not to Respond Unknown Unmapped Value White | 40 | |
| latest_sj_deadline_response_date | No | 63 | ||
| utcnow() | No | 31 | ||
| latest_sj_survey_top_factor | No | This question is “What’s most important to you in a degree program?”. If you choose to map this field into your instance, here are the options that EAB could send: Options Alumni network Emphasis on social justice Faculty and class size Job opportunities Reputation and academic rigor Scholarship availability | 23 | |
| email_address | No | user-email-address | 15 | |
| latest_appily_anticipated_program_start | No | EAB Value - Program Start Within 3 months 3-6 months 6-12 months At least 1 year Unsure | 54 | |
| birth_date | No | user-dob | 14 | |
| student_lsac_id | No | 34 | ||
| dnc_email_dt | No | 32 | ||
| gender | No | Gender is not mapped in the chance you need to build a calculated field for it or use a Regular Data Source rather than the System Data Source. EAB has 4 responses for this field: Male, Female, Unknown, Non-Binary or Another Gender. You can either map to your gender field and add the necessary transformations to line up to your options or use a calculated field. Below is an example of what the calculated field could look like: IF([C13]="Male","insert code for male", IF([C13]="Female","insert code for female", IF([C13]="Unknown","insert code for unknown or leave it blank", IF([C13]="Non-Binary or Another Gender","insert code for non-binary or another gender", "")))) | 13 | |
| latest_sj_content_give_channel | No | 62 | ||
| home_phone_number | No | user-phone-home-number | 53 | |
| eab_mailing_state | No | user-address-home-state | 9 | |
| eab_mailing_addr_2 | No | user-address-home-street2 | 7 | |
| latest_apply_program_format | No | 67 | ||
| latest_sj_inquiry_response_date | No | 64 | ||
| current_college_ceeb | No | 44 | ||
| latest_any_sj_form_marketing_consent_ind | No | Values for GDPR Marketing Consent are Y or N | 71 | |
| eab_race_5 | No | This field is addressed as a calculated field at the bottom of the template. EAB Value - Race American Indian/Alaska Native Asian Black/African American Multiracial Native Hawaiian/Pacific Islander Prefer Not to Respond Unknown Unmapped Value White | 43 | |
| latest_apply_channel | No | 60 | ||
| latest_sj_survey_decision_stage | No | This question is “Where are you in your decision making process?”. If you choose to map this field into your instance, here are the options that EAB could send: Options I've done my research, and I'm ready to apply. I am likely to apply to a program, but I'm still considering. I would like to earn my degree, but I don't know when I'll be ready. I would like to earn my degree, but I doubt it will ever be possible. | 24 | |
| latest_apply_date | No | 30 | ||
| latest_any_sj_form_campus_location_list | No | 69 | ||
| latest_work_experience | No | 51 | ||
| latest_sj_survey_channel | No | 61 | ||
| Hispanic Y/N | Yes | user-race-hispanic | This formula takes the data coming in from the Ethnicity field and translates it to the valid TRUE/FALSE values user-race-hispanic accepts. IF([C38]="Hispanic or Latino/a/e/x","TRUE", IF([C38]="Not Hispanic or Latino/a/e/x","FALSE","")) | 73 |
| primary_student_id | No | 1 | ||
| optin_sms_ind | No | user-sms-updates | 17 | |
| college_gpa | No | 46 | ||
| latest_appily_area_interest | No | EAB Value - Area of Interest Allied Health Diagnostic Services Health IT Health Services Management Mental or Social Health Public Health Research Executive & Leadership Finance, Accounting, and Economics Entrepreneurship Marketing and Creative IT and Analytics Operations, Project Management, & HR Classroom Instruction Special Education School Leadership and Administration Student Support and Guidance Curriculum Development and Instructional Design Education Policy, Research, and Consulting Nursing | 55 | |
| latest_any_sj_form_intended_entry_term | No | 70 | ||
| eab_race_1 | No | This field is addressed as a calculated field at the bottom of the template. EAB Value - Race American Indian/Alaska Native Asian Black/African American Multiracial Native Hawaiian/Pacific Islander Prefer Not to Respond Unknown Unmapped Value White | 39 | |
| latest_any_sj_form_area_interest | No | 68 | ||
| first_sj_contacted_date | No | 33 | ||
| eab_mailing_country | No | user-address-home-country | 12 | |
| original_source_type_label | No | If you are intended to map this field somewhere, the values below are: Value EAB Web form .EDU Web form GRE GMAT PCAT LSAT MCAT PTK CBSS Consumer Database Facebook Facebook (In Platform) LinkedIn LinkedIn (In Platform) Paid Search TOEFL Suspects Appily Advance Cappex Inquiry Cappex Candidate YouVisit Unknown Other Partner | 18 | |
| latest_sj_survey_obstacle | No | This question is “What’s your biggest obstacle to earning a degree?”. If you choose to map this field into your instance, here are the options that EAB could send: Options balancing school and family balancing school and work balancing school and other commitments earn a higher salary enhance my current skill set finances program prerequisites program uncertainty | 22 | |
| eab_race_3 | No | This field is addressed as a calculated field at the bottom of the template. EAB Value - Race American Indian/Alaska Native Asian Black/African American Multiracial Native Hawaiian/Pacific Islander Prefer Not to Respond Unknown Unmapped Value White | 41 | |
| latest_desired_degree_level | No | EAB Value - Area of Study Associates Bachelors Masters PhD Certificate Professional Licensure | 52 | |
| latest_any_sj_form_preferred_modality | No | 72 | ||
| latest_sj_content_give_response_date | No | 29 | ||
| ethnicity | No | This field is addressed as a calculated field at the bottom of the template. EAB Value - Ethnicity Hispanic or Latino/a/e/x Not Hispanic or Latino/a/e/x Prefer Not to Respond Unknown | 38 |
Was this page helpful?