|
|
In case you missed it, last week the Google Analytics blog highlighted some of the major services which allow you to integrated Google Analytics data right inside of Microsoft Excel.
-
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 – 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. ]
-
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.
Another tool to query and get GA data into Excel: http://www.youcalc.com/apps/1249652239535
Also allows you to generate a real-time pivot chart of your GA data, visualizing metrics by dimension.