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
-
Unsolved Solve a Lost GA Connection - can't get it to work
Hi, I followed all steps on https://moz.com/help/moz-pro/getting-started/troubleshoot-google-analytics?_ga=2.15852085.2007735045.1676157945-122376721.1676157945 below Solve a Lost GA Connection multiple times but I keep getting the message "Our connection to your Google Analytics account was lost. Don't worry, you won't lose any data. Please follow the steps in our guide to reconnect.
Moz Pro | | silvansoeters
" I am on the free trial and would obviously like to connect to GA to see how everything is working. Any help would be greatly appreciated. Thanks.0 -
Link Building Webinars
Hello all, Does anyone know of any good link building webinars coming up? thanks, Beth
Moz Pro | | cmuknbb0 -
What is the best link building management tool ?
What is the best link building management tool that can automatically fill in content for submission for me, check whether my sites are submitted on other sites, propose new lists of submission sites, organize my link building (by date, anchor text, url, page rank, both back links, reciprocal, paid, etc), organize my social media profiles and connect them to each other ?
Moz Pro | | CretanDevelopments0 -
Linking C Blocks - SEOMoz says its a good thing?
In the competitve analysis, one competitor have more Linking C Blocks, Seomoz has a tick by it almost like its a better thing. Surely a site with the same administrative relationship is not going to help you as much from a linking point of view.
Moz Pro | | sanchez19600 -
Domain Authority is up, how do I find out what changed?
Hi, I’m a noob so if this is a really obvious question, I apologize. Our domain authority increased this week. I wonder if there is any easy way to find out what changed. (We didn’t do anything.) Thank you! Ann
Moz Pro | | anns0 -
Newly acquired links not showing up on link analysis
I have recently gained a few links which I know are definitly up, because I have seen them, however, when I navigate to link analysis on SEOmoz pro, the number of links isnt showing as more than before. How long does it take to update?
Moz Pro | | CompleteOffice0 -
Best place to start link building
I am new to SEO and want to start doing some link building using SEO moz to help. I am looking for pointers on where to start. Our business is www.hairbowcenter.com and we sell ribbon and hairbow supplies. We are lacking a lot of good links and I wanted to start focusing getting more. What tools should I use and where do I begin. I noticed our Pagerank is only 1 for our site and I want to get that up as well.
Moz Pro | | tbanwart1 -
Open Site Explorer Question- Link Value?
One of my backlinks is from a site that has a page authority of 74. However, the domain is a domain I purchased and 302'd to my current main domain. What I'm wondering (without getting into why a 301 is better than a 302) is this: does OSE have any tool that shows if there is actually value in a link? My assumption is that despite this domain having a PA of 74, the 302 is not passing over any value. To be clear, I understand that a 302 doesn't pass over any SEO value, but my question is whether or not OSE shows the value of a link? Thanks!
Moz Pro | | RodrigoStockebrand0