Email_Engagement_Attributes Table

The Email_Engagement_Attributes table contains all fields from the Email_Engagement_Summary table, unique by Amperity ID and by email address. This table may be extended for related email engagement and transaction attributes.

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.

Note

The Email_Engagement_Attributes table relies on the Merged_Customers table and must be available in your customer 360 database.

Column reference

The Email_Engagement_Attributes table contains the following columns:

Column Name

Data type

Description

amperity_id

String

The unique identifier that is assigned to clusters of customer records that all represent the same individual. The Amperity ID does not replace primary and foreign keys, but exists alongside them within unified profiles.

Note

The Amperity ID is a universally unique identifier (UUID) that is represented by 36 characters spread across five groups separated by hyphens: 8-4-4-4-12.

For example:

123e4567-e89b-12d3-a456-426614174000

brand

String

The brand or company from which an email was sent.

email

String

The email address to which an email was sent.

event_datetime

Datetime

The date and time at which email event occurred.

event_type

String

The type of email event. Possible values:

  • Open

  • Click

  • Sent

  • Opt-in

  • Bounced

  • Converted

region

String

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

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.