Aaron,

Thanks for this resource. Wordtracker is a great tool. I often reference the SEO Book tool as well to get a general idea of search volumes to see what a campaign might drive long term. There are so many great resources, it's really a matter of finding the right matrix, and for different campaigns it's important to employ different tools. I'm always most curious about the process of keyword research for B2B vs B2C campaigns. Do you differentiate strategies there?

I think with B2B stuff you end up with lower search counts and higher per search value. With the B2B stuff I usually augment any SEO with a significant PPC campaign.

The PPC campaign is set up with at least a few groups. One version of them is targeted with geo specific keyword modifierss, while another group uses geotargeting.

On the PPC stuff I usually use my keyword list generator or other automated tools to create a bunch of permutations on the keywords, and let those ad impressions influence how I focus my inbound anchor text and internal site structure.

I also try to get some of the important modifiers in the page title and copy and mix up how they are used throughout to create a bit of a relevant keyword net that picks up many different queries.

Perfect work Aaron!

Some additions to the .xls file:

Transactional Terms modifiers
+ shop
+ store

Informational modifiers
+ Tutorial
+ Guide

Share some more such stuff please! :)

I added those Roman :)

I too use Analog to analyse my logfiles. However you don't have to use Analytics to find out what the longtail keywords/phrases are. You can modify the Analog configuration file to change the cutoff point for the search query report. For example with these lines in the config file (analog.cfg)

SEARCHQUERYFLOOR 1r
SEARCHWORDFLOOR 1r
INTSEARCHQUERYFLOOR 1r
INTSEARCHWORDFLOOR 1r

the report will show all keywords (even if they've only been used once). I too used to use Google Analytics, but I felt the javascript code you need to insert in each page to use it was slowing down page loading times.

I love to use Google Analytics and there you can identify the keywords very easy. I have never noticed a slow loading time due to Google Analytics. Of course, it must be happening but I think it is insignificant... Maybe you are very meticulous.

Either I am meticulous, or a Google engineer went out of his way to hand edit my site and make me not trust him (or Google).

May 5/09

Hello Aaron: Tell me why your videos are of such poor quality? You can't see anything properly in them to learn anything from them. You need to buy a better video camera really. SOON

Regina H.

You don't have to be able to see every word in the video to understand the basics of what I was mentioning in it.

Do keywords in Meta Tag really cary any wait anymore, or is it better to just place keywords within the text of your site?