ADO.NET Provider for Google Analytics

Build 24.0.9062

GamesReporting

A base view that retrieves Games Reporting data.

Table Specific Information

Select

Retrieves data for GamesReporting report. At least one metric must be specified in the query. In the query you can also specify up to 9 dimensions.

The following is an example query:

	SELECT AveragePurchaseRevenue, AverageRevenuePerUser FROM GamesReporting

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. A two digit integer from 01 to 12.
Week Integer True The week of the session. A two-digit number from 01 to 53. Each week starts on Sunday.
Day Integer True The day of the month. A two-digit 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 A two-digit hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time.
AudienceName String True The given name of an Audience.
FirstUserCampaignName String True Name of the marketing campaign that first acquired the user.
FirstUserGoogleAdsCreativeId String True The campaign creative ID that first acquired the user.
FirstUserGoogleAdsAdGroupId String True The Ad Group Id in Google Ads that first acquired the user.
FirstUserGoogleAdsAdGroupName String True The Ad Group Name in Google Ads that first acquired the user.
FirstUserGoogleAdsAdNetworkType String True The advertising network that first acquired the user.
FirstUserMedium String True True The medium that first acquired the user to the website or app.
FirstUserSource String True The source that first acquired the user to the website or app.
AveragePurchaseRevenue Decimal False True The average purchase revenue in the transaction group of events.
AveragePurchaseRevenuePerPayingUser Decimal False True Average revenue per paying user (ARPPU) is the total purchase revenue per active user that logged a purchase event. The summary metric is for the time period selected.
AverageRevenuePerUser Decimal False True Average revenue per active user (ARPU). The summary metric is for the time period selected.
EngagedSessionsPerUser Decimal False True Average number of engaged sessions per user.
FirstTimeBuyersPerNewUsers Decimal False True Percentage of unique new users to the game who made their first in-app purchase.
FirstTimePurchasers Integer False True The number of users that completed their first purchase event.
NewUsers Integer False True The number of users who interacted with the site or launched the app for the first time.
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).

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 24.0.9062