Orders
View the total number of purchase events. Data is shown over a defined period of time (last 30 days by default).
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 [Orders] WHERE [StartDate] = '2025-01-01' AND [EndDate] = '2025-01-31' AND [SegmentId] = 's300012345_1234567890'
Columns
| Name | Type | IsDimension | IsMetric | DefaultDimension | Description |
| Date | Date | True | True | The day the given metric occurred. | |
| Orders | Int | 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. |