Here’s a cool new tool I found on Moz:
Competitive Link Analysis: Link Intersect in Excel
It allows you to see which backlinks your competitors have, but you don’t. It can be a useful short cut if you are dealing with a ton of linking domains. Check it out:
Template and Instructions
I’ve decided to create two separate files:
Tools of the Trade
Before we start the Excel-fu, here’s a list of what you need to have at your disposal:
You might be shocked by this one, but you will need Excel to make this work 🙂 I used the 2010 32bit version in my example, but other versions should work just as well.
Backlink data. You can use the Moz OSE, Ahrefs’ Site Explorer, MajesticSEO’s Site Explorer, basically anything that meets the requirements I mentioned above and has the ability to export to Excel. For this example, I’ve used OSE exports. An alternative would be using an API to get the data, that’s up to you.
6 to 8 hours of your time. I’m joking 🙂