How to get PageSpeed Insights in Google Data Studio.

PageSpeed matters. With a lightning-fast website, you can rank higher than the competitors in google. Google makes it clear that page speed of a website is an important page rank criteria. So, a faster website will give your website a better ranking and therefore, more user traffic.

PageSpeed encompasses a number of factors that affect the overall web user experience. These include core web vitals like First Input Delay, Cumulative Layout Shift, Largest Meaningful Paint among other metrics. Understanding these metrics can help you improve and monitor any anomalies in your website.

If you own a number of websites or manage 1000s of important URLs the simple PageSpeed Insights Tool would not cut it for you. Entering each url one by one and keeping track of all the PageSpeed metrics regularly, can easily go out of hand.

Get Core web vitals in Google Data Studio

Without writing a single line of code you can automate PageSpeed insights reporting for multiple URLs for FREE using Two Minute Reports. All this with the convenience of owning everything within Google Data Studio. Keeping your SEO data within Google Data Studio makes it easier to track over a long period of time and share with someone when needed. Lets see how to quickly capture PageSpeed metrics for 1000s of URLs inside your Google Data Studio below.

Step 1 : Get your free API key and enable Google services

First, we need to enable PageSpeed services and get API key from Google. Using these API keys you can get PageSpeed metrics for up to 25,000 times a day. If you already have an API key you can skip this step.

  • Click on “My Project” and select an existing project or create a new google project. Then go to Credentials section and create a new API key.
  • Enable PageSpeed Insights API from this link, and then enable Chrome UX Report API from here.

PageSpeed Insights API enables you to scan your URLs on demand and get metrics in realtime. It also provides more than 20 sophisticated metrics about the URL.

Chrome UX Report API also called as CRUX, provides only core Web Vital metrics data namely : First Contentful Paint, Largest Contentful Paint, Cumulative Layout Shift and First Input Delay. These are the golden metrics that are very important to monitor and improve upon for better SEO and search ranking. CRUX data measures and aggregates these core vitals from real users over a rolling 28-Day period. Since this data is from a vast distribution of real users, it is more representative of the website performance in the real world than the web vitals from PageSpeed Insigths API.

Step 2 : Install Two Minute Reports

Now you need to install our PageSpeed Insights Connector for Google Data Studio. Just clicking this link will take you to our Google Data Studio Connector. After authorisation, you are now ready to use PageSpeed insights in all your Google Data Studio Reports.

Step 3 : Enter the URLs that you want to track

  • After Authorisation you’l see a “Two Minute Reports” pop up window, where you can add the API key we got from Step 1.
  • After which you can create a “Query Config” where we can enter upto 1000 URLs for checking their PageSpeed.
  • In the Query Config section, select the Method of your choice. Selecting Rolling 28Day will fetch data from the Chrome UX Report API. And selecting RealTime will fetch data from the PageSpeed Insights API.
  • The difference is that the Realtime option scans your website in real-time and gives you more additional metrics than the other method.
  • However, such a realtime scan can sometimes result in data not being representative of the real-world user experience. This can be overcome by using the Rolling 28Day data. This method aggregates data from real-world users, allowing you to get a consolidated view of your user experience.
  • You can scan up to 1000 URLs at a time using the Rolling 28Day method vs 5 URLs in the Realtime method
  • Once you have added your URLs, pressing save will process the URLs and save the Query Config.
  • Then finally Click Connect and Create Report buttons as they appear.

Now you can select data your need from the right sidebar and create reports to your liking.

Try Two Minute Reports for PageSpeed Insights for Free and start managing your SEO tasks in a breeze within Google Data Studio. Cheers!

Was this helpful?