기술 자료

​
​

Development

User Acquisition

Monetization

산업 분야

Analytics

Unity SDK

Client API

Analytics

이 페이지는 선택한 언어로 제공되지 않습니다.
LiveOps
​
​
Analytics
  • Overview
  • Get started
  • Pricing
  • Concepts
  • Tutorials
  • Reference
    • Standard events
    • Standard audiences
    • Reserved parameter names
    • Data Explorer V1 metrics
    • Data Explorer V2 measures and metrics
    • SDK Event class
    • SDK CustomEvent class
    • SDK behavior
    • SQL Data Explorer queryable tables
    • SQL Data Explorer cookbook
    • Data Access available views
    • Glossary
  • Privacy and consent
  • FAQ
  1. Unity Analytics

Data Access available views

Explore the tables and columns available in Snowflake for querying your Analytics data through Data Access.
읽는 시간 5분
최근 업데이트: 9달 전
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
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
Copyright © 2026 Unity Technologies
법률 정보개인정보 처리방침쿠키Documentation Terms of Use개인 정보 판매 또는 공유 금지개인정보 보호 선택(쿠키 설정)

'Unity', Unity 로고 및 기타 Unity 상표는 미국 및 기타 지역 내 Unity Technologies 또는 그 계열사의 상표 또는 등록상표입니다(자세한 내용은 여기에서 확인하세요). 기타 명칭 또는 브랜드는 해당 소유자의 상표입니다.

일부 페이지는 편의를 위해 기계 번역되었으며 부정확한 내용이 있을 수 있습니다. 정보가 상충되는 경우, 영어 버전을 우선으로 참조하세요.

  • 보고 있는 페이지

    • 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_PRODUCT_USERS_DAY

    • ACCOUNT_FACT_RETAINED_USERS_7_DAY

    • ACCOUNT_FACT_RETAINED_USERS_14_DAY

    • ACCOUNT_FACT_USER_SESSIONS_DAY

이 페이지의 문제 보고