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…

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…

How to Perform Topical Keyword Research

Spokes

The foundation to any successful online marketing strategy – content, social, or search – is keyword research. Without it, how will you know what to target and base your campaigns around? Fortunately, it’s not that difficult to do. In this post, we’re going to look at how you can perform keyword research to find the best terms for your business and your content, from start to finish. Discovering Base Keywords First off, you are going to need some base keywords to start with. Think about the main things your business…

Advanced Keyword Modelling – SES 2012

led-light

Earlier today I gave a presentation at SES London 2012 with Ron Jones from Symetri on the topic of advanced keyword modelling for keyword research. While Ron gave the theoretical overview of the concepts a good researcher might use to understand and categorise how users search, I gave a practical demonstration using SEO Tools for Excel and the Adwords API Extension. I also gave a preview of a new tool we’re testing to help keyword researchers predict keywords for the fresh index. More on that later, because it’s buggy as hell…

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…

Visualising Search Engine Rankings by Keyword in Excel

blue gloves

Originally posted on SEOmoz, this post still has legs, having been recently referred to in a number of Excel related posts including Mike’s Excel Guide to SEO. I thought it would be great to revisit the post, give it a bit of a rewrite and share it with our readers. Despite what some say, tracking rankings for your target terms is an important part of an organic search marketing campaign. On occasion, SEO people who follow specific niches tend to describe ranking fluctuations with smart looking charts describing ranking position,…

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…

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…