Im Bericht Browser und Betriebssystem finden Sie Daten über die Akquisition, das Verhalten und die Konversion Ihrer Nutzer, segmentiert nach Browser-Spezifikationen. Die (primären) Dimensionen, die verfügbar sind, sind browser, browser version, browser size, operation system, operation system version, screen resolution, screen colors, flash version und java support.
select
device.browser,
-- device.browserversion,
-- device.browsersize,
-- device.operatingsystem,
-- device.operatingsystemversion,
-- device.screenresolution,
-- device.screencolors,
-- device.flashversion,
-- case when device.javaenabled is true then 'Yes' else 'No' end as java_support,
count(distinct fullvisitorid) as users,
count(distinct(case when totals.newvisits = 1 then fullvisitorid else null end)) as new_users,
count(distinct concat(fullvisitorid, cast(visitstarttime as string))) as sessions,
count(distinct case when totals.bounces = 1 then concat(fullvisitorid, cast(visitstarttime as string)) else null end ) / count(distinct concat(fullvisitorid, cast(visitstarttime as string))) as bounce_rate,
sum(totals.pageviews) / count(distinct concat(fullvisitorid, cast(visitstarttime as string))) as pages_per_session,
ifnull(sum(totals.timeonsite) / count(distinct concat(fullvisitorid, cast(visitstarttime as string))),0) as average_session_duration,
ifnull(sum(totals.transactions),0) as transactions,
ifnull(sum(totals.totaltransactionrevenue),0)/1000000 as revenue,
ifnull(sum(totals.transactions) / count(distinct concat(fullvisitorid, cast(visitstarttime as string))),0) as ecommerce_conversion_rate
from
`bigquery-public-data.google_analytics_sample.ga_sessions_20160801`
where
totals.visits = 1
group by
browser
-- ,browserversion
-- ,browsersize
-- ,operatingsystem
-- ,operatingsystemversion
-- ,screenresolution
-- ,screencolors
-- ,flashversion
-- ,java_support
order by
users desc