Updating the Adwords Extension for Excel to v201109

sunset

On the 29th February, 2011 Google will be “sunsetting” Adwords API versions v13, v200909, v201003, v201008 and v201101. This will affect our old Google Adwords API extension (documentation here), so, Tom’s had his sleeves rolled up over the weekend and built us a shiny new version. From now, our Adwords API extension supports V201109 and, if you’re still using the old plugin by then, you’ll get errors from the 29th February. Eek! How to replace the old Adwords API extension Replacing the currently installed version is remarkably easy. Here’s how,…

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…

Favourite Keyword Research Tools From #MozCon

tomatoes

This year’s MozCon was, without a doubt, the best SEO conference I’ve ever been to. I’ve said that before and I’ll say it again – if you have the chance to go next year, and you’re a serious search marketer, you’d be insane not to attend. Show, not tell Big conference speaking is a little intimidating at times but I really enjoyed speaking about keyword research at MozCon. I gave a live demonstration of our adwords API extension, categorised some keyword data and learned so much about getting microphones attached…

Announcing Keyword Research – Inside Our New Tool

Our new keyword research tool

For the past few months, I’ve been working on a project to help make the keyword research process easier. Getting clear visibility on keyword search volume and opportunity data is painstaking and time intensive, but it’s such an important part of the initial and ongoing process of SEO. I’ve wanted to build something to automate the more laborious elements of keyword research for some time, and it’s (finally) ready to show the outside world. Introducing the SEOgadget Keyword Tool BETA Previewing our keyword research tool One of the greatest challenges…

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…