TLC SEO: The Linking Man's Blog

Competitive Analysis Hack: Find Blogs Linking to Your Competitors

Building links on sites that publish content on a regular basis is easier than having someone change hard coded content. Blogs need to publish on a regular basis or they will lose their audience.

blog_logo

Luckily, you can find most of the blogs linking to a competitor using Screaming Frog.

 Step 1) download all your competitor’s historic links from Majestic. Delete everything but the data in the source URL column:

Majestic_Fueled

Step 2) Delete duplicates and save it as a .csv file.

excel-remove-duplicates-3

Step 3) Upload the file into Screaming Frog using “List Mode”

Spider_to_List1

Step 4) Create the following custom filters:

RSS_SF_Filter

For the most part, Filter 1′s export will be all blogs, and filter export two will be everything else.

For Filter 1′s export, I like to format it into a prospecting pivot table and add all of the high value link targets I find into Buzzstream.

8 comments
spookseo
spookseo

This is one of Sun Tzu's stragery - If you know the enemy and know yourself you need not fear the results of a hundred battles. Not only applied in battleground but also in every marketing campaign as well as SEO. Thank you for sharing this John. Long live SEO!

MichaelCurtis
MichaelCurtis

Huh. I've been doing something similar, but looking for footprints from the main blogging CMS's instead. But I guess this is more comprehensive. Cheers

barriemoran
barriemoran

Great post! Been doing something similar, but this just simplified the process big time,!

Never even thought of loading them into frog, Duh!

Dan and the boys do great work and your right, every time to use screaminfrog  for something you fidn another use. Or someone else does and shares a post like this. Nice one.

ckj1211
ckj1211

Sooooo legit! I am excited to cease on some guest blogging opportunities

ProTechIG
ProTechIG

JH, informative as always. This can definitely speed up prospecting from a competitive analysis perspective.

StokedSEO
StokedSEO

Simplez. Awesome idea sir! (Gotta love Screaming Frog)

JHTScherck
JHTScherck moderator

@spookseo dude - i gotta ask. You comment on my blog a fair amount, but you are the largest link seller on Fivver. Are you finding that my tactics help with Fivver style link building? Or do you also do non-automated link building as well? This strategy could easily be used for Black Hat, but you seem to read this site regularly, so I had to ask. 


Got nothing against blackhats, I used to dabble when it was easy (pre-penguin) I just didn't know they would get any use out of this site :)

JHTScherck
JHTScherck moderator

@StokedSEO Thanks for stopping by Gaz! It seems like every time I use Screaming Frog, I am finding a new use for it. It's a limitless tool.