Supermetrics Blog. Master online marketing.
Making you an expert in reporting, analytics & PPC.
Update: this tool is no longer being developed. For another tool that can do everything this tool can and much more, see GA Data Grabber: GA Data Grabber To illustrate the kind of stuff that's possible with my GA-to-Excel functions, I created an Excel application...read more
UPDATE: Google is shutting down the free Translation API on which this solution depends. Instead, they have published a new paid API that you can access with our new translation add-in. Though it's not free, it's not expensive either, and it's much faster and more...read more
Using the Google Analytics VBA functions is by far the most convenient in Excel, but they work in Powerpoint too: this example PPT automatically updates itself with the latest figures from your Google Analytics profile (you need to have macros enabled in Powerpoint)....read more
UPDATE: This function has been replaced by the getGAaccountData function, see http://supermetrics.com/2009/08/excel-functions-for-fetching-data.htmlIn addition to the functions included in the previous post, I created a third function, getGAprofiles. With this...read more
Integrate Google Analytics data into Excel workbooks - no plugin installation needed. Now also available: an advanced reporting tool based on these functions. There are various solutions for fetching data from Google Analytics to Excel, as this article in Google's...read more