Element451Integrations Guide

Campaign Files

Updated Article

The import templates below are 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.

Cultivate

New database
67 rows
New database
NameElement451 Slug NameNotesRow
contact_keyuser-identities-eab1
partner_id2
contact_typeuser-profile-type3
source_type_label4
first_nameuser-first-name5
middle_nameuser-middle-name6
last_nameuser-last-name7
addr1user-address-home-street18
addr2user-address-home-street29
cityuser-address-home-city10
state11
zip5user-address-home-zip12
foreign_postal_code13
countryuser-address-home-country14
birth_dateuser-dob15
gender16
ethnicity17
race_118
race_219
race_320
race_421
race_522
emailuser-email-address23
phoneuser-phone-home-number24
mobileuser-phone-cell-number25
sms_opt_in_calc26
hs_ceebuser-education-highschools-ceeb27
hs_nameuser-education-highschools-name28
hs_address_1user-education-highschools-street129
hs_address_2user-education-highschools-street230
hs_cityuser-education-highschools-city31
hs_state32
hs_foreign_domestic33
hs_zipuser-education-highschools-zipcode34
current_grade_level35
grad_yearuser-education-highschools-graduate-date36
major137
major238
activity_1user-activities-1-name39
activity_2user-activities-2-name40
activity_3user-activities-3-name41
activity_4user-activities-4-name42
activity_5user-activities-5-name43
activity_6user-activities-6-name44
parent1_titleuser-family-guardian-1-prefix-name45
parent1_relationship46
parent1_first_nameuser-family-guardian-1-first-name47
parent1_last_nameuser-family-guardian-1-last-name48
parent1_emailuser-family-guardian-email-149
first_cultivate_contact_dt50
first_cultivate_ig_student_paper_engagement_date51
first_cultivate_ig_email_engagement_date52
first_cultivate_ig_student_sms_engagement_date53
first_cultivate_ig_email_jr_reengagement_date54
optout_email_dtuser-milestones-unsubscribe-email-date55
create_dt56
Calculated Fielduser-sources-source-codeEAB Offers Sources on Column 4, Source Type Label. To utilize those sources, use the following formula with your source taxonomy codes: IF([C4]="SAT (College Board)","insert Element451 taxonomy code here", IF([C4]="PSAT (College Board)","insert Element451 taxonomy code here", IF([C4]="AP (College Board)","insert Element451 taxonomy code here", IF([C4]="GPA-Only (College Board)","insert Element451 taxonomy code here", IF([C4]="Non-Assessment (College Board)","insert Element451 taxonomy code here", IF([C4]="Other (College Board)","insert Element451 taxonomy code here", IF([C4]="ACT-EOS (Encoura)","insert Element451 taxonomy code here", IF([C4]="PreACT (Encoura)","insert Element451 taxonomy code here", IF([C4]="NRCCUA (Encoura)","insert Element451 taxonomy code here", IF([C4]="GPA-Only (Encoura)","insert Element451 taxonomy code here", IF([C4]="Other (Encoura)","insert Element451 taxonomy code here", IF([C4]="CBSS","insert Element451 taxonomy code here", IF([C4]="Christian Connector","insert Element451 taxonomy code here", IF([C4]="YouVisit Inquiry","insert Element451 taxonomy code here", IF([C4]="Partner","insert Element451 taxonomy code here", IF([C4]="Partner (Relationship)","insert Element451 taxonomy code here", IF([C4]="Consumer Database","insert Element451 taxonomy code here", IF([C4]="EAB Form","insert Element451 taxonomy code here", IF([C4]="EAB Form (Relationship)","insert Element451 taxonomy code here", IF([C4]="Cappex Inquiry","insert Element451 taxonomy code here", IF([C4]="Cappex Inquiry (External)","insert Element451 taxonomy code here", IF([C4]="Cappex Candidate","insert Element451 taxonomy code here", IF([C4]="Cappex Candidate (External)","insert Element451 taxonomy code here", IF([C4]="Prospect (Common App)","insert Element451 taxonomy code here", IF([C4]="Suspect (Common App)","insert Element451 taxonomy code here", IF([C4]="EAB Application","insert Element451 taxonomy code here", IF([C4]="EAB Application (Relationship)","insert Element451 taxonomy code here",""))))))))))))))))))))))))))) Taxonomy codes are found under Contacts>Categories>Source Codes.You can also just insert a generic EAB source code if you wish to not be as granular as the above formula. If everyone is getting the same generic source code, insert the taxonomy code from Element451 inside a set of quotations, “example.taxonomy.451”.57
Calculated Fielduser-sources-source-code-dateIn this formula, you may use the created date found in Column 56, created date, or you can use a formula to default to the time the import is ran. To use the created date, use the following formula: DATE_READ([C56],"m/d/Y") To default the source date to the date you run the import, use the following formula: DATE_DEFAULT("Y-m-d\TH:i:sP")58
Calculated Fielduser-address-home-stateNo additional set up by the user is required. This formula checks if the home address country is the United States, if it is, it pulls in the state information into the Home Address State in Element451.59
Calculated Fielduser-address-home-provinceNo additional set up by the user is required. This formula checks if the home address country is the United States, if it is NOT, it pulls in the state information into the Home Address Province in Element451.60
Calculated Fielduser-genderEAB provides Gender on Column 16. The values they provide may not line up with the codes and names used by your institution. To complete set up, please insert the codes of the genders used in the Element451 instance in the formula. IF([C16]="Male","insert gender code", IF([C16]="Female","insert gender code", IF([C16]="Unknown","insert gender code", IF([C16]="Non-Binary or Another Gender","insert gender code","")))) If there is a gender that you don’t want mapped in, rather than placing a gender code, you would leave the quotations empty, for example, “”.61
Calculated Fielduser-race-hispanicNo additional set up by the user is required. This formula will return TRUE if Column 17, Ethnicity, has the value Hispanic or Latino/a/e/x and will return FALSE if the value is Not Hispanic or Latino/a/e/x.62
Calculated Fielduser-race-categoriesEAB sends race in separate fields when Element451 uses one field. This formula translates the incoming race values to the race values used in Element451 and combines all the columns into one string. You will need to insert the race codes used in your Element451 system to make sure the values get translated correctly. CONCAT( IF([C18]="American Indian/Alaska Native","insert race code", IF([C18]="Asian","insert race code", IF([C18]="Black/African American","insert race code", IF([C18]="Middle Eastern","insert race code", IF([C18]="Multiracial","insert race code", IF([C18]="Native Hawaiian/Pacific Islander","insert race code", IF([C18]="Other","insert race code", IF([C18]="Prefer Not to Respond","insert race code", IF([C18]="Unknown","insert race code", IF([C18]="Unmapped Value","insert race code", IF([C18]="White","insert race code",""))))))))))), ",", IF([C19]="American Indian/Alaska Native","insert race code", IF([C19]="Asian","insert race code", IF([C19]="Black/African American","insert race code", IF([C19]="Middle Eastern","insert race code", IF([C19]="Multiracial","insert race code", IF([C19]="Native Hawaiian/Pacific Islander","insert race code", IF([C19]="Other","insert race code", IF([C19]="Prefer Not to Respond","insert race code", IF([C19]="Unknown","insert race code", IF([C19]="Unmapped Value","insert race code", IF([C19]="White","insert race code",""))))))))))), ",", IF([C20]="American Indian/Alaska Native","insert race code", IF([C20]="Asian","insert race code", IF([C20]="Black/African American","insert race code", IF([C20]="Middle Eastern","insert race code", IF([C20]="Multiracial","insert race code", IF([C20]="Native Hawaiian/Pacific Islander","insert race code", IF([C20]="Other","insert race code", IF([C20]="Prefer Not to Respond","insert race code", IF([C20]="Unknown","insert race code", IF([C20]="Unmapped Value","insert race code", IF([C20]="White","insert race code",""))))))))))), ",", IF([C21]="American Indian/Alaska Native","insert race code", IF([C21]="Asian","insert race code", IF([C21]="Black/African American","insert race code", IF([C21]="Middle Eastern","insert race code", IF([C21]="Multiracial","insert race code", IF([C21]="Native Hawaiian/Pacific Islander","insert race code", IF([C21]="Other","insert race code", IF([C21]="Prefer Not to Respond","insert race code", IF([C21]="Unknown","insert race code", IF([C21]="Unmapped Value","insert race code", IF([C21]="White","insert race code",""))))))))))), ",", IF([C22]="American Indian/Alaska Native","insert race code", IF([C22]="Asian","insert race code", IF([C22]="Black/African American","insert race code", IF([C22]="Middle Eastern","insert race code", IF([C22]="Multiracial","insert race code", IF([C22]="Native Hawaiian/Pacific Islander","insert race code", IF([C22]="Other","insert race code", IF([C22]="Prefer Not to Respond","insert race code", IF([C22]="Unknown","insert race code", IF([C22]="Unmapped Value","insert race code", IF([C22]="White","insert race code",""))))))))))))63
Calculated Fielduser-education-highschools-stateNo additional set up by the user is required. This formula checks if the school address country is the United States, if it is, it pulls in the state information into the High School Address State in Element451.64
Calculated Fielduser-education-highschools-provinceNo additional set up by the user is required. This formula checks if the school address country is the United States, if it is NOT, it pulls in the state information into the High School Address Province in Element451.65
Calculated Fielduser-education-highschools-countryNo additional set up by the user is required. This formula looks at Column 33, High School Foreign Domestic. If the value is D, for domestic, the high school country is set to USA.66
Calculated Fielduser-education-preferred-majorFor intended major, we recommend creating a data source where column_1 is the EAB major name and column_2 is the major codes used on the Element451 major data source. The formula used is below: DB_MAP("major",DS_MAP([C37],"insert EAB regular data source id","column_1","column_2","insert undecided SIS code"),"code","guid","insert undecided guid code") The data source ID is found in the url of that data source. You will also need to include a fall back major if there isn’t a match, schools commonly fall back to the undecided major.67

