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.
ItemPromotionCreativeName	String	True			The name of the item-promotion creative.
ItemPromotionCreativeName	String	True			The name of the item-promotion creative.
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	True		The number of times an item promotion was clicked.
ItemPromotionClickThroughRate	Decimal	False	True		The number of users who selected a promotion(s) divided by the number of users who viewed the same promotion(s).
ItemPromotionViews	Integer	False	True		The number of times an item promotion was viewed.
ItemListViews	Integer	False	True		The number of times the item list was viewed.
ItemListViews	Integer	False	True		The number of times the item list was viewed.
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.
ItemViews	Integer	False	True		The number of times the item details were viewed.
PublisherAdClicks	Integer	False	True		The number of times an ad was clicked on the publisher
PublisherAdImpressions	Integer	False	True		The number of times an ad was displayed on the publisher
PurchaseToViewRate	Decimal	False	True		The total cost of shipping.
TotalAdRevenue	Integer	False	True		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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
PropertyId	String	Property ID value to be used when querying this table.