🔍 Content Gap Finder // JSVCV [Public]
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGH
1
2
🔍 Content Gap Finder
3
Made by jsvxc
4
5
1) Install this add-on to pull in SC data:
6
searchanalyticsforsheets.com
7
8
2) Configure the add-on:
9
Authorize your sheet
10
Go to Add-ons >>> Search Analytics for Sheets >>> Open Sidebar
11
⚠️Make sure your Google account is authorized to use the Search Console property you want to back up!⚠️
12
Authorize.
13
Choose site.
14
Add Query & Page to the Group By box.
15
16
17
18
19
3) Choose Data Destination
20
In Results Sheet, select 'RAW DATA'
21
22
23
24
25
Request data.
26
Any existing data in the RAW DATA tab will be overwritten.
27
This will fill the tab with data.
28
29
4) Add search volumes for your keywords.
30
The quickest way to get a rough idea of search volumes is to use Keywords Everywhere.
31
It's a free chrome plugin that that allows you to bulk look up keywords. Go get it here:
32
Keywords Everywhere
33
Once you've added it, click on the KE icon & bulk upload:
34
35
36
37
Copy + paste in your keywords. Click Get Metrics
38
Now hit Copy:
39
40
41
42
Go to the Search Volumes tab.
43
Click in cell A1 and paste in your keywords.
44
45
4) Go look at your Content Gaps! 👍
46
The CONTENT GAPS tab will show you
47
48
49
50
51
52
Loading...
Main menu