promotion_install
An event that occurs when the app is installed through a promotion. You can use it to create metrics such as the number of promotion installs, the number of new installs, and the number of installs by media.
| 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) |
| 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) |
| newUser | STRING | Indicates whether the user is a new user. Recorded based on userId issuance, and can be used to calculate the number of new users (NU). (Example: Y (new), N (existing), U (unknown)) |
| mediaId | STRING | Indicates the media identification information of the promotion install. Recorded based on the numeric value (App Index) of the media app that displayed the ad, and can be used to compare install metrics by media. |
| mediaIdCompany | STRING | Indicates the media company of the promotion install. Recorded based on the value that distinguishes the media company, and can be used to compare install metrics by media company. (Example: com2us_platform) |
| promotionType | STRING | Indicates the promotion type of the promotion install. Recorded based on the promotion type value, such as cross full-screen banner, offerwall, or UA, and can be used to compare install performance by promotion type. (Example: cross-great, offerwall-normal, ua-cpi) |
| deviceModel | STRING | Indicates the model name of the user's device at the time of the promotion install. Recorded based on the device model value sent by the client, and can be used to compare install metrics by device model. (Example: iPhone) |
| adId | STRING | Indicates the ID number of the advertiser app of the promotion install. 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 install metrics by advertiser. (Example: 2624) |
| adCompany | STRING | Indicates the advertiser company of the promotion install. Recorded based on the value that distinguishes the advertiser company, and can be used to compare metrics by advertiser company. (Example: com2us platform) |
| adAppId | STRING | Indicates the unique ID of the advertiser app of the promotion install. Recorded based on the APPID of the advertiser app registered in Hive Console > Project Settings > App ID, and can be used to compare install metrics by advertiser app. (Example: com.sample.analytics.google.global.android.common) |
| adAppIdGroup | STRING | Indicates the advertiser project of the promotion install. Recorded based on the GAMEID value registered in Hive Console > Project Settings > App ID, and can be used to compare performance metrics by advertiser project. (Example: com.sample.analytics) |
| mediadAppId | STRING | Indicates the unique ID of the media app of the promotion install. Recorded based on the APPID of the media app registered in Hive Console > Project Settings > App ID, and can be used to compare install metrics by media app. (Example: com.sample.analytics.google.global.android.common) |
| mediadAppIdGroup | STRING | Indicates the media project of the promotion install. Recorded based on the GAMEID value registered in Hive Console > Project Settings > App ID, and can be used to compare metrics by media app group. (Example: com.sample.analytics) |
| 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) |