Excellent Analytics Pro is an addin that brings all the power of Google Analytics right into Microsoft Excel. You don’t have to log into the Google Analytics interface to export data; you can import data from within Microsoft Excel instead. It has something that the free version doesn't: automation.
Key features:
- Fast and intuitive user interface
- Refresh all queries in the worksheet or workbook with one update
- Run the same query for multiple profiles in Google Analytics
- Import all the rows from Google Analytics (not limited to 10,000 rows)
- Use Excel’s formulas and charts
- Calculate your own KPIs
- Build your own dashboards and scorecards in Excel
- Gather all your data in one place by getting Google Analytics data in Excel
- Completely recoded from scratch compared to Excellent Analytics free version
- Improved user interface
- Free, 14-day, trial
How to use:
http://ampliofy.com/support/tutorials/excellent-analytics-pro-tutorial/
This app accesses data securely using
AuthSub, OAuth or Open ID.