TDV Adapter for Google Analytics

Build 21.0.8137

Monetization

Retrieves Monetization data.

Table Specific Information

Select

Retrieves data for Monetization report. At least one metric must be specified in the query. The following are example queries:

	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.
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.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137