TLD URL List Tool?

[WaterGuy]

I've been handed a list of a couple hundred domains that have been acquired over the years and want to get rid of most of them or make sure they redirect to the right sites.  To help me do that I want to see if they are currently being linked to and from where, and identify the URLs where they actually land (as suggested in OSE, "I see this redirects to").  I was planning to create a table in excel by searching each domain in OpenSiteExplorer (OSE), and then thought there must be a tool that already does this.

Any suggestions?

Bill Scully

[TomRayner]

Hey Bill

There is a tool that will give you a URLs response and then also the new URL if it redirects.

You can find it here: http://www.tomanthony.co.uk/tools/bulk-http-header-compare/

Better yet, you can export the results into a CSV, which will hopefully be useful for you.

As for the first question about what is linked to and where, you've probably found that OSE can do this for you.  I'd advise going into the "top pages" tab to see which URLs have external linking root domains.

Hope this helps.

[mihaiaperghis]

Hi Bill,

I'd probably do this using Excel as well. Get the domains in a column, use the Lins API for Excel tool to grab backlink/LRD information for each domain, then use the SEO Tools for Excel plug-in to check the redirect location.

You can also grab backlinks for each of the domain using the API tool, but you might need to do that in a separate sheet.

[WaterGuy]

This sounds great but I’m having a problem with the Links API Excel Extension (I use Excel 2010) . I can see the installed functions, but all I get is errors. I get an error even when I try a simple call like:
=SEOMOZ_linksAPI_toFit(seomoz.org,”page_to_page”,”page_authority”,”external+follow”,”TargetCols=8″,”SourceCols=103079215109″,”LinkCols=8″,100,25)

It returns this:
ERROR: Nothing returned for via http://lsapi.seomoz.com/linkscape/links/29?Scope=page_to_page&Sort=page_authority&Filter=external+follow&Limit=25&Offset=0&TargetCols=8&SourceCols=103079215109&LinkCols=8&AccessID=member-cfd***&Expires=130984648&Signiture=*** (Note *** indicates I've hidden the value)

Is this an API call issue? What am I doing wrong?

[mihaiaperghis]

I actually have an issue with that as well (I'm also using Excel 2010), been meaning to contact Richard Baxter to ask him about it, but I keep forgetting to do that.

I use the normal function, without "_toFit", and just select the cells beforehand and use CSE (ctrl+shift+enter).