Here’s a handy spreadsheet to help you record your best keyword phrases
Ideally when optimising a website you need to do some keyword research and then record the best phrases in a simple list; with a little further information on each phrase.
|
Free 5 Point SEO Action Plan Enter details below: You'll receive your 5 Point Action Plan within 48 working hours. All countries welcome.Click Here to learn more. |
I generally use a simple spreadsheet to do this and recently have moved over to using a Google Docs spreadsheet, as it is easier to share them with my clients.
So how does it work? Basically it is simply a way to store the keyword phrases with a little information around them. So the first column is the keywords themselves, then where I found them. The Search Volume column information I get from the Google AdWords keyword tool and gives some idea of the sorts of traffic you could expect from a high position. The final column is for any comments about the keyword.
Try it yourself – Add you own keywords
And that’s all there is to it. As I say it is a Google Docs spreadsheet so if you want to download it click “File” and then “Download as” Excel.
If you are a Google Docs user you can then upload the Excel file as a Google Docs spreadsheet and use it for your own keywords using Google Docs.
Download the Keyword Master List Template Now
Found it useful, or think some improvements could be made? Let me know below or through Twitter.
I’m just about to launch and need to learn seo, was directed here by twitter posts and so glad. It’s going to be a great start for me thank you.
Hi Bee,
I’m pleased you’ve found the site and wish you luck with learning more about search engine optimisation. To get started you can get 30 days free access to Premium SEO Membership to see how you get on.
Regards,
David
I hadn’t thought to use a spreadsheet to keep a track of keywords so this will be very useful! Thankyou
very good!
Hi Margaret,
Many thanks for your comments and feed back and I’m pleased you are finding the website useful.
David
I’m just starting to work seriously on keywords and ways of optimising my websites.
I think this template will be really helpful.
Thank you.
The rest of the site it good, too. For a beginner, like me, it’s a great place to learn.