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
-
Inbound Links/Spam Score - Disavow
Hi I have been using the Links tool in our Pro account on Moz, using the MOZ spam score/inbound links tool I can identify the linking domains and their spam rating. It shows we currently have around 4.8k linking domains and when I export the data I receive information like below. (Name - Spam Score)
Moz Pro | | mlb7
wall03d3.ga --%
wallieepattern.gq --%
ajij.tk --%
0pattern36.tk --%
70patterndesign.cf --%
discountbuy3cheap2.gq --%
androiddesktop39.ga --%
mobile2android7.ml --%
9321coupon.gq --%
9722.gq --%
blackphoto.us --%
yzbm.info 89%
e411info.info 90%
bcep2015.nl 91%
6vh.info 93% These sites are linking to our images on the site and also to the product the image is from. 80% of our links are like these ones above I understand these types of links are quite common especially for e commerce sites but should I disavow these on a regular basis or ignore them? I don’t want to ignore them if they could harm us. Thanks Mike0 -
Why are my month old links not showing in WMT or OSE?
Hey Everyone! I've been working hard on boosting my ranking after launching my new site 2 months ago. I realize that this process normally takes some time however I've come across a questions that I'm not sure I know that answer to... I had some really solid back links added about a month ago but nothing is showing up yet in WMT on them. When I run an OSE I don't see any links there (not even under newly discovered). Can someone please help with some insight on why they might now be showing. Is it just a time thing or should I be doing something different?Any insight will be very helpful. Thanks
Moz Pro | | MDesigns0 -
Open Site Explorer detects links from a site that redirects to it? How is this possible?
I was checking external links to a site: scte-brasilien.de/ and was wondering why there are so many links pointing from another domain (reisen-nach-brasilien.com/) although it redirects to scte-brasilien.de/? So when checking the redirecting domain OSE knows its redirecting... The URL you've entered redirects to another URL. We're showing results for scte-brasilien.de/ since it is likely to have more accurate link metrics. See data forreisen-nach-brasilien.com/ instead? How is this possible? best regards
Moz Pro | | inlinear
Holger0 -
Places to Find Good SEO Webinars
I've noticed that the Pro webinars on SEOMoz seems to have slowed considerably with the last one in April 2012. Are there other good places you would recommend to find good SEO webinars? Thanks!
Moz Pro | | ProjectLabs0 -
Links don't add up
Sorry if this is obvious, but I'm new to seomoz. I've run an analysis for one of my pages and it's showing 624 total links - 118 internal and 6 external. Why doesn't the sum of the internal and external links equal the total links?
Moz Pro | | landmark10 -
How do I finde out how my company ranksfor each keyword compared to their competitors?
Is there a tool or way to see how my company ranks for each keyword compared to the competition.I am new at this and am wondering if there is a tool for this and how to use it . Answers please in very laymans terms. Thank you.
Moz Pro | | poweradmin1 -
How long do old links stay in Open SIte Explorer stats?
Hi, In Open Site Explorer has around 2000 External followed links which would be great if it was true. I think the issue is that before my site wasn't appending slashes to the url so I think it was counting links from http://mydomain/page1 to http://mydomain/page2/ as an external link (could be wrong here). I corrected this a couple of months ago but I still seem to have over 2000 External links. When I look at the linking pages many of them are "sans slash" and have old anchor text in the link. How long does it take of OSE to update these stale links it there any way I can prompt it to take aciton?
Moz Pro | | moesian0 -
How best to gain Followed Linking Root Domains?
Hi All, Sorry if this question has been asked before. I've had a look through the Q&A sections and I couldn't really see anyone who'd asked the question as direct as this? Basically, I'm using the SEOMoz competitive domain analysis to compare some of our domains and our competitors domains and see where we're falling down. At the minute, we seem to be only scoring around '31', whereas our two closest competitors as 32 and 33 on the overall score. This still seems pretty low to me (maybe it's not) so I'm assuming we can make some good headway. At the minute, the analysis shows that we're beating our competitors hands down with the number of links to our site, these are all relatively good quality and they haven't just been spammed out there to gain links. We are however struggling to get followed linking root domains. As I understand it, these are basically just links from domains not on the same IP that are followed? Since I've seen this, I've looked through the open site explorer and gone through all of our competitors sites to get backlinks from URL's linking to them. I've had fairly good success with this but they only seem to have gone up by 1 - 2 links. Does this only get updated once a month? In addition to this, does anyone have any tips on how to build up followed linking domains? Kind Regards
Moz Pro | | LewisSellers
Lewis0