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.
email	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: Non-recipient (0 received emails) New (fewer than 5 received emails) Active (currently engaging with received emails) Inactive (not currently engaging with received emails) 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: Non-recipient (0 received emails) New (fewer than 5 received emails) Low (modeled open rate is in the lower third) Medium (modeled open rate is in the middle third) High (modeled open rate is in the upper third) 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.