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!
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
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
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
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…
Announcing: The Links API Extension for Excel for Mozscape
For a long, long time I’ve used Excel to gain insight, make calculations, create reports and solve problems. While perhaps, a full time developer might see some limitation in the platform, Excel is a godsend to almost the entire search marketing ecosystem. Last year, we announced the SEOgadget Adwords API Extension for Excel. It was (and remains) a huge hit with search marketers wishing to quickly fetch keyword search volume data as part of their market research process. Today, I’m absolutely delighted to announce we’re releasing the SEOgadget Links API…
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 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
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…
Updating the Adwords Extension for Excel to v201109
On the 29th February, 2011 Google will be “sunsetting” Adwords API versions v13, v200909, v201003, v201008 and v201101. This will affect our old Google Adwords API extension (documentation here), so, Tom’s had his sleeves rolled up over the weekend and built us a shiny new version. From now, our Adwords API extension supports V201109 and, if you’re still using the old plugin by then, you’ll get errors from the 29th February. Eek! How to replace the old Adwords API extension Replacing the currently installed version is remarkably easy. Here’s how,…
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 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…
Find us on