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
-
Do you get link equity from a redirect service?
When using a redirect service, do you get link equity from the redirect service or only from the linking website? Using opensite explorer in Moz, always shows me directory and redirect services as most important contribution for the domain authority. But I'm questioning if this is true. P.S. I'm not asking if link equity is passed from the linking website. That question has been answered many many many times. (hint: the answer is yes). H58xHAl.png pGH7e48.png
Moz Pro | | jasny0 -
Why would I be ranking for a term when it's not anywhere in my page or pages linking to it?
Hi, I have a keyword that's not anywhere in my page in page-grade tool nor are any pages linking to it with that term, why would that be ranking. The term is "dynamic card solution" This is a company we used to have 5 years ago and merged with our company. This term is ranking #1 for this page- http://www.datacard.com/instant-issuance-solutions . I can't figure why that would be even as this is a newer page in the past year. Thanks for any insight as I'm newer to moz. Laura
Moz Pro | | lauramrobinson320 -
DA as a measure of link-building success/failure?
Hi all 😃 What would be a good way to track weather a website is doing good or bad in regards to link-building in google's eyes? Is the Domain Authority the best credential? If a website is penalized for link-building schemes, would it reflect on the Domain Authority shown in Moz Analytics? What other Moz score would reflect this scenario? Best regards & Thank you for your help. Carlos
Moz Pro | | 90miLLA0 -
How do Infographics provide links? (example inside)
Hi, I don't get it...
Moz Pro | | BeytzNet
I've encountered the following infographic that seemed to do well: http://www.brilliance.com/4cs-of-diamonds-infograph As you can see, the page has thousands of social shares from Tweets to Facebook and obviously Pinterest. However, when I placed this page on Open Site Explorer (click to view) I see only 9 external links and page authority of 28/100. And this seems to me like a successful infographic. Any explanations? Thanks0 -
On Link Analysis tab I my best pages are 301 and 404 pages.
I looked on my redirrect file and found that /* redirects to /v/404.asp.
Moz Pro | | sbetzen
However if you look below at the link analysis the 404 page is getting a 404 error.
The homepage ecowindchimes.com/ is getting a 301 (but I don't know where it is going to).
The third one is also redirected. 1. [No Data] ecowindchimes.com/ ||| 301 ||| 2 ||| 36 2. 2. [No Data] ecowindchimes.com/v/404.asp ||| 404 ||| 2 ||| 34 3. [No Data] 3. ecowindchimes.com/index.html?lang=en-us&target=d2.html ||| 301 ||| 1 ||| 33 So I have 2 questions: 1) should this be fixed? and 2) how? This is a volusion site and I believe the "catchall" redirect was done by them0 -
Where can I find the page strength tool?
I have an SEOmoz account and can't seem to find the page strength tool. Is it somewhere in research tools?
Moz Pro | | elenaroi0 -
Sudden, drastic drop in # of links and root domains on website?
Noticed that my links and root domain numbers had dropped by ~40%, seemingly overnight. Any idea what could have contributed to this (Toolbar update???)?
Moz Pro | | wlefevre0 -
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