Natural Search Blog


New Tool to Annualize Google Keyword Data

Do you use Google’s AdWord Keyword Tool for your keyword research? If not, you might be missing out. Like all keyword research tools, it may not be the end all be all, and it isn’t without its own little quirks, but it is still rich keyword data whether you use it on its own or in relation with the other keyword tools you are using.

Google has modified the tool over time, and one of the great additions was the ability to see the monthly demand via a small little bar chart. This can be very useful for factoring in seasonality or growing demand for certain phrases. Wrapping your head around the actual numerical data is a bit more challenging. The Local number is just for the most recent month while the Global number is a monthly average. This is further complicated in that the Global number includes the world essentially while the Local number may factor in your campaign settings and locality (based on your AdWords campaign configuration).

To help tighten up data and provide a little more insight into the Local numbers, I just released an Excel spreadsheet that can take your Google Keyword Tool’s export and annualize the Local demand numbers. In some cases, this may dramatically change the order of importance of keywords to target.

Best of all, this tool is free to use so give it a play. The link below will take you to the download page for the tool as well as more detail about how it works and an example.

Google Keyword Tool Annualizer

SEO Tools: Using Xenu and Excel – Blindfolded SEO Audit Part 2

During Part 1 of the Blindfolded SEO Audit, we started learning how to use Xenu and Excel to begin our SEO audit and focused on the foundational element, URLs.

Now let’s move on to the most important signal a site’s pages can send to the search engines, the all powerful title tag. Like URL constructs, sites often have nearly as many constructs for title tags. Three things that a quick scan of our data will tell us:

(more…)

Blindfolded SEO Audit Part 1

SEO consultants spend a lot of time looking at websites. Moreover, like web designers, SEOs definitely “see” websites very differently than the average web user. Some days, it feels a little like the Matrix, where instead of seeing the streaming code, you see the people, cars and buildings that the code signifies. After doing web design, this is heightened even more, although perhaps inverted … instead of seeing shoes, cookware, and dog collars, I see title tags, heading tags, URL constructs and CSS.

Like any skill though, it takes continual honing and refining, along with the education. This is part of the concept behind the 60-Second Website Audit and training the eye to quickly identify key SEO issues and potential issues.

I’ve joked that, after so many audits, SEO consultants could probably do them blindfolded. So, whip out the blindfold and let’s put that to a test.

(more…)

Tools

Related tags

and/or
and/or
and/or
and/or
and/or
and/or
and/or

Related elsewhere
tools
title-tags
keyword-research
xenu
seo-audit
google-keyword-tool
excel
internal-linking
RSS Feeds
Categories
Archives
2011
May      
2010
Jan Feb Mar Apr
Sep      
2009
Jan Feb Apr May
Jun Jul Aug Sep
Oct Nov Dec  
2008
Jan Feb Mar Apr
May Jun Jul Aug
Sep Oct Dec  
2007
Jan Feb Mar Apr
May Jun Jul Aug
Sep Oct Nov Dec
2006
Mar Apr May Jun
Jul Aug Sep Oct
Nov Dec    
2005
Jan Feb Mar Dec
2004
May Jun Jul Aug
Sep Oct Nov Dec
Other