Posted on 2009-02-19
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
    LVL 23

    Accepted Solution

    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

    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

    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

    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.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Suggested Solutions

    Backlinks, links pointing to a site, are a critical part of an SEO campaign as they directly effect a large portion of search engines' ranking algorithms ( Links are what help search engines dete…
    A/B testing is a simple and effective trick to get to know your audience, increase website conversions and make the most out of your online ad campaigns. It's widely available and doesn't need much tech knowledge to be executed, but the results it y…
    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…
    This Micro Tutorial will demonstrate how to add subdomains to your content reports. This can be very importing in having a site with multiple subdomains.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now