Data Access available views

Explore the tables and columns available in Snowflake for querying your Analytics data through Data Access.

읽는 시간 5분

최근 업데이트: 8달 전

Through the Data Access feature, you gain access to a number of views containing your account's data.

참고

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

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`

Data Access available views

ACCOUNT_EVENTS

Column Name

Type

ACCOUNT_EVENT_JSON_KEYS

Column Name

Type

ACCOUNT_GAMES

Column Name

Type

ACCOUNT_USERS

Column Name

Type

ACCOUNT_FACT_EVENT_TYPE_USERS_DAY

Column Name

Type

ACCOUNT_FACT_WAU_USERS

Column Name

Type

ACCOUNT_FACT_MAU_USERS

Column Name

Type

ACCOUNT_FACT_MISSION_USERS_DAY

Column Name

Type

ACCOUNT_FACT_POTENTIAL_RETAINED_USERS_7_DAY

Column Name

Type

ACCOUNT_FACT_POTENTIAL_RETAINED_USERS_14_DAY

Column Name

Type

`ACCOUNT_FACT_PRODUCT_USERS_DAY

Column Name

Type

ACCOUNT_FACT_RETAINED_USERS_7_DAY

Column Name

Type

ACCOUNT_FACT_RETAINED_USERS_14_DAY

Column Name

Type

ACCOUNT_FACT_USER_SESSIONS_DAY

Column Name

Type

`ACCOUNT_EVENTS`

`ACCOUNT_EVENT_JSON_KEYS`

`ACCOUNT_GAMES`

`ACCOUNT_USERS`

`ACCOUNT_FACT_EVENT_TYPE_USERS_DAY`

`ACCOUNT_FACT_WAU_USERS`

`ACCOUNT_FACT_MAU_USERS`

`ACCOUNT_FACT_MISSION_USERS_DAY`

`ACCOUNT_FACT_POTENTIAL_RETAINED_USERS_7_DAY`

`ACCOUNT_FACT_POTENTIAL_RETAINED_USERS_14_DAY`

`ACCOUNT_FACT_RETAINED_USERS_7_DAY`

`ACCOUNT_FACT_RETAINED_USERS_14_DAY`

`ACCOUNT_FACT_USER_SESSIONS_DAY`