Unified_Email_Events Table

The Unified_Email_Events table contains individual email event information, such as sends, opens, clicks, opt-in and opt-out preferences, bounces, and conversions. This table is added as Stitch output when email event semantic tags are applied to data sources.

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 Unified_Email_Events table has a dependency on the Email_Engagement_Summary table. The Email_Engagement_Summary table requires email summary semantic tags to be applied feeds and/or custom domain tables that contain email engagement data.

Column reference

The Unified_Email_Events table contains the following columns:

Column Name

Data type

Description

brand

String

The brand or company from which an email was sent.

Values in this column depend on fields that are tagged with the email-event/brand semantic.

datasource

String

email

String

The email address to which an email was sent.

Values in this column depend on fields that are tagged with the email-event/email semantic.

event_datetime

Datetime

The date and time at which email event occurred.

Values in this column depend on fields that are tagged with the email-event/event-datetime semantic.

event_type

String

The type of email event. Possible values:

  • Open

  • Click

  • Sent

  • Opt-in

  • Bounced

  • Converted

Values in this column depend on fields that are tagged with the email-event/event-type semantic.

pk

String

region

String

The region or location from which an email was sent. The region or location is typically associated to a single brand.

Values in this column depend on fields that are tagged with the email-event/region semantic.

send_id

String

The unique identifier for the email that was sent to an email address at a specific date and time. If a data source does not provide a send ID a unique key is generated.

Values in this column depend on fields that are tagged with the email-event/send-id semantic.