subscription_cancel
An event that occurs when a user cancels a product subscription directly, or when the subscription is automatically canceled because it reaches its expiration. You can use it to create metrics such as the number of subscription cancellations, the number of users who canceled, the cancellation rate by product, and the estimated revenue loss from cancellations.
| 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) |
| 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)) |
| osVer | STRING | Indicates the OS version of the user's device when the event occurred. Recorded based on the device's operating system version, and can be used to compare metrics by OS version. (Example: 9.2, 16.3.1) |
| 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) |
| 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) |
| 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) |
| 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)) |
| transactionId | STRING | Indicates the unique number that identifies a payment. Recorded based on the receipt ID issued by the market for regular payments and refunds, and on the identifier issued per subscription for subscriptions, and can be used to count payments with a distinct count aggregation or to link purchases with refund and cancellation events. (Example: GPA.1234-5678-9101-12345) |
| productId | STRING | Indicates the ID of the purchased product. Recorded based on the unique product ID registered in Hive Billing, and can be used to compare revenue and the number of purchases by product. (Example: com.sample.analytics.dia1000) |
| productPrice | INT(FLOAT) | Indicates the payment amount for a single product. Recorded based on the product price sent by the client at the time of payment (supplementing productId), and can be used to analyze product prices and payment volume with sum and average aggregations. (Example: 1.99) |
| currency | STRING | Indicates the payment currency at the time of purchase. Recorded based on the payment currency value, and can be used to separate revenue by currency. (Example: KRW, USD, JPY) |
| subRenewalCount | INT(INTEGER) | Indicates the number of subscription renewals up to the time of cancellation. Recorded based on the cumulative number of times the subscription was renewed, and can be used to calculate the average subscription duration before cancellation with an average aggregation. |
| subStartDateTime | TIMESTAMP | Indicates the start date and time of the subscription renewal. Recorded based on the start time of the subscription renewal for that renewal period (for Google and Amazon, the date and time of the receipt verification request), and can be used to analyze subscription periods and renewal cycles. (Example: 2026-07-21 15:16:17) |
| subEndDateTime | TIMESTAMP | Indicates the end date and time of the subscription renewal. Recorded based on the end time of the subscription renewal for that renewal period, and can be used to analyze subscription periods and renewal cycles. (Example: 2026-07-20 15:16:17) |