Hub guest transition log
Category¶
| Common Server | service_metrics-guest_transition_log |
|---|---|
| Test Server | service_metrics_test-guest_transition_log |
Example¶
- Transition to new membership user
- A guest user (90049050329) at level 3 was transited to a membership user (118622361) without changing game server uid.
'{"date":"2014-08-19:16:01:00","channel":"C2S","game":"test","server_id":1,
"guest_channel_uid":"90049050329","guest_server_uid":1234,"guest_level":3,
"candidate_channel_uid":"118622361","candidate_server_uid":0,"candidate_level":0,
"selected_channel_uid":"118622361","selected_server_uid":1234,"selected_level":3,
"client_ip":"221.2.164.31","server_ip":"115.28.135.86","company":"C2S"}'
- Transition to the previous game data
- A user who once had played as a membership user (118159707) at level 10 (game server uid: 1500) newly played at level 5 (game server uid: 2000) as a guest user (90049050731). At the time of transition to guest user, the player selected to be the membership user (118159707).
'{"date":"2014-08-19 16:02:00","channel":"C2S","game":"test","server_id":1,
"guest_channel_uid":"90049050731","guest_server_uid":2000,"guest_level":5,
"candidate_channel_uid":"118159707","candidate_server_uid":1500, "candidate_level":10,
"selected_channel_uid":"118159707","selected_server_uid":1500,"selected_level":10,"
client_ip":"221.2.164.31","server_ip":"115.28.135.86","company":"C2S"}'
Log specification¶
Note
The snake-cased field, like server_id, is transformed to camel case, like serverId, when it stores in the final storage (BigQuery), and the log sent in the unspecified form, such as serverid, is not saved in its column.
| Field Name | Description | Type | Required |
|---|---|---|---|
| date | The time storing log, Format: yyyy-mm-dd hh ss e.g., 2012-01-19 16:24:00 | string | Y |
| timezone | UTC offset of time parameter in the log e.g., "UTC+10:30" (no space) Reference: Time Zone Lists | string | Y |
| channel | Login channel e.g., C2S: HIVE, KAK: Kakao Talk, LIN: LINE, WEI: Weibo (Contact the PIC to add new channel) | string(3) | Y |
| game | Use the brand name of game (e.g., derbydays). The third item of app_id e.g., com.com2us.littlelegends.kakao.freefull.apple.global.ios.universal → littlelegends | string(50) | Y |
| server_id | Server Code - After February 1, 2016 Refer to Table of Server Code to input server code (JSON Input Code) - Before February 1, 2016 If the field (e.g., Global/Korea/Japan/China/...) is 0, it means null. Games in service before adding server_id does not have any definition of field, so its value is 0. Games in service after adding server_id puts 1 in the Server ID, and add to meta table regardless of the number of server as a preparation for additional server. (Added on May 22, 2014) | - After February 1, 2016 string - Before February 1, 2016 tinyint | Y |
| guest_channel_uid | User identifier on login channel (Generally bigint is in use, but some channels may use string type) | string(64) | Y |
| guest_server_uid | User identifier used in game server | bigint | Y |
| guest_level | Play status of each user. e.g., user level | int | Y |
| guest_app_id | AppID of each game generated by Com2uS e.g., 'com.com2us.derbyday.kakao.freefull.google.global.android.common' | string(200) | Y |
| guest_did | Active User Module 2.0 did (the same as Hub DID) (Added on September 3, 2014) | bigint | Y |
| candidate_channel_uid | User identifier on login channel (Generally bigint is in use, but some channels may use string type) | string(64) | Y |
| candidate_server_uid | User identifier used in game server. When a newbie gets the Candidate UID by converting its status to guest user, game account relevant to this UID does not exist, therefore, send 0 to this value | bigint | Y |
| candidate_level | Play status of each user. e.g., user level When a newbie gets the Candidate UID by converting its status to guest user, game account relevant to this UID does not exist, therefore, send 0 to this value | int | Y |
| selected_channel_uid | User identifier on login channel (Generally bigint is in use, but some channels may use string type) | string(64) | Y |
| selected_server_uid | User identifier used in game server | bigint | Y |
| selected_level | Play status of each user. e.g., user level | int | Y |
| client_ip | Client IP | string(32) | Y |
| server_ip | Server IP | string(32) | Y |
| company | Game publishing company (C2S: Com2uS, GVI: Com2uS Holdings) | string(3) | Y |
Log sample¶
'{"date":"2014-08-19 16:02:00","channel":"C2S","game":"test","server_id":1,"guest_channel_uid":"90049050731","guest_server_uid":2000,"guest_level":5,
"candidate_channel_uid":"118159707","candidate_server_uid":1500,"candidate_level":10,
"selected_channel_uid":"118159707","selected_server_uid":1500,"selected_level":10,"client_ip":"221.2.164.31","server_ip":"115.28.135.86","company":"C2S"}'
How to use¶
- It is allowed to analyze the daily transition from guest to membership user (avilable by level as well).
- Number of transited users: In case one user (Hub_id) has numbers of Guest_ids;
- Based on Hub_id, count the transited Hub_id.
- Based on Guest_id, count the Guest_id.