Monetization
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 AddToCarts, 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. | ||
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 | True | The amount of time the ad unit was exposed to the user. | |
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). | |
Checkouts | Integer | False | True | Number of times users started the checkout process. | |
EcommercePurchases | Integer | False | True | The number of times users completed a purchase. | |
EventCount | Integer | False | True | The count of events. | |
FirstTimePurchasers | Integer | False | True | The number of users that completed their first purchase event. | |
ItemListClicks | Integer | False | True | The number of times users clicked an item when it appeared in a list. | |
ItemListClickThroughRate | Decimal | False | True | Rate at which users clicked the item in an item list to view the item details. | |
ItemListViews | Integer | False | True | The number of times the item list was viewed. | |
ItemPromotionClicks | Integer | False | The number of times an item promotion was clicked. | ||
ItemPromotionClickThroughRate | Decimal | False | The number of users who selected a promotion(s) divided by the number of users who viewed the same promotion(s). | ||
ItemPromotionViews | Integer | False | The number of times an item promotion was viewed. | ||
ItemPurchaseQuantity | Decimal | False | The total amount of tax. | ||
ItemRevenue | Decimal | False | The total revenue from items only. Item revenue is the product of its price and quantity. | ||
ItemViews | Integer | False | The number of times the item details were viewed. | ||
PublisherAdClicks | Integer | False | The number of times an ad was clicked on the publisher | ||
PublisherAdImpressions | Integer | False | The number of times an ad was displayed on the publisher | ||
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. |