| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
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 | |||||||