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 NameType
ACCOUNT_NAMETEXT
GAME_NAMETEXT
GAME_IDNUMBER
ENVIRONMENT_NAMETEXT
ENVIRONMENT_IDNUMBER
LOAD_IDNUMBER
EVENT_IDNUMBER
EVENT_TIMESTAMPTIMESTAMP
EVENT_NAMETEXT
PLAYER_START_DATEDATE
ACQUISITION_CHANNELTEXT
USER_COUNTRYTEXT
USER_IDTEXT
EVENT_JSONVARIANT
LOADED_TIMESTAMPTIMESTAMP

ACCOUNT_EVENT_JSON_KEYS

This table contains data on the event fields that are used for your games.

Column NameType
ACCOUNT_NAMETEXT
GAME_NAMETEXT
GAME_IDNUMBER
ENVIRONMENT_NAMETEXT
FIELD_NAMETEXT
INSERTED_TIMESTAMPTIMESTAMP

ACCOUNT_GAMES

This table lists all of the games that exist under your account.

Column NameType
ACCOUNT_NAMETEXT
GAME_NAMETEXT
GAME_IDNUMBER
ENVIRONMENT_NAMETEXT
ENVIRONMENT_IDNUMBER
UNITY_PROJECT_IDTEXT

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 NameType
ACCOUNT_NAMETEXT
GAME_NAMETEXT
GAME_IDNUMBER
ENVIRONMENT_NAMETEXT
ENVIRONMENT_IDNUMBER
USER_IDTEXT
BIRTH_YEARNUMBER
LAST_SESSION_IDTEXT
LAST_EVENT_TIMESTAMPTIMESTAMP
LAST_PLATFORMTEXT
COUNTRYTEXT
GENDERTEXT
START_DATEDATE
ACQUISITION_CHANNELTEXT
LAST_LOCALETEXT

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 NameType
ACCOUNT_NAMETEXT
GAME_NAMETEXT
GAME_IDNUMBER
ENVIRONMENT_NAMETEXT
ENVIRONMENT_IDNUMBER
EVENT_DATEDATE
USER_IDTEXT
AGE_GROUPTEXT
GENDERTEXT
USER_COUNTRYTEXT
ACQUISITION_CHANNELTEXT
PLAYER_START_DATEDATE
PLATFORMTEXT
CLIENT_VERSIONTEXT
EVENT_NAMETEXT
NUMBER_OF_EVENTSNUMBER
INSERTED_TIMESTAMPTIMESTAMP

ACCOUNT_FACT_WAU_USERS

This table lists all of the users that have sent in an event in the last week.

Column NameType
ACCOUNT_NAMETEXT
GAME_NAMETEXT
GAME_IDNUMBER
ENVIRONMENT_NAMETEXT
ENVIRONMENT_IDNUMBER
EVENT_DATEDATE
USER_IDTEXT
AGE_GROUPTEXT
GENDERTEXT
USER_COUNTRYTEXT
ACQUISITION_CHANNELTEXT
PLAYER_START_DATEDATE
PLATFORMTEXT
CLIENT_VERSIONTEXT

ACCOUNT_FACT_MAU_USERS

This table lists all of the users that have sent in an event in the last 30 days.

Column NameType
ACCOUNT_NAMETEXT
GAME_NAMETEXT
GAME_IDNUMBER
ENVIRONMENT_NAMETEXT
ENVIRONMENT_IDNUMBER
EVENT_DATEDATE
USER_IDTEXT
AGE_GROUPTEXT
GENDERTEXT
USER_COUNTRYTEXT
ACQUISITION_CHANNELTEXT
PLAYER_START_DATEDATE
PLATFORMTEXT
CLIENT_VERSIONTEXT

ACCOUNT_FACT_MISSION_USERS_DAY

This counts how often a user has started, completed, failed and abandoned missions.

