|Google Search Console Explorer|
What is this?
|Made by @hannahrampton|
|This free Google Sheet can help you to explore your Google Search Console data and find quick insights. |
Go to File > Make a Copy to get started.
Top Insights (Gain and Loss)
Search for and exclude queries using contains or regexmatch
See those with the greatest gains and losses in a leaderboard format
Segmented Gain and Loss
Order in more insightful ways such as Click Gain or Loss, Impression Gain or Loss
See the real picture with segmented gain and loss according to your search
SERP Distribution (Top 30)
See all the new queries now receiving impressions which did not in the prev period
Clicks and Impressions are divided into the top 3 pages of the results based on average position
[Optional] Add Search Volume data
See all the queries no longer receiving impressions compared to the prev period
Add your Keyword Keg export for search volume and trends alongside
|REQUIRED: This tool uses data from your Google Search Console, imported using the steps outlined below.|
GO TO GOOGLE SEARCH CONSOLE
|OPTIONAL: This tool can also leverage search volumes and annual trends using a Keyword Keg export. Additional steps also below.|
GO TO KWK BULK UPLOAD
|1. Go to your Performance area of Google Search Console||1. Go to tab|
'PASTE DATA HERE > GSC'
Follow the guidance there to add your data, pasting both headers and data
|If you use Keyword Keg, you can add an export to 'OPTIONAL: PASTE KWK'.|
|2. Select all four boxes (Clicks, Impressions, CTR and Avg Position)||Once exported, follow the guidance outlined in the tab above to add your data|
|3. Select comparison time period of your choice||To gather the related data, select all the keywords from your Search Console export and import these into the Bulk Uploader on Keyword Keg.|
|4. Export your data|
|You're ready to go! Explore.|
Examples to get started
|Search for multiple queries||>||Go to 'Search All' and use the search field to enter multiple queries separated by pipe/bar|
|See lost queries and explore related via search||>||View lost queries in either 'New and Lost' or 'List of Lost Terms'. |
Explore related themes by searching within all data to see how related terms have been affected.
|Quickly see the top performers and greatest decline||>||Go to Top Insights tab and select the amount of results to show. A list of those with the most gain and loss will be presented. |
This list can be further refined using the include or exclude search options.
|If you found this helpful, please share with others. Click the links below to share on your social channels:|
Icon by Freepik from www.flaticon.com
Made by Hannah Rampton. Connect with me on Twitter via