Forgot Password?
SEO Certificate


1.2.2 Shortlist your keywords

Now you have a long and versatile list of keywords and keyphrases to choose from.

So let′s brush aside all stuff and shortlist your search terms. Again, you can choose between a free but long way to do this, or use Rank Tracker tool you already know to make this task a snap.

Option 1: Sweep away the keyword trash, by hand

Calculating KEI

Here we go with the magic wand of SEOs. That′s the SEO know–how called KEI, or Keyword Efficiency Index. This index shows you how good a keyword is for bringing traffic to your site.n

You need keywords with high KEI.

Here′s what the importance of your keywords depends on:

  • Relevance (R): it is how closely your keyword is related to what you offer to your customers.

We use the three–grade scale to estimate relevance. So now you need to make a separate column for Relevance in your spreadsheet, and put one of the following numbers next to each word or phrase:

  • 1 for Excellent
  • 2 for Good
  • 3 for Poor
  • Search Volume (SV): it is how many queries are made for a keyword per month.

Here′s how you can check Search Volume for each word or phrase in Google AdWords. Let′s say you want to check it for "free ecard":

  • go to Google AdWords Keyword Tool or use Google Keyword Tool by Rank Tracker
  • copy and paste the selected keywords
  • select the desired match type on the left (I′ll explain the options in a second)
  • select your region, language and devices you wish to scan the traffic for, wait a little bit and VOILA! you are now armed with the monthly search volumes for your keywords.

As promised, below is the description of the available match types. If you′ve already used Google Keyword Tool or simply know how they differ from each other, just skip this paragraph.

  1. So, broad match type is the default option. For example, for the query "free ecard" you′ll see the number of searches, containing either or both words "free" and "ecard" in any order, possibly along with other relevant terms. This number may also include singular/plural forms queries and synonyms.
  2. Choosing [Exact] match you′ll see how many times per month the keyphrase is searched exactly as it′s entered by a user.
  3. And, finally, the "Phrase" match will reflect the number of queries where words are in the same order as in your keyphrase – even if other words are present in that query. For example, the number of searches for "free ecard", will also include keywords like "free ecard happy birthday" or "free ecard funny".

If you are not an international business or by any reasons are not interested in the numbers of search queries from all over the world, select the necessary country in the Local monthly searches column. Note, that these figures may not be exactly accurate, but reflect general trends.

Now, in your spreadsheet, make a column for Search Volume and enter the number of search values for each phrase.

  • Competition (C): that′s how many websites try to rank for this keyword. Generally, all sites that have the same keyword as you are your online competition. And the fewer websites are optimized for the same keyword, the better KEI this keyword has.

The way to check competition is simple. Enter 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 Google competition for the free ecard keyword

In a separate column for Competition in your spreadsheet, enter values for each keyword.

Here′s an example of how your keywords table may look like:

Relevance, Search Volume and Competition Values in Excel worksheet
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
Keyword Efficiency Index formula

Sometimes I also use an improved formula for better estimation. It takes into account real relevance of your keywords.

Keyword Efficiency Index with Relevance
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.

Keyword Efficiency Index in Excel worksheet Keyword Efficiency Index in Excel worksheet

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.

You do not need many 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.)

Now you′ve got a nice list. We′ll target the green–marked keywords in the first turn, make use of the yellow ones as alternative and mind the red ones just in case.

Looks complicated? It definitely does, that′s why I′ll provide you with a quicker and easier way to perform the same check automatically. Stay tuned!


Add comment Hide comments

Comments page:
#3944 2015-01-11 18:41:10 baixar facebook

I think this is one of the most interesting articles I’ve read on this subject

#3941 2015-01-11 07:22:52 Ideamax SEO in Bulgaria

Is it a problem if I want to use keywords with a lower coefficient?

#3947 2015-01-11 23:22:33 Dan Richmond

Low KEI means that the keyword does not have much potential. So, your efforts may not get repaid at the end.

#3894 2014-11-14 03:07:19 Emilian R.

The KEI concept it is quite fascinating, actually, because brings the math into this ...random (until now) algorithm, but with this we have increased chances to gain this battle!

#3835 2014-06-29 01:11:53 A10 Games

good post.Thank for sharing

#3774 2013-12-19 01:18:54 Anstip Blogging Tips

I used Traffic Travis, is that tool good ?

#3777 2013-12-24 06:57:45 Dan Richmond


Traffic Travis is a known SEO tool and seems to be used by many SEOs. But from my personal perspective SEO PowerSuite tools are much more effective and convenient once you are dealing with Website Optimization and Internet Marketing.

#3740 2013-10-02 07:46:46 Dan Richmond

Hi Hieu.

Actually “Relevance” is a relative factor which defines how closely your keyword is related to the theme of your website and it is for you to determine this metric. That is why the formula Rank Tracker uses to calculate KEI is KEI = Sv/C

#3739 2013-10-02 00:38:42 Hieu Mai Trung


I just bought the PDF version of SEO in Practice ! I have read about KEI.

Follow what I understood, the Relevance is good if they made by human. How the Rank Checker software can make the relevance for keywords?

Or the Rank Checker just calculate by formula : KEI = Sv/C

Thank you!

#3728 2013-08-15 11:27:50 jepara online

Excellent suggestion of including the relevance factor. That always seems to be the linchpin of a word being worth marketing to.

#3689 2013-05-13 22:17:03 Fatemeh Bahari

how i must estimation and know what is relevence of my keyword? i cant understand how you estimation relevence of your keyword.
for example "buy healthy book" what is relevence of this keyword?
thanks for your answer and your kindness

#3694 2013-05-18 01:54:18 Dan Richmond

Hello Fatemeh.
“Relevance” is a relative factor, that shows how closely your keyword is related to the theme of your website. So it is for you to decide how closely the keyword fits the niche your website occupies and determine this metric.

#3627 2013-01-16 20:35:41 Birla Medisoft

I have a doubt regarding relevance(R). The R is assigned manually for a keyword or is there some formula for it. If it is assigned manually, then the result will be varied. Please clarify my doubt.

#3632 2013-01-28 06:21:44 Dan Richmond

Hello Birla.
Relevance is the factor that you set yourself. It is for you to decide, if you really need this factor (since it is not a compulsory one)and it's value, because it is for you to know if this or another keyword is related to the service or a product you are selling on your site.

Comments page: