TDV Adapter for Adobe Analytics

Build 21.0.8137

OrdersReport

Generate data reports for orders made on your website.

View Specific Information

Refer to the explanation in the "Data Model" section to learn how to build optimal queries. The following are some use cases for this report:

SELECT Date, CartViews, CartAdditions, CartRemovals FROM OrdersReport
SELECT Date, Orders, OrdersPerVisitor FROM OrdersReport
SELECT Date, Revenue FROM OrdersReport

Columns

Name Type IsDimension IsMetric DefaultDimension Description
Date Date True True The datetime of the given data.
Carts Int True Number of carts.
CartAdditions Int True Number of cart additions.
CartRemovals Int True Number of carts removed.
CartViews Int True Number of cart views.
Orders Int True Number of orders made.
ConversionRate Int True Percentage of orders converted to purchase.
OrdersPerVisitor Int True Number of orders per visitor.
Revenue Decimal True Revenue made from sales.
RevenuePerOrder Decimal True Average revenue per each order.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
StartDate Datetime Use this to filter reports by the start date of the report.
EndDate Datetime Use this to filter reports by the end date of the report.
SegmentId String Use this to filter reports by a particular segment.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137