TestSearchSatisfcation browser breakdown sept 1-12 2018
ActivePublic
Actions

Authored by EBernhardson on Sep 12 2018, 8:05 PM.

Project Tags

None

Referenced Files

	F25790474: TestSearchSatisfcation browser breakdown sept 1-12 2018
	Sep 12 2018, 8:46 PM

	F25790207: TestSearchSatisfcation browser breakdown sept 1-12 2018
	Sep 12 2018, 8:05 PM

Subscribers

None

	select count(distinct event.searchSessionId) as total
	from event.testsearchsatisfaction2
	where year = 2018 and month = 9;

	===

	334155

	===

	select
	useragent.browser_family,
	useragent.browser_major,
	useragent.os_family,
	useragent.os_major,
	count(distinct event.searchSessionId) / 334155 as percent
	from event.testsearchsatisfaction2
	where year = 2018 and month = 9
	group by useragent.browser_family, useragent.browser_major, useragent.os_family, useragent.os_major
	order by percent desc
	limit 50;

	===============

	(above query with percent > 0.01)

	Chrome 68 Windows 10 0.24833984228875822
	Chrome 68 Windows 7 0.16060810103095868
	Edge 17 Windows 10 0.048229115230955695
	Firefox 61 Windows 10 0.03806915952177881
	Safari 11 Mac OS X 10 0.034570783019856055
	Chrome 68 Windows 8.1 0.03359818048510422
	Chrome 68 Mac OS X 10 0.030111774475916866
	IE 11 Windows 10 0.02915712768026814
	Firefox 61 Windows 7 0.026813903727312176
	IE 11 Windows 7 0.02441681255704688
	Firefox 62 Windows 10 0.021457108228217444
	Chrome 69 Windows 10 0.019966781882659244
	Firefox 62 Windows 7 0.015555655309661683
	Chrome 69 Windows 7 0.011976477981774925
	Chrome 49 Windows XP 0.011626341069264263
	Opera 55 Windows 10 0.01064176804177702

Event Timeline