Apply

New database
67 rows
New database
NameElement451 Slug NameNotesRow
contact_keyuser-identities-eab1
partner_id2
contact_typeuser-profile-type3
source_type_label4
first_nameuser-first-name5
middle_nameuser-middle-name6
last_nameuser-last-name7
addr1user-address-home-street18
addr2user-address-home-street29
cityuser-address-home-city10
state11
zip5user-address-home-zip12
foreign_postal_code13
countryuser-address-home-country14
birth_dateuser-dob15
gender16
ethnicity17
race_118
race_219
race_320
race_421
race_522
emailuser-email-address23
phoneuser-phone-home-number24
mobileuser-phone-cell-number25
sms_opt_in_calc26
hs_ceebuser-education-highschools-ceeb27
hs_nameuser-education-highschools-name28
hs_address_1user-education-highschools-street129
hs_address_2user-education-highschools-street230
hs_cityuser-education-highschools-city31
hs_state32
hs_foreign_domestic33
hs_zipuser-education-highschools-zipcode34
current_grade_level35
grad_yearuser-education-highschools-graduate-date36
major137
major238
activity_1user-activities-1-name39
activity_2user-activities-2-name40
activity_3user-activities-3-name41
activity_4user-activities-4-name42
activity_5user-activities-5-name43
activity_6user-activities-6-name44
parent1_titleuser-family-guardian-1-prefix-name45
parent1_relationship46
parent1_first_nameuser-family-guardian-1-first-name47
parent1_last_nameuser-family-guardian-1-last-name48
parent1_emailuser-family-guardian-email-149
first_apply_contact_date50
first_apply_email_engagement_date51
first_apply_paper_engagement_date52
first_apply_sms_engagement_date53
optout_email_dtuser-milestones-unsubscribe-email-date54
create_dt55
Calculated Fielduser-sources-source-codeEAB Offers Sources on Column 4, Source Type Label. To utilize those sources, use the following formula with your source taxonomy codes: IF([C4]="SAT (College Board)","insert Element451 taxonomy code here", IF([C4]="PSAT (College Board)","insert Element451 taxonomy code here", IF([C4]="AP (College Board)","insert Element451 taxonomy code here", IF([C4]="GPA-Only (College Board)","insert Element451 taxonomy code here", IF([C4]="Non-Assessment (College Board)","insert Element451 taxonomy code here", IF([C4]="Other (College Board)","insert Element451 taxonomy code here", IF([C4]="ACT-EOS (Encoura)","insert Element451 taxonomy code here", IF([C4]="PreACT (Encoura)","insert Element451 taxonomy code here", IF([C4]="NRCCUA (Encoura)","insert Element451 taxonomy code here", IF([C4]="GPA-Only (Encoura)","insert Element451 taxonomy code here", IF([C4]="Other (Encoura)","insert Element451 taxonomy code here", IF([C4]="CBSS","insert Element451 taxonomy code here", IF([C4]="Christian Connector","insert Element451 taxonomy code here", IF([C4]="YouVisit Inquiry","insert Element451 taxonomy code here", IF([C4]="Partner","insert Element451 taxonomy code here", IF([C4]="Partner (Relationship)","insert Element451 taxonomy code here", IF([C4]="Consumer Database","insert Element451 taxonomy code here", IF([C4]="EAB Form","insert Element451 taxonomy code here", IF([C4]="EAB Form (Relationship)","insert Element451 taxonomy code here", IF([C4]="Cappex Inquiry","insert Element451 taxonomy code here", IF([C4]="Cappex Inquiry (External)","insert Element451 taxonomy code here", IF([C4]="Cappex Candidate","insert Element451 taxonomy code here", IF([C4]="Cappex Candidate (External)","insert Element451 taxonomy code here", IF([C4]="Prospect (Common App)","insert Element451 taxonomy code here", IF([C4]="Suspect (Common App)","insert Element451 taxonomy code here", IF([C4]="EAB Application","insert Element451 taxonomy code here", IF([C4]="EAB Application (Relationship)","insert Element451 taxonomy code here",""))))))))))))))))))))))))))) Taxonomy codes are found under Contacts>Categories>Source Codes. You can also just insert a generic EAB source code if you wish to not be as granular as the above formula. If everyone is getting the same generic source code, insert the taxonomy code from Element451 inside a set of quotations, “example.taxonomy.451”.56
Calculated Fielduser-sources-source-code-dateIn this formula, you may use the created date found in Column 56, created date, or you can use a formula to default to the time the import is ran. To use the created date, use the following formula: DATE_READ([C56],"m/d/Y") To default the source date to the date you run the import, use the following formula: DATE_DEFAULT("Y-m-d\TH:i:sP")57
Calculated Fielduser-addresses-home-stateNo additional set up by the user is required. This formula checks if the home address country is the United States, if it is, it pulls in the state information into the Home Address State in Element451.58
Calculated Fielduser-addresses-home-provinceNo additional set up by the user is required. This formula checks if the home address country is the United States, if it is NOT, it pulls in the state information into the Home Address Province in Element451.59
Calculated Fielduser-genderEAB provides Gender on Column 16. The values they provide may not line up with the codes and names used by your institution. To complete set up, please insert the codes of the genders used in the Element451 instance in the formula. IF([C16]="Male","insert gender code", IF([C16]="Female","insert gender code", IF([C16]="Unknown","insert gender code", IF([C16]="Non-Binary or Another Gender","insert gender code","")))) If there is a gender that you don’t want mapped in, rather than placing a gender code, you would leave the quotations empty, for example, “”.60
Calculated Fielduser-race-hispanicNo additional set up by the user is required. This formula will return TRUE if Column 17, Ethnicity, has the value Hispanic or Latino/a/e/x and will return FALSE if the value is Not Hispanic or Latino/a/e/x.61
Calculated Fielduser-race-categoriesEAB sends race in separate fields when Element451 uses one field. This formula translates the incoming race values to the race values used in Element451 and combines all the columns into one string. You will need to insert the race codes used in your Element451 system to make sure the values get translated correctly. CONCAT( IF([C18]="American Indian/Alaska Native","insert race code", IF([C18]="Asian","insert race code", IF([C18]="Black/African American","insert race code", IF([C18]="Middle Eastern","insert race code", IF([C18]="Multiracial","insert race code", IF([C18]="Native Hawaiian/Pacific Islander","insert race code", IF([C18]="Other","insert race code", IF([C18]="Prefer Not to Respond","insert race code", IF([C18]="Unknown","insert race code", IF([C18]="Unmapped Value","insert race code", IF([C18]="White","insert race code",""))))))))))), ",", IF([C19]="American Indian/Alaska Native","insert race code", IF([C19]="Asian","insert race code", IF([C19]="Black/African American","insert race code", IF([C19]="Middle Eastern","insert race code", IF([C19]="Multiracial","insert race code", IF([C19]="Native Hawaiian/Pacific Islander","insert race code", IF([C19]="Other","insert race code", IF([C19]="Prefer Not to Respond","insert race code", IF([C19]="Unknown","insert race code", IF([C19]="Unmapped Value","insert race code", IF([C19]="White","insert race code",""))))))))))), ",", IF([C20]="American Indian/Alaska Native","insert race code", IF([C20]="Asian","insert race code", IF([C20]="Black/African American","insert race code", IF([C20]="Middle Eastern","insert race code", IF([C20]="Multiracial","insert race code", IF([C20]="Native Hawaiian/Pacific Islander","insert race code", IF([C20]="Other","insert race code", IF([C20]="Prefer Not to Respond","insert race code", IF([C20]="Unknown","insert race code", IF([C20]="Unmapped Value","insert race code", IF([C20]="White","insert race code",""))))))))))), ",", IF([C21]="American Indian/Alaska Native","insert race code", IF([C21]="Asian","insert race code", IF([C21]="Black/African American","insert race code", IF([C21]="Middle Eastern","insert race code", IF([C21]="Multiracial","insert race code", IF([C21]="Native Hawaiian/Pacific Islander","insert race code", IF([C21]="Other","insert race code", IF([C21]="Prefer Not to Respond","insert race code", IF([C21]="Unknown","insert race code", IF([C21]="Unmapped Value","insert race code", IF([C21]="White","insert race code",""))))))))))), ",", IF([C22]="American Indian/Alaska Native","insert race code", IF([C22]="Asian","insert race code", IF([C22]="Black/African American","insert race code", IF([C22]="Middle Eastern","insert race code", IF([C22]="Multiracial","insert race code", IF([C22]="Native Hawaiian/Pacific Islander","insert race code", IF([C22]="Other","insert race code", IF([C22]="Prefer Not to Respond","insert race code", IF([C22]="Unknown","insert race code", IF([C22]="Unmapped Value","insert race code", IF([C22]="White","insert race code",""))))))))))))62
Calculated Fielduser-education-highschools-stateNo additional set up by the user is required. This formula checks if the school address country is the United States, if it is, it pulls in the state information into the High School Address State in Element451.63
Calculated Fielduser-education-highschools-provinceNo additional set up by the user is required. This formula checks if the school address country is the United States, if it is NOT, it pulls in the state information into the High School Address Province in Element451.64
Calculated Fielduser-education-highschools-countryNo additional set up by the user is required. This formula looks at Column 33, High School Foreign Domestic. If the value is D, for domestic, the high school country is set to USA.65
Calculated Fielduser-applications-majorThis is an optional field, if you do not want to create an application on import, delete this field.66
Calculated Fielduser-applications-major-secondThis is an optional field, if you do not want to create an application on import, delete this field.67

