Welcome to the Q&A Forum

In fact when I shared the list of competitors with my client they are sure I'm missing a large proportion of the affiliates. Any ideas?

Hey guys,

I'm trying to develop lists of our competitors affiliates using opensiteexplorer using the following method

1. When logged in to seomoz, go to http://www.opensiteexplorer.org/
2. Search for<rival company="" domain=""></rival>
3. Select Show ALL links from ALL pages to PAGES ON THIS ROOT DOMAIN and SHOW LINKS UNGROUPED
4. Click 'Filter'
5. Click_ 'Download csv'_
6. Open the csv in excel and filter the Target URL column for any known part of the affiliate link (example ?a_aid) - this leaves you with a list of the affiliate links
7. Filter out duplicates

Is this the best process? I have a feeling I'm missing some as OSE truncates to 25 links per domain. It would be nice also if OSE could do the filtering for me.

Any better ways to do this?

Hey guys,

I'm trying to develop lists of our competitors affiliates using opensiteexplorer using the following method

1. When logged in to seomoz, go to http://www.opensiteexplorer.org/
2. Search for<rival company="" domain=""></rival>
3. Select Show ALL links from ALL pages to PAGES ON THIS ROOT DOMAIN and SHOW LINKS UNGROUPED
4. Click 'Filter'
5. Click_ 'Download csv'_
6. Open the csv in excel and filter the Target URL column for any known part of the affiliate link (example ?a_aid) - this leaves you with a list of the affiliate links
7. Filter out duplicates

Is this the best process? I have a feeling I'm missing some as OSE truncates to 25 links per domain. It would be nice also if OSE could do the filtering for me.

Any better ways to do this?