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. These 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.

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. These requirements are associated with the email summary semantic tags.

Ask your Amperity representative about how you 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.