Posts tagged as:

Keyword Research

Using Tables in Microsoft Excel 2007

by richardbaxterseo on October 27, 2009

[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]

{ 10 comments }

Google Keyword Tool [External vs Beta] – What’s the Difference?

by richardbaxterseo on October 8, 2009

Testing keyword research tools from Google in the lab

On the 24th September 2009, Google announced a revision of their Keyword Tool, the imaginatively titled “Keyword Tool (Beta)”.

As Barry reported that morning at Search Engine Roundtable,

Google has a beta version of a new keyword tool available in the AdWords console. To get to it, login to adwords.google.com, go to a campaign, click on opportunities (if you have that tab), then on the left bar, click on keyword tool. A “beta” link should be available for you to click on in the top paragraph.

{ 7 comments }

Matching user intent to the right organic landing pages – IBM Thinkpad

by richardbaxterseo on August 2, 2009

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:

search results IBM thinkpad

{ 1 comment }

How to calculate approximate traffic volume for the past 12 months in Google Keyword Tool

by richardbaxterseo on December 26, 2008

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:

{ 0 comments }

Using VLOOKUP to match keyword volume and rankings data

by richardbaxterseo on November 21, 2008

Ever needed to compare lists of keywords in different data tables and match corresponding values together? For example, matching keyword volume data to search engine rankings? Today we’re going to take a look at a really simple but powerful query in Microsoft Excel called VLOOKUP which makes that possible.

Here’s the definition of VLOOKUP from office.microsoft.com:

Searches for a value in the first column of a table array and returns a value in the same row from another column in the table array. The V in VLOOKUP stands for vertical. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data that you want to find.

{ 2 comments }