promotion_open
An event that occurs when a promotion banner is displayed on the user's screen. You can use it to create metrics such as the number of promotion impressions, the impression-to-click conversion rate, and the number of impressions by promotion.
| Attribute name | Data type | Description |
|---|---|---|
| dateTime | TIMESTAMP | Indicates the date and time when the event occurred. Recorded based on the event time, and can be used as the basis for aggregation by period unit (day/week/month/hour/minute) and date range queries. (Example: 2023-05-09 19:30:35) |
| eventName | STRING | Indicates the name that identifies the event. Because all events are loaded together into a single source log, this value identifies which event it is, and it can be used as the basis for querying data by event. (Example: app_login) |
| userId | STRING | Indicates the account-based identifier of the user who triggered the event. Recorded based on the user's unique ID in the app, and can be used to count unique users, such as AU, with a distinct count aggregation. |
| identifierProvider | STRING | Indicates the system that issued the user identifier. The value is always "hive". |
| deviceId | STRING | Indicates the device-based identifier of the user who triggered the event. Recorded based on the instance value issued for each device every time the app is installed, and can be used to count unique devices (such as the number of terms agreements) with a distinct count aggregation. (Example: 33333333) |
| appIdGroup | STRING | Indicates the project where the event occurred. Recorded based on the GAMEID value registered in Hive Console > Project Settings > App ID, and can be used to compare metrics by project when you query multiple projects together. (Example: com.sample.analytics) |
| appId | STRING | Indicates the unique ID of the app where the event occurred. Recorded based on the APPID registered in Hive Console > Project Settings > App ID, and can be used to distinguish metrics by app. (Example: com.sample.analytics.google.global.android.common) |
| country | STRING | Indicates the user's country identified when the event occurred. Recorded in ISO 3166-1 alpha-2 uppercase format, and can be used to compare the number of users, revenue, retention, and so on by country. (Example: KR, US) |
| serverId | STRING | Indicates the app server the user was connected to when the event occurred. Recorded based on the server identifier sent by the app, and can be used to compare the number of users, revenue, and retention by server. (Example: KR, GLOBAL) |
| market | STRING | Indicates the market where the user installed the app when the event occurred. Recorded based on the market where the app is installed or serviced, and can be used to compare metrics by market. (Example: GO (Google Play), AP (Apple App Store), HS (direct distribution)) |
| os | STRING | Indicates the operating system of the user's device when the event occurred. Recorded based on the platform value sent by the client, and can be used to compare metrics by OS. (Example: A (Android), I (iOS)) |
| clientIp | STRING | Indicates the IP of the user's device where the event occurred. Recorded with the last segment of the IP masked, and can be used to query data such as the number of devices by IP range. (Example: 127.0.0.x) |
| sdkVer | STRING | Indicates the Hive Axyl SDK version when the event occurred. Recorded based on the Hive Axyl SDK version applied to the client, and can be used to compare data collection status by SDK version. (Example: 1.0.0) |
| no | INT(INTEGER) | Unique number |
| promotionNo | INT(INTEGER) | Indicates the unique number of the promotion campaign associated with the event. Recorded based on the unique number of the promotion or coupon campaign, and can be used to compare metrics by campaign. (Example: 202694) |
| bucketNo | INT(INTEGER) | Indicates the inflow image number of the promotion. Recorded based on the promotion inflow image number, and can be used to compare promotion performance by creative. (Example: 1) |
| path | STRING | Indicates the inflow path of the event. Recorded based on the path value, such as billing module (M), Hive IAP (I), or subscription (S) for payments and banner or offerwall for promotions, and can be used to compare metrics by path. (Example: M, I, banner, offerwall) |
| pubAppIndex | INT(INTEGER) | Indicates the ID number of the promotion's ad media app. Recorded based on the numeric value (App Index) mapped 1:1 to the appId in Project Settings > App ID, and can be used to compare promotion metrics by media. (Example: 2624) |
| advAppIndex | INT(INTEGER) | Indicates the ID number of the promotion's advertiser app. Recorded based on the numeric value (App Index) mapped 1:1 to the appId in Project Settings > App ID, and can be used to compare promotion metrics by advertiser app. (Example: 5020) |
| userDeviceModel | STRING | Indicates the model of the user's device when the promotion occurred. Recorded based on the device model value, and can be used to compare promotion metrics by device model. (Example: SM-A515F) |
| userDeviceOs | STRING | Indicates the OS of the user's device when the promotion occurred. Recorded based on the device OS value, and can be used to compare promotion metrics by OS. (Example: android, iOS) |
| userDeviceOsVersion | STRING | Indicates the OS version of the user's device when the promotion occurred. Recorded based on the device OS version value, and can be used to compare promotion metrics by OS version. (Example: 10, 8.1.0) |
| language | STRING | Indicates the language when the promotion occurred. Recorded based on the user's language value (lowercase), and can be used to compare promotion metrics by language. (Example: ko, zh-hant) |
| pubAppVersion | STRING | Indicates the version of the promotion's ad media app. Recorded based on the version of the media app that displayed the ad, and can be used to compare status by media version. (Example: 5.3.0) |
| additionalInfo | STRING | Indicates additional information in the promotion log. Recorded based on the supplementary information in JSON format sent with the promotion log, and can be used as supporting information for detailed analysis. (Example: {"server":1}) |
| typeCamp | STRING | Indicates the campaign type of the promotion. Recorded based on the promotion type registered in the Hive 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. Recorded based on the banner type registered in the Hive 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 app number of the promotion open. Recorded based on the numeric value (Game Index) mapped 1:1 to the GAMEID in Project Settings > App ID, and can be used to compare metrics by advertiser app. (Example: 539) |