Data Access available views
Through the Data Access feature, you gain access to a number of views containing your account's data.
Note: The Data Access views use multiple timestamps:
EVENT_TIMESTAMP
: The time when the event was created on the client device.LOADED_TIMESTAMP
: The time when the event was loaded into the data warehouse.
ACCOUNT_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.
Column Name | Type |
---|---|
ACCOUNT_NAME | TEXT |
GAME_NAME | TEXT |
GAME_ID | NUMBER |
ENVIRONMENT_NAME | TEXT |
ENVIRONMENT_ID | NUMBER |
LOAD_ID | NUMBER |
EVENT_ID | NUMBER |
EVENT_TIMESTAMP | TIMESTAMP |
EVENT_NAME | TEXT |
PLAYER_START_DATE | DATE |
ACQUISITION_CHANNEL | TEXT |
USER_COUNTRY | TEXT |
USER_ID | TEXT |
EVENT_JSON | VARIANT |
LOADED_TIMESTAMP | TIMESTAMP |
ACCOUNT_EVENT_JSON_KEYS
This table contains data on the event fields that are used for your games.
Column Name | Type |
---|---|
ACCOUNT_NAME | TEXT |
GAME_NAME | TEXT |
GAME_ID | NUMBER |
ENVIRONMENT_NAME | TEXT |
FIELD_NAME | TEXT |
INSERTED_TIMESTAMP | TIMESTAMP |
ACCOUNT_GAMES
This table lists all of the games that exist under your account.
Column Name | Type |
---|---|
ACCOUNT_NAME | TEXT |
GAME_NAME | TEXT |
GAME_ID | NUMBER |
ENVIRONMENT_NAME | TEXT |
ENVIRONMENT_ID | NUMBER |
UNITY_PROJECT_ID | TEXT |
ACCOUNT_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.
Column Name | Type |
---|---|
ACCOUNT_NAME | TEXT |
GAME_NAME | TEXT |
GAME_ID | NUMBER |
ENVIRONMENT_NAME | TEXT |
ENVIRONMENT_ID | NUMBER |
USER_ID | TEXT |
BIRTH_YEAR | NUMBER |
LAST_SESSION_ID | TEXT |
LAST_EVENT_TIMESTAMP | TIMESTAMP |
LAST_PLATFORM | TEXT |
COUNTRY | TEXT |
GENDER | TEXT |
START_DATE | DATE |
ACQUISITION_CHANNEL | TEXT |
LAST_LOCALE | TEXT |
ACCOUNT_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.
Column Name | Type |
---|---|
ACCOUNT_NAME | TEXT |
GAME_NAME | TEXT |
GAME_ID | NUMBER |
ENVIRONMENT_NAME | TEXT |
ENVIRONMENT_ID | NUMBER |
EVENT_DATE | DATE |
USER_ID | TEXT |
AGE_GROUP | TEXT |
GENDER | TEXT |
USER_COUNTRY | TEXT |
ACQUISITION_CHANNEL | TEXT |
PLAYER_START_DATE | DATE |
PLATFORM | TEXT |
CLIENT_VERSION | TEXT |
EVENT_NAME | TEXT |
NUMBER_OF_EVENTS | NUMBER |
INSERTED_TIMESTAMP | TIMESTAMP |
ACCOUNT_FACT_WAU_USERS
This table lists all of the users that have sent in an event in the last week.
Column Name | Type |
---|---|
ACCOUNT_NAME | TEXT |
GAME_NAME | TEXT |
GAME_ID | NUMBER |
ENVIRONMENT_NAME | TEXT |
ENVIRONMENT_ID | NUMBER |
EVENT_DATE | DATE |
USER_ID | TEXT |
AGE_GROUP | TEXT |
GENDER | TEXT |
USER_COUNTRY | TEXT |
ACQUISITION_CHANNEL | TEXT |
PLAYER_START_DATE | DATE |
PLATFORM | TEXT |
CLIENT_VERSION | TEXT |
ACCOUNT_FACT_MAU_USERS
This table lists all of the users that have sent in an event in the last 30 days.
Column Name | Type |
---|---|
ACCOUNT_NAME | TEXT |
GAME_NAME | TEXT |
GAME_ID | NUMBER |
ENVIRONMENT_NAME | TEXT |
ENVIRONMENT_ID | NUMBER |
EVENT_DATE | DATE |
USER_ID | TEXT |
AGE_GROUP | TEXT |
GENDER | TEXT |
USER_COUNTRY | TEXT |
ACQUISITION_CHANNEL | TEXT |
PLAYER_START_DATE | DATE |
PLATFORM | TEXT |
CLIENT_VERSION | TEXT |
ACCOUNT_FACT_MISSION_USERS_DAY
This counts how often a user has started, completed, failed and abandoned missions.
Column Name | Type |
---|---|
ACCOUNT_NAME | TEXT |
GAME_NAME | TEXT |
GAME_ID | NUMBER |
ENVIRONMENT_NAME | TEXT |
ENVIRONMENT_ID | NUMBER |
EVENT_DATE | DATE |
USER_ID | TEXT |
AGE_GROUP | TEXT |
GENDER | TEXT |
USER_COUNTRY | TEXT |
ACQUISITION_CHANNEL | TEXT |
PLAYER_START_DATE | DATE |
PLATFORM | TEXT |
CLIENT_VERSION | TEXT |
MISSION_NAME | TEXT |
MISSIONS_STARTED | NUMBER |
MISSIONS_COMPLETED | NUMBER |
MISSIONS_FAILED | NUMBER |
MISSIONS_ABANDONED | NUMBER |
INSERTED_TIMESTAMP | TIMESTAMP |
ACCOUNT_FACT_POTENTIAL_RETAINED_USERS_7_DAY
This table contains data on Users retained after installing in the last 7 days.
Column Name | Type |
---|---|
ACCOUNT_NAME | TEXT |
GAME_NAME | TEXT |
GAME_ID | NUMBER |
ENVIRONMENT_NAME | TEXT |
ENVIRONMENT_ID | NUMBER |
EVENT_DATE | DATE |
USER_ID | TEXT |
AGE_GROUP | TEXT |
GENDER | TEXT |
USER_COUNTRY | TEXT |
ACQUISITION_CHANNEL | TEXT |
PLAYER_START_DATE | DATE |
PLATFORM | TEXT |
CLIENT_VERSION | TEXT |
ACCOUNT_FACT_POTENTIAL_RETAINED_USERS_14_DAY
This table contains data on Users retained after installing in the last 14 days.
Column Name | Type |
---|---|
ACCOUNT_NAME | TEXT |
GAME_NAME | TEXT |
GAME_ID | NUMBER |
ENVIRONMENT_NAME | TEXT |
ENVIRONMENT_ID | NUMBER |
EVENT_DATE | DATE |
USER_ID | TEXT |
AGE_GROUP | TEXT |
GENDER | TEXT |
USER_COUNTRY | TEXT |
ACQUISITION_CHANNEL | TEXT |
PLAYER_START_DATE | DATE |
PLATFORM | TEXT |
CLIENT_VERSION | TEXT |
`ACCOUNT_FACT_PRODUCT_USERS_DAY
This table contains the number of products bought split out by the standard filter parameters. The data comes from the productsReceived
object in the transaction
event.
Column Name | Type |
---|---|
ACCOUNT_NAME | TEXT |
GAME_NAME | TEXT |
GAME_ID | NUMBER |
ENVIRONMENT_NAME | TEXT |
ENVIRONMENT_ID | NUMBER |
EVENT_DATE | DATE |
USER_ID | TEXT |
AGE_GROUP | TEXT |
GENDER | TEXT |
USER_COUNTRY | TEXT |
ACQUISITION_CHANNEL | TEXT |
PLAYER_START_DATE | DATE |
PLATFORM | TEXT |
CLIENT_VERSION | TEXT |
PRODUCT_CATEGORY | TEXT |
ACCOUNT_FACT_RETAINED_USERS_7_DAY
This table contains data on users retained after installing in the last 7 days.
Column Name | Type |
---|---|
ACCOUNT_NAME | TEXT |
GAME_NAME | TEXT |
GAME_ID | NUMBER |
ENVIRONMENT_NAME | TEXT |
ENVIRONMENT_ID | NUMBER |
EVENT_DATE | DATE |
USER_ID | TEXT |
AGE_GROUP | TEXT |
GENDER | TEXT |
USER_COUNTRY | TEXT |
ACQUISITION_CHANNEL | TEXT |
PLAYER_START_DATE | DATE |
PLATFORM | TEXT |
CLIENT_VERSION | TEXT |
ACCOUNT_FACT_RETAINED_USERS_14_DAY
This table contains data on users retained after installing in the last 14 days.
Column Name | Type |
---|---|
ACCOUNT_NAME | TEXT |
GAME_NAME | TEXT |
GAME_ID | NUMBER |
ENVIRONMENT_NAME | TEXT |
ENVIRONMENT_ID | NUMBER |
EVENT_DATE | DATE |
USER_ID | TEXT |
AGE_GROUP | TEXT |
GENDER | TEXT |
USER_COUNTRY | TEXT |
ACQUISITION_CHANNEL | TEXT |
PLAYER_START_DATE | DATE |
PLATFORM | TEXT |
CLIENT_VERSION | TEXT |
ACCOUNT_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 in this table, excluding aggregate dimensions, change during a session (for example, AGE_GROUP
or GENDER
), a new record will be created for that session.
Column Name | Type |
---|---|
ACCOUNT_NAME | TEXT |
GAME_NAME | TEXT |
GAME_ID | NUMBER |
ENVIRONMENT_NAME | TEXT |
ENVIRONMENT_ID | NUMBER |
EVENT_DATE | DATE |
USER_ID | TEXT |
AGE_GROUP | TEXT |
GENDER | TEXT |
USER_COUNTRY | TEXT |
ACQUISITION_CHANNEL | TEXT |
PLAYER_START_DATE | DATE |
PLATFORM | TEXT |
CLIENT_VERSION | TEXT |
SESSION_ID | TEXT |