SEO Keyword Competition Tool In Excel

June 25th, 2010

Here’s a little SEO tool built in Excel for getting an idea of how difficult a keyword will be to rank well in Google. It comes with a couple big caveats** but I think the overall idea works. Here’s how to use it:

1. Put your keyword choices in column A.

2. Use Google’s keyword tool to find the Local Monthly Searches (local means it gives you the results based on the specified location and language above the search button) for that keyword and paste those in column B.

3. Do a search for those keywords using the allintitle: operator and paste the amount of results into column C. Use the allintitle: operator so that you get a more accurate number of sites you’ll be competing with that use your keyword in their page title. Also put in a quote like this: allintitle:” so that it keeps your keyphrase together.

4. The spreadsheet is pre-formated to calculate the average popularity and competition of of those keywords once you do steps 1 -3 and will highlight in red the ones that are harder and green for the ones that are easier.

Download the SEO keyword competition tool in excel.

Let me know what you think!

*If one of the keywords is much more popular than the others it will skew the average quite a bit which all the other keywords are based on, so try using words that have similar popularity.

* The amount of search results for a given keyword is not the only factor for the competition of a keyword. The amount of backlinks to those pages is just as important, if not more so.

Entry Filed under: SEO,Uncategorized

Leave a Comment

Required

Required, hidden

Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Trackback this post  |  Subscribe to the comments via RSS Feed


Hi, my name is Zach Olsen, internet marketing professional, web entrepreneur & proud dad. Read more...

Get New Posts Via Email

Enter your email address:

Digital Marketing Top Posts

Web Analytics Top Posts

Display/Remarketing Top Posts

Paid Search Top Posts

SEO Top Posts