You read my mind. We have dozens of dealerships that we want to report on - AdWords-CTR, CPL, Spend, Impressions share, and Analytics-time on site, bounce rate, pages viewed, etc. etc.
It looks like I'm going down the same route you already forged! Thanks again. Big help.