Contact Rollups
Contact rollups is a daily process that we use to aggregate emails that we've collected in various ways across our site (eg, Hour of Code signups, Code Studio account signups, Professional Development enrollments). We also aggregate metadata about each email (eg, where are they, have they attended professional learning, etc.) Finally, we pass this information to our marketing platform (Pardot).
We take information from across our database and collate it into one entry per email. The table below provides some information about where we collect information, where it eventually ends up in Pardot, and our order of preference for different data sources.
| Field name in Pardot | Field description | Sources (preferred source listed first, if relevant) | Possible values (if relevant) |
|---|---|---|---|
| db_City | City | school location > account sign up IP address > form submission IP address | |
| db_Postal_Code | ZIP code | school postal code > user postal code > form geo postal code | |
| db_State | State | school state > user state > form geo state | |
| db_Country | Country | account sign up IP address > form submission IP address | |
| db_Has_Teacher_Account | Does this email have a teacher account on Code.org? | "true" (blank otherwise) | |
| db_Professional_Learning_Enrolled | Which PL courses has this email enrolled in? (can be many, comma separated) | CS Fundamentals CS Discoveries CS Principles Counselor Admin Facilitator CS in Science CS in Algebra Exploring Computer Science |
|
| db_Professional_Learning_Attended | Which PL courses has this email enrolled in? (can be many, comma separated) | CS Fundamentals CS Discoveries CS Principles Counselor Admin Facilitator CS in Science CS in Algebra Exploring Computer Science |
|
| db_Roles | Based on their behavior (teaching courses, attending PD, filling out forms) on our site, which roles can be associated with this email? (can be many, comma separated) | Teacher Petition Signer CSP Teacher CSD Teacher CSF Teacher Form Submitter Parent Facilitator Workshop Organizer District Contact |
|
| db_Form_Roles | Based on form submissions, which roles has this email identified as? (can be many, comma separated) | We have a lot of forms on our site, but some primary sources are: Hour of Code Signups Access Report Submissions at code.org/yourschool Petition at https://code.org/promote Volunteers sign up at https://code.org/volunteer ... |
teacher administrator parent volunteer other educator engineer student |
| db_Forms_Submitted | Which forms has this email filled out? (can be many, comma separated) | We have a lot of forms on our site, but some primary sources are: Hour of Code Signups Access Report Submissions at code.org/yourschool Petition at https://code.org/promote Volunteers sign up at https://code.org/volunteer ... |
Please inquire with whoever edited this wiki page most recently for more detail here if needed |
| db_Hour_of_Code_Organizer | Which years did this email organize an Hour of Code event (can be many, comma separated) | 2013-2020 | |
| db_Opt_In | Has this email opted in or out of email communication from us? | Yes/No |
The second version of contact rollups does not sync all of the fields that were synced by the first version of contact rollups. Those deprecated fields are:
- db_Ages_Taught
- db_District
- db_District_City
- db_District_State
- db_Facilitator_Type
- db_Grades_Taught
- db_Name
- db_School