Adding Disavowed Domains to Open Site Explorer?

[BeytzNet]

Hi,

Is there a way to add to the OSE a list of disavowed domains?

Also, how often is it refreshed?
I know that the GWMT shows us links on sites that are down for months now.

Thanks

[TomRayner]

There's no way (that I can think of) for the OSE to know which domains you'd disavowed, so it would have to be manually done.  The way I'd do this would be to export the backlink report into a .CSV file, lift the domains that you have disavowed and then, in Excel, remove any domains from the OSE list that are on your disavow list.  You should be able to do this fairly quickly with the find+replace function.  Alternatively, you could colour the cells of those domains in red, which again you could do quite quickly en masse.

Next index update is pencilled in for March 12th - you can find the information here.  It usually takes a month, but what you'll no doubt notice on that page is that the index updates have been coming quicker and quicker; the last 2 updates have come only 14-15 days after the last one.

[MarieHaynes]

I agree with Tom, but I do see what you are saying.  I think you are saying that you would like an option where you can upload your disavow.txt file to SEOMoz and then get a list of your backlinks minus the disavowed files.  It's not a bad idea for a feature!

But until then, Tom's plan to do it manually in excel would work.  Another way this could work in Excel is to add your disavowed domains in column A and have your OSE domains in column B then in column C use this forumula:

=if(B1=A1,"duplicate","")

This will flag all of the domains that are in your OSE list and also in your disavow list.  You can then filter them out.

[TomRayner]

That's the sort of excel macro love that I was hoping for.  Thanks, Marie!

Also, uploading the .txt - that's not a bad or totally unrealistic idea, is it?

[BeytzNet]

Thanks Marie and Tom,

Marie, this is what I meant. Now that people are disavowing more and more domains and links, the OSE picture is plain wrong (unfortunately I disavowed a lot).

I will work with the excel for now.

Thank you both

[KeriMorgret]

Thanks for the assistance with a workaround Marie! This sounds like it'd be something good to write up for our feature request forum at https://seomoz.zendesk.com/forums/293194-SEOmoz-PRO-Feature-Requests, too.

Keri