Datastudio & URL report

[Abel]

Hello,

I am looking to setup a dashboard using Data studio for multiple pages on my website.

As stated below, we can now fetch the latest report on a URL basis using programmatically but I am looking for a way to easily integrate this into Datastudio so I can build graphs etc.

https://web.dev/chrome-ux-report-api/

There seems to be no available connector that supports fetching data at a URL level (origin level is possible as you can see in the screenshot).

Any tips?

Thanks in advance

Abel

[Rick Viscomi]

Hi,

While there isn't a CrUX API connector, it should be possible to get a URL-level dashboard using Google Sheets as an intermediary.

A while ago I wrote A step by step guide to monitoring the competition with the Chrome UX Report in which I walk through how to set up Sheets to monitor URL-level data using the PageSpeed Insights API. You could upgrade it to the CrUX API using something like this Apps Script sample code. And with the data in Sheets, you can use the Google Sheets connector to add a visualization layer to the URL-level data.

Hope that helps!

Rick

[Abel]

That makes sense thanks Rick.

I noticed in the JSON response that I get back from the v5 API it is now showing the 90th percentile as per the docs. Is there any way to get the 75th percentile?
E.g. https://www.googleapis.com/pagespeedonline/v5/runPagespeed?url=url:https://www.google.com/search

Thanks,

Abel

[Rick Viscomi]

Hi Abel,

The latest version of the PSI API (v5) returns the 75th percentile, I think the docs you're referring to may be outdated.

That said, if you're only interested in field data from CrUX, I would recommend using the CrUX API instead. The data is the same as the PSI API but you wouldn't have to wait for the Lighthouse tests, so it's much faster.

Rick