Vanity Check: “Keyword Intelligence Tools”

ducks-rubber

It’s not about the tools you have, it’s about how you interpret the data. Most importantly, it’s how you evaluate what your data is really telling you. Look at this chart: Now, ask yourself what you see. Say it out loud, or in your head, whatever. I bet the first thing you said was: “The rankings on this site dropped”. That’s not correct. If you said, “The keyword rankings for this site have dropped according to Searchmetrics.” You’d be perfectly right. The problem with keyword intelligence The very name implies someone…

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…