export it o excel, then use seo tools for excel to check broken pages, etc.

See this post here - https://seogadget.co.uk/check-your-xml-sitemap-errors/

You can also run it through screaming frog, but with excel it's free

Let me know how it goes

Mark

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

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!

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

You'll have to do this in Google docs and not in Excel, but try this solution:

http://www.seomoz.org/ugc/updated-tool-seomoz-api-data-for-google-docs

HI Joel,

I'm looking at a blog post now on the site - http://activerain.com/blogsview/3275081/the-true-cost-of-collecting- - it's links are followed - you can use the mozbar to check/highlight followed and nofollow links. The links on this page are certainly followed and passing link equity.

That being said, blog here for the exposure to the readership and potential clientele, in addition to the brand exposure. Don't just do it for SEO purposes, but contribute value to the community - your returns will be greater in the long run with this mentality!

Mark

I'd do exactly what you're saying. Make the pages no index, follow. If they're already indexed, you can remove the page search.php from the engines through webmaster tools.

Let me know how it turns out.

Instead of looking at keyword density, I'd look at more important metrics and factors in on site optimization.

Use moz's on on page report card http://pro.seomoz.org/tools/on-page-keyword-optimization/new to check your onpage optimization. Also, you can use the toolbar to highlight a certain keyword. I think most people nowadays don't really take keyword density into account, unless it's extremely high and the post is very spammy looking. Go for natural text that will make sense for a reader, a real human being, to read the content. Use your keywords naturally throughout the text, and I think you'll see better results than incorporating a keyword wherever possible to increase keyword density levels.