mysql:research@analytics-store.eqiad.wmnet [log]> SELECT DISTINCT(userAgent) FROM log.MobileWikiAppDailyStats_12637385 WHERE userAgent NOT LIKE '%Android%';
userAgent |
Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html) |
"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)" |
Some of these have nonzero installation age indeed (cf. schema):
mysql:research@analytics-store.eqiad.wmnet [log]> SELECT DISTINCT(event_appInstallAgeDays) FROM log.MobileWikiAppDailyStats_12637385 WHERE userAgent LIKE '%Googlebot%';
event_appInstallAgeDays |
0 |
1 |
2 |