All Opted-In Emails table¶

The All Opted In Emails table contains all opted-in email addresses (and associated Amperity IDs). This table is built from the Email Opt Status table, after which it can be extended to support brands, region, email program, and language preferences.

Use in segments¶

Use the contactable_email attribute from the Customer Attributes table when building segments.

For each sub-audience in a campaign, to send only email addresses that have opted in, open Edit Attributes and use the email attribute in the All Opted-In Emails table.

For example:

You may use other attributes in the All Opted-In Emails table (if they are available) to apply additional filters to the sub-audience.

Note

The email attribute in the All Opted-In Emails table may represent more than one opted-in email address for the same customer. This is not uncommon and you may notice a difference between the number of records in the segment versus the (typically higher) number of records that were delivered by the campaign.

Warning

The All Opted-In Emails table is not unique by Amperity ID and should not be used within the Segment Editor.

Add table¶

The All Opted-In Emails table requires the Email Opt Status table, after which you can extend support for additional requirements.

To add the All Opted-In Emails table

From the Database Editor, click Add Table.
Name the table “All Opted-In Emails”.
Set the build mode to SQL.
Click Apply template, and then select All Opted-In Emails.

The minimum requirement for this table is to SELECT all attributes from the Email Opt Status table:
```
SELECT
  *
FROM Email_Opt_Status
WHERE is_email_opted_in
```
Click Validate to verify the SQL runs without error.
Click Next. This opens the Database Table Definition page.
Add a table description. This enables a tooltip that is visible from other areas in Amperity.
Select Make available in Visual Segment Editor. This ensures the table is available from the Edit Attributes dialog in the campaign editor.

Important

You should not use attributes in this table to build segments.
Leave the Table Semantics drop-down empty.
Click Save.

Extend table¶

You can extend the All Opted-In Emails table to contain specific sets of attributes. For example:

A brand
A region
The name of your email program
The frequency at which your customers allow emails to be sent
Language preference

For example, to extend the All Opted-In Emails table to support a single brand in Europe, update the SQL for the All Opted In Emails table:

SELECT
  *
FROM Email_Opt_Status
WHERE is_email_opted_in
AND brand = ACME
AND region = Europe

You can use an AND clause for any of the individual fields in the Email Opt Status table.

Add brand-specific table¶

You can add brand-specific tables using the same steps for adding the All Opted In Emails table. Append the name of your brand after the name of the table. For example: “All_Opted_In_Emails_ACME”.

Column reference¶

The All Opted In Emails table contains the same columns as the Email Opt Status table. Unlike the Email Opt Status table, the All Opted In Emails table should be made available to the Segment Editor. This ensures that the email attribute in this table is available to campaigns. (Choose the email attribute from the All Opted In Emails table from the Edit Attributes menu.)

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 an individual customer record. A customer record may be associated with multiple email addresses.
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.