Products
Return order counts grouped by product name or SKU, allowing analysis of top-performing items sold within the last 30 days.
This predefined report view is based on the corresponding Adobe Analytics template. By default, the report covers the last 30 days. To customize the date range, specify StartDate and EndDate in the WHERE clause. If only StartDate is provided, EndDate defaults to today. If only EndDate is provided, StartDate defaults to two years before the specified EndDate.
You can also filter the report by segment using the SegmentId column in the WHERE clause. For instance, an example query might be:
SELECT * FROM [Products] WHERE [StartDate] = '2025-01-01' AND [EndDate] = '2025-01-31' AND [SegmentId] = 's300012345_1234567890'
Columns
| Name | Type | IsDimension | IsMetric | DefaultDimension | DefaultMetric | Description |
| Product | String | True | True | The name of the product in the hit. | ||
| Orders | Int | True | True | The total number of purchase events made on your site. This metric is vital for eCommerce sites in measuring conversion because you can combine this metric with any dimension to see which dimension items contributed to an order. | ||
| StartDate | String | Specifies the beginning of the reporting period. | ||||
| EndDate | String | Specifies the end of the reporting period. | ||||
| SegmentId | String | Specifies the ID of a predefined or custom segment to filter the report data. |