GamesReporting
A base view that retrieves Games Reporting data.
View-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). |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| PropertyId | String | Property ID value to be used when querying this table. |
| CurrencyCode | String | A currency code in ISO4217 format, such as AED, USD, JPY. If the field is empty, the report uses the property's default currency. |