In OpenSiteExplorer - how do I find out which in bound links were lost?
-
http://www.opensiteexplorer.org/www.homefinder.com/a!links
The # of inbound root domains is ~3,100 and has remained relatively flat for a while yet we've been acquiring 1000's of new root domains that link to us.
That said, we want to get some clarity on why the count has remained flat. It would be helpful if we could see which domains have stopped linking to us from one OSE index to the next. Is it really the case that we're losing links as fast as we're gaining them or is something else going on?
-
Exporting data on a regular basis from OSE is necessary to do this; and you need to do the analysis in excel to get the answer. Basically you want to export your links & linking root domains at least once a month or after each linkscape/OSE update.
Then you would put linking root domains from last month in a column and linking root domains from current month in a column. In a third column you would do a comparison match with an excel formula to see which are missing. Here is some help documentation on the excel formula: http://office.microsoft.com/en-us/excel-help/use-excel-to-compare-two-lists-of-data-HA001103915.aspx
Assuming last month domains are in column A and current month domains you could use this formula in column
=ISNA(MATCH(B2,$A$2:$A$10001,0))
-
Hi HomeFinder,
You could export your data to CSV and then use Excel or an other spreadsheet program to put all OSE updates in a different column and then compare the colomns to see what are the new links and the vanished ones.
Best regards,
Guillaume Voyer.
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
-
Moz can't see my link from an external site
Hi, I'm hoping someone can shed some light on this. I've had a followed link created from http://www.dubaisharks.com/ pointing to my website - http://www.yallarugby.com but in the reports it doesn't show that there is a link coming fro this website. The link has been active for a few months now, but still no record of it. Any ideas?
Moz Pro | | SeoSheikh0 -
I have a site that is showing Internal 0 Equity-Passing Links, 0 Internal links, and every page bar the homepage has a PageAuthority of 0\. Any suggestions on why this could be?
The website has been around for several years, although did undergo a significant redesign at the end of last year. I greatly appreciate any help.
Moz Pro | | embracedarrenhughes0 -
Why do links appear then disappear month to month?
What I mean by this is, a link to my site shows up in the August mozscape crawl, then the next month it doesn't, but its still an active link on the website. Once a site is crawled, shouldn't it always be there from now on?
Moz Pro | | SeanConroy0 -
Tried to find correlation between SEOMOZ statistic and google ranking.
I've made Google US search and than tried to compare SEOMOZ data for first few result. I've used Open Site Explorer and On-Page Report Card. On attached picture you can find this statistic. Pages are sorted in order as they appear in Google search. For me is big question why position 2 and 4 is so hight and 6 is only 6. And what position 6 should do to go up. Thank you. 2s9zlu8.jpg
Moz Pro | | ctam0 -
How can I find my past KW rankings?
I want to know how I can find out how a client's site was ranking for keywords at the beginning of the campaign so I can compare it with current rankings. I haven't been generating reports regularly. I kinda assumed I could ask for the reports retroactively. As in, what was the ranking of my keywords from the first crawl done by SEO moz. Thanks!
Moz Pro | | GreenGrowthSEO0 -
Opensiteexplorer details in API
Is there a way to access opensiteexplorer result details via seomoz's API? Most interested in the social media results
Moz Pro | | fuzzlepop0 -
No Local Directory links in Open Site Explorer?
Hi there, I just signed up for seomoz pro today and have been playing around in OSE looking at a number of local business websites that I manage SEO for. For all of them, I have put an endless amount of effort ensuring they have good quality, accurate business listings in all the local directories like yelp, yellowpages, hotfrog, tripadvisor, etc. For most of them, I did this months or even up to a year ago. However, I don't see a single link reported in OSE that is a result of my efforts here. Does OSE not report links from local business directories, or should I be concerned that I'm somehow not optimizing properly, or are these types of links of such little value that they don't get picked up, something else? Thanks for the help!
Moz Pro | | rianDS1 -
Can I get a list of all links on a given domain?
Sorry, this is actually kind of a tripartite question: I was looking at the Competitive Link Analysis on one my clients' campaigns. Sometime between June and September their total links went up by about 120,000. We have no idea where those links came from (although the numbers would indicate that they're mostly internal). Question 1: In none of the other tools can I figure out how to list these links on a domain level. Is there a way to get a list of all links for our given domain? I've been playing around with the page-by-page and even that doesn't show me everything. For example, I'm looking at OSE for their homepage and it lists 45 links for a page that it claims has 151 total. Question 2: How did it pick those 45 to display out of the 151 possible? If these are only external links, why do half of them come from one of our subdomains? Also... Question 3: If our client hasn't made any major changes recently, why has the number of internal links gone up so dramatically? Thanks.
Moz Pro | | MackenzieFogelson1