Download data in a .csv format for quick import into Excel, Access, or other data analysis programs.
To download data in a CSV file:
Click Activities, then click the desired activity from the list.
If you have many activities, you can filter the list by selecting options from the Type, Status, Reporting Source, Experience Composer, Metrics Type, and Activity Source drop-down lists.
Click the Reports tab.
Click the Download icon, then select a report type to download for analysis in Excel and other tools.
The Success Metrics report shows you information about your success metrics, and the following metrics that are not available in the Target UI:
Data is saved until the end of the activity.
The CSV report includes only raw data and does not include calculated metrics such as revenue per visitor, lift, or confidence used for A/B tests. To calculate these calculated metrics, download the Target Complete Confidence Calculator Excel file to input the activity’s value, or review Statistical calculations in A/Bn tests.
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.
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.
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.
orderTotalparameter must be passed.
ProductPurchasedIdmbox parameter are listed in the Order Details report.
orderTotal. This allows duplicate orders to automatically be ignored.
The following information applies to the Download option: