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.

Last updated