Datastudio & URL report

54 views
Skip to first unread message

Abel

unread,
Aug 17, 2021, 11:41:15 AMAug 17
to Chrome UX Report (Discussions)
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.


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
Screenshot 2021-08-17 at 16.39.55.pngAbel

Rick Viscomi

unread,
Aug 17, 2021, 5:05:54 PMAug 17
to Chrome UX Report (Discussions), contact...@gmail.com
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

unread,
Aug 20, 2021, 6:35:38 AMAug 20
to Chrome UX Report (Discussions), rvis...@google.com, 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

unread,
Aug 20, 2021, 12:19:12 PMAug 20
to Abel, Chrome UX Report (Discussions)
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
Reply all
Reply to author
Forward
0 new messages