EcommPurchasesItemCategoryReportCombined
A predefined view that retrieves Ecommerce purchase item category data.
Select
The component uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:
- PropertyId supports the following operator: =
- ItemCategory supports the following operator: =
- ItemCategory2 supports the following operator: =
- ItemCategory3 supports the following operator: =
- ItemCategory3 supports the following operator: =
- ItemCategory5 supports the following operator: =
- Date supports the following operators: =,>=,<=,<,>
For example, the following queries are processed server-side:
SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE PropertyId = 342020667 SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE ItemCategory = 'Apparel' SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE ItemCategory2 = 'Mens' SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE ItemCategory3 = 'Summer' SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE ItemCategory4 = 'Shirts' SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE ItemCategory5 = 'T-shirts' SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE Date = '01/05/2023' SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE PropertyId = 342020667 AND ItemCategory = 'Apparel' AND Date = '01/05/2023' SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE Date >= '01/01/2022' AND <= '01/05/2023' SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE Date >= '01/01/2022' SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE Date <= '01/01/2022' SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE Date > '01/01/2022' SELECT * FROM EcommPurchasesItemCategoryReportCombined WHERE Date < '01/01/2022'The rest of the filter is executed client-side in the component.
Columns
Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
ItemCategory | String | True | True | A Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Apparel is the item category. | |
ItemCategory2 | String | True | True | A Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Mens is the item category2 | |
ItemCategory3 | String | True | True | A Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Summer is the item category3. | |
ItemCategory4 | String | True | True | A Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Shirts is the item category4. | |
ItemCategory5 | String | True | True | A Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, T-shirts is the item category5. | |
Date | Date | True | True | The date of the session formatted as YYYYMMDD. | |
ItemsAddedToCart | Integer | False | True | The number of times users added items to their shopping carts. Since AddToCarts is not compatible with item-scoped dimensions, this is the replacement for the AddToCarts metric. | |
CartToViewRate | Integer | False | True | The number of users who added a product(s) to their cart divided by the number of users who viewed the same product(s). | |
EcommercePurchases | Integer | False | The number of times users completed a purchase. This metric is not compatible with item-scoped dimensions. | ||
PurchaseToViewRate | Decimal | False | True | The total cost of shipping. | |
ItemsPurchased | Decimal | False | True | The total amount of tax. The ItemPurchaseQuantity metric has been renamed to this metric. | |
ItemRevenue | Decimal | False | True | The total revenue from items only. Item revenue is the product of its price and quantity. | |
ItemsViewed | Integer | False | True | The number of units viewed for a single item. This metric counts the quantity of items in 'view_item' events. |
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 |
PropertyId | String | The Property Id value to be used when querying this table. |