Monetization
A base view that retrieves Monetization data.
ビュー固有の情報
Select
Monetization レポートのデータを取得します。クエリには少なくとも 1 つの指標を指定する必要があります。また、クエリには最大 9 つのディメンションを指定できます。
次にクエリの例を示します。
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 | 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). | |
| 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 | Integer | 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. | ||
| ItemViewEvents | 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 | Decimal | 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). |
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. |