Can we auto-update code for UA parser? need to determine first before starting this task.
It appears that Bing bots (e.g., bingbot and BingPreview) may be getting classified as user traffic. Should they be spider instead?
hive> select day, user_agent_map['browser_family'], count(*) from wmf.webrequest where year = 2015 and month = 7 and day < 15 and (hour = 1 or hour = 7 or hour = 13 or hour = 19) and access_method = 'mobile web' and uri_host like '%.m.wikipedia.org' and is_pageview = true and agent_type = 'user' group by day, user_agent_map['browser_family']; 1 Mobile Safari 12132057 1 Chrome Mobile 8801804 1 Android 3749250 1 Other 2528518 1 Opera Mini 1403237 1 Chrome 900893 1 IE Mobile 681078 1 Chrome Mobile iOS 621432 1 BingPreview 449956 1 UC Browser 297750 1 IE 204187 1 Firefox Mobile 178981 1 BlackBerry WebKit 152236 1 Amazon Silk 118894 1 Opera Mobile 102316 1 NetFront NX 64352 1 Firefox 53725 1 Yandex Browser 50416 1 UP.Browser 40531 1 NetFront 37946 1 Nokia Browser 29383 1 bingbot 28545 1 Nokia Services (WAP) Browser 24726 1 Opera 22199 1 Safari 19415 1 BlackBerry 18870 ...