You've successfully subscribed to GA4BigQuery
Success! Your account is fully activated, you now have access to all content.
Success! Your billing info is updated.
Billing info update failed.

Platform and device: dimensions & metrics

Join 2,600+ other professionals and receive a monthly newsletter packed with GA4 & BigQuery news, tips & tricks

Great! Check your inbox and click the link to confirm your subscription
Please enter a valid email address!
Already have an account? Sign in
💡
This article is about GA3 - Universal Analytics

This example query contains all following Google Analytics platform and device dimensions and metrics. If you only need one dimension or metric, look at the -- comments in the example query and copy the part you need from the select clause. Make sure that you also add any additional conditions (in the from, where, group by and order by) that are necessary to calculate the results correctly.

Platform and device dimensions

  • browser
  • browser version
  • operating system
  • operating system version
  • mobile device branding
  • mobile device model
  • mobile input selector
  • mobile device info
  • mobile device marketing name
  • device category
  • browser size
  • data source

Platform and device metrics

-

Example query

select
  -- browser (dimension)
  device.browser as browser,
  -- browser version (dimension)
  device.browserversion as browser_version,
  -- operating system (dimension)
  device.operatingsystem as operating_system,
  -- operating system version (dimension)
  device.operatingsystemversion as operating_system_version,
  -- mobile device branding (dimension)
  device.mobiledevicebranding as mobile_device_branding,
  -- mobile device model (dimension)
  device.mobiledevicemodel as mobile_device_model,
  -- mobile input selector (dimension)
  device.mobileinputselector as mobile_input_selector,
  -- mobile device info (dimension)
  device.mobiledeviceinfo as mobile_device_info,
  -- mobile device marketing name (dimension)
  device.mobiledevicemarketingname as mobile_device_marketing_name,
  -- device category (dimension)
  device.devicecategory as device_category,
  -- browser size (dimension)
  device.browsersize as browser_size,
  -- data source (dimension)
  (select datasource from unnest(hits) group by datasource) as data_source
from
  `bigquery-public-data.google_analytics_sample.ga_sessions_20160801`
where
  totals.visits = 1