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…

SEOgadget for Excel: How to Get Your Back Link Data with MajesticSEO’s API

bottle-house

One of the biggest problems we’ve always had with our new users getting to a confident user level with SEOgadget for Excel is simply put, the level of accessibility of the documentation. Learning a completely new syntax for 6 different API services is, hard. I really hope we’re helping there with the instruction manual, but I’m also in the process of recording some short videos on getting started with the tool itself. Here are the first two: How to Install SEOgadget for Excel Here’s the long over due “how to”…

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…

Tools of the Trade: Excel Tips from Richard at SES London 2012

IMG_6931

While preparing myself for an SEO conference presentation, I like to practice to make sure I can fit in what I have to say, or in this case; show. Speaking on the SES London 2012 “SEO Tools of the Trade” panel, I gave  up a few interesting Excel tips using SEO Tools for Excel and the Adwords API extension. Here are the guides: - SEO Tools for Excel - Check your Sitemap for Errors with Excel - Fun With The SEOmoz API – Get Links Data Straight into Excel - Adwords…

Check Your XML Sitemap For Errors with this Excel Tip

parked-bicycle

Today, I want to share a tip for quickly weeding out errors in sitemap XML files. This post will teach your a few new Excel tricks and (hopefully) save you some time in your own technical SEO audit projects. Why a nice clean sitemap? Google have invested a lot of time and effort into improving the sitemaps functionality in Webmaster Tools and the advice I’ve always heard from Google people is advice like; keep your sitemaps as error free as you can, use the correct canonical URL. I’ve always felt…

Why You Should Supercharge Your Video Strategy & How to Do It

Video thumbnail for youtube video Supercharging Your Video Strategy

Introductory video: Video vs. Copy & Infographics Since users only read an average of 28% of words on web pages, we can conclude that copy just isn’t a great conveyer of information online for human users (although I’ve had to use it along with videos in this post – I hope you read it all!). Copy’s weakness is one of the reasons for the infographic boom, yet video can go further than infographics at conveying information quickly. Consequently, I’m surprised videos aren’t used more widely in SEO. They are probably…