How to find List of Origin that passed Core Web Vitals Stat ?

[Sham]

Hi All, 

The changelog (https://developers.google.com/web/tools/chrome-user-experience-report/bigquery/changelog)reports the origins having good Core Web Vitals, and This info is excellent!  Please share if you know the below information related to good Core Web Vitals Stat.

1)   Is changelog reporting for Desktop Or Mobile Or Tablet OR all three?

2)   Was it for the entire Origin Or only for the homepage of Origin? 

3)   Where can I see the list of origins that passed Core Web Vitals?  If not available & need to find ourself would you mind Giving the query Or Add into Crux CookBook (https://github.com/GoogleChrome/CrUX/tree/master/sql)?  I tried to run myself constructing query & run, Got Quote Exceed error sounds due to account limitation. 

Thanks for your attention. 

Thanks,

[Rick Viscomi]

Hi,

Responses inline:

1)   Is changelog reporting for Desktop Or Mobile Or Tablet OR all three?

All three combined.

2)   Was it for the entire Origin Or only for the homepage of Origin? 

All BigQuery data is aggregated at the origin level, so these compliance rates apply to the entire origin.

3)   Where can I see the list of origins that passed Core Web Vitals?  If not available & need to find ourself would you mind Giving the query Or Add into Crux CookBook (https://github.com/GoogleChrome/CrUX/tree/master/sql)?  I tried to run myself constructing query & run, Got Quote Exceed error sounds due to account limitation. 

https://github.com/GoogleChrome/CrUX/blob/main/sql/core-web-vitals-compliance-rates.sql is a good starting point. Here's a modification of that query to get the list of origins that pass the CWV assessment: (793 MB processed)

CREATE TEMP FUNCTION IS_GOOD (good FLOAT64, needs_improvement FLOAT64, poor FLOAT64) RETURNS BOOL AS (

  good / (good + needs_improvement + poor) >= 0.75

);

CREATE TEMP FUNCTION IS_NON_ZERO (good FLOAT64, needs_improvement FLOAT64, poor FLOAT64) RETURNS BOOL AS (

  good + needs_improvement + poor > 0

);

SELECT DISTINCT

  origin

FROM

  `chrome-ux-report.materialized.metrics_summary`

WHERE

  date = '2021-03-01' AND

  IS_GOOD(fast_lcp, avg_lcp, slow_lcp) AND

  IS_GOOD(fast_fid, avg_fid, slow_fid) AND

  IS_GOOD(small_cls, medium_cls, large_cls) AND

  IS_NON_ZERO(fast_lcp, avg_lcp, slow_lcp) AND

  IS_NON_ZERO(fast_fid, avg_fid, slow_fid) AND

  IS_NON_ZERO(small_cls, medium_cls, large_cls)