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.
Purchase Before Signup	Boolean	This flag indicates whether an Amperity ID is associated with a previous transaction before signing up with this email address.
Signup To Purchase Days	Integer	The number of days between the time this email was used to signup and the next transaction associated with an Amperity ID. Note This field will appear null if there is no transaction(s) made after the email signup.