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

Authored by • Tbayer on Nov 29 2018, 6:30 PM.

Tags

None

Referenced Files

	F27325587: Browsers with largest year-over-year pageview changes Q4&Q1 2018
	Nov 29 2018, 6:30 PM

Subscribers

None

	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)

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