2.Get some good KEI(keyword efficiency index) keywords
There are many way to getting keywords which have good KEI .we can do manually or by using a tools like Ranktracker and many other.
Manual process is given-
Calculating KEI
This is a very very important step for SEOs. That's the SEO know-how called
KEI, or
Keyword Efficiency Index.
KEI give the actual picture about a keyword’s ability for for bringing traffic to your site.
We always prefer keywords with high KEI.
These are three things to measure KEI
Relevance (R): it is how closely a keywords represent our targeted business or product o customers.
We categories the keywords in three groups according to their relevance. And we add a column in sheet.
1 for Excellent
2 for Good
3 for Poor
Search Volume (Sv): It give idea about how many queries are made for a keyword per month.
We can check Search Volume for each word or phrase: go to
Wordtracker and typing the keyword or phrase in, say
free ecard. Wait a while, and along with keyword suggestions, we will
see number of searches
per month.
We can use Free Wordtracker Keyword Suggestion Tool
We
can see on this picture, people search for
free ecard 11384 times per day, or about 347201 times per month.
We make a column for Search Volume and enter the number of searches values for each phrase.
- Competition (C): This is the no. of site that have been althat's how many websites are already more or less optimized for that keyword. Generally, all the web sites that have the same keywords as you are your online competition. And the some websites are optimized for the same keyword, the better KEI this keyword has.
To check the competition is simple. Type
the keyword in Google and click to search. Now look at the image below to see where you find the Competition value:
Google competition for the free ecard keyword
In a separate column for Competition in your spreadsheet, enter values for each keyword.
Here's how your table will look:
Relevance, Search Volume and Competition Values in Excel worksheet
So what makes a KEI better? Higher relevance, higher search volume, and smaller competition.
Now, let's
count the magic KEI number for your keywords.
The classical formula for KEI looks like this:
Keyword Efficiency Index formula
More accurate form of formula as follow
KEI=(Sv*Sv/C)*(4--R)/3
Keyword Efficiency Index with Relevance
Now make a column for KEI in your Excel spreadsheet and apply the second formula to calculate KEI for each phrase.
Let's choose the best keywords
First, sort all keywords in your spreadsheet by KEI. As I already said, the higher KEI, the better your keywords.
We will
optimize not
keywords to optimize your site for, so look at your list and
choose top 5 keywords. Mark them as the major ones (say, color them
green.) Then,
choose the following 30 and mark them as important (you can color them
yellow.)
Some more 65 or so keywords should be marked as supplemental (e.g.
red.)
We
got a nice list. We will target the green-marked keywords first of all ,then make use of the yellow ones as alternative and mind the red ones just in case.
