ドキュメント

​
​

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

このページの問題を報告する