Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium



Posted on 2009-02-19
Medium Priority
Last Modified: 2012-05-06
I am having trouble believing my own figures, so I am wondering if i have the formula wrong in the spreadsheet.

Having started some research on various keywords I am fidning they all have very high KEI/KOI/KFI fingures.

I have created a spreadsheet for working out the KEI/KOI and KFI  and using Google's Keyword Tool started filling in the figures, which for one particular keyword returned these: (it was just a one word keyword)

Approx Avg Search Volume: 7,480,000
Competition: 72,700,000
allinachor: 1,190
allintitle: 3,400,000

Which with my formula gives

KEI: 769,606.60
KOI: 47,017,142,857.14
KFI: 16,456,000.00

Having been used to finding higher competitive keywords with very low KEI, I am a little shocked to find find keywords with such high ones, does this really mean they are high searched low competition keyword?  

What does such a high KEI really mean?

Or have I just got a fault in my formula?
Question by:wood1e
  • 2
  • 2
LVL 23

Accepted Solution

Tony McCreath earned 2000 total points
ID: 23690511
If you've recently started getting your search volumes from google then you will probably be entering in far higher search values than before. And therefore getting bigger results.

As long as you use the same data sources for all your keywords then your results will be comparable.

Also, google provides results based on the whole world or for specific regions. Make sure you set this correctly before gathering data

Author Comment

ID: 23691140
Thanks for that, it is just surprising that so many keywords in my niche are soo uncompetitive, with high search numbers.  It seems strange that no-one else in my niche has even attempted to optimise their sites....

Author Comment

ID: 23691148
PS, I am new to this niche, so are the figures, as you say they will be comparable over time.. Would it be better to stick with Google (as I can pick my country/region etc) for average searches or use a 3rd party software like WebCEO, where I can't!
LVL 23

Expert Comment

by:Tony McCreath
ID: 23691658
Googles service is very new and it's long term existence is not certain!

It does have access to more data than any other service of the type, and the ability to focus on regions is a bonus.

I'd try Google. If you have to switch later and are trying to do historical comparisons then note down the change over time and maybe work out an adjustment factor to make things equal out.


Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SEO can be a real minefield to navigate, but there are three simple ways to up your SEO game just be re-assessing your content output.
Some of the SEO trends we might expect in 2017.
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question