Internal page broken down by core web vitals expanded view

[Prag]

Hello everyone,

Is it possible to pull a report (excel / data studio) that consists of a website's internal page's speed checked for core web vitals and have all the percentages for "Good", "Needs Improvement" and "Poor"? Basically, the way data is populated in the Google Page Speed Insights tool.

1) Are these core web vitals 3 categories percentage data present in Big Query tables for website internal pages? If yes, please guide. I tried to check in GitHub but couldn't find it.

2) Is there any scraping script to pull these percentages from the Google Page Speed Insights tool interface? If yes, please share.

I had checked the PSI API but it doesn't have these percentage data and the 3 categories. The API only says, pass or fail along with the 75th percentile number.

Your help is highly appreciated.

Many thanks & kind regards,

Prag

[Ben Schwarz]

Hey Prag, 

You're looking for the CrUX REST API, which includes breakdowns for metrics like this: 

{
  "histogram": [
    {
      "start": 0,
      "end": 1000,
      "density": 0.38179089544772343
    },
    {
      "start": 1000,
      "end": 3000,
      "density": 0.49904952476238057
    },
    {
      "start": 3000,
      "density": 0.11915957978989571
    }
  ],
}

Hope that helps Prag :-) 

Cheers,

Ben

--
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/5a35eabf-18c4-428c-b0d5-d93bb21ec2fen%40chromium.org.

[Alex Loaiza]

Do you need to collect data for a page rather than the origin (domain) ?

I have this tool that you can use: https://core-web-vitals.vercel.app/

To view this discussion on the web visit https://groups.google.com/a/chromium.org/d/msgid/chrome-ux-report/CAM7piU4t_QXgRGFiAdscBGM%2B0QoK15ouDt-cMxv2rngxnBbk8A%40mail.gmail.com.

--

- Alex Loaiza 

[Pragyanshu Labh]

Thank you so much Ben for introducing me to CrUX REST API. I was looking for something like this.

I came across this page https://blr.design/blog/crux-web-vitals-python/ and it helped me to pull some numbers for 75th percentile. To my surprise, the CrUX API numbers did not match at all and had huge differences with Google PSI interface field data numbers. Is it a known fact?

Also, do you have any script or known blog for CrUX API in python to pull the 3 categories percentages (Good, Need Improvement, Poor)?

Thank you so much for your help!

Regards,

Prag

To view this discussion on the web visit https://groups.google.com/a/chromium.org/d/msgid/chrome-ux-report/CAM7piU4t_QXgRGFiAdscBGM%2B0QoK15ouDt-cMxv2rngxnBbk8A%40mail.gmail.com.

[Pragyanshu Labh]

Hello Alex,

Thanks for sharing the nice tool but I do not think it serves what I'm looking for. I'm looking for automation (frequency: weekly) of pulling CWV data for multiple website's internal pages. Sorry if the tool has this feature and I missed it. :)

Best,

Prag

[Alex Loaiza]

I think I understand what you're trying to do now. 

If google sheets doesn't work for you, then give this a try with sitespeed and grafana. This method works well if you want to catch down trends before they are shown in the data studio report, because it uses the crux api to pull data daily. For the monthly reports I still heavily recommend the crux connector connected to google's crux data studio.

--

- Alex Loaiza