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…
How To: Build Open Site Explorer in Excel
Want to Build Opensiteexplorer in Excel? Back in late July 2012, we launched the Links API Extension for Excel, a free Excel extension for SEOmoz API consumers to quickly and easily pull link data into their reporting. There’s been a larger volume of requests for the Open Site Explorer template I constructed to demonstrate the power of this extension so, I thought I’d share the download and give a little information on how, exactly it works. To download the file, follow this link. How does Open Site Explorer for Excel work? If…
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…
Review Snippet Over-Saturation in Google Search Results
Earlier this week I had a lot of fun putting together a presentation for (a thoroughly excellent) SMX Advanced. Originally I was going to broach the (often slightly) dry topic of using Person Schema (or hCard) to get “people” rich snippets for author pages. As it turns out, using hCard or Schema.org on an author page to get a rich snippet doesn’t work. That’s a different story and one I’ll come on to in another post. This story’s quite a lot more interesting. Late on the eve of my presentation…
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…
Find us on