This is the kind of thing that I hesitate to admit getting excited about in fear of forever being branded as nerdy beyond salvation but in this case I had to risk it. The Google analytics blog has a great post about several free new Excel plugins that have come out that use the Google analytics APIs to allow you to generate your analytics reports right in Excel. This is an interestting use of the API and a great time-saver for those of use to generating analytics reports and then crunching through them on our own in Excel.
Here are the tools:
- VBA Macros – The simplest solution of them all. Mikael Thuneberg’s page explains how to make API requests directly from Excel using VBA Scripts and includes a pre-built Excel worksheet to get you started.
- The Tatvic Excel Plugin – Another easy-to-use plugin for Windows users that supports both Excel 2003 and Excel 2007. To get started you download the plugin then register to use the tool. Its simple UI helps you build complex queries and get data from Analytics right into your Excel worksheet.
- Excellent Analytics – Is an open-source initiative by Mark Red and Dropit. This Excel 2007 plugin works on Vista/XP and comes with a query builder to help you create Google Analytics queries and pull data right into Excel. Webanalytics.info put together a great step by step tutorial to get started using this plugin.
- ShufflePoint – Works somewhat differently than the solutions above. ShufflePoint has developed a query language that works with the Google Analytics API to achieve common tasks, such as defining the last 30 days as a date range. One then uses this language to construct an Analytics Data Export API query either by navigating to a URL within Excel, or by using their web-based query builder, then importing this data into Excel. This process allows the ShufflePoint solution to work across most versions of Excel, as well as Powerpoint, and iGoogle gadgets.
Let me know what you think of these as you try them out.