Chrome User Experience Report Analyzed with Google BigQuery

3G-fraction-1s-example.sql

SELECT
  SUM(fcp.density)
FROM
  `chrome-ux-report.chrome_ux_report.201710`,
  UNNEST(first_contentful_paint.histogram.bin) AS fcp
WHERE
  origin = "https://www.google.co.in"
  AND effective_connection_type.name = "3G"
  AND fcp.END <= 1000

3G-fraction-example.sql

SELECT
  SUM(fcp.density)
FROM
  `chrome-ux-report.chrome_ux_report.201710`,
  UNNEST(first_contentful_paint.histogram.bin) AS fcp
WHERE
  origin = "https://www.google.co.in"
  AND effective_connection_type.name = "3G"

all-origin-3G-4G.sql

  (
  SELECT
    origin
  FROM
    `chrome-ux-report.chrome_ux_report.201710`
  WHERE
    effective_connection_type.name = "4G"
  GROUP BY
    origin ) INTERSECT DISTINCT (
  SELECT
    origin
  FROM
    `chrome-ux-report.chrome_ux_report.201710`
  WHERE
    effective_connection_type.name = "3G"
  GROUP BY
    origin )

count-origin-connection-type.sql

SELECT
  COUNT(*)
FROM (
  SELECT
    origin
  FROM
    `chrome-ux-report.chrome_ux_report.201710`
  WHERE
    effective_connection_type.name = "4G"
  GROUP BY
    origin )

google-india-3g.sql

SELECT
  SUM(onload.density)
FROM
  `chrome-ux-report.chrome_ux_report.201710`,
  UNNEST(onload.histogram.bin) AS onload
WHERE
  origin = "https://www.google.co.in"
  AND effective_connection_type.name = "3G"

sum-onload-density-across-dimension.sql

SELECT
  SUM(onload.density)
FROM
  `chrome-ux-report.chrome_ux_report.201710`,
  UNNEST(onload.histogram.bin) AS onload
WHERE
  origin = "http://example.com"