Skip to content

Instantly share code, notes, and snippets.

@rviscomi

rviscomi/pct_good_fid.sql Secret

Last active November 10, 2023 01:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rviscomi/7a0ca7052199314a1cdfc4b7d12b4a33 to your computer and use it in GitHub Desktop.
Save rviscomi/7a0ca7052199314a1cdfc4b7d12b4a33 to your computer and use it in GitHub Desktop.
Download ZIP
The percentage of website that are assessed as having good FID on desktop and mobile (where applicable).
Raw
pct_good_fid.sql
WITH origins AS (
SELECT
origin,
LOGICAL_AND((fast_fid / (fast_fid + avg_fid + slow_fid)) >= 0.75) AS good_fid
FROM
`chrome-ux-report.materialized.device_summary`
WHERE
date = '2023-09-01' AND
device IN ('desktop', 'phone') AND
fast_fid IS NOT NULL
GROUP BY
origin
)
SELECT
COUNTIF(good_fid) / COUNT(0) AS pct_good_fid
FROM
origins
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment