Units
Show the total number of individual product units purchased across all orders in the selected reporting window.
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 [Units] WHERE [StartDate] = '2025-01-01' AND [EndDate] = '2025-01-31' AND [SegmentId] = 's300012345_1234567890'
Columns
| Name | Type | IsDimension | IsMetric | DefaultDimension | DefaultMetric | Description |
| Date | Date | True | True | The day the given metric occurred. | ||
| Units | Int | True | True | The total number of products purchased within all orders. 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 the number of products purchased. | ||
| 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. |