SQL Data Explorer queryable tables reference

Explore the tables and columns you can query in SQL Data Explorer.

阅读时间3 分钟

最后更新于 9 个月前

Through the SQL Data Explorer you have access to a number of tables.

For examples of SQL queries that can be written to access data via these tables, see the SQL Data Explorer Cookbook.

EVENTS

This table lists all of the events that have been sent in from your application. Event-specific parameters can be found in the

EVENT_JSON

column as a JSON object. As the parameters are stored as a JSON object, you'll need to parse the content in order to query it. Examples for parsing your parameters can be seen in the samples included in this repository. You can also retrieve the syntax to parse the parameters by typing in the parameter name and pressing TAB to auto-complete the syntax. This table is updated every 1-2 hours.

Column Name	Type
`UNITY_ENVIRONMENT_NAME`	`TEXT`
`UNITY_APPLICATION_NAME`	`TEXT`
`EVENT_ID`	`NUMBER`
`EVENT_JSON`	`VARIANT`
`AGE_GROUP`	`TEXT`
`ACQUSITION_CHANNEL`	`TEXT`
`MAIN_EVENT_ID`	`NUMBER`
`PLATFORM`	`TEXT`
`EVENT_DATE`	`DATE`
`EVENT_LEVEL`	`NUMBER`
`CLIENT_VERSION`	`TEXT`
`USER_ID`	`TEXT`
`USER_COUNTRY`	`TEXT`
`EVENT_TIMESTAMP`	`TIMESTAMP`
`PLAYER_START_DATE`	`DATE`
`EVENT_NAME`	`TEXT`
`GENDER`	`TEXT`

USERS

This table lists all the users who have sent in an event in the past. For each user, the columns contain a variety of useful metrics. This table is updated every 3-4 hours.

Column Name	Type
`UNITY_ENVIRONMENT_NAME`	`TEXT`
`UNITY_APPLICATION_NAME`	`TEXT`
`ACQUISITION_CHANNEL`	`TEXT`
`BIRTH_YEAR`	`INTEGER`
`MESSAGE_COUNTS`	`VARIANT`
`COUNTRY`	`TEXT`
`LAST_LOCALE`	`TEXT`
`LAST_SESSION_ID`	`TEXT`
`START_DATE`	`DATE`
`DDNA_CROSS_GAME_USER_ID`	`TEXT`
`IS_SDK_NATIVE`	`INTEGER`
`CREATED_TIMESTAMP`	`TIMESTAMP`
`LAST_PLATFORM`	`TEXT`
`LAST_UPDATED_TIMESTAMP`	`TIMESTAMP`
`COHORTS`	`TEXT`
`LAST_ANDROID_REGISTRATION_ID`	`TEXT`
`LAST_PUSH_NOTIFICATION_TOKEN`	`TEXT`
`METRICS`	`VARIANT`
`GENDER`	`TEXT`
`USER_ID`	`TEXT`
`CUSTOM_VALUES`	`VARIANT`
`UNITY_CAMPAIGNS`	`VARIANT`
`LAST_EVENT_TIMESTAMP`	`TIMESTAMP`
`LAST_TIMEZONE_OFFSET`	`TEXT`
`LAST_SEEN_TIMESTAMP`	`TIMESTAMP`

FACT_USER_SESSIONS_DAY

This table has a record for each user session. Each record contains a variety of user level aggregate KPIs for that session. If any of the dimensions excluding aggregate dimensions, are recorded in this table change during a session (for example,

AGE_GROUP

GENDER

), a new record will be created for that session. This table is updated every 1-2 hours.

Column Name	Type
`UNITY_ENVIRONMENT_NAME`	`TEXT`
`UNITY_APPLICATION_NAME`	`TEXT`
`MISSION_ABORTED`	`INTEGER`
`CLIENT_VERSION`	`TEXT`
`AGE_GROUP`	`TEXT`
`MISSIONS_FAILED`	`INTEGER`
`INVITES_ACCEPTED`	`INTEGER`
`PLAYER_START_DATE`	`DATE`
`MISSIONS_COMPLETED`	`INTEGER`
`NUMBER_OF_EVENTS`	`INTEGER`
`USER_COUNTRY`	`TEXT`
`INVITES_SENT`	`INTEGER`

FACT_EVENT_TYPE_USERS_DAY

This table lists all of the events a user has recorded in one day and how many times they have sent in each of those events. This table is updated every 1-2 hours.

Column Name	Type
`UNITY_ENVIRONMENT_NAME`	`TEXT`
`UNITY_APPLICATION_NAME`	`TEXT`
`GENDER`	`TEXT`
`CLIENT_VERSION`	`TEXT`
`EVENT_DATE`	`DATE`
`NUMBER_OF_EVENTS`	`INTEGER`
`PLATFORM`	`TEXT`
`ACQUISITION_CHANNEL`	`TEXT`
`INSERTED_TIMESTAMP`	`TIMESTAMP`
`USER_ID`	`TEXT`
`AGE_GROUP`	`TEXT`
`EVENT_NAME`	`TEXT`
`PLAYER_START_DATE`	`DATE`
`USER_COUNTRY`	`TEXT`

FACT_WAU_USERS

This table lists all of the users that have sent in an event in the last seven days. This table is updated every 1-2 hours.

Column Name	Type
`UNITY_ENVIRONMENT_NAME`	`TEXT`
`UNITY_APPLICATION_NAME`	`TEXT`
`PLAYER_START_DATE`	`DATE`
`USER_ID`	`TEXT`
`INSERTED_TIMESTAMP`	`TIMESTAMP`
`EVENT_DATE`	`DATE`
`USER_COUNTRY`	`TEXT`
`PLATFORM`	`TEXT`
`GENDER`	`TEXT`
`ACQUISITION_CHANNEL`	`TEXT`
`CLIENT_VERSION`	`TEXT`
`AGE_GROUP`	`TEXT`

FACT_MAU_USERS

This table lists all of the users that have sent in an event in the last 30 days. This table is updated every 1-2 hours.

Column Name	Type
`UNITY_ENVIRONMENT_NAME`	`TEXT`
`UNITY_APPLICATION_NAME`	`TEXT`
`PLAYER_START_DATE`	`DATE`
`USER_ID`	`TEXT`
`INSERTED_TIMESTAMP`	`TIMESTAMP`
`EVENT_DATE`	`DATE`
`USER_COUNTRY`	`TEXT`
`PLATFORM`	`TEXT`
`GENDER`	`TEXT`
`ACQUISITION_CHANNEL`	`TEXT`
`CLIENT_VERSION`	`TEXT`
`AGE_GROUP`	`TEXT`

文档

Development

User Acquisition

Monetization

工业

文档

Development

User Acquisition

Monetization

工业

Analytics

Unity SDK

Client API

Analytics

SQL Data Explorer queryable tables reference

`EVENTS`

Column Name

Type

`USERS`

Column Name

Type

`FACT_USER_SESSIONS_DAY`

Column Name

Type

`FACT_EVENT_TYPE_USERS_DAY`

Column Name

Type

`FACT_WAU_USERS`

Column Name

Type

`FACT_MAU_USERS`

Column Name

Type