Keyword Analysis Reporting Tool
I just recently wrote a post on SEOmoz on how to build an advanced keyword analysis report in Excel. The post provides an in-depth guide to building out your own keyword analysis report which pulls in data from several different places. It walks you through using Google Analytics and Adwords APIs and using pivot tables to categorize your keyword data sets.
If it sounds interesting, you can find that post here. In the comments I was asked if I was willing to share my data set to help people through the guide. So that is the main purpose of this post and here it is. Enjoy.