promotion_reward¶
This is an event that occurs when promotional rewards are paid out, and can be used to create metrics such as the number of promotional reward payments and the number of payments per 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)) |
| 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 |
| cpiLogNo | INT(INTEGER) | Indicates the CPI log unique number of the promotional reward. It is recorded based on the unique number of cpi_log_v2 (transaction ID) and can be used to identify compensation cases. (Example: 456060) |
| 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) |
| 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) |
| rewardProperty | STRING | Indicates the reward entity of the promotional reward. It is recorded based on the publisher (pub) and advertiser (adv) classification values, and can be used to compare indicators by reward entity. (Example: pub, adv) |
| type | STRING | Indicates the campaign type or friend invitation type of the promotion. It is recorded based on campaign and invitation type values, and can be used to compare promotion indicators by type. (Example: offerwall) |
| uaCode | INT(INTEGER) | Indicates the promotion's invite-a-friend code. It is recorded based on the friend invitation code value, and can be used to compare inflow indicators by invitation code. (Example: 0) |
| rewardItem | STRING | Indicates an item provided as a promotional reward. It is recorded based on the paid compensation item information (JSON) value, and can be used as auxiliary information for detailed analysis. (Example: {"[6,1]":24}) |
| rewardResult | STRING | Indicates the payment result of promotional rewards. It is recorded based on the compensation payment result value and can be used as auxiliary information for detailed analysis. |
| 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) |
| 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) |
| 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}) |