Get the Top 10 Inbound Marketing News - once a month:

//   by Josh Bruce |

How to Export Every Search Term that you Rank for and their Average Positions

How to Export Every Search Term you Rank from Google Search Console

Have you imagined if you could download an accurate list of every search term your website ranks for and its corresponding page? Well, now you can!

There are various SEO tools which give estimates of this data, however, keyword research tools such as Ahrefs or SEMRush will often have outdated and inaccurate information. The most accurate data is inside the Google Search Console.

If you export this data, there are plenty of ways you can use this to help increase the traffic to your website.

Anyone familiar with using a ‘low hanging fruit’ strategy for SEO knows how important it is to find keywords that are on page two of the SERPs. With almost all click-throughs from the SERPs happening on page one, finding easy areas to improve and get on page one can have an instant impact on your website’s traffic.

Furthermore, any keywords that you’re not ranking highly for can be quickly highlighted as areas to improve.

This guide leads you through how you can export all your ranking data and how you can use this to get more traffic to your website.

Google Search Console

If you don’t have Google Search Console set up, there are multiple installation methods available. If you already have Google Analytics set up with Admin rights, you can verify it in seconds through connecting your Google Analytics account.

To view search analytics data, start by logging in to Google Search Console and navigate to the Performance section from the left-hand sidebar.

google search console performance

By viewing Performance statistics, you’ll be able to see lots of useful information about the search queries that users are searching to get on your website.

There is a range of filters available to investigate this data, including the Date, Query, Page, Country, and Device.

google search console filters

Select Query and Date at the top of the screen and you’ll see the average position of that specific query for the chosen date period.

Through this, you can compare the click-through rate (CTR) of different pages and look for areas where you could tweak the metadata to improve click-throughs or make changes to improve the rankings for specific keywords.

This is really useful information, however, Google only allows you to view the top 1000 queries or pages. If you’re running a large e-commerce website or blog, 1000 queries really aren’t that many. Fortunately, you can export ALL of your Google Search Console data by using a free Excel plugin called Analytics Edge.

How to View all your Keyword Data with Analytics Edge

1. Download Analytics Edge and install it on your computer.

2. Open Microsoft Excel and navigate to Analytics Edge at the top. Then click the padlock symbol and register your free Analytics Edge account.

analytics edge register

3. Once you have registered for the free trial, you will need to link the plugin to your Google Search Console account.

Click Google Search, and select Account to link your Google account to Analytics Edge. You will be prompted to enter your login details and allow the plugin to access the data.

analytics edge accounts

4. Once you’ve linked your accounts, select Search Analytics from the Google Search dropdown. You will see a list of all the websites you manage in Google Search Console. Choose the website you wish to examine from the dropdown and select Fields. Then add the page and query fields to Dimensions and click Finish.

analytics edge accounts

The default options for the date range will be the last 3 months. You can change this to any date range you wish in the ‘dates’ tab.

5. Once you’ve done this, every search term that your website ranks for on Google, and the corresponding landing page will be exported! This could be thousands of pages.

Using the Data to find Low Hanging Fruit

Apply filters to the data which allow you to sort the numbers from largest to smallest. You can then see every search term that is bringing traffic to your website on order from most to least. This is a great opportunity to look for search terms where you’re ranking on page two but still getting traffic to the website.

Identify high volume keywords where your website is ranked between 10th and 20th position. Below is an example where we’ve identified a few pages that are bringing high volumes of traffic to the website, without being on the first page of Google.

analytics edge accounts

Once you’ve identified these pages, you can look to improve these specific keywords by increasing the number of backlinks to those pages or by improving your on-page SEO elements.

Here are just 3 quick wins you can do to increase the likelihood of appearing on page one for these keywords and drive much more traffic to your website.

1. Improve Content

Increasing the content on your page is a quick SEO win. Generally speaking, pages with more content perform better than pages with lower content. Between 1500 and 2500 is a great amount to go for. Any pages with fewer than 300 words should be updated.

Content should also be relevant and high quality. The amount of time that users spend on your website is a ranking factor, so you want to make your content engaging so readers don’t leave your page.

2. Increase Links

Adding more links to your pages that aren’t on page one could give them the boost they need to get on page one. If you have an article that doesn’t have many internal links pointing to it, try adding more links to it from other pages on your website that have authority.

Backlinks are one of the most important SEO ranking factors and adding external links from high authority websites will increase your chances of ranking on page one. Try reaching out to bloggers in your niche and promoting your content or write guest posts on authority sites which link back to your content.

3. Update Title Tags

Your primary keyword should be placed at the front of your title tag. Look at the position of the keyword in the title and consider increasing the prominence of it to give it more SEO weighing. This will help Google identify it as an important keyword.

If your title tag is lower than 50 characters, try adding more characters to help either encourage click-through or add a long-tail keyword.

Google shows up to 65 characters in the SERPs so its good to take advantage of this and show as many useful characters as possible.

Conclusion – Export a Higher Quantity of Accurate Data

Combining Google Search Console and Analytics edge is the perfect way to access an accurate and broad set of data about your website. You can use this data to look for ways to find new keyword opportunities and bring more traffic to your website without being limited to the 1000 row limit in Google Search Console. This data is useful for other things too, such as finding a list of pages indexed by Google or analyzing Google algorithm updates.

Try out exporting your search analytics data and find out more that you knew was possible about how users find your website through Google!

Double Your Growth.

We curate the best of inbound marketing news and send over the top 10 we know will contribute to your growth - once a month.

Skip to toolbar