StrategiQ - Keyword Research Document (Manyminds)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFG
1



https://strategiqmarketing.co.uk/
Unit 16, Brightwell Barns
Ipswich Road
Brightwell, Suffolk
IP10 0BJ
enquiries@strategiq.co
0333 358 3343
2
Instructions:
3
(You will need to make your own copy of this document in your Google Drive by going to 'File > Make a copy...')
4
1. Add your Search Analytics data from Google Search Console to the 'GSC data' sheet and select how many months of data you are using.
5
2. Add your keywords, keyword source search volume and competitiveness data to the 'Keyword data' sheet in columns B to F.
6
(Note, SEMrush works this out on a 1-100 scale whereas Google KWP uses a 0-1 scale. If you are using mixed data from both sources, it is best to divide the SEMrush data by 100 before inserting.)
7
3. Manually categorise and group each of your keywords as required in column D in the on the same sheet, labelled 'Category'
8
4. All other data in the 'keyword data' sheet from columns H to O will auto-populate with data, as will the data in the 'Category data' sheet
9
5. Use this data to help inform where you should focus your SEO efforts based on potential gains, competitiveness and gaps in your website.
10
11
Please send any issues or feedback via email (dan@strategiq.co) or Twitter (@callis1987). Thank you.
12
13
This tool was a free download as part of Dan Callis' 'Manyminds Give it a Go' conference talk in October 2017:
14
https://strategiqmarketing.co.uk/blog/keywords-everywhere-manyminds-giag-october-2017/
15
Loading...
 
 
 
Instructions
Keyword data
Category data
GSC data
CTR data
Category data (Pivot)
 
 
Main menu