Instantly share code, notes, and snippets.

Embed
What would you like to do?
Chrome User Experience Report Analyzed with Google BigQuery
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
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"
(
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 )
SELECT
COUNT(*)
FROM (
SELECT
origin
FROM
`chrome-ux-report.chrome_ux_report.201710`
WHERE
effective_connection_type.name = "4G"
GROUP BY
origin )
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"
SELECT
SUM(onload.density)
FROM
`chrome-ux-report.chrome_ux_report.201710`,
UNNEST(onload.histogram.bin) AS onload
WHERE
origin = "http://example.com"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment