Skip to content

promotion_reward

An event that occurs when a promotion reward is granted. You can use it to create metrics such as the number of promotion rewards granted and the number of grants 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))
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
cpiLogNo INT(INTEGER) Indicates the unique CPI log number of the promotion reward. Recorded based on the unique number (transaction ID) in cpi_log_v2, and can be used to identify each reward. (Example: 456060)
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)
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)
rewardProperty STRING Indicates the reward party of the promotion reward. Recorded based on the value that distinguishes the publisher (pub) and the advertiser (adv), and can be used to compare metrics by reward party. (Example: pub, adv)
type STRING Indicates the campaign type or friend invitation type of the promotion. Recorded based on the campaign or invitation type value, and can be used to compare promotion metrics by type. (Example: offerwall)
uaCode INT(INTEGER) Indicates the friend invitation code of the promotion. Recorded based on the friend invitation code value, and can be used to compare inflow metrics by invitation code. (Example: 0)
rewardItem STRING Indicates the items granted as the promotion reward. Recorded based on the granted reward item information (JSON), and can be used as supporting information for detailed analysis. (Example: {"[6,1]":24})
rewardResult STRING Indicates the grant result of the promotion reward. Recorded based on the reward grant result value, and can be used as supporting information for detailed analysis.
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)
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)
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})