Revenue
Aggregate the total revenue generated from all completed orders within the reporting period (defaults to 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 [Revenue] 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. | ||
| Revenue | Decimal | True | True | The monetary amount 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 revenue. | ||
| 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. |