TDV Adapter for Adobe Analytics

Build 21.0.8137

ProductsReport

Generate data reports regarding your products.

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 Product, Date, ProductViews, Unit FROM ProductsReport
SELECT Product, Orders, Checkouts FROM ProductsReport
SELECT Product, Date, Revenue FROM ProductsReport

Columns

Name Type IsDimension IsMetric DefaultDimension Description
Product String True Name of the product.
Date Date True True The datetime of the given data.
ProductViews Int True Number of views a products has received.
CartAdditions Int True Number of times the product was added in a cart.
Checkouts Int True Number of checkouts.
Orders Int True Number of orders.
Units Int True Number of units.
Revenue Decimal True Revenue made from products sales.

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