ad_open¶
This is an event that occurs when an ad is exposed to a user, and can be used to generate metrics such as the number of ad impressions, the number of users who view the ad, and the number of impressions by ad position.
| Attribute name | Data type | Description |
|---|---|---|
| dateTime | TIMESTAMP | Indicates the date and time when the event occurred. It is recorded based on the time of event occurrence, and can be used as a basis for period unit (day/week/month/hour/minute) aggregation and date range searches. (Example: 2023-05-09 19:30:35) |
| eventName | STRING | Indicates a name that identifies the event. Since all events are loaded together in one source log, this value identifies which event it is and can be used as a standard for searching data on an event-by-event basis. (Example: app_login) |
| userId | STRING | Indicates the user identifier based on the account that triggered the event. It is recorded based on the unique user ID in the game, and can be used to count the number of unique users such as AU by deduplicating the number. |
| identifierProvider | STRING | Indicates the user identifier issuance system, and "hive" is fixed. |
| deviceId | STRING | Indicates the user identifier based on the terminal that generated the event. Each time an app is installed, it is recorded based on the instance value issued for each device, and can be used to count the number of unique devices (the number of terms and conditions agreed, etc.) by deduplicating the number. (Example: 33333333) |
| appIdGroup | STRING | Indicates the project where the event occurred. Hive is recorded based on the GAMEID value registered in the console app center, and can be used to compare indicators by dividing them by project when viewing multiple projects together. (Example: com.sample.analytics) |
| appId | STRING | Indicates the unique ID of the app where the event occurred. Hive is recorded based on APPID registered in the console app center, and can be used to distinguish indicators for each app. (Example: com.sample.analytics.google.global.android.common) |
| country | STRING | Indicates the country of the user identified at the time the event occurred. ISO 3166-1 alpha-2 It is recorded in uppercase format and can be used to compare the number of users, sales, retention, etc. by country. (Example: KR, US) |
| serverId | STRING | Indicates the game server the user connected to when the event occurred. It is recorded based on the server identifier sent by the game, and can be used to compare the number of users, sales, and retention by server. (Example: KR, GLOBAL) |
| model | STRING | Indicates the model name of the user terminal at the time the event occurred. It is recorded based on the terminal model value sent by the client, and can be used to compare indicators by device model. (Example: iPhone 12 Pro, SHW-M250S) |
| appVer | STRING | Indicates the game app version at the time the event occurred. It is recorded based on app version information, and can be used with the os attribute to compare users by app version. (e.g. 4.3.3, 1.6.5) |
| market | STRING | Indicates the market where the user installed the game when the event occurred. It is recorded based on the market value where the app is installed or serviced, and can be used to compare indicators by market. (Example: GO(Google Play), AP(Apple App Store), HS(direct distribution)) |
| osVer | STRING | Indicates the OS version of the user terminal at the time the event occurred. It is recorded based on the terminal's operating system version value, and OS can be used to compare indicators by version. (Example: 9.2, 16.3.1) |
| lang | STRING | Indicates the language value at the time the event occurred. It is recorded based on the game or device language value (ISO 639 alpha-2 lowercase), and can be used to compare indicators by language. (Example: ko, en) |
| os | STRING | Indicates the operating system of the user terminal at the time the event occurred. It is recorded based on the platform value sent by the client, and can be used to compare indicators by OS. (Example: A(Android), I(iOS)) |
| clientIp | STRING | Indicates IP of the user terminal where the event occurred. It is recorded based on the masked value of the last section of IP, and can be used to query data such as the number of terminals for a specific IP band. (Example: 127.0.0.x) |
| sdkVer | STRING | Indicates the Hive SDK version at the time the event occurred. It is recorded based on the Hive SDK version value applied to the client, and can be used to compare the data collection status by SDK version. (Example: 4.16.2.2) |
| adNetwork | STRING | Indicates the advertising network from which the ad was exposed or viewed. It is recorded based on the value of the network that provided the advertisement, and can be used to compare advertising indicators by network. (Example: admob) |
| uniqueSessionKey | STRING | Indicates a unique session key that identifies a single ad viewing. It is recorded based on the ad viewing session key value, and can be used to count the number of unique ad viewing sessions through deduplication. |
| adUnitId | STRING | Indicates the ad unit unique key for the viewed ad. It is recorded based on the unique key of the ad identified in mediation, and can be used to compare metrics for each ad unit. |
| rewardType | STRING | Indicates the type of reward item paid after watching the advertisement. When advertising compensation is paid, it is recorded based on the reward item type value, and can be used to compare indicators by reward type. (Example: coins) |
| rewardAmount | INT(FLOAT) | Indicates the quantity of reward items paid after watching the advertisement. When advertising compensation is paid, it is recorded based on the compensation quantity value, and can be used to calculate the compensation payment amount by sum or average. (Example: 10.0) |
| adPlacement | STRING | Indicates where the ad was exposed or viewed. It is recorded based on the ad placement value sent from the game, and can be used to compare viewing and click indicators by ad location. (Example: inapp_banner) |
| adSource | STRING | Indicates information about the advertising module linked to the advertisement. It is recorded based on the value of the advertising module linked to the game, and can be used to compare indicators for each advertising module. (Example: ADOP, ADX) |
| ecpm | INT(FLOAT) | Indicates the expected revenue per 1,000 ad impressions. It is recorded based on the eCPM value calculated when advertising sales are generated, and can be used to compare profitability by advertising network and advertising location. (Example: 10.0) |