A Simple Process To Prepare Your Link Lists For Google Disavow

By | October 16, 2013

The link disavow process has become a necessary evil for many webmasters. The number of negative SEO attacks that my site and those of some of my clients have been subject to is on the rise since Penguin 2.1 in particular.

Link building SEO in 2014Checking behind the scenes we are seeing that blog style sites are being spammed with links in their comments section at a far greater degree than ever before. They go straight to the spam folder or held for review, but the number incoming has increased hugely in the last 2 weeks. Also the quality of this spam is lower than I have ever seen. Clear negative SEO tactics.

On the other side of the coin a look through Majestic SEO or similar reveals the huge number of backlinks being added to our own sites profiles on an almost daily basis. Sometimes thousands of new links appearing within hours as we are targeted by negative SEO campaigns.

It is a situation Google has caused by having a system that rewards negative SEO very quickly and with huge profit potential. That a system should exist that rewards spam rather than blanket ignores it is entirely Google’s doing, and (on a side note) something they may regret in the future when the internet community gathers to take a class action suit against them for encouraging the destruction of the internet as people’s sites, servers and livelihoods are destroyed under a rising tide of spam as a result of their incompetence

Let’s Get Down To Business

Sadly, it’s often the honest webmaster left to clean up the mess.

Download your link profile from webmaster tools and you might be in for a shock. Tens of thousands of links – and a list that looks almost impenetrable. You might be forgiven for just giving up, surely this is too much to do. Here’s how you get the list

Well, that’s where this spread sheet comes in.

With the help of this sheet and Scrapebox (or a similar tool) if you have it, in less than an hour you can turn a list of 10,000 into a list of a few hundred using safe criteria.

We are looking at specifically.

  • Spammed links – where you link appears many times on the same site.
  • Zero Value Links –Where Google has not even considered the site linking to you for any Page rank (i.e not “0” PR – but “N/A”).
  • None context links – Links from sites you don;t think are relevant to your niche.

Most of this can be sorted and a clean list for manual review achieved in under an hour.

Ok – here’s the process for getting your links

  1. On the Webmaster Tools home page, click the site you want.
  2. On the Dashboard, click Search Traffic, and then click Links to Your Site.
  3. Under Who links the most, click More.
  4. Click Download more sample links. If you click Download latest links, you’ll see dates as well.

Note: When looking at the links to your site in Webmaster Tools, you may want to verify both the www and the non-www version of your domain in your Webmaster Tools account. To Google, these are entirely different sites. Take a look at the data for both sites

Ok, now you should have a link list – Time for the videos…

Adding your list to our link examination spread sheet.

Done that?

Note that videos are better quality on Youtube…

Download Openoffice Spread sheet Download Microsoft Excel Spread sheet

If you don’t have have a spread sheet program you can download Openoffice free from here

If you have Scrapebox or a similar tool, then using the PR checker will save you a lot more time and effort in the long run and the most from the tool.

Sorry for the tiny screen. I have password proxies so dragged the vid capture area away from them. It’s only a 50 second video Smile

Quick idea of how to grab the PR from the list. Use the image below to show you how to export them to a CSV file (notepad)

Then export the file as “.CSV”…. like this

Export As CSV

Ok, follow the very simple instructions in video one. Done that? Time for video 2

Reuploaded (sorry) Now the real second part to the link disavow technique

Bear in mind that this process will not suffice if you need to do a “reconsideration request” after an un-natural linking notice and sandbox style penalty.

In that case there is another step to go through. It is best to contact the sites that you have the most unwanted links from first. As you can see contacting 20 webmasters in this case would actually account for 75% of the links. If I increased that to 50 it would be well over 80% of the links.

Of course they may well decline – but at least you have tried. Send Google the details of your effort.

Finally – can’t find the email address of the webmaster you need to contact. Then just try “admin at domain name dot com” of whatever the suffix is. This will get about 60% of them in my experience.

The long term answer is for Google to stop rewarding spam via negative SEO attacks. To do this requires that spam is just ignored.

No benefit to the webmaster trying to game links

No benefit to the negative SEO scum trying to destroy your site

Google often give us the opinion that they are bright clever people and that their algorithm is smart. This lack of prudence and sledgehammer approach to offsite link spam proves they might be too smart for their own good and that their algorithm is either very dumb or so over engineered that the right hand doesn’t know what the left hand is doing.

Peace Smile

Paul Rone-Clarke (AKA “Scritty”)

You may like;

Category: Editorial Google Updates Tags: , , , , ,

About Paul Rone-Clarke

+Paul Rone-Clarke Hi, I'm Scritty (Paul Rone-Clarke) I've been writing my one man rant against SEO nonsense for years now. On the other hand, you've probably never heard of me - so maybe I'm not that good... Don't want to read over 300 posts? Can't say I blame you. To save you the bother, here's my main points: Effective marketing of your website is not achieved with "Link Blasts" but automation is a great way to get your "busy work" done more effectively. So, NOT "Black Hat", but still using automation! HERESY! How dare I suggest you can have one without the other. It's enough to make smoke come out of Rand Fishkin's ears - and that's something I'd pay to watch! Why not check out the my archives?