Creating a CrUX dashboard in Data Studio

Sam Underwood
Sam Underwood
November 10, 2019
4 mins read

In my recent post on site speed tools, I mentioned one way to monitor your site speed on an ongoing basis for free is to utilise the Chrome User Experience Report (CrUX) data studio connector to create a CrUX dashboard.

What is CrUX you may ask...

The Chrome User Experience Report (CrUX) gives various user experience metrics gathered from real-world Chrome users. The data it gives is freely available and queryable from a BigQuery database.

Here is an example of a CrUX data studio dashboard I use for all my clients (you'll have something similar by the end of this blog post):

crux dashboard

This has been updated to use core web vitals

Google has recently announced they will soon be using core web vitals as a ranking factor. These metrics are also included within CrUX so I have updated the dashboard linked below to use them.

Enjoy!

crux dashboard

What are the benefits of setting up CrUX reports?

Personally, I think if you're a site owner you should definitely have this as part of your reporting suite as it gives access to data on the experience real users have on your site. This is really useful as it can answer the question of whether site speed should be something you're focusing on.

One great benefit of utilising CruX data for this kind of reporting is that it has loads of historical data in it. So even if you get this report set up today, you can still see how your site performance has been for your users over the past 12 months or more.

The only downside to utilising CrUX data is that it is only a sample of users that visit your site i.e the users that use Chrome and allow the data to be shared. So you won't be getting the full picture of what the speed experience is like for everyone.

To make this all much easier, I've created a free template for you to use to get started. To get started, click the below button the head on to the next section of the guide.

Getting the report setup

1. Make a copy of the template

The first step once you are on the template is to head to 'Make a copy' in the top bar.

data studio make a copy

2. Create a new data source

You will then want to create a new data source so you can set the CrUX report to whichever domain you want to analyse.

crux dashboard step 2

3. Search for the 'Chrome UX Report' connector

Use the search function and look for the Chrome UX Report, it will be under the 'open source connectors' header.

crux dashboard step 3

4. Enter the domain you want to analyse

In your new data source, enter the origin URL you want to run the analysis on including the subdomain. If the domain is using the HTTP protocol rather than HTTPS make sure you add that in also.

crux dashboard step 4

After this, click the blue connect button in the top right.

4. Keep moving, click 'add to report'

crux dashboard step 5

5. Then click 'copy report'

crux dashboard step 6

6. Enjoy your fancy crux dashboard

You've made it! You will now have a speed report that looks like the below.

rum data studio report

Final words

You should now have a great base template for analysing site speed, but you can definitely take this further! One obvious thing is to set up additional data sources for your competitors so you can see what the experience is like on their site compared to yours.

If you need to make a business case for improving site speed, your own data mixed with some competitor insights can be a great way to do this.

If there is too much red/yellow on your own charts, consider looking at my big list of site speed tips and diagnosing what is causing the issues using a site speed tool.

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram