Continued from page 1
Once you have added all keywords in right pane which are applicable for your site, click on next keyword in left pane which is applicable for your site. Once again, WordTracker will display a list of keywords in right pane which contain keyword you had clicked on in left pane. Again, copy keywords in right pane which are applicable for your site and paste them in first column of your spreadsheet. Also, copy figures present in Count column and paste them in second column beside corresponding keywords. Repeat this process for each of keywords in left pane.
Step 5: Once you have finished with all keywords in left pane, press your browser's Back button a number of times until WordTracker again displays text box which asks you to type in a keyword. Type in second keyword in your original list (i.e. "travel to Australia"), click on "Proceed >>" button and repeat Step 4. Do this for each of keywords that you developed in Step 1.
Step 6: Go to AltaVista. Search for first keyword that is present in your spreadsheet using exact match search (i.e. you should wrap keyword in quotes, i.e. you should type a quotation mark before typing keyword and a quotation mark after typing it). AltaVista will return number of sites which are relevant to that keyword. Add this number to third column of spreadsheet in same row in which keyword is present. Repeat this process for each of keywords present in your spreadsheet. Once you have done that, your first column will contain keywords, your second column will show popularity of keywords and your third column will contain number of sites you are competing against to get a high ranking for those keywords.
Now it's time to calculate KEI!
Step 7: The Keyword Effectiveness Index is square of popularity of a keyword multiplied by 1000 and divided by number of sites which appear in AltaVista for that keyword. It is designed to measure which keywords are worth optimizing your site for. Higher KEI, better keyword. How formula for KEI is arrived at is beyond scope of this article. If you want to know, send a blank email to mailto:kei@1stSearchRanking.com
If you had used spreadsheet file that I created for you (see Step 2), you won't need to enter formula for calculating KEI yourself. The KEI would be automatically calculated for you moment you enter values in columns 2 and 3. You can go straight to Step 8.
In case you didn't download file, here's how you can calculate KEI.
I am assuming that you have created spreadsheet columns in way I recommended in Step 3 and that you are using Microsoft Excel. If you using some other spreadsheet program, you will need to adjust formula to requirements of your spreadsheet program. Click on cell D2. Type in following exactly as it is shown:
=IF(C2<>0,B2^2/C2*1000,B2^2*1000)
Then click on Copy button to copy formula, select all cells in column 4 which have keywords associated with them and press Paste button to paste formula. The KEI for each keyword will be displayed.
Step 8: Use your spreadsheet program's Sort feature to sort rows in descending order of KEI. In Excel 97, you would click on Data menu, click on Sort menu item, choose KEI from drop-down combo box named "Sort by", click on "Descending" option next to it, and then click on OK.
And guess what - that's it! You now know keywords which you should optimize your site for. You can now start optimizing your site one by one for each keyword, starting with keyword with highest KEI. Exactly how many of keywords you choose to optimize your site for largely depends on amount of time that you can spare from your normal business activities. But whatever number of keywords that you target, it obviously makes sense to go for most effective keywords first.
Tying up loose ends:
The number of related keywords that WordTracker displays in trial version is limited. In order to get all keywords which are related to keywords you had developed in Step 1, you would need to subscribe to WordTracker's paid service. We highly recommend that you do subscribe to WordTracker's paid service as otherwise, you will miss out on a lot of keywords that can prove to be extremely valuable to you.
Article by Sumantra Roy. Sumantra is one of the most respected search engine positioning specialists on the Internet. To have Sumantra's company place your site at the top of the search engines, go to http://the-easy-way.com/main.html For more advice on how you can take your web site to the top of the search engines, subscribe to his FREE newsletter by going to http://the-easy-way.com/newsletter.html