Paste P7869

Browsers with largest year-over-year pageview changes Q4&Q1 2018
ActivePublic

Authored by Tbayer on Thu, Nov 29, 6:30 PM.
SELECT browser, changeratio,
ROUND(viewsthisyear/122000000,1) AS milliondailyviewsthisyear
FROM (
SELECT user_agent_map['browser_family'] AS browser,
ROUND(100*
SUM(IF(year = 2018, view_count, 0))/
SUM(IF(year = 2017, view_count, 0))
-100,1) AS changeratio,
SUM(IF(year = 2018, view_count, 0)) AS viewsthisyear
FROM wmf.pageview_hourly
WHERE
year >= 2017 AND year <= 2018
AND month >= 6 AND month <= 9
AND agent_type = 'user'
GROUP BY user_agent_map['browser_family'])
AS browserlist
WHERE viewsthisyear > 122000000
GROUP BY browser, changeratio, viewsthisyear
ORDER BY ABS(changeratio) DESC LIMIT 50;
browser changeratio milliondailyviewsthisyear
Firefox Mobile 69.6 3.2
IE Mobile -51.9 1.0
Opera Mini -31.2 3.5
IE -21.8 35.8
Chrome Mobile iOS 21.2 7.2
Android -15.3 9.8
Mobile Safari 12.1 102.3
Opera Mobile 8.1 1.1
Opera -8.0 4.8
Other 7.3 13.1
Firefox -7.0 36.2
Chrome Mobile 6.8 117.7
Chrome -4.7 115.0
Safari -3.4 12.3
Yandex Browser 2.8 2.4
UC Browser -0.7 3.3
Edge 0.2 9.1
Samsung Internet NULL 16.0
Mobile Safari UI/WKWebView NULL 1.2
Chrome Mobile WebView NULL 3.5
Apple Mail NULL 1.1
21 rows selected (3970.267 seconds)
Tbayer created this paste.Thu, Nov 29, 6:30 PM