SEO keyword tool

Status
Not open for further replies.
K

ke111

New member
May 8, 2008
109
1
0
I was doing some preliminary keyword research using the free SEO tool and was wondering whether anyone could provide some ball park figures of how many searches would indicate that you potentially have a good niche or term?

For example, if a term gets less than 500 searches should you forget about it?

Or, if a term gets over 1,000 searches, does that mean it's a potentially good niche?
 


It depends on the competetion. Search it in Google "Keyword here" I like to do anything over 300 searchers with under 300K competetion. That's just my preference.

This does bring me to a question I've had for a while....does anyone have a good competetion ratio number? search/competetion = x?
 
turbolapp said:
It depends on the competetion. Search it in Google "Keyword here" I like to do anything over 300 searchers with under 300K competetion. That's just my preference.

This does bring me to a question I've had for a while....does anyone have a good competetion ratio number? search/competetion = x?
Click to expand...

Keyword Effectiveness Index (KEI) Explained
^^ It's a good start. KEI essentially measures how easy it would be to rank for a keyword.
 
Start with KEI (Wordtracker - you can access this link without an account). Above 10 is good.
Use common sense. Sometimes, it can be unreliable.
If you need something to start with, it is good.

Wordze also shows KEI, and along with it, displays "Word Rank" (I don't know if you can access this link without an account) - so, both of these together should tell you something.

If you are not using any paid tools:
Go to SEOBook Keyword Suggestion Tool and type in the keyword phrase
Export to CSV and open using Excel
You can type the exact phrase and find out the competition
Enter the numbers & formula in Excel and do the analysis
Don't get bogged down - if you are doing PPC - analyze the top "action mode" keyword phrases. If you are aiming for organic search traffic, analyze the top "information mode" keyword phrases. This will give you an idea.
Edit: The first link is the same as the one posted by Rasher - guess I was typing while he posted it!
 
  • Like
Reactions: turbolapp
what do you mean google keyword here? are you talking about the google keyword tool?
 
ToJilldomains:

You said enter the numbers and formulae and do the analysis....what exactly is this formulae and how would you go about doing the calculation?
 
If this is the formula you are talking about, it just sounds too complicated
[FONT=Arial, Helvetica, sans-serif]A good KEI must satisfy all the 3 axioms. Let P denote the popularity of the keyword and C the competitiveness.[/FONT]
[FONT=Arial, Helvetica, sans-serif]The formula that we have chosen is KEI = (P^2/C), i.e. KEI is the square of the popularity of the keyword and divided by its competitiveness. This formula satisfies all the 3 axioms:[/FONT]
[FONT=Arial, Helvetica, sans-serif]i) If P increases, P^2 increases and hence KEI increases. Hence, Axiom 1 is satisfied.[/FONT]
[FONT=Arial, Helvetica, sans-serif]ii) If C increases, KEI decreases and hence, Axiom 2 is satisfied.[/FONT]
[FONT=Arial, Helvetica, sans-serif]iii) If P and C both increase such that P/C is the same as before, KEI increases since KEI can be written as[/FONT]
[FONT=Arial, Helvetica, sans-serif]KEI = (P^2/C) = (P/C * P). Since P/C remains the same, and P increases, KEI must increase. Hence, Axiom 3 is satisfied.[/FONT]
 
ke111:

When you do the search using the free tool, it will show you the number of searches.
When you export that to Excel, you will have those numbers inside Excel, ready for analysis.

Now, you need to analyze the competition. So, you should go to Google, and type in the keyword phrase with quotes, and see how many results are there.
Enter this number into a new column in Excel.

Optional: If you want to analyze further, type in allintitle:keyword in Google, to see how many pages are there with the proper title - if there are not many, you have a better chance, with on-page optimization. (Note: This step is optional - you need to do this only if you have a sufficiently high volume keyword)

After you have done all these steps, in the next column (new column, ok?), enter the formula for KEI for all the cells in that column - it is available at the link which fast Rasher posted before me ;)

Now, you will see the KEI for all of those keywords. Analyze the KEI values, and use common sense.

Does this make sense?
 
That's right, I totally forgot about KEI. What do you guys look for when calculating KEI? I mean obviously the higher the better....but do you guys have any specific cutt off point you are hoping for?
 
jilldomains:

It's making more sense. So, in the 3rd column, I should type in this formula? KEI = (P^2/C).
 
KEI - no hard and fast rules - when a niche has multiple keyword phrases with KEIs around 300, it should be a great one to research further.

Personally, I do not use KEI much (I used it a lot when I started) nowadays, except to gauge the level of competition.

If you are researching only one niche, just do the exact phrase search, and do the allintitle search. See how many results are there. Also, for both, check the PR of the top 10 sites.


If a niche is sufficiently lucrative, you can go after it, even if it is currently very competitive. Be prepared to work hard for a long period. It will be worth the effort, though.

ke111: I should have an Excel sheet which I used to work with - I will send it to you in the evening or tomorrow morning. PM me if I forget.
 
Interesting post... there are many tools out there that make this whole process a much easier, quicker and effective one... thanks for the post and the info.
 
Excel sheet for calculating KEI in different ways

I just thought I will post it here.

KEI-WT is according to the WordTracker formula.
If you are using only this, anything above 10 should be good.

KEI-Total shows you the effectiveness w.r.t. total search volume per day.
It is my formula.

KEI-Title is based on the total search volume per day, but competitiveness is assessed based on the number of "title search results" out there.
Again, it is my customized formula.

If you are using all of these, do not use the magic number "10" to decide which one is good and which one is bad.

The number depends on the niche, many a time. So, do a comparison based analysis for each niche, and not one based on absolute values.

Plug in the values for the searches and search results, and the KEI columns will update automatically.

It should be pretty simple to use.
 

Attachments

KEI Columns:

To extend the KEI formula downwards, just drag the last cells (with formula) of the KEI columns downwards.
 
Status
Not open for further replies.
Top Bottom