subscription_cancel¶
This is an event that occurs when a product's subscription is canceled directly by the user or automatically canceled due to the expiration period. It can be used to generate metrics such as the number of subscription cancellations, number of canceled users, cancellation rate by product, and expected sales loss due to cancellation.
| 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) |
| os | STRING | Indicates the operating system of the user terminal at the time the event occurred. It is recorded based on the platform value sent by the client, and can be used to compare indicators by OS. (Example: A(Android), I(iOS)) |
| osVer | STRING | Indicates the OS version of the user terminal at the time the event occurred. It is recorded based on the terminal's operating system version value, and OS can be used to compare indicators by version. (Example: 9.2, 16.3.1) |
| 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) |
| 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) |
| lang | STRING | Indicates the language value at the time the event occurred. It is recorded based on the game or device language value (ISO 639 alpha-2 lowercase), and can be used to compare indicators by language. (Example: ko, en) |
| 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)) |
| transactionId | STRING | Indicates a unique number that identifies the payment. General payments and refunds are recorded based on the receipt ID issued by the market, and subscriptions are recorded based on the identifier value issued per subscription. This can be used to count the number of payments or connect purchases and refund/cancellation events by removing duplicates. (Example: GPA.1234-5678-9101-12345) |
| productId | STRING | Indicates ID of the purchased product. Hive is recorded based on the unique product ID value registered in billing, and can be used to compare sales and number of purchases by product. (Example: com.sample.analytics.dia1000) |
| productPrice | INT(FLOAT) | Indicates the payment amount based on one product. It is recorded based on the product price value delivered by the client at the time of payment (auxiliary to productId), and can be used to analyze product price and payment size through sum/average aggregation. (Example: 1.99) |
| currency | STRING | Indicates the payment currency unit at the time of purchase. It is recorded based on the payment currency value and can be used to distinguish sales by currency. (Example: KRW, USD, JPY) |
| subRenewalCount | INT(INTEGER) | Indicates the number of subscription renewals until cancellation. Subscriptions are recorded based on the cumulative number of renewals, and the average count can be used to calculate the average subscription maintenance period before cancellation. |
| subStartDateTime | TIMESTAMP | Indicates the subscription renewal start date and time. It is recorded based on the subscription renewal start time for the relevant period (receipt verification request date and time for Google and Amazon), and can be used to analyze the subscription period and renewal cycle. (Example: 2026-07-21 15:16:17) |
| subEndDateTime | TIMESTAMP | Indicates the subscription renewal end date and time. It is recorded based on the subscription renewal end time for the relevant period, and can be used to analyze the subscription period and renewal cycle. (Example: 2026-07-20 15:16:17) |