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
-
3 of my clients suddenly lost alexa and DA ranks.
3 of my clients suddenly lost alexa and DA ranks. Websites are active, created more than 10 years ago, and actively updated. About 5000 users each month. What could be the reason? I want to note that we never spam. We do only holistic SEO and write only Unique articles. This looks very strange to me. Any suggestions?
Moz Pro | | isaacaiden0 -
Spam links with high DA
I'm running through the spam analysis and noticed a few links that are considered to be 9+ on the spam score (high spam level), but some of them have DA of 60 -75. How can this be possible? When I view the sites they appear to be be pretty low quality. If i'm considering disavowing a site should I focus on spam score or DA? A DA of 75 is a pretty reputable standing.
Moz Pro | | STP_SEO0 -
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 -
SeoMoz reporting 301 redirects I can't find
So I'm trying to find a bunch of redirects that SeoMoz is reporting that were created by Wordpress but I can't seem to find. I'm finding a bunch of redirects FROM pages like this: www.mysite.com/wp-content/themes/mimbo/page-name.com redirecting to www.mysite.com/page-name.com Anybody have any idea how I can track down the offending page that has a link to that url. I took a look at my templates and content with the pages and can't seem to find anything that would create it.
Moz Pro | | brandco0 -
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 -
How long will it take for the link analysis to be updated?
In an effort to evaluate SEOmoz I started off my free trial with a fresh website that I am going to get to rank on the first page and hopefully to the #1 spot. I have been link building and changing the website around a lot. When I created the website hosted by HostGator with wordpress installed I marked down where it showed up the first time. After checking for many days to about the 100th spot I found it in spot 65. I have since then been spending some time (not a ton of time, but enough) guest posting, some bookmarking, press release creation and some other odds and ends stuff. The page has gone up to 23rd but there have been no signs of any work done on the link analysis. So, How long does it take?
Moz Pro | | DLRISM0 -
Fixing the Too Many On-Page Links
In our campaign I see that it reported that some of our pages have too many on-page links. But I think most of the links that was seen by MozBot is related to our images. There are a lot of images in our site and at the same time we support 11 languages which adds additional links One of the pages that have a lot of links is www.florahospitality.com/dining.aspx What can you <a></a>suggest to fix this? Thanks. <a></a><a></a><a></a><a></a><a></a><a></a><a></a><a></a><a></a><a></a><a></a><a></a><a></a><a></a><a></a><a></a><a></a>
Moz Pro | | shebinhassan0 -
Competitive link finder not working
Hi guys, I just wanted to check the status of the Competitive Link Finder. I've been trying to use it for well over a week, literally trying it every day and every single time I get the "we may be a little busy" message. Are there any plans to upgrade it? I realise its a labs tool, but its actually a really useful tool which I just don't seem to be able to benefit from whatsoever. Would love to hear what the plans for this tool are. Thanks Al
Moz Pro | | dotcentric0