Automate CrUX data for set of origins in a custom table

[Chris]

Hi there,

I'm a complete newbie to this and was hoping to get some guidance on whether this is possible.

I'd like to build a Data Studio dashboard for some clients that monitors their core web vitals over time compared to a list of competitors. I'd also like to make it easy to duplicate this and switch our the list of domains that are monitored depending on the client.

The key, once the dashboard is created I'd like it to be super user friendly for another coworker to duplicate and set up with a different client without any knowledge of CrUX or Bigquery - in other words they just duplicate the data studio dashboard, switch out the domains that it is reporting on and it's good to go.

So I'm wondering how I would go about doing this if it is possible?

I'd also be open to commissioning someone to create this for me :)

Thanks!

Chris

[Gilberto Cocchi]

Hi Chris, I have few ideas to suggest but it depends how frequently you want to update the data on your dashboard.

- Chrome UX Report Big Query datasets are updated on a monthly basis, it might make sense to use export once a month the data from BigQuery to Google Sheets and use the Google Sheets Origins results to visualize the trends in a Data Studio dashboard otherwise you can add the BigQuery data directly as a Data Source for your dashboard.

- Chrome UX Report API allows you to query daily a list of Origins and/or URLs and observe more progressive trends. You can try this workflow where there is already a template available to use and modify for your needs working with the CrUX API workflow and npm module autowebperf https://github.com/GoogleChromeLabs/AutoWebPerf/blob/stable/docs/sheets-connector.md

Hope this helps.

Gil

--
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/2fa4ae76-80b4-4ddf-8d50-62bbaec0f621n%40chromium.org.

--

gTech Up

Gilberto Cocchi Web Ecosystem Consultant gilb...@google.com +39 02 3661 8337

Google Italy | Via Federico Confalonieri 4 | Porta Nuova Isola | Building C | Milan 20124

Registered in Milan, Italy

This email may be confidential and privileged. If you received this communication by mistake, please don't forward it to anyone else, please erase all copies and attachments, and please let me know that it has gone to the wrong person.

The above terms reflect a potential business arrangement, are provided solely as a basis for further discussion, and are not intended to be and do not constitute a legally binding obligation. No legally binding obligations will be created, implied, or inferred until an agreement in final form is executed in writing by all parties involved.

[Chris]

Thanks Gilberto, this is very helpful.

The one thing I'm not entirely sure about is how to automate the check so it pulls in the data at set periods, so in your above two solutions:

1. How do I ensure the new BigQuery dataset is pulled in each month to the Google sheet? - I think this would be the most feasible and preferred method.

2. If I used the Chrome UX report method (which I think sounds more confusing), how do I automate it so the API queries are run weekly for example?

Thanks again!

Chris

[Ryan Siddle]

Hi Chris,

Google Data Studio has quite a few limitations when you start working past simple use cases. Have you considered looking at storing a subset of data in BigQuery and using Grafana Dashboards to visualise? It does have more of a steep learning curve, but it would give you the flexibility that you are looking for. For example, if you are working for a global company, you may have quite a few sites to monitor with competitors. You could look at tagging them by brand and aggregating the origin data to have a brand like-for-like comparison. This would allow you to see which of the global sites also have opportunity compared to the average in the dataset.

Best regards,

Ryan

[Gilberto Cocchi]

Hi Chris, great question sorry I forgot to address that point:

You can achieve that by calling the Chrome UX Report API or by querying Chrome UX Report via BigQuery in Appscript with Triggers.

You can also achieve a similar effect by using the npm module AutoWebPerf https://github.com/GoogleChromeLabs/AutoWebPerf and setting a cronjob to upload the results into a Google Sheet via Google Sheets API.