promotion_open¶
This is an event that occurs when a promotional banner is exposed to the user's screen, and can be used to generate metrics such as the number of promotional impressions, click-to-exposure conversion rate, and number of impressions by promotion.
| 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) |
| 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)) |
| 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) |
| no | INT(INTEGER) | Unique number |
| promotionNo | INT(INTEGER) | Indicates the unique number of the promotional campaign with which the event is associated. It is recorded based on the promotion and coupon campaign unique number value, and can be used to compare indicators for each campaign. (Example: 202694) |
| bucketNo | INT(INTEGER) | Indicates the incoming image number of the promotion. It is recorded based on the promotional inflow image number value, and can be used to compare promotion performance by material. (Example: 1) |
| path | STRING | Indicates the inflow path of the event. Payments are recorded based on the billing module (M), Hive IAP(I), subscription (S), etc. Promotions are recorded based on path values such as banners and offer walls, and can be used to compare indicators for each path. (Example: M, I, banner, offerwall) |
| pubAppIndex | INT(INTEGER) | Indicates the number of the promotion's advertising medium app. It is recorded based on a numeric value (App Index) that is mapped 1:1 with App Center appId, and can be used to compare promotion indicators by medium. (Example: 2624) |
| advAppIndex | INT(INTEGER) | Indicates the number of the advertiser app for the promotion. It is recorded based on a numeric value (App Index) that is mapped 1:1 with App Center appId, and can be used to compare promotion indicators for each app advertiser. (Example: 5020) |
| userDeviceModel | STRING | Indicates the model of the user's terminal when a promotion occurs. It is recorded based on the device model value, and can be used to compare promotion indicators by device model. (Example: SM-A515F) |
| userDeviceOs | STRING | Indicates OS on the user terminal when a promotion occurs. It is recorded based on the terminal OS value, and can be used to compare promotion indicators for each OS. (Example: android, iOS) |
| userDeviceOsVersion | STRING | Indicates the OS version of the user's terminal when a promotion occurs. It is recorded based on the terminal OS version value, and OS can be used to compare promotion indicators by version. (Example: 10, 8.1.0) |
| language | STRING | Indicates the language in which the promotion occurred. It is recorded based on the user language value (lowercase) and can be used to compare promotion indicators by language. (Example: ko, zh-hant) |
| pubAppVersion | STRING | Indicates the version of the promotion's advertising medium app. It is recorded based on the app version value of the media game that exposed the advertisement, and can be used to compare the status by media version. (Example: 5.3.0) |
| additionalInfo | STRING | Indicates additional information from the promotion log. It is recorded based on the value of additional information in the JSON format sent along with the promotion log, and can be used as auxiliary information for detailed analysis. (Example: {"server":1}) |
| typeCamp | STRING | Indicates the campaign type of the promotion. Hive is recorded based on the promotion type value registered in the promotion information (lowercase, ua for UA campaigns), and can be used to compare performance by campaign type. (Example: notice, ua) |
| typeBanner | STRING | Indicates the banner type of the promotion. Hive is recorded based on the banner type value registered in the promotion information (lowercase, null for UA campaigns), and can be used to compare performance by banner type. (Example: great) |
| adv_gameindex | INT(INTEGER) | Indicates the advertiser game number of the promotion open. It is recorded based on numeric values (Game Index) that are mapped 1:1 with App Center GAMEID, and can be used to compare metrics for each advertiser's game. (Example: 539) |