Email Opt Status table¶

The Email Opt Status table contains a row for each unique combination of email address, brand, region, and email program.

Important

Amperity is not the source of truth for email consent status. Email consent status can change quickly, including between the time of this table’s most recent update and the time at which your brand wants to send your customers an email as part of a campaign.

The source of truth for consent status exists downstream from Amperity, often directly within the marketing tool or application that you are using to configure the email campaign, such as Cordial, Braze, Klaviyo, or Attentive.

Use this table to filter audiences in Amperity to include customers who have consented to receiving email messages, and then build a step within the downstream marketing tool that verifies consent status immediately prior to sending an email.

Note

The Email Opt Status table represents every email address for which you have provided customer consent data to Amperity. There should be only one consent status by combination of email address, brand, region, or email program.

If you have multiple brands, regions or email programs, it’s possible for the same email address to have more than one customer consent status.

If a brand, region, or email program does not exist, there should be only one customer consent status for each unique email address.

Add table¶

The Email Opt Status table is a recommended table for the customer 360 database and is always built as a passthrough table.

Important

This table is only available after semantic tags for email opt-in status have been applied in your tenant.

To add the Email Opt Status table

From the Customer 360 page, under All Databases, select the menu for the customer 360 database, and then click Edit.
From the Database Editor, click Add Table.
Name the table “Email Opt Status”.
Set the build mode to Passthrough.
From the Source Table drop-down, select the Email Opt Status table.
Click Next.
Add a table description. This enables a tooltip that is visible from other areas in Amperity.
From the Table Semantics drop-down, select Email Opt Status.

Important

Remove any automatically applied customer profile semantic tags, such as email, before saving the table.
Under Version History, select Enable table version history.
Click Save.

Column reference¶

The Email Opt Status table contains the following columns:

Semantic Name	Datatype	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.
Brand	String	The brand to which the opt-in status applies.
Email	String	The email address that is associated with a customer. A customer may have more than one email address.
Email Frequency	String	The preferred frequency for email messages.
Email Program	String	The email program to which the customer has opted-in.
Is Email Opted In	Boolean	Indicates whether a customer has given consent to being contacted by your brand using the customer’s email address.
Language Preference	String	The customer’s preferred language for email messages.
Region	String	The region to which the opt-in status applies.