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.