Column NameType
ACCOUNT_NAMETEXT
GAME_NAMETEXT
GAME_IDNUMBER
ENVIRONMENT_NAMETEXT
ENVIRONMENT_IDNUMBER
EVENT_DATEDATE
USER_IDTEXT
AGE_GROUPTEXT
GENDERTEXT
USER_COUNTRYTEXT
ACQUISITION_CHANNELTEXT
PLAYER_START_DATEDATE
PLATFORMTEXT
CLIENT_VERSIONTEXT
MISSION_NAMETEXT
MISSIONS_STARTEDNUMBER
MISSIONS_COMPLETEDNUMBER
MISSIONS_FAILEDNUMBER
MISSIONS_ABANDONEDNUMBER
INSERTED_TIMESTAMPTIMESTAMP

ACCOUNT_FACT_POTENTIAL_RETAINED_USERS_7_DAY

This table contains data on Users retained after installing in the last 7 days.

Column NameType
ACCOUNT_NAMETEXT
GAME_NAMETEXT
GAME_IDNUMBER
ENVIRONMENT_NAMETEXT
ENVIRONMENT_IDNUMBER
EVENT_DATEDATE
USER_IDTEXT
AGE_GROUPTEXT
GENDERTEXT
USER_COUNTRYTEXT
ACQUISITION_CHANNELTEXT
PLAYER_START_DATEDATE
PLATFORMTEXT
CLIENT_VERSIONTEXT

ACCOUNT_FACT_POTENTIAL_RETAINED_USERS_14_DAY

This table contains data on Users retained after installing in the last 14 days.

Column NameType
ACCOUNT_NAMETEXT
GAME_NAMETEXT
GAME_IDNUMBER
ENVIRONMENT_NAMETEXT
ENVIRONMENT_IDNUMBER
EVENT_DATEDATE
USER_IDTEXT
AGE_GROUPTEXT
GENDERTEXT
USER_COUNTRYTEXT
ACQUISITION_CHANNELTEXT
PLAYER_START_DATEDATE
PLATFORMTEXT
CLIENT_VERSIONTEXT

`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 NameType
ACCOUNT_NAMETEXT
GAME_NAMETEXT
GAME_IDNUMBER
ENVIRONMENT_NAMETEXT
ENVIRONMENT_IDNUMBER
EVENT_DATEDATE
USER_IDTEXT
AGE_GROUPTEXT
GENDERTEXT
USER_COUNTRYTEXT
ACQUISITION_CHANNELTEXT
PLAYER_START_DATEDATE
PLATFORMTEXT
CLIENT_VERSIONTEXT
PRODUCT_CATEGORYTEXT

ACCOUNT_FACT_RETAINED_USERS_7_DAY

This table contains data on users retained after installing in the last 7 days.

Column NameType
ACCOUNT_NAMETEXT
GAME_NAMETEXT
GAME_IDNUMBER
ENVIRONMENT_NAMETEXT
ENVIRONMENT_IDNUMBER
EVENT_DATEDATE
USER_IDTEXT
AGE_GROUPTEXT
GENDERTEXT
USER_COUNTRYTEXT
ACQUISITION_CHANNELTEXT
PLAYER_START_DATEDATE
PLATFORMTEXT
CLIENT_VERSIONTEXT

ACCOUNT_FACT_RETAINED_USERS_14_DAY

This table contains data on users retained after installing in the last 14 days.

Column NameType
ACCOUNT_NAMETEXT
GAME_NAMETEXT
GAME_IDNUMBER
ENVIRONMENT_NAMETEXT
ENVIRONMENT_IDNUMBER
EVENT_DATEDATE
USER_IDTEXT
AGE_GROUPTEXT
GENDERTEXT
USER_COUNTRYTEXT
ACQUISITION_CHANNELTEXT
PLAYER_START_DATEDATE
PLATFORMTEXT
CLIENT_VERSIONTEXT

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 NameType
ACCOUNT_NAMETEXT
GAME_NAMETEXT
GAME_IDNUMBER
ENVIRONMENT_NAMETEXT
ENVIRONMENT_IDNUMBER
EVENT_DATEDATE
USER_IDTEXT
AGE_GROUPTEXT
GENDERTEXT
USER_COUNTRYTEXT
ACQUISITION_CHANNELTEXT
PLAYER_START_DATEDATE
PLATFORMTEXT
CLIENT_VERSIONTEXT
SESSION_IDTEXT