Grepwords – Powerful Keyword Research without Adwords

superman

Google took away the Keyword Tool, and pretty much every SEO Agency’s API access earlier this year. Let’s not hold it against them, though, because Grepwords is amazing and it’s available in SEOgadget for Excel. You’ll remember that for the longest time, I’ve taught keyword research and categorisation methodologies using our Adwords API Extension for Excel. Given Google’s stance on the usage policy on that platform, we can no longer support it – you’ll see it disappearing quite soon. Right now, especially in the US, the Grepwords API is where it’s…

Updated to 201209: Google Adwords API Extension for Excel

chairs-header

Update: 22/11/2012 This plugin is updated for the latest API which is 201209. The major change is that EXACT is now the only match type. The add-in now ignores any values passed in. AVERAGE_TARGETED_MONTHLY_SEARCHES is replaced by SEARCH_VOLUME. This is equivalent to AVERAGE_TARGETED_MONTHLY_SEARCHES if language and/or location is specified. SEARCH_VOLUME is equivalent to GLOBAL_MONTHLY_SEARCHES if language and/or location is not specified. Capture search volumes and seasonality data straight into Excel Yes, you heard that right. Introducing the SEOgadget Adwords API Extension for Microsoft Excel – easily capture large volumes of…

Handy How To Video for Our Keyword Tools

bees

Since launch, we’ve had some user feedback requesting better “how to” content and support material for our keyword tools. While we’ve been working on product quality and platform stability, some of the more important elements (user guides, instructional aids) have been put on the back burner. I hope you like our helpful “how to” video (warning: may contain Jazz music) Embed this video The SEOgadget Keyword Tool hosted on Youtube. A few charts I made earlier Just recently I used our tools to throw together some data for an SEO…

How to Use Our Keyword Tools

dots

An industry friend recently said to me; “by the time you get round to writing the how to, it’ll be out of date”. It’s funny how you get so immersed in building something that you lose sight of the obvious things. Perhaps one mind only has the capacity to work with a fixed amount of variables, and for me, those variables have been so focused on engineering and testing that marketing took a back seat (the irony). Building and launching a keyword tool has been an incredible experience. Not that…

Extract Your Competitor Keyword Strategy [Excel Skills]

beans

At the recent SEOmoz / Distilled Pro Seminar in London, I gave a presentation on advanced keyword research. Today I’d like to share one of the tips I gave on how to extract your competitors target keyword list, with relative ease using tools we all have at our disposal. Here’s the pro training slide, just if you’re keen for a sneaky preview of this post: Predictable, SEO people can be That meticulous attention to detail SEM practitioners apply to the optimised pages of their big dynamic sites can be quite…

Understanding Competitiveness in Search Engine Rankings [Keyword Research Tools]

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. Using the keyword difficulty…

Using Tables in Microsoft Excel 2007

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…

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

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. SEO’s all agree, the…

Matching User Intent to the Right Organic Landing Pages – IBM Thinkpad

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…

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

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…