Explore the tables and columns you can query in SQL Data Explorer.
Read time 3 minutesLast updated 19 hours ago
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
or
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.