Today at Pubcon I will be announcing a new keyword analysis, research and measurement tool from BusinessOnLine that is free and built simply using Excel. This search analytics tool can be used to baseline and understand the long tail keyword performance of your Web site. At SES in San Jose, I told people of the importance of understanding your long tail performance over time as another key indicator of the success of your SEO campaign. However at that time, I told people that it is virtually impossible to do this in most existing analytics platforms and that we use a proprietary tool to accomplish our long tail baselines and subsequent performance monitoring. Well after I said that I felt like I had let some people down by not giving them a solution to the problem. So for Pubcon 2009 here in Las Vegas, I wanted things to be different. So I had Ilya, the mad Russian scientist of BusinessOnLine who is an Excel expert, but together a simple tutorial on how to build an long tail keyword analysis tool for FREE 
So, here is the new Free Long Tail Keyword Analysis and Research Tool from BusinessOnLine. Let me know how you like it and also if any of you other Excel wizards want to add other cool features to it, let me know and I will post those updates for the community.
Related SEO Blog Post
Tags: Conference, Keyword Research, Long Tail, PubCon
I love the insight, but do you have an tips of exporting all keywords from Google Analytics to excel cause you can only do 500 at a time..
Hey Catfish – awesome presentation, thanks for the free tool, and cool meeting ya at the SEOMoz party. It kickass to be in the audience and hear you speak finally! Keep on rockin!
Toby´s last blog ..Senate Votes “Yes” to Extend Home Buyer Tax Credit
What do you guys think about http://www.ispionage.com? They have an excellent keyword tool over there. Including long tail keywords, this tool uses a large keywords database, that is daily updated over the internet, based on actual search volume. All the work you need is being taken care of, once you have the keywords lists generated by the tool, you can clean them, group them and create adgroups. You can even build your PPC campaign using this tool. Vital information are provided to you, such as search volume on Yahoo, Google and MSN over the last month, for the given keywords, and competitors’ interest on them. You should give it a test on http://www.ispionage.com.
Though Google is one of the top search engines around, you might also want to consider keyword research tools that will take other search engine data into account.
[...] long tail performance, not just your performance on competitive keyword phrases. You can use the free keyword analysis Excel tool I made to help. If you aren’t measuring the long tail then you aren’t seeing the full [...]
This is a great SEO tool for finding those hidden keywords, you never knew you had. It is especially important when dealing with eCommerce and Product Finders or Selectors. Ajax Product Selectors Javascript files do not get indexed bywords to use between the Google, and so it is important to know which keywords to use between the tags in the page. Some examples of rich, animated Javascript Product Finder applications that can benefit from this technique are listed here: http://clicky.me/3S0