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

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.