Skip to content

coupon_use

An event that occurs when a user successfully uses a coupon. You can use it to create metrics such as the number of coupon uses, the number of users who used coupons, and the number of uses 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)
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))
lang STRING Indicates the language value when the event occurred. Recorded based on the app or device language (ISO 639 alpha-2, lowercase), and can be used to compare metrics by language. (Example: ko, en)
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))
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)
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)
userNo INT(INTEGER) Indicates the ID number of the user who used the coupon. Recorded based on the identifier (userId) of the user who used the coupon, and can be used to count the users who used coupons with a distinct count aggregation. (Example: 1234567)
couponId STRING Indicates the ID number of the coupon that was used. Recorded based on the ID number of the coupon used, and can be used to compare usage metrics by coupon. (Example: 1006CLTT)