Finding affiliate links with opensiteexplorer
-
Hey guys,
I'm trying to develop lists of our competitors affiliates using opensiteexplorer using the following method
- When logged in to seomoz, go to http://www.opensiteexplorer.org/
- Search for<rival company="" domain=""></rival>
- Select Show ALL links from ALL pages to PAGES ON THIS ROOT DOMAIN and SHOW LINKS UNGROUPED
- Click 'Filter'
- Click_ 'Download csv'_
- 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
- 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?
-
Howdy Pilkster!
Sounds like your method is pretty good, and I don't have too many suggestions to improve it.
In my experience, lot of sites either cloak or redirect affiliate links, so I bet they can be near impossible to find, even for search engines!
OSE advanced reports can filter by anchor text and several other variables, but as you noted it can't sort by URL parameters. If you'd like to see this as a feature request, we have a forum for that - https://seomoz.zendesk.com/forums/293194-SEOmoz-PRO-Feature-Requests
(it would be a pretty cool feature actually - I'd vote for it
As for only seeing 25 links per domain, this could miss some links, but I suspect the majority of the time if a domain links to another with an affiliate link, most of the links would also be affiliate links. There are plans to expose more of this data in the future, at least through the API.
Thanks for the feedback!
-
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?
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Why did my DA and Links go down?
How could I begin to research this to find out why we have less total links and a lower domain authority. Our DA has gone down two points and our total links dropped by a few thousand. I'd like to find out why that happened but I'm just not sure where to start. Thanks!
Moz Pro | | Sika220 -
Find out what keywords a site is ranking for
I want to find out what keywords a site is ranking for. In other words, I want to find out how Google is currently seeing a site. I've used Google KW tool - not very accurate when you simply type in the URL. Is there anything in SEOMoz I can use? New to this. thanks
Moz Pro | | goodge0 -
I am trying to find inbound links for one of my site urls. My question is does SEOMoz able to track all internal links as the Open Site Explorer shows 0 internal links?
It shows 0 internal links when I am pretty sure we have multiple internal links.Should we use absolute urls or relative urls for internal links?
Moz Pro | | SulekhaUSLLC0 -
Does Google Reward Bad Links in Some Industries?
This week I've been diving into competitive research again for several clients in different industries, and unless the data in Open Site Explorer is wrong, it really does appear that Google continues to reward sites with unnatural links in certain industries, especially industries that are less tech-savvy (agriculture, finance, manual labor). I've combed through all the links carefully, to ensure there aren't some secret high-quality links lurking, and for some of these sites that are showing up in the top ten for search they do not even one real, high-quality link. Also, their onsite optimization is often way over the top and the user experience is nothing less than nauseating. Could it be a MozScape issue, or does Google continue to reward terrible sites and link structures in certain industries? I'd love to hear your thoughts.
Moz Pro | | newwhy0 -
Is seomoz rogerbot only crawling the subdomains by links or as well by id?
I´m new at seomoz and just set up a first campaign. After the first crawling i got quite a few 404 errors due to deleted (spammy) forum threads. I was sure there are no links to these deleted threads so my question is weather the seomoz rogerbot is only crawling my subdomains by links or as well by ids (the forum thread ids are serially numbered from 1 to x). If the rogerbot crawls as well serially numbered ids do i have to be concerned by the 404 error on behalf of the googlebot as well?
Moz Pro | | sauspiel0 -
How to Link build for our site
Hello, A client of mine has a site that gives advice to people. It's moderately competitive. It's a content site. Using Open Site explorer, I looked up competitor's top pages and backlinks, and there were things such as sites that were heavy on directories, sites heavily on editorial mension, sites on juicy topics that I don't want to cover, and the rest was pretty much junk. Just so that you know, I only link build with quality websites that look strong, long term, have a nice design, are high quality, and are not a directory (with a few exceptions) What's the standard way to link build with a site like this? We've got 7 articles of good content that is from me spending hours learning about the subject and using my skills as a life coach. Right now I'm just adding quality content and social media. I am not a top expert in the field, but I'm learning as much as possible. How do we link build?
Moz Pro | | BobGW0 -
Why is the linking root domains count not increasing
For the last month I have been tracking my backlinks thru open site explorer. Over the same period I have gone on a minor link building exercise via social media, some directories as well as writing fresh new content for the site. However, my backlink count has increased in the Rank Tracker tool but my root linking domains have remain at the same level. Is there a lag or is this because some of these site are not in the open site index? To be specific - I have personally setup follow links from sites like tumblr, posterous, stumbleUpon, delicious and other like these. Would really like to understand the limitations so I can take the appropriate action. Thanks
Moz Pro | | versinge0 -
How come there are no links to my website according to SEOmoz Competive domain analysis, while in google webmaster i do see links.?
I dont see any links to at all when i do a Competitive Domain Analysis in SEOmoz. However i do see links in google webmaster tools. this strikes me as odd. Also when i use open site exployer my website dont seem te be found. In google im on page 9 on my focus keyword so i do think there are links to my site. I would like to know what i can do so i can analyse my links in seomoz Competitive domain analysis. Many thanks. url: http://www.sadpanda.nl
Moz Pro | | Aquive0