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.


Keyword Analysis Reporting Template

About Dan

Dan Peskin is a SEO Specialist at Geary LSF Group. He is passionate about digital marketing and focuses on the development of integrated SEO and PPC strategies for his clients and his company.

3 Responses for Keyword Analysis Reporting Tool

Comments RSS ?

I’ve read your post on SEOMoz and it helps determining a powerful SEO Strategy that works all the way.

February 8, 2012 6:38 am

Thanks, glad to help. Having this kind of reporting tool gives you such a clear picture on how to define and analyze your keyword strategy. It really is powerful!

February 10, 2012 8:07 pm

Wow, nice. I never thought that keyword analysis is such hard work. I wanted to try keyword researching and happen to read you post on SEOMoz, it was great I learned a lot but unfortunately I also learned that its by far no easy task.

I guess its back to the drawing board for me and start small time.

May 24, 2012 11:32 am

Comment now!