Power BI Connector for Google Analytics

Build 23.0.8839

Monetization

A base view that 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 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 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).
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 Decimal 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.
ItemsViewed 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 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839