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
-
Why does page report still have "Too Many Links" alert?
I'm a new Moz Pro user and see that the on-page optimization report includes "too many links" on page and references the "100 links" guideline that Google no longer endorses: http://www.youtube.com/watch?feature=player_embedded&v=l6g5hoBYlf0 Too many links is still an issue in terms of passing link juice, but not much else. Matt Cutts has stated that it is fine to have many internal links in this regard. Please correct me if I am mistaken.
Moz Pro | | Shannon-PayLoadz0 -
Need help locating a 404 link
My reports are showing a 404 error for a link to a page in our WP site for which we changed the URL months ago. I can't find where the link is coming from. I used Screaming Frog, but can't find where it might tell me the origin of the link, only that it exists. I am pretty sure it's internal. Can someone please tell me how to find the originating page so I can remove the link without having to comb through every page of the site to look for it? Thanks!
Moz Pro | | gfiedel0 -
Site Explorer shows links as followable but they have nofollow tags
Hello, I am looking at site explorer and sites linking to my site moneyfact.co.uk. I've got thousands of links showing as 'followable' but when i check them they have rel="nofollow" tags. e.g: http://www.dianomioffers.co.uk/partner/moneyfacts.co.uk/brochures.epl?partner=93&partner_id=93&partner_variant_id=33 Why would they show as followable when the links are nofollowed? Thanks Steve
Moz Pro | | SteveBrumpton0 -
Find 404 errors
Seomoz is currently reporting 404-errors, without saying where these errors are found. What good is this report when it does'nt say a word about where I can find the page linking to the 404? Screen: http://filer.crenia.no/NJPZ I really think it's time for Seomoz to prioritize upgrading the pro tools. Feels like they haven't been updated in ages..
Moz Pro | | Inevo1 -
Link reporting.
Is there a way in the Pro reporting where I can see a summary of the number of incoming links by type (blogs / news / wiki / dir / forums etc)? Even better, could the report give me an average Page Rank for each link type? Thanks,
Moz Pro | | CarlDarby0 -
Sometimes we could not download all the data of inbound links from all linking domains
Sometimes we could not download all the data of inbound links from all linking domains. (Around tithe.) Don't you have any idea?
Moz Pro | | crossfinity0 -
Difference between Webmaster and SEOMoz back-link stats?
Hi there, I just noticed that there are differences between the links to my site showing on my Google Webmaster account and what is showing on my link analysis on SEOMoz. Has anyone noticed this? In webmaster I am showing 857 links to my site from 92 different domains. In SEOMoz I am showing 816 links to my site from 53 total linking root domains and only 39 followed domains? Does anyone know why this there is a difference? Are the links showing in Webmaster all indexed and followed links? Thanks in advance 🙂 Karl
Moz Pro | | onlineexpression0 -
Is canonical link enough?
Hi SEOmozers! I have a question. SEOmoz analysis report me some duplicate that I thought I had fix. I can give a concrete example. This page: http://www.nuxeo.com/en/about/events/dec2011training-boston/moreinfo is reported as having 6 duplicated URL in the tool. When I click on 6, SEOMOZ tells me "Our crawl bots are getting their joints greased to fetch you even better data. Sorry for the delay!" And on the page itself, I placed a canonical link to follow recommandation. rel="canonical" href="http://www.nuxeo.com/en/about/events/apr2012training-boston" /> As a result I am curious why I would have this reported as duplicate by SEOmoz. Is this a bug? Thanks for feedback!
Moz Pro | | nuxeo0