Google Search Console Query Deep Diving

Oct 3, 2021 | How To, News | 0 comments

By Shane Pollard

Google Search Console 16 month view

Here is a little tip that I do to help get stuck websites momentum. You can find a similar report to what I am referencing if you visit your Google Search Console.

It is called Google Search Console query profiling.

This is a Do It Yourself tip.

In my circle and in agency land I keep hearing irrelevant references to topic entities and entity based SEO. The buzz word hype is real. 

But its real enough to take advantage of topics and user intent to help your website.

But do you know what your search console query diversity says about the scope of your content?

Did you know that missaligned terms at an exact URL level means the scope and theme of your content aren’t aligned well enough with focal queries?

Look at the relationship between queries by click and by impression.

To do this I dump out 16 months’ worth of URL > Query data in search analytics for Google sheets, then I will start to group queries together.

Google Search Console 16 month view

How I use Google Search Console (GSC) to Improve my SEO Content and acquire thousands of new website visitors: 

  1. Sign up then into GSC.
  2. Go to the “Performance” area.
  3. Filter results for the “Last 3 months”.
  4. Order Queries for Clicks then Impressions. 
  5. Analyze and notice top performing keywords. 
  6. Do the same for Pages. 
  7. Click “Export” at the top for Google Sheets.
  8. Open and freeze the top row. 
  9. Sort by “Position” A to Z. 
  10. Add a filter for “Position” between 5 and 25. 
  11. Find the page ranking for those keywords. 
  12. Create Upgrade Plan for each page. 
  13. Publish the updates. 
  14. Let Google do it’s thing. 
  15. Check results after 1 month. 

Most client websites have a lot of potential money-making pages sitting between position 5 & 25 in Google but may not know this. 

My job when engaged as an SEO Freelancer is to help pluck these pages from obscurity and put them in Google’s spotlight. 

Any time you have keywords in striking distance of Page 1 position 1-5 you should make an effort to improve the pages that those keywords are on so you get higher rankings and in turn more website visitors.

Doing this could be the difference in 1,000s of new visitors. Thousands of new potential customers.

We’re often too focused on new content. 

My Advice: Don’t forget about the old content.

Only then you can start re-writing your content to have a more targeted topical alignment with the focus keyword. Your content becomes better optimised for the search intent and Google will see this and reward you with higher rankings.

*This is not set and forget. If your competitor has a SEO Freelancer working on their pages this creates a game of chess between Google, Your competitor(s) and you.

If you plan ahead and monitor your results you can get a market share of the search terms. It takes work and that’s why SEO is never done once and is a journey.

I know the above might sound a tad confusing – I am looking to put some videos together to show and explain the process.

This is the exact process I use to build more informative pages based on what I find inside Google Search Console. You can do this yourself just by following this guide.

Explore More Marketing Insights

I Cleaned Up Agency Mistakes

I Cleaned Up Agency Mistakes

The title of this article has been a recurring occurrence over the last 7 years. Ive picked dup a lot of work as an expert in my field with requests generally coming in from past clients who know my quality of work but had to move on for various reasons. I would get...

read more
The DIY SEO Toolbox

The DIY SEO Toolbox

My goal is to educate and empower people to manage their businesses themselves or through their teams. To help get businesses back in control of their marketing and off heavy retainers of marketing agencies. I've done this for 20+ businesses and Ill share my toolbox...

read more
Keyword Research Process How To Guide

Keyword Research Process How To Guide

How to Assess Keywords When Researching Them There are many ways to do keyword research and Ive always found it best to be relevant to the demand of the task, so looking for organic keywords, looking for paid advertising keywords that cost money to target or looking...

read more

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *