Google Search Console: New Free Keyword Data Template

Google has set up a new, free template to easily analyze keyword data from Google Search Console. With Bubble Chart you have a visual overview for your keyword data. Previously you needed other tools to do this – now it’s a standard template from Google. And that saves a lot of time. In this article I will take you through how to use this and what you can get out of it.

How do you use the Google Search Console Bubble Chart?

The Google Search Console Bubble Chart makes it easy to gain insight into keyword data. With the click of a button you have insight into the performance. Thanks to the Bubble Chart you can quickly see which keywords are performing well for your site and which can be improved.

To work:

  1. Sign in with a Google account that contains the Google Search Console account you want to analyze.
  2. If you’re signed in with the correct Google account, find the Bubble Chart template here† To be sure, check again whether you have opened the template with the correct Google account.
  3. Then choose your Google Search Console account in the template from which you want to see data.
  4. The data is loaded and the Bubble Chart is completed.

Screenshot Google Bubble Chart

What can you see in the Bubble Chart?

The document shows how keywords are performing based on the following data:

  • The y-axis shows the average position for the keyword.
  • The x-axis shows the click-through rate on the keyword.
  • The size of the bubble shows how many clicks you have achieved through that keyword.
  • The color of the bubble shows which device it is (mobile, desktop or tablet).
  • The red dotted line shows the mean of the two axes.

Each bubble represents a keyword. The data used comes from the “site impressions” table from Google Search Console.

You can also filter by keyword so that you can focus the data. In addition, the Bubble Chart offers the possibility to filter on keywords, devices and countries. This allows you to quickly arrive at the correct data.

What insights can you gain from it?

That depends on many factors for each site, of course. Nevertheless, there are often a few general topics that are interesting to investigate. Here are a few tips on how to look at the Bubble Chart:

  • Do you have 1 very large bubble? Scratch yourself: aren’t you too dependent on this keyword? Even more interesting, how can you get even more of these bubbles?
  • Are you in 1st place with a keyword and is your CTR% below average? Then take a look at the SERP and try to find out what it contains.
  • Compare keyword data between different device categories. If you have place 1 on desktop with a keyword and place 10 on mobile, there may be something about your mobile view.

Disadvantages of the Google Search Console Bubble Chart

As so often there are advantages and disadvantages with these types of templates. Although it is a very handy way to analyze, you would also benefit from a little more insights.

For example, you don’t see how keyword data has evolved over time. For example, if you drop from 1st place to 10th place halfway through the period, your average position will still seem pretty good and it won’t give you a reason to look at the keyword. You would actually want this if it turns out that because of a change, such as a Google update, your position has plummeted. Fortunately, there are plenty of SEO tools that make this clear.

In addition, the filtering option is only intended to include keywords, not to exclude. Unless you’re really good with regular expressions (regular expressions are a way of describing patterns that allow software to recognize text) – but most of them aren’t. At least not myself. For example, if you want to exclude branded-search terms, this is now difficult to do.

Make use of it

All in all, the Bubble Chart gives you a good idea of ​​which keywords you should focus on and invest time on. Doing this without the Google Search Console Bubble Chart can cost you a lot of time. The Google Search Bubble Chart may not give you all the insights, but it will help you find keywords that you can optimize.

Source: Frankwatching by

*The article has been translated based on the content of Frankwatching by If there is any problem regarding the content, copyright, please leave a report below the article. We will try to process as quickly as possible to protect the rights of the author. Thank you very much!

*We just want readers to access information more quickly and easily with other multilingual content, instead of information only available in a certain language.

*We always respect the copyright of the content of the author and always include the original link of the source article.If the author disagrees, just leave the report below the article, the article will be edited or deleted at the request of the author. Thanks very much! Best regards!