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.
- Order report data includes four weeks of data for the default environment (host group) and two weeks for all non-default environments.
- Revenue metrics that are set to “Increment count and keep the user in the activity” log order details only for the first order made by the same visitor. All subsequent orders increase conversion count, but do not add revenue to RPV/AOV/Sales, and are not included in the Order Details report.
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 anorderTotal
. 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.