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.
  • 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).

Log Specification

Field Name Description Type Required
date The time storing log, Format: yyyy-mm-dd hh:mm: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

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.