Campaign Recipients table¶

The Campaign Recipients table has a list of Amperity IDs associated with campaigns sent from Amperity, along with details about the campaign. These details include control and treatment groups, audience segments, destinations, and launch dates.

The Campaign Recipients table is generated by Amperity, and then made available as a standard database table. Use this table to access campaign attributes, perform historical campaign analysis, and to build segments and multi-stage campaigns that use the results of previous campaigns.

Important

Data in the Campaign Recipients table is updated after the next database run. If your database is configured to run once per day then data in the Campaign Recipients table will be available on a 1-day delayed rolling basis.

Requirements¶

This topic assumes that at least one campaign has been configured, and then sent from Amperity.

Add table¶

A Campaign Recipients table can be enabled directly from the Campaigns page. It may be enabled for each combination of database + activation that is configured in your tenant.

To enable Campaign Recipients tables

Click the Campaign settings link next to the Create campaign button, and then open the Campaign Recipients tab.
Select the databases for which the Campaign Recipients table should be enabled.
Click Save.

Campaign delivery dates¶

The following query returns campaigns sorted by earliest and latest delivery dates by campaign ID or campaign name.

SELECT
  campaign_id
  ,campaign_name
  ,sub_audience_name
  ,treatment_name
  ,treatment_id
  ,delivery_datetime
  ,MIN(delivery_datetime) AS earliest_delivery_date
  ,MAX(delivery_datetime) AS latest_delivery_date
FROM Campaign_Recipients
WHERE campaign_id IN ('campaign-id')
OR campaign_name IN ('campaign-name')
GROUP BY 1,2,3,4,5,6
ORDER BY 5,6,7

where the WHERE statement is updated for the specific campaign ID and/or campaign name.

Column reference¶

The Campaign Recipients table contains the following columns:

Column name	Data type	Description
Amperity ID	String	The unique identifier assigned to clusters of customer profiles that all represent the same individual. The Amperity ID does not replace primary, foreign, or other unique customer keys, but exists alongside them within unified profiles. Note The Amperity ID is a universally unique identifier (UUID) that is 36 characters spread across five groups separated by hyphens: 8-4-4-4-12. For example: 123e4567-e89b-12d3-a456-426614174000
Campaign ID	String	The unique ID for a campaign.
Campaign Name	String	The name of the campaign.
Campaign Type	String	A campaign is a message or offer sent to a specific group of customers or recipients. A campaign may be one of the following types: One-time Recurring A one-time campaign represents a specific campaign message sent only once. A recurring campaign automatically sends an updated or refreshed audience with a predefined campaign message and cadence for a list of recipients. For example, a state change, an accepted return, a change to loyalty status, or an alert based on credit card status.
Database ID	String	The unique ID for the database.
Database Name	String	The name of the database.
Dataset Version	String	A unique ID for the dataset used with this set of campaign recipients.
Delivery Datetime	Datetime	The date and time at which the associated campaign ID was delivered to the destination.
Destination ID	String	The unique ID for a destination.
Destination Name	String	The name of the destination to which the associated campaign ID was sent.
Is Control	Boolean	A flag that indicates if the Treatment ID represents a control group.
Launch Datetime	Datetime	The date and time at which the associated campaign ID was sent from Amperity to its downstream workflow.
PK	String	The combination of data source and primary key allows Amperity to uniquely identify every row in every data table across the entirety of customer data input to Amperity.
Segment ID	String	The unique ID for the segment that generated the list of recipients for the associated campaign ID.
Segment Name	String	The name of the segment used with the associated campaign ID.
Sub Audience ID	String	The unique ID for the sub-audience to which the associated campaign was sent.
Sub Audience Name	String	The name of the sub-audience to which the associated campaign was sent.
Target ID	String	The unique ID for the data template that was used to send campaign data to a downstream channel or workflow.
Target Name	String	The name of the data template that was used to send campaign data to a downstream channel or workflow.
Treatment ID	String	The ID for the treatment group.
Treatment Name	String	The name of the treatment group for a campaign. All treatment groups, along with the control group, combine for measuring campaign quality.
Workflow ID	String	The unique ID for the workflow that managed the associated campaign.