SEOmoz have just released an exciting update to their keyword difficulty tool. The new version of the tool gathers data from the Google Adwords API and Linkscape to help get a more detailed understanding of the SEO challenge involved with targeting a specific keyword ranking. I’ve been super lucky to get an early view of the tool and in this post we’ll take a first look at it and use exported data to get a sense of how competitive some search engine rankings can really be.
Read the full post...
![[How to] use tables in MS Excel [How to] use tables in MS Excel](http://seogadget.co.uk/wp-content/uploads/2009/10/using-tables-in-MS-Excel.jpg)
In my SEOmoz pro session last week I spent some time explaining the benefits of using Tables in Microsoft Excel. Gone are the days of broken formulas that once worked, and extending your cell range references every time you add new data in a spreadsheet.
Using this technique isn’t all that different to using cell references, and the outcome is a more agile and robust Excel, with an ability to manage your data faster making for a more time efficient experience. What’s not to like?
What are Tables?
From Microsoft Office Online [Overview of Excel tables] Read the full post...
Getting traffic to a site through a vast portfolio of traffic driving, high value keywords is at the top of every search engine marketer’s priority list. That said, what if all that traffic is going to the wrong pages on your site?
While researching laptops this afternoon I decided to take a look at the IBM / Lenovo Thinkpads and compare them to some other machines I’d been looking at from HP.
Using the search term “IBM Thinkpad”, I blindly selected the first organic result:

A click that took me to a page I didn’t expect, until I realised I’d entered the site via the hardware drivers page: Read the full post...
In my “Demand for SEO Jobs” post, I plotted keyword demand for the phrase “SEO Jobs” across 2008 based on Google keywords data. A few folks have asked me to explain how I did that, so without further ado:
How to calculate approximate traffic volume for the past 12 months in Google Keyword Tool
First of all you’re going to need the data. Go to Google’s keyword tool and select a few keywords you’re interested in.
Before you export data from the keyword tool, be sure to select “Show Search Volume Trends” in the “Choose columns to be displayed:” drop down list:
Read the full post...