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://mza.seotoolninja.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 -
I see some links on Youtube.com that look like they are "Do-follow" links am I wrong?
Hi, I have some videos on YouTube.com and I notice many of the links show as "Do-Follow" per the Moz Bar. I have a feeling they are not actually "Dofollow" links because they never show up in Moz Pro, SemRush or any of my other tools. Can some of you people with greater knowledge of YouTube please clarify why the links look like "Do Follow". I am specifically thinking of my own backlinks on the videos and also the links in the "Comments". Best Regards, Bill Dalessi
Moz Pro | | Dalessi0 -
Only 2 Inbound Links which are the Redirect 301 Links
Hello Everyone, We're having a serious Problem with the ranking of our website so we started testing the website in different Tools. Almost all of the tools say our website works great and in comparision to our competitors we win in almost every test – but we rank behind them. The only thing that makes me wonder is the fact that our website has only 2 Inbound links (Open Site Explorer) when the link source is set to only internal. And the only links shown are 2 links that come from the old http (we're using https) and redirect 301 to our https. No other links – in other tools we have around 80 internal links to our rmain https-webadress. Does anyone have an idea where that comes from? I'm afraid this might be our issue in ranking behind of lots of our competitors. Lokking forward to your ideas and suggestions.
Moz Pro | | Franksen3o3
Greets Frank0 -
Two PR 5 websites, but little to no link data in OSE. How??
As the title states - We've recently developed two sites for clients - within the last 4 months or so. With the Google PR update, both sites are sitting as PR 5 sites. I've tried to have a look in the OSE for the backlink profile of both websites, but I see nothing. Even Majestic SEO's fresh index doesn't provide much info. The DA of each site is 11-16. I would really love to see what's generating the link juice to these sites. Any ideas? The two sites are: https://bfore.co.za
Moz Pro | | Mark.RedGiant
http://ictjournalafrica.net0 -
No follow link
Hi There, We pay for our site (www.residentialland.com) to appear on a popular property site: http://www.homesandproperty.co.uk/ When I use Open Site Explorer, it is our top link, but it has 'no follow' above it. So I had a look at the source code on the homesandproperty website and I cant see any nofollow code that would effect our link. I also used this tool which confirmed it isnt classed as a no follow link: http://www.seorankings.com/tools/nofollow-link-checker Can anyone else tell me if our paid for link on homesandproperty is a no follow, or if it is 'search engine friendly' so to speak? We pay for links across their site, so we want to get the full benefit. Any help would be appreciated, Thanks, Rob
Moz Pro | | op010 -
How many of my linked pages should I redirect (301's)
I'm moving my store to a new site and will have a much friendlier but completely different URL structure. I used Open Site Explorer to find inbound links to 513 pages and have done about half so far. The remaining pages have one link each at a page authority of 27 or less - but there are still 250+ of them. I have to manually view each old page, search for the product on the new site, and enter the redirect as there is no way to translate old URL's to new ones. How important is it for rankings to redirect the remaining 250 or so pages?
Moz Pro | | agirlandamac0 -
Latest OSE Update - Strange Numbers and Links
Hey everyone. I just checked our website in OSE with the latest update and noticed some strange numbers. The number of linking domains skyrocketed from 300 to 785 which definitely caught me off guard. Like all good SEOers I work hard to get links, but in a typical month I usually get between 40 and 50. To suddenly jump up by over 300 seems odd. Digging deeper, I noticed that some of the incoming link domains could be considered less than trustworthy (pages filled with links), while others I couldn't find at all on the page in question. I also never ever asked for any of these links, nor did anyone on my team. Should I be worried? I've heard of websites who purposely gain bad links to their competitors in order to penalize them. Is there an easy way to find out if this is going on? Could this possibly be a problem with OSE and just reporting non-existant links? Thanks for your feedback! Andrew BTW, the website in question is www.gooverseas.com
Moz Pro | | dunklea0 -
Is the "Too Many Links" metric a blunt instrument?
The SEO Moz crawl diagnostics suggest that we have too many on-page links on several pages including on our homepage. How does your system determine when a page has too many links. It looks like when a page as more than 100 links it’s too many. Should the system take into account the page authority, domain authority, depth of page or other metrics? In addition, no-follow links are being included. As these are dropped from Google’s link graph, does it matter if we have too many? For example, we could have 200 links, 120 of which are no follow. Your tools would tell us we have too many links. Feedback appreciated. Donal
Moz Pro | | AdiRste0