EcommPurchasesItemCategory2Report
A predefined view that retrieves Ecommerce purchase item category data.
Select
本製品 は Google Analytics API を使用して、以下のカラムと演算子で構築された WHERE 句条件を処理します：
- PropertyId は次の演算子をサポートします：=
- ItemCategory2 は次の演算子をサポートします：=
- Date は次の演算子をサポートします：=、>=、<=、<、>
- CurrencyCode は次の演算子をサポートします：=
例えば、次のクエリはサーバーサイドで処理されます。
SELECT * FROM EcommPurchasesItemCategory2Report WHERE PropertyId = 342020667
SELECT * FROM EcommPurchasesItemCategory2Report WHERE ItemCategory2 = 'Apparel'
SELECT * FROM EcommPurchasesItemCategory2Report WHERE Date = '01/05/2023'
SELECT * FROM EcommPurchasesItemCategory2Report WHERE PropertyId = 342020667 AND ItemCategory2 = 'Apparel' AND Date = '01/05/2023'
SELECT * FROM EcommPurchasesItemCategory2Report WHERE Date >= '01/01/2022' AND Date <= '01/05/2023'
SELECT * FROM EcommPurchasesItemCategory2Report WHERE Date >= '01/01/2022'
SELECT * FROM EcommPurchasesItemCategory2Report WHERE Date <= '01/01/2022'
SELECT * FROM EcommPurchasesItemCategory2Report WHERE Date > '01/01/2022'
SELECT * FROM EcommPurchasesItemCategory2Report WHERE Date < '01/01/2022'
その他のフィルタはクライアントサイドで 本製品 内部で処理されます。
Columns
| Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
| ItemCategory2 | String | True | True | Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, Mens is the item category2 | |
| 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, hence this is the replacement of the AddToCarts metric. | |
| CartToViewRate | Decimal | 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 | Integer | False | True | The total amount of tax. 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. |
Pseudocolumns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| Name | Type | Description |
| PropertyId | String | Property ID value to be used when querying this table. |
| CurrencyCode | String | A currency code in ISO4217 format, such as AED, USD, JPY. If the field is empty, the report uses the property's default currency. |