After seeing lot of analytics and other reporting tool, but didn't find any suitable tool to create different type of reports for Clients, Managers and Executives. Mainly the comparison report where I can see latest report with last week and a month ago and same week in last year etc... That is what my SEO people do manually these days for me and managers. So do you think industry need that sort of product which can generate different comparison reports? Or if there is any one?
If you can't manipulate Google Analytics to do what you want it would be quicker to use their API to pull out the data you need and graph it than to go to all the effort of recreating it.
In my opinion you can use Google webmaster tools to analyze them. You hit mark keywords since you do and after a month or a certain period of time will be reported to them.
I believe there is a tool that does this called RankTracker from Link-Assistant. Or where you thinking about a strictly web based solution?