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

lego-bricks

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 link removal and penalty reconsideration requests. If that time’s going to get spent, let’s spend it efficiently. If you want to save yourselves some time on the day to day task of link auditing, you’re…

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…

Forum Spam – A Practical Guide

Skydive Easter 13

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 the accuracy and subtlety of a sawn-off shotgun. So, as part of your clean-up operation you’re faced with some wretched old forum within whose monstrous spammy bowels lie a few hundred links to your domain.…

LinkLove 2013 – Thanks for Coming!

me-at-linklove

I love a good SEO conference – it’s extremely rewarding to meet lots of nice, interested and passionate people. It’s always sad when something comes to an end, but Distilled did a great job of their final LinkLove. Ask and you shall receive @richardbaxter hey Richard, I know it’s a tad cheating but could you make your demo Excel doc from #LinkLove available? — Matt Evans (@DigiMatt) March 25, 2013 In my session, I did a live demo of our Links API Extension for Excel and Niel’s SEO Tools for…

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

dj-cdj

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, when we launched the tool, I didn’t have a lot of time to document anything but the main API calls. That’s got to change (seriously – 25% of the features of our own Links API…

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

beans-I-like-them

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 drop moment, I hadn’t thought of putting the two together. Until now. Get site contact details, easily! Here’s the kind of story you can tell with this tool: “Show me the contact URLs for my…

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

space-x-grasshopper

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* a lot about the way the various tool providers must be crawling and updating their indices. I concluded that it’s wise to have access to GWMT, Mozscape and Majestic data as a bare minimum, and for extra…

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…

Combining AWR and Screaming Frog to Spot Quick Wins

grinder

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 thought I’d write about something I’ve been trying out and getting a little bit addicted to; combining already existing data and reports to provide more insights from the information you already have. I recently wrote…