Page MenuHomePhabricator
Paste P7539

TestSearchSatisfcation browser breakdown sept 1-12 2018
ActivePublic

Authored by EBernhardson on Sep 12 2018, 8:05 PM.
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