Google Search Console Explorer (Google Sheets Edition) V1

	B	C	D	F	H	I	J
1	Google Search Console Explorer
2
3
4
5	What is this?						Made by @hannahrampton
6
7	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. Features include:
8
9
10		Advanced Search			Top Insights (Gain and Loss)
11		Search for and exclude queries using contains or regexmatch			See those with the greatest gains and losses in a leaderboard format
12		Smarter Sorting			Segmented Gain and Loss
13		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
14		New Queries			SERP Distribution (Top 30)
15		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
16		Lost Queries			[Optional] Add Search Volume data
17		See all the queries no longer receiving impressions compared to the prev period			Add your Keyword Keg export for search volume and trends alongside
18
19	Data Needed
20
21		REQUIRED: This tool uses data from your Google Search Console, imported using the steps outlined below.
22
23		GO TO GOOGLE SEARCH CONSOLE
24		http://search.google.com/performance/search-analytics
25
26		OPTIONAL: This tool can also leverage search volumes and annual trends using a Keyword Keg export. Additional steps also below.
27
28		GO TO KWK BULK UPLOAD
29		https://app.keywordkeg.com/bulk-upload
30
31
32
33	Setup
34
35			REQUIRED	REQUIRED	OPTIONAL
36			STEP 1	STEP 2	STEP 3
37
38			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'.
39
40			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
41
42			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.
43
44			4. Export your data
45
46
47
48			You're ready to go! Explore.
49			You're ready to go! Explore.
50
51
52
53	Examples to get started
54
55
56	Search for multiple queries	>	Go to 'Search All' and use the search field to enter multiple queries separated by pipe/bar E.g. motorcycle\|motorbike
57
58
59	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.
60
61
62	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.
63
64
65
66
67	Help Others
68
69	If you found this helpful, please share with others. Click the links below to share on your social channels:
70
71
72	Direct Link		https://www.hannahrampton.co.uk/search-console-explorer-sheet-free-google-sheet/
73	Twitter		http://www.twitter.com/share?url=https://www.hannahrampton.co.uk/search-console-explorer-sheet-free-google-sheet/
74	LinkedIn		https://www.linkedin.com/sharing/share-offsite/?url=https://www.hannahrampton.co.uk/search-console-explorer-sheet-free-google-sheet/
75
76
77
78	Icon by Freepik from www.flaticon.com					Made by Hannah Rampton. Connect with me on Twitter via	@hannahrampton