by George Peirson, 2/6/2006

So how do you go about creating the Master Keyword list? You first have to decide what you need from your keywords. Most likely you will have a product or service that will dictate the broad category for the list. As an example I will use Nikon Camera as my starting point. Maybe I have a site that specializes in information about Nikons, or I have a store that sells Nikon Cameras, or maybe I sell software that would complement a Nikon Camera. These questions and more will begin to focus your keyword search.

Start by building a basic list using this approach, you don't need to capitalize, leave everything lowercase.

nikon, nikon camera, nikon information, nikon sales, nikon software

Put down the basic keywords that spring into your head when thinking about your subject. This does not need to be an exhaustive list, just a starting point.

We now need to expand on this list by using tools freely available on the internet. My personal favorite is on Overture.com in their Resource Center. They have a valuable little tool called the Keyword Selector Tool. This tool will give you a list of keyword searches on Overture over a one month period. Simply type in your keyword and hit the button. You will get a list of keywords including the keyword you typed in and the number of searches performed on the keyword.

A search for "Nikon" came back with 100 keyword possibilities. Depending on your original keyword search you may have to clean this list up a bit before using it. For instance one of the keywords was "Nikon rifle scopes", not what I need so I will delete that one. I usually copy the information from this web page and paste it into an Excel spreadsheet where I can manipulate it as I like. Each month you may get a different set of keywords on Overture, so don't just do this one time and forget it. Keep on checking back to add more keywords to your list.

Another valuable tool is over on Google. (https://adwords.google.com/select/main?cmd=KeywordSandbox) You can also find this tool in the Tools section of Google Adwords. This is used like the Overture tool, simply type in your keyword and click on Get More Keywords. This search gave me 225 possible keywords, many of which I will clean out. A nice feature of the Adwords tool is that it allows you to download the list as a CSV file for use in Excel or another program.