Supermetrics Blog. Master online marketing.
Making you an expert in reporting, analytics & PPC.
I've just renamed my site to AutomateAnalytics.com. For quite some time, I've thought "Mikael's Page" wasn't the best possible name for the site, but haven't had the time to make the change. So now it's much clearer from the title and URL what this site is about - of...read more
Update: due to changes made by Twitter, this script does not work at the moment. We have published a new version that is now included in our Supermetrics Functions product. Our project of the day: creating a solution for fetching a list of tweets by keyword from...read more
UPDATE March 2014: We've published a new Google Docs add-on that makes it very simple to get your metrics from Google Analytics and other sources: Supermetrics for Google Docs UPDATE: Due to changes by Google, this no longer works. We have a new version available...read more
Eliminate time-consuming manual work in data processing and visualization - GA Data Grabber automates all this and helps you keep up with the latest developments for a large number of Google Analytics profiles or AdWords accounts. Works within MS Excel, making it easy...read more
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 GrabberI've created a new version of my data visualization tool, MT Google Analytics Visualizer. With this tool you can...read more
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