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.