Core summaries
This section provides detailed information about Core summaries.
Currently, all summaries are physical tables and columns.
Link to details | Table name | Table description | Data load |
|---|---|---|---|
| Best general information about unique (Individual + Business Unit) role, data elements such as profile type, gender, DOB, employee status, preferred language, profile origin, best contact address ID, email ID, and phone ID(s), etc. Examples:
| Full refresh (the whole table is recalculated every time) Run after ContactAuth Summary / Email Summary | |
| Best PII information about unique (Individual + Business Unit) such as name, standard address, email address, and phone number(s), etc. Examples:
| Full refresh Run after ContactAuth Summary / Email Summary | |
| Aggregated summaries at the unique Email Address Level (grain email address) that are derived based on the email onboarding and responses to email interactions (opens, clicks, bounces, etc.). Data elements such as last open datetime, last click-through datetime, last bounce datetime, number of times emails were opened/clicked/bounced within period of time. | Full refresh | |
| Aggregated summaries at the unique Email Address Level (grain email address) and Individual + Business Unit that are derived based on the email onboarding and responses to email interactions (opens, clicks, bounces, etc.). Data elements such as last open datetime, last click-through datetime, last bounce datetime, number of times emails were opened/clicked/bounced within period of time. | Full refresh | |
| Suppression information about unique (Individual + Business Unit) role, data elements such as board member indicator, current and historical bulk buyer indicators, freight forwarder indicator. Examples:
| Full refresh | |
| Summarized permission to contact information at the unique Email Address / BU level (distinct email address + BU) grain. The information is derived based on the email onboarding, opt out/opt in events and responses to email interactions (unsubscribe). Examples:
| Full refresh | |
| Summarized permission to contact information at the unique Mobile Phone / BU level (distinct mobile phone number + BU) grain. The information is derived based on the opt out/opt in events. | Full refresh | |
| Summarized permission to contact information at the unique Phone / BU level (distinct phone number + BU) grain. The information is derived based on opt out/opt in events. | Full refresh | |
| Summarized permission to contact information at the unique Address / BU level (distinct address ID + BU) grain. The information is derived based on the opt out/opt in events. | Full refresh | |
| Aggregated summaries at the unique Customer Account Business Unit Level. | Full refresh Run after Individual Golden Record (IGR) | |
| Aggregated summaries at the unique Loyalty Account Business Unit Level. | Full refresh Run after IGR |