Monetization
A base view that retrieves Monetization data.
Table Specific Information
Select
Retrieves data for Monetization report. At least one metric must be specified in the query. In the query you can also specify up to nine dimensions.
The following is an example query:
SELECT ItemsAddedToCart, CartToViewRate FROM Monetization
Columns
| Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
| Date | Date | True | The date of the session formatted as YYYYMMDD. | ||
| Year | Integer | True | The year of the session. A four-digit year from 2005 to the current year. | ||
| Month | Integer | True | The month of the session. An integer from 01 to 12. | ||
| Week | Integer | True | The week of the session. A number from 01 to 53. Each week starts on Sunday. | ||
| Day | Integer | True | The day of the month. A number from 01 to 31. | ||
| DayOfWeekName | String | True | The day of the week in English. This dimension has values of Sunday, Monday, etc. | ||
| IsoWeek | Integer | True | ISO week number, where each week starts on Monday. Example values include 01, 02, 53. | ||
| IsoYear | Integer | True | The ISO year of the event. Example values include 2022 2023. | ||
| IsoYearIsoWeek | Integer | True | The combined values of isoWeek and isoYear. Example values include 201652 and 201701. | ||
| YearMonth | Integer | True | The combined values of year and month. Example values include 202212 or 202301. | ||
| YearWeek | Integer | True | The combined values of year and week. Example values include 202253 or 202301. | ||
| Hour | Integer | True | An hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time. | ||
| Country | String | True | The country of users, derived from IP addresses. | ||
| City | String | True | The cities of property users, derived from IP addresses. | ||
| AdFormat | String | True | Format of the ad(e.g., text, image, video). | ||
| AdSourceName | String | True | Demand source that provided the ad. | ||
| AdUnitName | String | True | Space on the website or app that displayed the ad. | ||
| ItemBrand | String | True | Brand name of the item. | ||
| ItemCategory | String | True | 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 | 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 | 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 | 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 | Hierarchical category in which the item is classified. For example, in Apparel/Mens/Summer/Shirts/T-shirts, T-shirts is the item category5. | ||
| ItemId | String | True | ID of the item. | ||
| ItemListId | String | True | The ID of the item list. | ||
| ItemListName | String | True | The name of the item list. | ||
| ItemName | String | True | True | The name of the item. | |
| ItemPromotionCreativeName | String | True | The name of the item-promotion creative. | ||
| ItemPromotionId | String | True | ID of the item promotion. | ||
| ItemPromotionName | String | True | Name of the promotion for the item. | ||
| OrderCoupon | String | True | Code for the order-level coupon. | ||
| UnifiedPageScreen | String | True | The page path (web) or screen class (app) on which the event was logged. | ||
| TransactionId | String | True | The ID of the ecommerce transaction. | ||
| adUnitExposure | Integer | False | The amount of time the ad unit was exposed to the user. This metric is not compatible with item-scoped dimensions. | ||
| 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 | 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). | |
| ItemsCheckedOut | Integer | False | True | Number of times users started the checkout process. Since Checkouts is not compatible with item-scoped dimensions, hence this is the replacement of the Checkouts metric. | |
| EcommercePurchases | Integer | False | The number of times users completed a purchase. This metric is not compatible with item-scoped dimensions. | ||
| EventCount | Integer | False | The count of events. This metric is not compatible with item-scoped dimensions. This metric is not compatible with item-scoped dimensions. | ||
| FirstTimePurchasers | Integer | False | True | The number of users that completed their first purchase event. | |
| ItemsClickedInList | Integer | False | True | The number of times users clicked an item when it appeared in a list. Since ItemListClicks is not compatible with item-scoped dimensions, hence this is the replacement of the ItemListClicks metric. | |
| ItemListClickThroughRate | Decimal | False | True | Rate at which users clicked the item in an item list to view the item details. | |
| ItemsViewedInList | Integer | False | True | The number of times the item list was viewed. Since ItemListViews is not compatible with item-scoped dimensions, hence this is the replacement of the ItemListViews metric. | |
| PromotionClicks | Integer | False | The number of times an item promotion was clicked. ItemPromotionClicks metric has been renamed to this metric. | ||
| ItemPromotionClickThroughRate | Decimal | False | The number of users who selected a promotion(s) divided by the number of users who viewed the same promotion(s). | ||
| PromotionViews | Integer | False | The number of times an item promotion was viewed. ItemPromotionViews metric has been renamed to this metric. | ||
| ItemsPurchased | Decimal | False | The total amount of tax. ItemPurchaseQuantity metric has been renamed to this metric. | ||
| ItemRevenue | Decimal | False | The total revenue from items only. Item revenue is the product of its price and quantity. | ||
| ItemsViewed | Integer | False | The number of times the item details were viewed. ItemViews metric has been renamed to this metric. | ||
| PublisherAdClicks | Integer | False | The number of times an ad was clicked on the publisher's site. | ||
| PublisherAdImpressions | Integer | False | The number of times an ad was displayed on the publisher's site. | ||
| PurchaseToViewRate | Decimal | False | The total cost of shipping. | ||
| TotalAdRevenue | Integer | False | Sum of all advertising revenue. | ||
| StartDate | String | Start date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo). | |||
| EndDate | String | End date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo). | |||
| Dimensions | String | A comma-separated list of dimensions to retrieve in addition to the columns defined in the schema. Set to empty string to retrieve no dimensions. | |||
| Metrics | String | A comma-separated list of metrics to retrieve in addition to the columns defined in the schema. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| PropertyId | String | Property ID value to be used when querying this table. |