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 my website internal links on moz is 0?
My Web site: https://www.basictrailers.com.au/ I have been using Moz for almost 3 months, from the start to now, the internal links are always 0. However, if I check the links on my Google Search Console, it is over 1500. So what is the problem? If Moz is trying to make its algorithm similar to Google, why that they even cannot find my internal links. That is ridiculous. 0fhTnQG
Moz Pro | | Lilycharlie2 -
Inbound Links to Subdomains
Hi I want to gather a list of sites that are linking to individual blog items. Is there a way of gathering this data easily in Open Site Explorer? I've tried putting in the url/blog domain in the search box, and this just brings up those sites that link to the blog home page. I want to see all the inbound links that link to ALL subdomains within a particular URL. Any help appreciated. thanks
Moz Pro | | goodge0 -
How often does SEOMoz refresh their link analysis data?
I know that my link profile has changed within the last month, yet both SEOMoz campaign link analysis and Open Site Explorer have shown the exact same number of links for more than a month. Majestic SEO fluctuates as I would expect, but Moz data is unchanged.
Moz Pro | | Aggie0 -
Google Inbound Links much higher than SEOMOZ
I just started here and really like everything the community and tools so far. One question. My SEOMOZ dashboard shows only one inbound link while Google Web Tools shows 300+. My site has been up for 3 months now and I'm curious about the lack of indexing. Any help, tips or feedback is greatly appreciated. http://CrossTrainingandFitness.com Robb Jarrett
Moz Pro | | carbbon0 -
Is it possible to create a report where per page only external links are shown?
Hi all, When I create a report on page level (links to pages per page), it seems that also internal links are included. Is it possible to create a report where per page only external links are shown? thnx Dennis
Moz Pro | | djingel10 -
Were do I find the old Link Scape report that shows Domain Juice passed?
It looks like they are retiring the old Link scape. Where do we find the report that showed the Domain Juice passed by each link? Is it in the advanced reports and we need to request and wait?
Moz Pro | | MBayes0 -
Can't find email address or contact form on website I want link from
Hi, How do you use whois or other resources to find an email address for a site that doesn't list their email address or have a contact form? Our competitors look like they have contacted the site but I don't know how to contact the site myself. They have a facebook fan page and a twitter account. Thanks.
Moz Pro | | BobGW0 -
Competitive Link Analysis
How can I make the a new report for the Competitive Link Analysis? My report has a date from two weeks ago and I would like to see an update.
Moz Pro | | CalgaryRealtor390