Supermetrics Blog. Master online marketing.

Making you an expert in reporting, analytics & PPC.

Fetch up to a million rows of GA data to Excel

We've just published a new version of GA Data Grabber, which can fetch up to a million rows of data per profile. While the Analytics API has a limit of 10 000 rows per query, GA Data Grabber now has the ability to loop through up to a hundred queries and combine the...

read more

Visualizing changes in popularity of site content

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 bumped into this post on the SEOmoz blog, and decided it might be a good time to make a new post about a tool we...

read more

AdWords API solution for Excel now available

I'm excited to publish a great new solution for fetching AdWords figures to Excel through the AdWords API, something that many people have been asking for.We've created two products based on this technology: 1. AdWords module for GA Data GrabberWith our popular report...

read more

AutomateAnalytics featured in the GA blog

Today, Google published an article about my business and solutions in the official Google Analytics blog - check it out here!I'm really happy to be recognized this way 🙂 Lots of thanks for this, and also for the earlier article published last August, to Nick...

read more

GA Data Grabber – New version in 3D!

Version 1.1 of GA Data Grabber, the tool that helps you analyze multiple Google Analytics profiles, is now out!There are several new features that make this tool even more useful for people working with many profiles:New visualizations: The tool now really takes...

read more

The site is now AutomateAnalytics

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

Fetching tweets to Excel/Word/PPT/Google Docs

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

Google Analytics data to Google Docs

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

Function for fetching a list of GA profiles

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

Get started with Supermetrics.

#1 reporting automation tool for PPC, SEO, social and web analytics.
 Free trial with full features. No credit card required.

Start Free Trial

Share This