OrdersReport
Generate data reports for orders made on your website.
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 Date, CartViews, CartAdditions, CartRemovals FROM OrdersReport SELECT Date, Orders, OrdersPerVisitor FROM OrdersReport SELECT Date, Revenue FROM OrdersReport
Columns
| Name | Type | IsDimension | IsMetric | DefaultDimension | Description |
| Date | Date | True | True | The datetime of the given data. | |
| Carts | Int | True | Number of carts. | ||
| CartAdditions | Int | True | Number of cart additions. | ||
| CartRemovals | Int | True | Number of carts removed. | ||
| CartViews | Int | True | Number of cart views. | ||
| Orders | Int | True | Number of orders made. | ||
| ConversionRate | Int | True | Percentage of orders converted to purchase. | ||
| OrdersPerVisitor | Int | True | Number of orders per visitor. | ||
| Revenue | Decimal | True | Revenue made from sales. | ||
| RevenuePerOrder | Decimal | True | Average revenue per each order. |
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. |