I’ve had two separate occasions in as many weeks where I’ve needed to answer the question: “What Are My Most Linked to Subfolders?” for a client, or for myself. I thought it would be quite fun to do a quick write up on how I answer this question using a simple Excel query, some Webmaster Tools data or Open Site Explorer.
In this post we’re going to use raw external link data from Webmaster Tools to quickly identify the most linked to subfolders on a site. You can repeat the same process using Open Site Explorer data, too.
Read the full post...
For SEOgadget clients, most of the SEO work they receive from me is delivered at the end of a heavily data driven process. If you’re feeling a shift towards data driven SEO too, then the chances are using pivot tables and charts in Excel is a near daily part of your SEO consulting activity.
At some point we all have to up our game, especially with Excel and general analysis skills, so at the SEOmoz Pro Training Seminar late last year, I gave a step by step tutorial on how to make a beautiful chart based on an Excel Pivot Table. Read the full post...
![[How to] use tables in MS Excel](http://seogadget.co.uk/wp-content/uploads/2009/10/using-tables-in-MS-Excel.jpg "[How to] use tables in MS Excel")
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...
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...
