EcommPurchasesItemIdReport
Retrieves Ecommerce purchase item data.
Select
The 本製品 uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:
- PropertyId supports the following operator: =
- ItemId supports the following operator: =
- Date supports the following operators: =,>=,<=,<,>
For example, the following queries are processed server-side:
SELECT * FROM EcommPurchasesItemIdReport WHERE PropertyId = 342020667 SELECT * FROM EcommPurchasesItemIdReport WHERE ItemId = '1234' SELECT * FROM EcommPurchasesItemIdReport WHERE Date = '01/05/2023' SELECT * FROM EcommPurchasesItemIdReport WHERE PropertyId = 342020667 AND ItemId = '1234' and Date = '01/05/2023' SELECT * FROM EcommPurchasesItemIdReport WHERE Date >= '01/01/2022' AND <= '01/05/2023' SELECT * FROM EcommPurchasesItemIdReport WHERE Date >= '01/01/2022' SELECT * FROM EcommPurchasesItemIdReport WHERE Date <= '01/01/2022' SELECT * FROM EcommPurchasesItemIdReport WHERE Date > '01/01/2022' SELECT * FROM EcommPurchasesItemIdReport WHERE Date < '01/01/2022'The rest of the filter is executed client-side in the 本製品.
Columns
Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
ItemId | String | True | True | ID of the item. | |
Date | Date | True | True | The date of the session formatted as YYYYMMDD. | |
AddToCarts | Integer | False | True | The number of times users added items to their shopping carts. | |
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 | True | The number of times users completed a purchase. | |
PurchaseToViewRate | Decimal | False | True | The total cost of shipping. | |
ItemPurchaseQuantity | Decimal | False | True | The total amount of tax. | |
ItemRevenue | Decimal | False | True | The total revenue from items only. Item revenue is the product of its price and quantity. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
PropertyId | String | Property ID value to be used when querying this table. |