Email_Engagement_Summary Table¶
The Email_Engagement_Summary table contains a summary of email event statistics, such as counts for opens and clicks, the first open, and the most recent click, unique by email address.
Important
The Email_Engagement_Attributes, Email_Engagement_Summary, and Unified_Email_Events tables are used to enable email engagement workflows within Amperity.
The Email_Engagement_Summary and Unified_Email**Events tables are generated as Stitch output after applying email events semantic tags to data sources that contain email engagement data, such as opens, clicks, opt-in and opt-out preferences, or conversions, along with email summary if that data is available.
The Email_Engagement_Attributes table is built using a built-in SQL template in your customer 360 database. Some customization of this SQL template is necessary to align the behavior of this table to the data that exists in your tenant.
Requirements¶
The Email_Engagement_Summary table requires a specific set of fields to be present before rolled-up calculations are enabled:
Email clicks for 1, 3, 5, 7, 14 day intervals
Email clicks for 3, 6, 9, 12 month intervals
Email opens for 1, 3, 5, 7, 14 day intervals
Email opens for 3, 6, 9, 12 month intervals
along with fields that track the date and time for the most recent click. Use the email summary semantic tags to identify these fields.
Ask your Amperity representative about how to configure email engagement data when these requirements are not present.
Column reference¶
The Email_Engagement_Summary table contains the following columns:
Column Name |
Data type |
Description |
---|---|---|
brand |
String |
The brand or company from which an email was sent. |
String |
The email address to which an email was sent. |
|
email_clicks_last_x_day |
Integer |
The number of email clicks in the last 1, 3, 5, 7, or 14 days. |
email_clicks_last_x_months |
Integer |
The number of email clicks in the last 3, 6, 9, or 12 months. |
email_opens_last_x_day |
Integer |
The number of email opens in the last 1, 3, 5, 7, or 14 days. |
email_opens_last_x_months |
Integer |
The number of email opens in the last 3, 6, 9, or 12 months. |
engagement_frequency_last_15_months |
Varchar |
A classification that measures engagement frequency click rates for email addresses that have received a low volume of emails. Possible values:
Important Send rates must be available. |
engagement_status_last_15_months |
Varchar |
A classification that measures click rates for email addresses that have received a low volume of emails. Possible values:
Important Send rates must be available. |
first_email_click_datetime |
Datetime |
The date and time at which an email was first clicked. |
first_email_open_datetime |
Datetime |
The date and time at which an email was first opened. |
first_email_send_datetime |
Datetime |
The date and time at which an email was sent. |
most_recent_email_bounce_datetime |
Datetime |
The date and time for the most recent bounced email. |
most_recent_email_click_datetime |
Datetime |
The date and time at which a customer most recently clicked a link or offer within an opened email. |
most_recent_email_open_datetime |
Datetime |
The date and time at which a customer most recently opened an email. |
most_recent_email_optin_datetime |
Datetime |
The date and time at which a customer most recently opted-in to receiving email. |
most_recent_email_optout_datetime |
Datetime |
The date and time at which a customer most recently opted-out from receiving email. |
most_recent_email_send_datetime |
Datetime |
The date and time at which an email was most recently sent. |