Find New and Lost Back Links with MajesticSEO and SEOgadget for Excel

One of the most pressing issues in current SEO strategy is developing your ability to monitor new links, and track lost links. It’s a sad fact of our day to day lives as marketers in search. Some of our time doesn’t get spent on marketing at all, it gets spent on undoing bad marketing through […]

Read more

Grepwords – Powerful Keyword Research without Adwords

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. […]

Read more

Forum Spam – A Practical Guide

If you’ve landed on this page hoping to find tips on enhancing your forum spam strategy, I’m afraid you’re out of luck. This guide is intended for those poor souls tasked with cleaning up the aftermath of a merciless spam campaign that has plastered your lovely domain across countless hell-holes of the internet with all […]

Read more

Get Your Backlink Growth History in Excel with the Links API Extension For Excel

Back in late November, we added Majestic SEO to the Links API Extension for Excel. If you’re using the extension in Excel, you can do pretty much everything the Majestic API will let you do (there are 19 API calls, I think) including URL metrics, anchor text and top pages and a lot of other stuff. Anyway, […]

Read more

SEOgadget’s API Now Available in the Links API Extension for Excel

About a month ago, I had a penny drop moment. We’ve had the Links API Extension for Excel available for free download since July – initially launching it with Mozscape, and later Majestic SEO. We’ve had a free API that does a ton of stuff for about the same period of time. Until that penny […]

Read more

We’ve Added Majestic SEO to the Links API Extension for Excel

You heard. We’ve added Majestic SEO’s API to the function list of our Links API Extension for Excel. Woah! Back in July this year, I spent a full two days analysing the differences between Majestic, Google Webmaster Tools, SEOmoz’s Mozscape, aHrefs and SearchMetrics. All I can say about that experience is that I learned *such* […]

Read more

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

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 […]

Read more

Check Your XML Sitemap For Errors with this Excel Tip

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 […]

Read more

Combining AWR and Screaming Frog to Spot Quick Wins

First things first, I’m extremely happy to announce that I’ll be joining the SEOgadget team within the next couple of weeks. This really is massively exciting and I can’t wait to get started on working with a great bunch of people on some fantastic projects! For my first post here on the SEOgadget blog I […]

Read more

Updated to 201209: Google Adwords API Extension for Excel

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 […]

Read more

Page 1 of 212