Log Data Migration Guide¶
All log data accumulated over the entire period since the game's launch will be mapped to taxonomy-based events and migrated. Please refer to the event names below, which are derived from the existing logs using filter conditions. No additional action is required on your part for the migration, and if you have any further questions, please contact technical support (tam@com2us.com).
Basic Logs → Event Data¶
| Existing Log Table | Table Description | Filter Condition | New Event Name | New Event Description |
|---|---|---|---|---|
t_hive_purchase_fail_log | A table that stores information about failed item grants after a consumable product (item) purchase | - | hive_usable_product_fail | An event that fires when a product purchase fails |
t_hive_promotion_open_log | Promotion open log collected when using the Hive promotion feature | - | hive_promotion_open | An event that fires when a promotion is displayed on the user's screen |
t_hive_promotion_click_log | Promotion click log collected when using the Hive promotion feature | - | hive_promotion_click | An event that fires when a promotion is clicked |
t_hive_purchase_item_send_log | A table that stores information about items successfully granted to a user after a consumable product (item) purchase | - | hive_usable_product_grant | An event that fires when an item is granted after payment is completed |
t_hive_concurrent_user_log | A table that receives and stores connection information from clients with the Hive SDK applied, sent every 2 minutes ※ Not collected when the 'Minimize Network Communication' option is enabled in the Hive console. | - | hive_session_maintain | An event sent every 2 minutes to report connection status after login |
t_hive_unionauth_disconnect_log | A table that stores information about the disconnection of a linked IdP (external account) integrated through the Hive authentication feature | - | hive_unionauth_disconnect | An event that fires when an integrated authentication link is disconnected |
t_hive_coupon_use_log | A table that stores information about a user entering and using a coupon code (receiving a reward) through the Hive coupon feature | - | hive_coupon_use | An event that fires when a coupon is used |
t_hive_pre_event_regist_log | A table that stores information about a user participating in (registering for) a game pre-registration event | - | hive_pre_event_register | An event that fires when a user applies for a pre-registration event |
t_hive_promotion_reward_v2_log | A table that stores information about rewards granted to a user through the Hive promotion feature | - | hive_promotion_reward | An event that fires when a promotion reward is granted |
t_hive_purchase_refund_log | A table that stores information about cancelled consumable product purchases | - | hive_product_refund | An event that fires when a product purchase is refunded |
t_hive_webshop_access_log | A table that stores information about a user accessing the web store when using the Hive web store (webshop) feature | - | hive_webstore_access | An event that fires when a user accesses the web store page |
t_hive_remoteplay_ccu_user | A table that stores concurrent connection information for a user connecting (connect) to or logging in (login) to remote play through the Hive remote play feature | - | hive_remote_play_connect | An event that fires when a host PC connection succeeds in remote play |
| - | hive_remote_play_login | An event that fires when Hive login succeeds in remote play | ||
t_hive_push_open_log | A table that stores information about a user opening a push notification when using the Hive notification feature | - | hive_push_open | An event that fires when a user taps a push notification to enter the app |
t_hive_promotion_install_log | Promotion install log collected when using the Hive promotion feature | - | hive_promotion_install | An event that fires when the app is installed through a promotion |
t_hive_did_log | A table that stores information about changes to a user's device identifier (DID) | - | hive_device_change | An event that fires when a change is detected in device-related information (app version, advertising ID, device model, root/jailbreak status) |
t_hive_logout_log | A table that stores information about a user who logged out after logging in through the Hive authentication feature | - | hive_app_logout | An event that fires when a user logs out of the app |
t_hive_purchase_log | A table that stores user purchase activity and payment information generated through the Hive billing feature | (env is null or upper(env) <> 'TEST') and isException is null | hive_product_purchase | An event that fires when receipt verification for a product is completed |
upper(env) = 'TEST' OR isException IS NOT NULL | hive_product_purchase_test | An event that fires when a test payment for a product occurs | ||
t_hive_ad_watch_log | Ad viewing log provided through Hive AdKit when AD(X) or ADOP is applied | eventType IN ('click') | hive_ad_click | An event that fires when an ad is clicked |
eventType IN ('closed') | hive_ad_close | An event that fires when ad viewing ends | ||
eventType IN ('load') | hive_ad_load | An event that fires when ad creative is loaded on the client | ||
eventType IN ('open') | hive_ad_open | An event that fires when an ad is displayed to the user | ||
eventType IN ('paid') | hive_ad_pay | An event that records ad eCPM revenue information | ||
eventType IN ('reward') | hive_ad_reward | An event that fires when a reward is granted after watching an ad | ||
t_hive_au_download_log | A table that stores download information when a game is downloaded, after the terms agreement screen, through the Hive provisioning feature | first IN (0) | hive_app_redownload | An event that fires when an existing user reinstalls or updates the app |
first IN (1) | hive_terms_agree | An event that fires when a new user agrees to the terms after the initial install | ||
t_hive_sub_purchase_log | A table that stores subscription product purchase activity and payment information generated through the Hive billing feature | priceType='PAID' AND (upper(env) = 'TEST' OR isException IS NOT NULL) | hive_product_purchase_test | An event that fires when a test payment for a product occurs |
priceType='PAID' AND (env is null or upper(env) <> 'TEST') and isException is null | hive_product_purchase | An event that fires when receipt verification for a product is completed | ||
t_hive_quit_log | A log generated when a withdrawal request occurs in-game, storing information about the user's withdrawal request and completion | quitStatus IN ('D') | hive_account_quit_complete | An event that fires when account withdrawal is finally completed |
quitStatus IN ('R') | hive_account_quit_request | An event that fires when a user requests account withdrawal | ||
t_hive_user_entry_log | A table that stores information about each section a user passes through, from launching the game to arriving at the game lobby | sectionId IN (1000) | hive_banner_expose | A client event for the app entry funnel that fires when a Hive promotion full-screen banner is displayed |
sectionId IN (400) | hive_app_first_launch | A client event for the app entry funnel that fires when the app is launched for the first time after a new install | ||
sectionId IN (401) | hive_app_start | A client event for the app entry funnel that fires at SDK initialization (app start) | ||
sectionId IN (410) | hive_permission_notice | A client event for the app entry funnel that fires when the user enters the permissions notice screen | ||
sectionId IN (420) | hive_notice_expose | A client event for the app entry funnel that fires when a notice popup is displayed | ||
sectionId IN (430) | hive_terms_enter | A client event for the app entry funnel that fires when the user enters the terms agreement screen | ||
sectionId IN (500) | hive_server_select | A client event for the app entry funnel that fires when the user enters the server selection screen | ||
sectionId IN (600) | hive_maintenance_expose | A client event for the app entry funnel that fires when a server maintenance popup is displayed | ||
sectionId IN (700) | hive_download_start | A client event for the app entry funnel that fires when an additional download starts | ||
sectionId IN (800) | hive_download_complete | A client event for the app entry funnel that fires when an additional download completes | ||
sectionId IN (900) | hive_login_enter | A client event for the app entry funnel that fires when the user enters the login section | ||
sectionId >= 10000 | game_user_entry | An event that fires when a user enters a section defined by the game | ||
t_hive_login_log | A table that stores login information for a user who logged in through the Hive authentication feature | source IN ('membership') | hive_membership_login | An event that fires when login with a Hive membership account is completed |
source NOT IN ('membership') | hive_app_login | An event that fires when app login is completed using a method other than Hive membership | ||
t_hive_user_block_log | A table that stores information about a user being blocked or unblocked through the Hive suspension (block) feature | status IN ('블럭중') | hive_user_block | An event that fires when a suspension is applied to a user |
status NOT IN ('블럭중') | hive_user_unblock | An event that fires when a user's suspension is lifted |
Game Logs → Event Data¶
Game logs are sent directly using the client log transmission feature. Game logs not included in the table below are migrated to the new event name using the existing log name as-is, with no additional mapping.
| Existing Log Table | Table Description | Filter Condition | New Event Name | New Event Description |
|---|---|---|---|---|
t_pub_user_property_log | A custom user property table, collected via the Hive SDK, for property values freely defined beyond the predefined properties | - | user_property_{propertyName} | An event that fires when the value of a custom user property (propertyName), freely defined beyond the predefined properties, is sent |
t_pub_asset_log | Currency log | amountVar < 0 | hive_asset_use | An event that fires when in-game currency is consumed |
amountVar > 0 | hive_asset_get | An event that fires when in-game currency is acquired | ||
t_pub_store_click_log | Store click log | clickType IN ('detail') | hive_store_product_click | An event that fires when a user clicks product details in the in-game store |
clickType IN ('purchase') | hive_store_product_purchase | An event that fires when a user clicks the purchase button in the in-game store | ||
t_pub_contents_log | Content log | contentStatus IN ('accept') | hive_contents_accept | An event that fires when game content is accepted |
contentStatus IN ('cancel') | hive_contents_cancel | An event that fires when game content is cancelled | ||
contentStatus IN ('fail') | hive_contents_fail | An event that fires when game content fails | ||
contentStatus IN ('success') | hive_contents_success | An event that fires when game content is cleared | ||
contentStatus IN ('wait') | hive_contents_wait | An event that fires when a user enters the waiting period before game content starts | ||
t_pub_levelup_log | Level-up log | levelUpType IN ('account') | hive_account_level_change | An event recorded when a user account levels up |
levelUpType IN ('character') | hive_character_level_change | An event recorded when a character levels up | ||
levelUpType IN ('guild') | hive_guild_level_change | An event recorded when a guild levels up | ||
levelUpType IN ('skill') | hive_skill_level_change | An event recorded when a skill levels up | ||
t_pub_mate_log | Mate log | mateChangeAmount < 0 | hive_mate_consume | An event that fires when a mate (pet, companion, etc.) is consumed |
mateChangeAmount > 0 | hive_mate_get | An event that fires when a mate (pet, companion, etc.) is acquired | ||
t_pub_society_log | Social activity log | societyType IN ('friend') | hive_friend_society_invite | An event recorded when a change occurs in the friend list |
societyType IN ('guild') | hive_guild_society_invite | An event recorded when a change occurs in guild membership | ||
societyType IN ('party') | hive_party_society_invite | An event recorded when a change occurs in party membership |
MMP Logs → Event Data¶
If you have integrated an MMP (Airbridge, AppsFlyer, Adjust), the MMP's new event names are changed to new event names in the form of the MMP product name prefixed to the event name ({MMP product name}_{eventName}) and migrated. The table below is the list of automatically tracked events; events not listed in the table are migrated using the same rule.
| MMP | Existing Log Table | MMP eventName | New Event Name |
|---|---|---|---|
| Airbridge | t_hive_airbridge_log | Sign-in | airbridge_Sign-in |
Sign-out | airbridge_Sign-out | ||
Initiate Checkout | airbridge_Initiate Checkout | ||
Order Complete | airbridge_Order Complete | ||
Order Cancel | airbridge_Order Cancel | ||
Subscribe | airbridge_Subscribe | ||
Ad Impression | airbridge_Ad Impression | ||
Ad Click | airbridge_Ad Click | ||
Rate | airbridge_Rate | ||
Share | airbridge_Share | ||
Install | airbridge_Install | ||
Open | airbridge_Open | ||
Update | airbridge_Update | ||
Purchase | airbridge_Purchase | ||
| Adjust | t_hive_adjust_log | Install | adjust_Install |
Open | adjust_Open | ||
Update | adjust_Update | ||
Purchase | adjust_Purchase | ||
| AppsFlyer | t_hive_appsflyer_log | Install | appsflyer_Install |
Open | appsflyer_Open | ||
Update | appsflyer_Update | ||
Purchase | appsflyer_Purchase |