TestSearchSatisfcation browser breakdown sept 1-12 2018
No One
Actions

Authored By

	EBernhardson
	Sep 12 2018, 8:46 PM

Size

1 KB

Referenced Files

None

Subscribers

None

TestSearchSatisfcation browser breakdown sept 1-12 2018
View Options

	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

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 6410137
Default Alt Text: TestSearchSatisfcation browser breakdown sept 1-12 2018 (1 KB)