Yield

New database
104 rows
New database
NameElement451 Slug NameNotesRow
contact_keyuser-identities-eab1
partner_id2
application_ID3
fin_aid_student_ID4
first_nameuser-first-name5
middle_nameuser-middle-name6
last_nameuser-last-name7
addr1user-address-home-street18
addr2user-address-home-street29
cityuser-address-home-city10
state11
zip5user-address-home-zip12
emailuser-email-address13
grad_yearuser-education-highschools-graduate-date14
current_funnel_stage15
entry_term16
parent1_titleuser-family-guardian-1-prefix-name17
parent1_relationship18
parent1_first_nameuser-family-guardian-1-first-name19
parent1_last_nameuser-family-guardian-1-last-name20
parent1_emailuser-family-guardian-email-121
counselor_emailuser-education-highschools-counselor-email-new22
counselor_first_nameuser-education-highschools-counselor-first-name23
counselor_last_nameuser-education-highschools-counselor-last-name24
first_yield_contact_dt25
qual_first_response_dt26
qual_newest_response27
qual_newest_method28
qual_newest_response_dt29
qual_count_response30
more_info_contact_me_email31
more_info_email_address32
more_info_contact_me_phone33
more_info_phone34
more_info_contact_me_SMS35
more_info_SMS36
more_info_call_time_from37
more_info_call_time_to38
more_info_financial39
more_info_majors40
more_info_housing41
more_info_none42
more_info_other_explain43
maybe_info_this_school44
maybe_info_other_school45
maybe_info_other_reason46
no_survey_submit47
no_plans48
no_other_ceeb49
no_other_sch_name50
no_other_sch_city51
no_other_sch_state52
no_app_count53
no_interest54
no_affordable_comp55
no_parent_education56
no_app_1_ceeb57
no_app_1_sch_name58
no_app_1_sch_city59
no_app_1_sch_state60
no_app_2_ceeb61
no_app_2_sch_name62
no_app_2_sch_city63
no_app_2_sch_state64
no_app_3_ceeb65
no_app_3_sch_name66
no_app_3_sch_city67
no_app_3_sch_state68
no_influence_parent69
no_influence_sibling70
no_influence_otherfam71
no_influence_hscounselor72
no_influence_collegecounselor73
no_influence_indcounselor74
no_influence_teacher75
no_influence_friend76
no_influence_coach77
no_influence_spirituallead78
no_influence_other79
no_influence_other_specified80
no_comp_personal_interest81
no_comp_aid_more82
no_comp_aid_timing83
no_comp_cost84
no_comp_app_decision85
no_comp_contact_pre_app86
no_comp_contact_post_admit87
no_comp_visit_first88
no_comp_student_life89
no_comp_field_reputation90
no_reason_chosen_191
no_reason_chosen_292
no_reason_chosen_393
no_factor_194
no_factor_295
no_factor_396
no_not_attending_plans97
no_not_attending_other98
no_additional_info99
no_communication_opt_in100
yield_rank_percentile101
likelihood_to_yield102
Calculated Fielduser-addresses-home-stateNo additional set up by the user is required. This formula checks if the home address country is the United States, if it is, it pulls in the state information into the Home Address State in Element451.103
Calculated Fielduser-addresses-home-provinceNo additional set up by the user is required. This formula checks if the home address country is the United States, if it is NOT, it pulls in the state information into the Home Address Province in Element451.104