How to find domains which did not pass Core Web Vitals Stat, by technology ?

[Elad Vardi]

Hi all, 

I'm Elad from webzie (webzie.com). webzie is a new webiste builder which is optimized for performance.

I looked on the Core Web Vitals Technology Report for webzie technology (Link:  https://bit.ly/3EOnBgD) 

Currently there is one domain on webzie that did not pass Core Web Vitals Stat (preventing webzie from achieving 100% on mobile).

I wish to diagnose which domain(s) has failed.

I tried to run several queries using the example query, but couldn't locate the failing domain. Moreover I didn't see a way to query by technology (I used the example query from here: https://groups.google.com/a/chromium.org/g/chrome-ux-report/c/glcBP606Wmg?pli=1). 

Is there a way to query and find which domain did not pass Core Web Vitals, by technology (i.e. I only wish to find failing domains for webzie technology)?

I think it can help any technology that wants to diagnose performance issues and to have the ability to improve.

Thank you very much for your help.

[Barry Pollard]

Hi Elad,

Here's a query to join the CrUX data with the HTTP Archive data

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

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

);

SELECT DISTINCT

device,

origin,

IS_GOOD(fast_lcp, avg_lcp, slow_lcp) AS good_lcp,

IS_GOOD(fast_fid, avg_fid, slow_fid) AS good_fid,

IS_GOOD(small_cls, medium_cls, large_cls) AS good_cls,

(

IS_GOOD(fast_lcp, avg_lcp, slow_lcp) AND

(fast_fid + avg_fid + slow_fid = 0 OR IS_GOOD(fast_fid, avg_fid, slow_fid)) AND

IS_GOOD(small_cls, medium_cls, large_cls)) AS good_cwv

FROM

`chrome-ux-report.materialized.device_summary`

JOIN (

SELECT

IF(client = 'desktop', 'desktop', 'phone') AS device,

date,

SUBSTR(root_page, 0, LENGTH(root_page) - 1) AS origin,

technology.technology

FROM

`httparchive.all.pages`,

UNNEST (technologies) AS technology

WHERE

date = '2022-10-01' AND

technology.technology = 'Webzie')

USING (date, device, origin)

WHERE

date = '2022-10-01' AND

(

IS_GOOD(fast_lcp, avg_lcp, slow_lcp) AND

(fast_fid + avg_fid + slow_fid = 0 OR IS_GOOD(fast_fid, avg_fid, slow_fid)) AND

IS_GOOD(small_cls, medium_cls, large_cls)) = FALSE

ORDER BY

device DESC,

origin DESC

Looks like just one origin doesn't pass: https://www.yalla.co.il due to poor FID.

Thanks,

Barry

--
You received this message because you are subscribed to the Google Groups "Chrome UX Report (Discussions)" group.
To unsubscribe from this group and stop receiving emails from it, send an email to chrome-ux-repo...@chromium.org.
To view this discussion on the web visit https://groups.google.com/a/chromium.org/d/msgid/chrome-ux-report/dc4ff65e-f235-4c29-97e7-96bf5b460318n%40chromium.org.

[Elad Vardi]

Thank you so much for your help!