In OpenSiteExplorer - how do I find out which in bound links were lost?

[homefinder]

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?

[G-Force]

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.

[elephantseo]

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))