There are various solutions for fetching data from Google Analytics to Excel, as this article in Google’s Analytics blog describes. My approach is to use custom functions to achieve this, whereas the other solutions are Excel plugins you need to install. I think the benefits of this approach are:
- Speed: No need to install a plugin that slows down Excel
- Ease of use: The functions are used just the same as any of Excel’s built-in functions (like SUM or COUNT). No knowledge of VBA is required!
- Easy sharing: The code fetching the data from Google Analytics is embedded in the Excel workbook, so you can send the workbook to others, and they can refresh the GA data or modify the queries without them having to install anything
- Flexibility: The query parameters can be outputs from other functions or macros; execution of queries can be controlled with macros
- Compatibility: Works in Windows Excel 2003, 2007 and 2010 (maybe older versions too, haven’t tested). Also available for Google Docs Spreadsheet. For Mac OS X, we provide Supermetrics Data Grabber, which works with Mac Excel 2011 (in addition to Windows Excel versions 2003 and later).
- New API features immediately available: Whenever there are new metrics or dimensions added to the Analytics API, you can start fetching them immediately, without needing to wait for a plugin provider to add those to their tool.
- Customization: If you know VBA, you can easily modify the functions to fit your specific needs
There two options to get started using my solution to import Analytics data to Excel:
- To try out an advanced analysis tool created with this technology, take a look at Supermetrics Data Grabber – it automatically creates charts and PowerPoints of your data, and can be used to automate analysis of Google Analytics, AdWords, BingAds and Facebook data
- To design reports on your own using our Supermetrics Functions, download the latest version of this Excel file and start building from there. Just get an authentication token from http://AnalyticsFunctions.com and copy it to the sheet, and it should automatically load some of your data. I’ve added a few examples on how to use the functions to that file – by modifying it you can create all kinds of reporting solutions. Note that you need to have macros enabled in Excel’s security settings for the functions to work (after changing the settings, you may have to restart Excel).
Lots of thanks for everyone who have helped us develop this by reporting bugs and sharing their ideas.