There are lot of ways you can optimize your reporting with Google Analytics and I would like to bring your attention to a very powerful solution as described below.
Our solution is not an Excel plugin but it is a packaged Datawarehouse. Let me assure and explain in very simple terms.
- Connect to your profile [or as many profiles]
- Pick your metrics
- Save your query
This 3 step process will let you define a complete workflow of extracting your website metrics into a MySQL database table. Yes, you can import any combination of Google metrics and columns into any MySQL table.
Once you define the workflow, it will perform a full load and then on a daily basis it will keep appending new data to the same table. This happens without any intervention from your side.