Finding sites to target for backlinks

[Nashville]

How can I quickly find a list of sites that link with follow and 301 links to my competitor, but not to me?

[PeterAlexLeigh]

By the way, if you need some help with excel and vlookup, check this link outl

http://www.distilled.net/excel-for-seo/

These links may help you also;

http://www.seomoz.org/blog/an-inside-look-at-competitors-backlinks-with-open-site-explorer

http://www.seomoz.org/blog/link-profiling-with-open-site-explorer

http://www.seomoz.org/blog/weed-out-your-lowest-performing-pages

[PeterAlexLeigh]

I would then just pull another query for your site. Export the results of both to excel and do a vlookup to remove the links that point to your site and your competitors

[Nashville]

And that will show the ones that link to that competitor but NOT to me? I thought that was just the links for that competitor (regardless if they linked to me or not).

thanks.

[PeterAlexLeigh]

Quicker than a toilet stop in rattle snake country.

Go to Open Site Explorer > Type in your competitor's URL > from the 'show' drop down select 301. Job done!