Decide
out the base keyword phrase of your site.(Keywords are
too general...instead use key phrase)
Go
to : http://inventory.overture.com/d/searchinventory/suggestion/
start a search using your base key phrase and overture
will return you a list of related key phrases actually
used in that search engine.They also give you the no of
searches made last month using a particular keywords.
Open
any spreadsheet program . I assume you are using Microsoft
Excel. If you are using some other spreadsheet program,
just change the spreadsheet related procedures outlined
here to fit your program. Create 4 columns - one for the
keyword, one for the popularity of the keyword,
one for the number of sites that appear in AltaVista
for that keyword and the last for something I call the
Keyword Effectiveness Index (don't worry - I'll
explain what KEI means later on). In order to ensure that
you can follow what I am saying, I recommend that you
add the following column headers to the first four columns
of the first row of your spreadsheet:
Now
write down the key words/phrases found from overture(Search
Term)in keyword column,No of searches fig.(Count) in popularity
column.
Go
to http://www.altavista.com
.Search for the first keyword that is present in your
spreadsheet using exact match search (i.e. you should
wrap the keyword in quotes, i.e. you should type a quotation
mark before typing the keyword and a quotation mark after
typing it). AltaVista will return the number of sites
which are relevant to that keyword. Add this number to
the third column(No. of Competitors ) of the spreadsheet
in the same row in which the keyword is present. Repeat
this process for each of the keywords present in your
spreadsheet. Once you have done that, your first column
will contain the keywords, your second column will show
the popularity of the keywords and your third column will
contain the number of sites you are competing against
to get a high ranking for those keywords.
Now..calculation
of Keyword Effectiveness Index .The Keyword Effectiveness
Index is the square of the popularity of a keyword multiplied
by 1000 and divided by the number of sites which appear
in AltaVista for that keyword. It is designed to measure
which keywords are worth optimizing your site for. Higher
the KEI, better the keyword. Click on top cell
of column KEI. Type in the following exactly as it is
shown: =IF(C2<>0,B2^2/C2*1000,0) Then click on
the Copy button to copy the formula, select all the cells
in column 4 which have keywords associated with them and
press the Paste button to paste the formula. The KEI for
each keyword will be displayed.
Use
your spreadsheet program's Sort feature to sort the rows
in descending order of the KEI. In Excel 97, you would
click on the Data menu, click on the Sort menu item, choose
KEI from the drop-down combo box named "Sort by", click
on the "Descending" option next to it, and then click
on OK.
You
can now start optimizing your site one by one for each
keyword, starting with the keyword with the highest KEI.But
remember.. don't take more than 5 key phrases/words
for a single page.
Why?
You will find it difficult to optimize your page for all
of them and your keyword prominence goes down.
If
you don't want to do this research work manually,there
is an excellent service from Word
Tracker ...they do the same thing for you but for
hundreds of popular keywords.
To
learn more about Wordtracker, please click here
