Step-by-step Tutorial on Finding the Right Keywords to Optimize Your Site
This basic keyword research tutorial is the result of a suggestion made by The Lady Programmer. For this purpose, let’s pretend we have a freelance writer’s website. So obviously we want to find the right keywords starting with the keywords “freelance” and “writer”.
Why Google Keyword Tool?
I have 3 reasons why I’m using it for this tutorial:
1. It’s free!
2. I have used it at work.
3. It uses Google search results data. In short, it’s Google and more people are using it for their searches more than the other search engines.
Here’s the link to the tool: https://adwords.google.com/select/KeywordToolExternal
Step 1: Collect the Seeds
Seeds are the main keywords or the general keywords that our website is known for. And for the sake of our example, our top seeds would be “freelance”, “writer” and a combination of both which is “freelance writing”.
From these seeds we are going to find other keywords to help optimize our website. One main reason behind this is because our seed terms are usually general terms and therefore we will find more competition in the search results. By finding more specific keywords, we can have better chances of ranking using those keywords.
Step 2: Expand Those Seeds
How do we do this? I have two ways to expand seeds. First thing I would usually do is to get a thesaurus and find the synonyms to those seeds. So for “freelance” and “writer”, I found these synonyms:
self-employed, non-staff, free agent, unaffiliated
author, editor, journalist, columnist, biographer, copywriter, freelancer, scribe, screenwriter, reporter, blogger
Second, I would find a competitor website and spy…err…I mean, find out what keywords he is using. If you do this, at least find a competitor with a better ranking than yours.
Step 3: Preparing to Use the Google Keyword Tool
Okay, first thing you will have to do is decide what country’s search results data do you want to know. What this means is, in your opinion, from what country do your site’s visitors usually come from?
Find the phrase “Results are tailored to English, United States” and click on Edit. Choose the language and country of your choice. But for this tutorial, we’re going to use English, United States.

Step 4: Type Your Seeds and Start Looking for Your Keywords
Type your main keywords one keyword or phrase per line. You might want to cover all possible related keywords so better include both the singular and plural forms of your keywords as well as the misspellings.
Leave the box for “Use synonyms” checked to help you expand your keyword research. But when you have seen the results and you find that there are a lot of unrelated keywords, repeat the process but this time do not check the box.
Your results will look like this:

Whew! It’s quite a list, isn’t it? And as you can see, I just cut the image so there are still a lot of results.
Now you will want to download these data to your Excel or OpenOffice Calc and sort them all out. To do this, go to the end of the results and click on .csv.
Step 5: Sort Out Your Search Results Data Using Microsoft Excel or OpenOffice.Org Calc
Download the .csv file of your keyword research data and sort out data in any manner that you prefer. As for myself, I prefer to sort the data based on the Approximate Average Search Volume.

So that’s it! Now we have a fresh list of possible keywords that we can use to optimize our website. You can repeat the whole process with another set of seeds or main keywords so you can build on your previous data.
One thing that I want to point out is that a keyword research tool is still just a tool. It is up to you to form your own insight on the keyword data that you will gather and decide which keywords are the best ones for your needs.
As a rule, do not rely on just one tool. There are lots of other tools out there, both free and proprietary. You can use Keyword Discovery, WordTracker, SeoBook Keyword Suggestion Tool, and many others.
Good luck on your keyword research!



{ 9 comments… read them below or add one }
This is very insightful.
Can you further educate me on how I can put this keyword search list to use in optimizing my site?
Your suggestions will be highly appreciated.
The one I’ve been waiting for. Thanks for sharing! It’s worth a Digg!
I wonder if you are also using other keyword research tools – like KeywordSpy and WordTracker. Is it effective to use a combination of these, or is Google Keyword tool effective in itself?
Hi Gem,
Thanks for dropping by.
I have also tried SEO Book Keyword Suggestion Tool, WordTracker (not the free version), GoRank and a few others that I’ve already forgotten their names.
Use at least 3 keyword research tools to make a good comparison of the keywords that you want. It’s also a great way to spot trends on what keywords are the best to use.
I have a friend who is an SEO expert at U.S. Auto Parts and he uses Google Keyword Tool, SEO Book, WordTracker and GoRank all at the same time when he does keyword research. I learned what I posted here through him.
I also once worked for an Australian client, he’s an SEO expert and he tasked me with maintaining his online business’ PPC campaign as well as for his keyword research. He insisted on using only Google Keyword Tool, not because it’s free, but because he said we’re optimizing for Google so we should only use Google’s tool.
So I guess that’s it. If you want to optimize solely for Google, you can concentrate on using Google Keyword Tool.
If you want to optimize for Google as well as the other search engines, I suggest you use at least 3 different tools.
But between the two, I would prefer using more than one keyword tool.
I hope this helps.
Thanks for the clarification. I would probably use Google’s keyword tool first, then gradually use the others. Most traffic come from Google anyway.
Thank you very much for this very helpful information. I am curious about the following: what is the minimum volume you should consider in examining the keyword results, and what is too much volume (e.g., making for too much competition?)
Steve´s last blog post..Links for 2009-01-11 [del.icio.us]
certainly worth a digg!
have tried others (seobook and another online tool) but personally, i find the suggestions in google keyword tool pretty incomparable.
it would be nice to combine them true. i read the seomoz has a similar too. havent had the chance to explore it though.
awesome tutorial. dugg ^_^
techniqueal t.´s last blog post..Recent Comments Widget for Blogger CommentLuv Users
this is an excellent tutorial, I especially like your explanation about seed keywords.
brock @ mma gear´s last blog post..Shane Carwin T Shirt UFC 96
I also use the Google Keyword Research tool. Two thumbs up. Glad you are taking the time to help others with the tool.
A wonderful article…. In my life, I have never seen a man be so selfless in helping others around him to get along and get working. I feel good that there are people like you too. Thanks for this great weblog of yours. Its surely going to get me to go to higher places!