Optimizing website performance with a Search Console bubble chart  |  Google Search Central Blog  |  Google Developers

Wednesday, April 06, 2022

Analyzing Search performance data is always a challenge, but even more so when you have plenty of long-tail queries,
which are harder to visualize and understand. In this post, we’ll provide tips to help you uncover opportunities to
optimize your site’s Google Search performance.

If you haven’t read our recent posts on connecting Search Console to Data Studio
and monitoring Search traffic with Data Studio,
consider checking them out to understand more about what you can do with Search Console in Data Studio.

Today we’ll discuss a bubble chart
that can help you understand which queries are performing well for your site, and which could be improved. We’ll first
explain the main elements in the chart, describing specific settings and how they influence the data. Then we’ll provide
some pointers on what to look for when analyzing the data.

Starting with the good news: you don’t need to build the chart from scratch, you can use
this templateconnect to your data,
and tweak any settings you want.

Without further ado…

Data Studio report showing a bubble chart with Search Console data

Understanding the chart

A bubble chart is a great visualization when you have multiple metrics and dimensions because it enables you to see
relationships and patterns in your data more effectively. In the example shown here, you can see traffic attributes
(click-through rate (CTR), average position)
and volume (total clicks) for different dimensions (query, device) at the same time.

We’ll go through some of the chart elements to clarify what it shows, and what it doesn’t.

Data source

For this chart, we’re using the Site Impression table available through the
Search Console data source
which includes Search
performance data
aggregated by site and queries.

Filters and data controls

In order to make it easy for you to control your data effectively, we included five customization options in the chart:

  1. Data control: Choose the Search Console
    property you’d like to analyze.
  2. Date range: Choose the date range you’d like to see in the report; by default you’ll see the last 28 days.
  3. Query: Include or exclude queries to focus on. You can use regular
    similar to the way you use them in Search Console.
  4. Country: Include or exclude countries.
  5. Device: Include or exclude device categories.


The axes in the chart are Average position (y-axis) and Site CTR (x-axis), but we made three significant transformations
to make the chart more insightful:

  • Reverse y-axis direction: Since the y-axis shows average position, inverting it means that 1 is at the top.
    For most business charts, the best position is in the top right corner, so it is more intuitive to invert the y-axis
    when using it to display average position.
  • Log scale: A logarithmic scale is
    “a way of displaying numerical data over a very wide range of values in a compact way (…) moving a unit of distance along
    the scale means the number has been multiplied by 10”. Using log scale for both axes enables you to have a better understanding
    of queries that are in the extremities of the chart (very low CTR, average position, or both).
  • Reference lines: The reference line
    is very helpful to highlight values that are above or below a certain threshold. Looking at the average, median, or a certain
    percentile can call attention to deviations from the pattern.


Each bubble in the chart represents a single query, and in order to make the chart more useful, we used two
style properties:

  • Size: Using the number of clicks as the bubble size helps you see in a glance which queries are driving the bulk
    of the traffic — the larger the bubble the more traffic the query generates.
  • Color: Using the device category as the bubble color helps you understand the differences between mobile and desktop
    Search performance. You can use any dimension as the color, but as the number of values increases, the harder it is to
    recognize patterns.

Analyzing the data

The goal of this visualization is to help surface query optimization opportunities. The chart shows query performance, where
the y-axis represents average positionthe x-axis represents CTRthe bubble size represents total number of
clicksand the bubble color represents device category.

The red reference lines show the average for each of the axes, which split the chart into quadrants, showing four types of
query performance. Your quadrants are likely to look different than the one shared in this post; they’ll depend on how your
site queries are distributed.

chart showing four types of query performance

In general, the chart will show four groups you can analyze to help you decide where to invest your time when optimizing your query performance.

  1. Top position, high CTR: There’s not much you need to do for those; you’re doing a great job already.
  2. Low position, high CTR: Those queries seem relevant to users; they get a high CTR even when ranking lower
    than the average query on your website. They could represent a significant contribution if their position goes up —
    invest in optimizing them!
  3. Low position, low CTR: When looking at queries with low CTR (this and the next bullet), it’s especially interesting to look
    at the bubble sizes to understand which queries have a low CTR but are still driving significant traffic. While the queries in this
    quadrant might seem unworthy of your effort, they can be divided into two main groups:

    • Related queries: If the query in question is important to you, it’s a good start to have it appearing in Search already.
      Prioritize these queries over queries that are not appearing in Search results at all, as they’ll be easier to optimize.
    • Unrelated queries: If the query is unrelated to your site, maybe it’s a good opportunity to fine-tune your content to
      focus on queries that will bring relevant traffic.
  4. Top position, low CTR: Those queries might have a low CTR for various reasons. You should check
    the largest bubbles to find signs of the following:

    • Your competitors may have structured data markup and are showing up with rich results, which might attract users to click
      their results instead of yours. Consider enabling Search result
      features for your site
    • You may have optimized, or be “accidentally” ranking, for a query that users are not interested in relation to your site.
    • Users may have already found the information they needed, for example your company’s opening hours, address, or phone number.

Optimizing your website performance

Once you find queries that are worth the time and effort, make sure to optimize for them with the help of the
SEO starter guide. Here are some tips:

  • Ensure that your title elements,
    description meta tagsand alt attributes are descriptive, specific, and accurate.
  • Use heading elements to emphasize important text and help create a hierarchical structure for your content, making it easier
    for users and search engines to navigate through your document.
  • Add structured data markup to describe your content to search engines and be eligible to display your content in useful
    (and eye-catching) ways in search results.
  • Think about the words that a user might search for to find a piece of your content. You can use the
    Keyword Planner provided by Google Ads to
    help you discover new keyword variations and see the approximate search volume for each keyword. You can also use
    Google Trends to find ideas from rising topics and queries
    related to your website.


As always, let us know if you have any questions through the Google
Search Central Community
or the Data Studio Community.
Also, if you’re on Twitter, make sure to follow usas we’ll announce future posts over there.

Leave a Comment