Downloading data in a CSV file

Download data in a .csv format for quick import into Excel, Access, or other data analysis programs.

To download data in a CSV file:

1. Click Activities, then click the desired activity from the list.

   If you have many activities, click the Filter ( ) icon to filter the list by selecting options from the Type, Status, Reporting Source, Experience Composer, Metrics Type, and Activity Source drop-down lists.

2. Click the Reports tab.

3. Click the Download ( ) icon, then select a report type to download for analysis in Excel and other tools.

   • Export Reports to CSV
   • Export Order Details to CSV

Export Report to CSV

The Success Metrics report shows you information about your success metrics, and the following metrics that are not available in the Target UI:

• Mean time to conversion in hours, so you can see how long it takes the average visitor to reach the conversion point
• Sum of revenues, squared, for offline statistical confidence calculations

Data is saved until the end of the activity.

Export Order Details to CSV

The Order Details report shows you information about your orders, including:

• Order date and time

• Order amount (if you inserted a Place Order mbox)

  The Order Details report works only if you have orders.

• Order flag (duplicate or extreme orders)

  An order is flagged as extreme if it is more than +/- 3 standard deviations from the average order value. This calculation uses the last month of data (up to the point in time in which the calculation was made). An activity will have its extreme orders excluded once the activity has run for an hour or until after 15 orders, whichever comes first. For more information, see Excluding Extreme Orders.

• Product ID

  The total length of product IDs, concatenated with commas, should not exceed 255 characters or the IDs do not display properly in the report. For example, if your order had products with IDs “aa, bb” then the total length is “aa,bb” = 5.

• Experience

  In the Order Details report for A/B Test, Experience Targeting (XT), and Multivariate Test (MVT) activities, the Experience column contains the experience localId. This is the value output from the $campaign.recipe.id in offer tokens.

  There is not an Experience column for Automated Personalization (AP) activities. The current Algorithm Name column has been replaced with “Control” versus “Targeted” terminology, as shown elsewhere in Target.

  There was no impact on Recommendations activities.

Best Practices

• To record an order record, the orderTotal parameter must be passed.
• Values passed via the ProductPurchasedId mbox parameter are listed in the Order Details report.
• Best practice is to include an orderID and an orderTotal. This allows duplicate orders to automatically be ignored.

Caveats

The following information applies to the Download option:

• You can download both reports for A/B Test, Automated Personalization, Experience Targeting, and Multivariate activities. You cannot download the Success Metrics report for Recommendations activities.
• The Download option is not available for A/B Test and Experience Targeting activities created before Target version 15.7.1 (July 2015).
• Experiences with no associated data are not recorded in the downloaded report.
• Audiences applied in the Target reporting UI do not carry over to the download report.
• Reports generated for download as .csv files are inconsistent if the activity uses more than one metric. The downloadable report is generated based on the report settings only and considers the same value for any other metrics used. The source of truth is always the displayed report in the Target UI.