Analyze campaign data

You can analyze data for campaigns by downloading campaign results or recipient lists or by analyzing campaign results from the Queries page.

Download recipients

You can download a file that contains a list of campaign recipients (Amperity IDs) who belonged to a treatment group for a delivered campaign.

Important

For recurring campaigns, each date on which that campaign was sent must be selected, and then downloaded individually.

To download campaign recipients

1. From the Campaigns page, choose a campaign, and then from the    menu, choose Download recipients. This opens the Download recipients dialog.

2. Select the delivery date for the campaign.

3. Click Download. This downloads a CSV file to your local computer with two columns: one for the Amperity ID and the other for the treatment group ID.

Download results

You can download a file that contains a list of campaign results.

For example, a daily campaign has a launch date of March 7. From the Download results dialog, select “March 7” and 4 days. The downloaded file will show one row of data for each treatment group for every email address (as identified by the Amperity ID) that received the campaign on March 7-10.

To download campaign results

1. From the Campaigns page, choose a campaign, and then from the    menu, choose Download results. This opens the Download results dialog.

2. Select the list delivery date.

3. Select the date range for which you want to pull data. The first is the date from which data should begin, and the second is an integer that represents the number of days for which results should be downloaded.

4. Click Download.

Campaign results columns

You can finds details about the columns found in the campaign results download file in the table below.

Column name	Data type	Description
Average Order Value	Decimal	The average dollar value per order made by purchasers during the campaign measurement period. Note This metric is calculated by total revenue divided by the recipients count for the specific treatment group/sub-audiences.
Average Unit Revenue	Decimal	The average revenue per item purchased during the campaign measurement period. Note This is calculated as the total revenue divided by the total items.
Campaign Name	String	The name the customer gives the campaign.
Conversion Rate	Decimal	The percentage of unique customers (associated with Amperity IDs) who performed a desired outcome (transaction or other events) during the campaign measurement period. Note This metric indicates the rate of recipients converted to make a purchase as a result of the campaign.
Conversion Rate Lift (Over Control)	Decimal	The percentage difference in conversion rate by the recipients group relative to the control group. Note This is calculated as the difference in the incremental conversion rate divided by the total control recipients.
Delivery Date	Datetime	The delivery date on which campaign treatment groups/sub-audiences were sent out of Amperity.
Incremental Conversion Rate (Over Control)	Decimal	Additional percentage of recipients converted in the treatment group relative to the control group during the campaign measurement period. Note This column will appear as null if there is no control group.
Incremental Revenue (Over Control)	Decimal	Additional revenue generated measured by the difference between total test revenue recipient and total control revenue per recipient and then multiply that by test recipients. Note This column will appear as null if there is no control group.
Incremental Revenue Per Recipient (Over Control)	Decimal	Additional revenue per recipient in the treatment group relative to the control audience during the campaign measurement period. Note This column will appear as null if there is no control group.
Is Control	Boolean	Indicates whether the treatment group is a control group.
Items Per Order	Integer	The average number of items per order purchased during the campaign measurement period.
Measurement End Date	Datetime	The end of the campaign measurement period, plus the number of days selected prior to that date. The date prior to all preceding transactions and events associated with outcomes of this campaign. Note By default, this end date is 7 days preceding the selected measurement start date.
Measurement Start Date	Datetime	The start of the campaign measurement period. The date following all transactions and events associated with the outcomes of this campaign. Note By default, this is the launch date selected for the campaign in Amperity, but can be changed when downloaded.
Orders Per Purchaser	Integer	The average number of orders per purchaser. Note This is calculated by total orders divided by the purchaser count.
Purchaser Count	Integer	The number of unique customers (associated with Amperity IDs) in the recipients group/sub-audience who made a purchase during the campaign measurement period.
Recipient Count	Integer	The total number of unique customers (associated with Amperity IDs) included in the treatment group/sub-audience.
Revenue Per Recipient	Decimal	The amount of revenue per recipient in a campaign. Note This metric is calculated by total revenue divided by the recipients count for the specific treatment group/sub-audiences.
Revenue Per Recipient Lift (Over Control)	Decimal	The percentage difference in revenue per recipient by the treatment group relative to the control group. Note This is calculated as the difference in the incremental revenue per recipient divided by the total control recipients.
Standard Deviation Revenue	Decimal	The standard deviation (measure of variance) of revenue for each recipient in the treatment group/sub-audience who have received the campaign (associated with Amperity IDs).
Sub-audience Name	String	The name the customer gives the sub-audience.
Total Items	Integer	The total quantity of items ordered by unique customers (associated with Amperity IDs) in the recipients group/sub-audience during the campaign measurement period.
Total Orders	Integer	The total number of purchase orders made by unique customers (associated with Amperity IDs) in the recipients group/sub-audience during the campaign measurement period.
Total Revenue	Decimal	The total revenue associated with Amperity IDs in the treatment group/sub-audience, during the campaign measurement period. Note By default, the order_revenue field in the Unified Transactions table is calculated as gross revenue and the gross sales details are provided in the campaign results download file.
Treatment ID	String	The numerical identifier Amperity assigns to the treatment group.
Treatment Name	String	The name the customer gives the treatment group.