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
-
Total External Links
Hi There, I'm looking at my link profile and my Total External Links dropped uber dramatically back in April. Any way to figure out what the heck happened? My only idea is that this was around the time we launched a new version of the website but I'm not sure it corresponds exactly and anyway the domain didn't change. Possibly some urls did but all have been redirected. Any ideas? Thanks, site is www.nationalpardon.org
Moz Pro | | NationalPardon0 -
What is the best tool for checking do follow outbound links?
what is the best software for detecting "do follow" outbound links from my site? thanks all!
Moz Pro | | tm46150 -
No link data for my domains + still no adwords data
All 3 sites In my campaign have no link data analysis done. 5 to 6 months after you said you were working on it Adwords data is still not available in Keyword analysis Partial service is understandable for a few days but not for months. Beyond the nice screens, what data & services do you exactly provide and what are we paying for?
Moz Pro | | ResourceLab0 -
Conflict in reported link data
I have a competitor in a campaign - the campaign report shows 181 linked domains BUT - the site explorer report shows only 15 linked domains. Which is correct? And if the site explorer is correct - how do we fix the campaign report? [URL]]([URL=http://imgur.com/m9xFv][IMG]http://i.imgur.com/m9xFv.jpg[/IMG][/URL]) m9xFv open-site-explorer open-site-explorer competitive-domain-analysis-humphreys-assoc.com-seomoz-pro
Moz Pro | | robertdonnell0 -
Is Opensiteexplorer.org missing a lot of backlink data?
I was checking a few of my clients backlinks that recently got hit by the "penguin" update to possibly try and remove some of the potentially spammy links. I ran reports in both opensiteexplorer.org and majesticseo and majesticseo brings back a ton more links, and these are sites that don't even have the max 10,000 backlinks that OSE should be bringing back. Does OSE bring back reliable backlink data? I'm starting to wonder.
Moz Pro | | RonMedlin0 -
OpenSiteExplorer Doesn't Show accurate links
Why do I get different results from SEOmoz tool bar and OpenSiteExplorer for some sites. For instance I look at one site and toolbar says it has 101 link domains, so I check it in OpenSiteExplorer and it says 2 link domains...? Am I missing something, or is it just not working properly?
Moz Pro | | barnst0 -
How often does the competitive link checker get updated?
I just found a link in the competitive link checker that links to a couple of my competitors. The checker says that i do not have a link on that page, but there is one.. i recently (last week) obtained that link. So that raises the question: how many times is the competitive link checker updated? kind regards
Moz Pro | | JarnoNijzing0 -
SEOmoz vs Google Webmaster Tools on incoming links
I'm working on basic SEO for http://queueassoc.com. Google has indexed the non-www verions of the pages and these are what the SERPS return SEOmoz toolbar shows that all of the incoming links juice goes to the www. versions of the pages, none to the non-www version. Yesterday I set up GWMT for the site, submitted a sitemap with the www version of the pages and set the default address to the www version. I had to verify both versions of the site in order to do this and in looking at the non-www version I saw that Google had all the incoming links there and none in the www.version, the opposite of what SEOmoz shows. Is this just because Google only has the non-www versions in its index? Will they show the links to the www version once they get them in the index? I'm worried about losing Google Page Rank value or SEOmoz DA by making this switch.
Moz Pro | | bvalentine0