GamesReporting
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. | ||
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. | ||
FirstUserCreativeId | 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). | |||
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. |