]
  • seo featured image

Get the Most Out of Search Console Using Google Data Studio

Google Search Console is not a great keyword reporting tool. You can’t save custom reports. You can’t create your own filters. And, you’re limited to 1,000 results. These limitations make analyzing organic search data a time-consuming, and often fruitless, task.

Although improvements are coming to Search Console, you can get the most out of the data today by integrating it with Google Data Studio. There, you can do everything I mentioned above that isn’t possible in Search Console.

Plus, you get way more keyword data! See below – 5,957 keywords!

more seo keyword data with data studio

In this post, I’ll share a few ways that I’ve been able to get much more value out of Search Console using Data Studio. The primary benefit is that you can save all of the reports and configurations so that you can access the always-updated data at anytime.

Here’s what you’ll learn:

See live examples of all these filters in this Data Studio report:

Create a Filter Control to Separate Brand and Non-Brand Queries

If you want split your brand and non-brand keywords in Search Console, you’re limited to entering one phrase into the query filter.

search console query filter

This isn’t much help if your website ranks for multiple brand names or has brand misspellings. But with Data Studio, you can create a filter that includes any and all variations of your brand.

Here’s what the result looks like:

google data studio brand non-brand keyword filter for search console data

Here’s how you can create your own:

  1. After integrating Search Console with Data Studio, create a table with the data you’d like to view
  2. With your table created, add a filter control
  3. Set your data source to your Search Console profile
    data studio filter control properties
  4. Click on the green oval to set a dimension
  5. Select “Create New Dimension”
    data studio create new dimension
  6. Name your new brand / non-brand keyword filter
  7. Write the formula for your new dimension using a CASE statement to segment brand terms from non-brand terms
    data studio case statement for brand non-brand keyword filter
  8. Here’s how you should enter the CASE statement:
    CASE WHEN REGEXP_MATCH(Query, ".*brand name.*|.*brand nmae.*|.*brand variation.*") THEN "Brand" ELSE "Non-Brand" END
  9. Breaking down the CASE statement:
    1. CASE WHEN
      1. This is how you open a CASE statement
    2. REGEXP_MATCH(Query, “.*regular expression.*”)
      1. Using this formula, you can write a regular expression that captures all the variations of your brand names
      2. Add “.*” before and after your brand phrases to capture all of them
      3. Use the “|” symbol to separate unique variations of your brand phrases
    3. THEN “Brand”
      1. This categorizes every keyword that meets your regular expression rules as a “Brand” query
    4. ELSE “Non-Brand”
      1. Every keyword that does not match your regular expression will be categorized as “non-brand”
    5. END
      1. Ends the CASE statement
  10. Hit “Done” to save your new dimension
  11. Go back to your filter control and select your new dimension
    data studio filter control
  12. Specify a metric to display in your filter control (I use Clicks)

You now have a filter that allows you to quickly switch between viewing brand and non-brand keyword performance.

Create a Filter Control to See Short-Tail vs Long-Tail Keywords

I know when I dive deep into Search Console, I’m often searching for untapped long-tail keyword opportunities. However, there’s no filter for keyword length. So, I created one in Data Studio using a CASE statement.

Here’s what the result looks like:

data studio keyword word count filter with search console

This filter lets you view keywords by their word count.

Here’s how you can create your own:

  1. After integrating Search Console with Data Studio, create a table with the data you’d like to view
  2. With your table created, add a filter control
  3. Set your data source to your Search Console profile
    data studio filter control properties
  4. Click on the green oval to set a dimension
  5. Select “Create New Dimension”
    data studio create new dimension
  6. Name your new keyword word count filter
  7. Write the formula for your new dimension using a CASE statement to categorize keywords by their word count
    data studio keyword word count filter using search console
  8. Here’s how you should enter the CASE statement to categorize keywords by word count for up to 8 words (you can do more or less by lengthening or shortening this statement):
    CASE WHEN REGEXP_MATCH(Query, "^[a-zA-z0-9]+ [a-zA-z0-9]+ [a-zA-z0-9]+ [a-zA-z0-9]+ [a-zA-z0-9]+ [a-zA-z0-9]+ [a-zA-z0-9]+$") THEN "7 Words" WHEN REGEXP_MATCH(Search Query, "^[a-zA-z0-9]+ [a-zA-z0-9]+ [a-zA-z0-9]+ [a-zA-z0-9]+ [a-zA-z0-9]+ [a-zA-z0-9]+$") THEN "6 Words" WHEN REGEXP_MATCH(Search Query, "^[a-zA-z0-9]+ [a-zA-z0-9]+ [a-zA-z0-9]+ [a-zA-z0-9]+ [a-zA-z0-9]+$") THEN "5 Words" WHEN REGEXP_MATCH(Search Query, "^[a-zA-z0-9]+ [a-zA-z0-9]+ [a-zA-z0-9]+ [a-zA-z0-9]+$") THEN "4 Words" WHEN REGEXP_MATCH(Search Query, "^[a-zA-z0-9]+ [a-zA-z0-9]+ [a-zA-z0-9]+$") THEN "3 Words" WHEN REGEXP_MATCH(Search Query, "^[a-zA-z0-9]+ [a-zA-z0-9]+$") THEN "2 Words" WHEN REGEXP_MATCH(Search Query, "^[a-zA-z0-9]+$") THEN "1 Word" ELSE "8+ Words" END
  9. Breaking down the CASE statement:
    1. CASE WHEN
      1. This is how you open a CASE statement
    2. REGEXP_MATCH(Query, “^[a-zA-z0-9]+$…”)
      1. Using this formula, you can write a regular expression that counts the number of spaces in a query to determine how many words it’s composed of
    3. THEN “[#] Word[s]”
      1. This categorizes every keyword by its word count
    4. ELSE “8+ Words”
      1. I cap the categorization at 8+ words. You can choose differently
    5. END
      1. Ends the CASE statement
  10. Hit “Done” to save your new dimension
  11. Go back to your filter control and select your new dimension

I recommend selecting the “Expandable” style option for easy filtering.

style data studio filter control properties

Now can can filter keywords by their word count to quickly assess short- to long-tail optimization opportunities.

Create a Filter to View Keywords at Specified Ranking Positions

If you want to view, say, keywords that rank between position 4 and 7 in Search Console, your only option is to export 1,000 keywords to a CSV. Using Excel or Sheets, you can then filter by ranking position.

By building this filter into Data Studio, you’ll save yourself time and and be able to view a lot more keyword data.

Here’s what the result looks like:

filter keywords by ranking position in data studio

Here’s how you can create your own:

  1. In Data Studio, select the table that you’d like to apply this filter to.
  2. In the “Table properties” menu, scroll to the bottom and select “Table filter”
    table filter in data studio
  3. Click “Create a Filter”
    create a filter button in data studio
  4. Name your filter
  5. Use the options to specify how you’d like to filter the ranking positions
    data studio table filter for keyword ranking position filter
  6. Click “Save”

Now you have a table that filters keywords by the ranking positions you specified, making quick analysis for optimization opportunities possible.


By using Data Studio you can get so much more value out of Search Console data. Let me know if you come up with any new filters or helpful functionalities and I’ll add them to this list.

By | 2017-09-11T00:19:19+00:00 September 11th, 2017|SEO, Tools|0 Comments