Is there a tool to keep track of internal links?

[BlueTraffic]

I am looking for a tool that will help me keep track of internal links. We are working on a website that has roughly 500 pages of unique content. We are at a point where we plan to go through all of those pages and look for natural, internal link building opportunities (as well as pages that may have too many "over optimized" links). It would be really helpful to know the following for each page:

1. URL (we can extract this)
2. Meta Title (we can extract this)
3. Target Keywords (we can manually enter these)

4. Internal Links To Other Pages - A field (or fields) where we could manually enter the URL of each page that this page links to (including the anchor text used)

Once all of this data is entered, it would be great if this tool could also count how many incoming links each page has (from other pages on the site) or somehow show which pages link to it. This would help to identify pages that have zero internal links.

Do you know if a tool like this already exists, or even a spreadsheet with some functionality like this already built in?

Thanks,
JC

[BlueTraffic]

Very interesting...I will take a closer look and thanks so much for the link.

[Mark_Ginsberg]

your comment about visualizing internal linking in charts reminded me of this post and the posts that are linked within - maybe this will help a bit

http://www.seomoz.org/ugc/one-more-great-way-to-use-fusion-tables-for-seo

[BlueTraffic]

Great to know. I have been using another "meta data extractor" for that, so if I can do it all at once with the Frog...even better.

What I'd really like to find is a way to keep track of all the pages that link to each other (and the anchor text)...even if I have to initialy enter the data manually. It would be so nice as we are creating new pages to quickly see other related pages that could use a link, and see all the pages that could be linking to the new page we just added.

Seems like someone would have created this. I could use the same thing for a client who has about 200 related websites in the same niche, as he prefers to link them together while avoiding too much interlinking.

Jeff

[Mark_Ginsberg]

It pulls title tags, meta descriptions, meta keywords if they're on the page, H1, H2, etc - very useful and it seems like it'll do a lot of what you're looking for - definitely worth the 99 pounds fro the year!

[BlueTraffic]

Thanks Mark. I downloaded the free version a while back and tried it out on one website but I didn't recall that functionality. This should save me a bunch of time. I am also hoping that someone may know of a tool that will help me with the other items too.

Jeff

[Mark_Ginsberg]

You can use screaming frog to crawl the site, and it will show you the internal links and anchor text to each page across the site as well. Though this post from Branko is a bit old,it's still a great resource on using Screaming Frog to check for internal linking issues - http://www.seo-scientist.com/seo-spider-review-xenu-on-seo-steroids.html

Screaming Frog has a paid version, but the free version will you crawl up to 500 URLs, so that might be sufficient for ya.

Hope this helps and good luck.

Mark