ProductsReport
Generate data reports regarding your products.
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 Product, Date, ProductViews, Unit FROM ProductsReport SELECT Product, Orders, Checkouts FROM ProductsReport SELECT Product, Date, Revenue FROM ProductsReport
Columns
| Name | Type | IsDimension | IsMetric | DefaultDimension | Description |
| Product | String | True | Name of the product. | ||
| Date | Date | True | True | The datetime of the given data. | |
| ProductViews | Int | True | Number of views a products has received. | ||
| CartAdditions | Int | True | Number of times the product was added in a cart. | ||
| Checkouts | Int | True | Number of checkouts. | ||
| Orders | Int | True | Number of orders. | ||
| Units | Int | True | Number of units. | ||
| Revenue | Decimal | True | Revenue made from products sales. |
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. |