Visit log
It is a function to visit other users in games, so this log helps you check how many times the users of your game visits their friends’ village.
Category¶
- Scribe / FTP type
| Common Server | service_metrics-visit_log |
|---|---|
| Test Server | service_metrics_test-visit_log |
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" | string | 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 |
| channel | C2S: HIVE, KAK: Kakao Talk, LIN: LINE, WEI: Weibo | string (3) | Y |
| user_id | User identifier used with the configured channel field C2S: vid KAK: User identifier issued by App Center LIN: User identifier issued by App Center WEI: Weibo | bigint | Y |
| country | Get the country code directly if you cannot receive client_ip. e.g., KR | string(2) | N |
| lang | Language code of user Format: ISO 639-2 alpha-3 e.g., "KOR" | string (3) | Y |
| market | Market information "TS": SKT Tstore "OL": KT OllehMarket "OZ": LGU+ OzStore "AP": Apple Appstore "GO": Google Play "SA": Samsung Apps "LE": Com2us Lebi "MM": ChinaMobile MobileMarket "SN": Sina WeiboPoint "36": Qihu 360Point "MO": Momo MomoPoint "DN": DeNA MobagePoint "NA": NaverAppStore "AM": Amazon "ON": OneStore | string (2) | Y |
| level | The level of user in the game (The highest level if character is many) | int | Y |
| visit_user_id | The user identifier of the channel | bigint | Y |
| visit_map_type | The identifier of maps which game provides If the game has one map only, set the identifier as 1 Sends each code separately if the game has multiple maps such as Tiny Farm. | int | Y |
| client_ip | Client IP. This value extracts the value of country from GeoIP | string (32) | Y |
| server_ip | Server IP | string (32) | Y |
| company | Game publishing company, the target of log: e.g., "C2S": Com2uS, "GVI": Com2uS Holdings | string (3) | Y |
| server_id | Server Code Refer to Table of Server Code to input server code (JSON Input Code) | string | Y |
Log sample¶
{
"date": "2013-06-07 13:55:46",
"game": "magictree",
"channel": "C2S",
"user_id": 2807259,
"country": "US",
"lang": "ENG",
"market": "GO",
"level": 25,
"visit_user_id": 2199217,
"visit_map_type": 1,
"server_ip": "112.175.60.166",
"client_ip": "198.228.201.162",
"server_id": 1
}
How to use¶
- Visit log shows how many times the users of your game visits their friends’ village.
- Friends visit user: count(distinct user_id), The number of visits: count(*), The number of users to visit: count(distinct visit_user_id)
