Supermetrics Blog

Supermetrics at the Google Analytics Partner Summit 2014

Supermetrics at the Google Analytics Partner Summit 2014

The annual Google Analytics Summit for GA Certified Partners and GA Premium users was held in San Francisco this week, and we were happy to be selected as one of only five companies (and the only one outside North America) to get a demo booth for showing our products. We focused mostly on demoing our new… Read more »

Supermetrics vs Google Analytics: Add-on feature comparison

Supermetrics vs Google Analytics: Add-on feature comparison

In addition to Supermetrics for Google Docs, there’s another Google Sheets add-on that can be used to get data from Google Analytics, the official Google Analytics add-on published by Google. We decided to put together a feature comparison of the add-ons so you can more easily choose between them. Of course, it’s not very objective… Read more »

Date range comparisons and multi-segment queries in Supermetrics for Google Docs

Date range comparisons and multi-segment queries in Supermetrics for Google Docs

We’ve released a new version of our Google Docs add-on with some nice new features: Automatic comparisons to previous values Supermetrics for Google Docs can now automatically calculate year-over-year changes and other comparisons. Just go to the Select dates tab and use the Compare to dropdown menu. You can choose to compare to the same… Read more »

Get your search query metrics from Google Webmaster Tools

Get your search query metrics from Google Webmaster Tools

We’ve added a new data source that many users of our tools have been requesting for a long time: Supermetrics Data Grabber and Supermetrics for Google Docs can now connect to Google Webmaster Tools. This data is extremely useful now that Google Analytics shows “not provided” for most search keywords. Things you can get using… Read more »

New Supermetrics Add-on for Google Docs & Sheets

New Supermetrics Add-on for Google Docs & Sheets

Google has just launched add-ons for Google Docs and Sheets. We’re proud to be among the first the developers to release add-ons, and we have two of them! You can find and install them via these links: For Google Sheets For Google Docs The Supermetrics add-ons make it simple to fetch all your metrics into Google Docs… Read more »

We’ve added Google Analytics Multi-Channel Funnels

We’ve added Google Analytics Multi-Channel Funnels

Both our reporting tools, Supermetrics Data Grabber and Supermetrics Functions, now support Google Analytics Multi-Channel Funnels. This means you can now get detailed analytics on interaction paths leading to conversions on your site, you’re no longer limited to just seeing conversions for the last interaction. You can get a breakdown of conversion value attributed to each… Read more »

Introducing the Twitter Module for Supermetrics Data Grabber

Introducing the Twitter Module for Supermetrics Data Grabber

We’re happy to announce a new Supermetrics Data Grabber module for accessing Twitter. The Twitter Module is super simple to use: just specify a search keyword, press the Fetch Tweets button, and you’ll get a lists of tweets containing the keyword. As with all Data Grabber modules, you can set up a bunch of reports with different… Read more »

Supermetrics Functions can now access Twitter & pivot your data

Supermetrics Functions can now access Twitter & pivot your data

Today we’re releasing version 2.3 of Supermetrics Functions for Windows Excel and Google Sheets. We’ve heard your feedback and have added several powerful new features: New getTweets function for searching tweets In addition to the five data sources we had (Google Analytics, AdWords, Bing Ads, YouTube & Facebook), Supermetrics Functions can now access Twitter to… Read more »

We’re now Supermetrics

We’re now Supermetrics

This week marks a major milestone for our company: we are retiring our old AutomateAnalytics, GA Data Grabber and GA Data Uploader brands to become Supermetrics. We’re doing this because we want to bring our various tools closer together and to make it clearer what we are offering. After reviewing hundreds of names, we decided… Read more »

Easy AdWords reporting in Google Spreadsheet

Easy AdWords reporting in Google Spreadsheet

UPDATE March 2014: We’ve published a new Google Docs add-on that makes it even easier to get your metrics from AdWords and other sources: Supermetrics for Google Docs Our AutomateAnalytics Functions provide a great way of building AdWords reports in Google Spreadsheets. The functions can be typed to spreadsheet cells, and using the function parameters, you… Read more »

GA Data Grabber can now avoid Google Analytics data sampling

GA Data Grabber can now avoid Google Analytics data sampling

When using the Google Analytics API to fetch data for sites with high traffic volume, Google often returns sampled results. These usually differ from the figures displayed in the Google Analytics web interface by a few percent. Data sampling is especially likely to occur when fetching data over a long date range, splitting by several… Read more »

New report types available in GA Data Grabber

New report types available in GA Data Grabber

Producing great-looking reports automatically is one of the big benefits of using GA Data Grabber: you don’t need to spend time formatting the data and creating charts, as GADG does all this for you. Still, we’ve noticed that in addition to the built-in GADG report formats, many people also build their own dashboards and visualizations… Read more »

Upload cost data from any source into Google Analytics

Upload cost data from any source into Google Analytics

We’re happy to announce a new feature in GA Data Uploader: you can now use it to upload CSV files containing ad cost data into Google Analytics. This lets you get cost data from any source, for example Facebook Ads, LinkedIn Ads or Yahoo, into GA. GA Data Uploader automatically guesses which CSV columns contain what… Read more »

Introducing the YouTube Module for GA Data Grabber

Introducing the YouTube Module for GA Data Grabber

When we ask GA Data Grabber users which new data source they’d most like to see added to the tool, YouTube has consistently been one of the top answers. We’ve heard your wishes and have now added a YouTube Module. This new module lets you fetch statistics for any number of YouTube channels and videos… Read more »

AutomateAnalytics Functions can now fetch AdWords & YouTube data into Excel & Google Spreadsheet

Last summer we published a new version of our Google Analytics VBA functions, when the old 2009 version was broken by changes Google did to their API. We’re now releasing the first major update to this, with two major changes:In addition to Excel, the functions now work in Google Docs. The usage is just the… Read more »

Get your Bing Ads cost data into Google Analytics

Get your Bing Ads cost data into Google Analytics

At the Google Analytics Conference in October, Google published a new cost import API, which allows importing cost data into Google Analytics. This API has now been rolled out to all GA users, so we’re ready to introduce our new tool, GA Data Uploader, which uses the new API to link your Bing Ads accounts… Read more »

GA Data Grabber at the Google Analytics Conference

GA Data Grabber at the Google Analytics Conference

We were really happy to be one of only five tool vendors that Google invited to have a booth at the Google Analytics Conference held last week in Mountain View, California. The conference was attended by 400 Google Analytics Certified Partners and Google Analytics Premium clients from over the world.   Lots of great new… Read more »

Lots of new data available via the Analytics API

Lots of new data available via the Analytics API

Google has just published an update of the Google Analytics API, which adds lots of new data fields, including detailed information on mobile devices and social interactions. We’ve included the new data in version 1.64 of GA Data Grabber, which is now available for download. Users of our Google Analytics VBA Functions can also start… Read more »

Multi-segment reports in GA Data Grabber: branded vs non-branded keywords

Multi-segment reports in GA Data Grabber: branded vs non-branded keywords

We’ve just uploaded version 1.63 of GA Data Grabber, with a great new feature: the ability to pick several Google Analytics segments into one report. This opens up the possibility to do all kinds of analyses that would’ve previously required running several reports and combining the results. One useful example is comparing branded vs. non-branded… Read more »

Google Analytics VBA Functions for Excel – new version available

UPDATE: Now also available for Google Docs, see more information here One of the most popular solutions for fetching Google Analytics data into Excel has been my set of VBA functions that can be used on an Excel worksheet just like any of Excel’s built-in functions. Shortly after the Analytics API was released three years… Read more »

Check out our new excellent analytics tool, now in beta

Check out our new excellent analytics tool, now in beta

We’re happy to introduce our new Google Analytics tool for Excel users, FasterMetrics. It’s an easy-to-use plugin that gets your Google Analytics data into Excel, and works on both Mac and Windows Excel. It’s similar to a tool called Excellent Analytics, but it also works in Mac OS X, is faster, and lets you set… Read more »

Google Analytics Account Overview report with GA Data Grabber

Google Analytics Account Overview report with GA Data Grabber

The old Google Analytics interface is being deprecated, and even though the new one is in many ways an improvement, it lack some features of the old interface. One of these is the Account Overview, which displays on one page certain core metrics for all of the profiles of an Analytics account, and also shows… Read more »

GA Data Grabber featured in the Google Analytics Blog

The official Google Analytics blog has a new article out that shows how useful GA Data Grabber can be for automating multi-site Google Analytics reporting. The American TV network PBS is featured as a case study. Check out the article here.Lots of thanks to Amy Sample from PBS for agreeing to the case study, and… Read more »

New Facebook page & app analytics tool now available

New Facebook page & app analytics tool now available

We’re happy to announce a new Facebook Module for GA Data Grabber, the #1 reporting tool for Google Analytics, AdWords & MS adCenter! The Facebook Module makes it easy to keep track of a large number of fan pages and applications, as it can fetch the numbers for dozens of pages/apps into an Excel sheet… Read more »

Get the beta of the new GA Data Grabber

Update: the new version has been released and can now be downloaded from http://supermetrics.com/product/supermetrics-data-grabber/We’ve been working on a big update to GA Data Grabber. We’re now at the beta stage – you can download the beta version here.I’ll write a more detailed post on the new features once this version comes out of beta, but some… Read more »

Translation Tool for Excel

Translation Tool for Excel

Two years ago, I published a small script I made for using Google Translate in Excel (http://supermetrics.com/2009/09/excel-function-for-translating-text.html). I didn’t give it much attention since, but apparently it’s grown quite popular. Unfortunately, Google is now shutting down the free translation API that my script used, so it will stop functioning very soon. Many people contacted me regarding… Read more »

New version of the AdWords Addin for Excel

We’ve just uploaded a new version of the AdWords Addin for Excel. This new version uses the new AdWords API version, which means you don’t need to pay by usage anymore – the only cost is the annual license price (currently $199 USD per MCC). When using the functions, you no longer input an AdWords developer… Read more »

Usage of GA Data Grabber AdWords module is now free!

Usage of GA Data Grabber AdWords module is now free!

Google has published a new version of the AdWords API: with this new version, it’s no longer necessary to purchase AdWords API units in order to run reports. We have just uploaded a new version of GA Data Grabber that takes advantage of the new API version, you can get it here. This means that… Read more »

New Microsoft AdCenter reporting tool

New Microsoft AdCenter reporting tool

After the transition of Yahoo Search Marketing to Microsoft AdCenter (formerly known as MSN AdCenter) last year, AdCenter now serves ads to both Bing and Yahoo search engines, and currently has around 30 % of the US market. To help advertisers working with AdCenter, we are now introducing a new tool, GA Data Grabber AdCenter… Read more »

8 new metrics available in GA Data Grabber

8 new metrics available in GA Data Grabber

We’re happy to announce the addition of 8 new metrics into GA Data Grabber! Google hasn’t updated their API, but GA Data Grabber now uses existing dimension fields to calculate new interesting metrics, which are not available via the Analytics web interface nor through other tools that use the Analytics API. The new metrics are… Read more »

GA Data Grabber now groups site content by directory

GA Data Grabber now groups site content by directory

One popular report of Google Analytics is Content Drilldown, which lets you see the metrics per content on different directory levels, instead of by individual URL. This report isn’t available through the Analytics API directly, but we have now managed to add it into GA Data Grabber, by parsing it from the available data. There… Read more »

New free Analytics tool available: metrics by hour of day

New free Analytics tool available: metrics by hour of day

UPDATE: Due to changes by Google, this tool no longer works. Instead, you should check out the AutomateAnalytics Functions, which you can use to create a report similar to this, and countless others – it’s the most flexible way of getting Google Analytics and AdWords data into Excel and Google Spreadsheet. It’s been some time… Read more »

Automate Snoobi reporting in Excel

Automate Snoobi reporting in Excel

Today we’re happy to announce a new product, Snoobi for Excel. It’s an analysis tool working in MS Excel that automatically fetches and visualizes your Snoobi data. Snoobi for Excel creates in a matter of seconds reports that would take hours to set up manually. With this tool, you can put your time into interpreting… Read more »

GA Data Grabber now supports multiple logins and OAuth

GA Data Grabber now supports multiple logins and OAuth

We have recently added several major new features to GA Data Grabber. Here’s a brief overview of the most important ones. To test them for yourself, download the latest version here.Support for multiple Analytics loginsGA Data Grabber now lets you log in with multiple Analytics users (Google Accounts) simultaneously. This is a handy feature if… Read more »

GA Data Grabber AdWords module no longer requires a developer token

GA Data Grabber AdWords module no longer requires a developer token

With the latest version of GA Data Grabber (available here), you no longer need to have an AdWords developer token in order to use the AdWords module. This means that anyone with an AdWords account can now use this great reporting tool! When you have a GA Data Grabber subscription, you can buy AdWords API… Read more »

Google Analytics & AdWords tool for Mac OS X Excel

Google Analytics & AdWords tool for Mac OS X Excel

Since I published the Google Analytics VBA functions for Windows Excel in 2009, lots of people have contacted me hoping to find a similar solution for Mac Excel. After several months of development and testing, we now have this solution ready: Google Analytics and AdWords data can now be fetched directly to an Excel spreadsheet… Read more »

New Google Analytics data available

On Tuesday, Google announced lots of new metrics and dimensions being available through the Analytics API. Most significantly:There are 10 new AdWords dimensions available, such as the ‘matched query’ dimension, which shows the actual search query typed by the visitor that triggered the impression of the AdWords ad. The ‘visitors’ metrics can now be split… Read more »

AutomateAnalytics In Twitter

Our products such as GA Data Grabber are being constantly improved. To make it easier for you to see when there’s something new, we will begin announcing these updates in Twitter. You can follow us at twitter.com/MTAnalytics AutomateAnalytics wishes you a happy Christmas!

Validating EU VAT numbers in Google Docs

I’ve recently struggled to learn the tax accounting procedures for intra-European Union trade. One part of this process is obtaining the VAT numbers of all the client companies in EU countries, which must then be verified before sending the forms to the tax office. There’s a tool for doing this validation on the EU commission site,… Read more »

Demo version of GA Data Grabber for AdWords now available for download

Demo version of GA Data Grabber for AdWords now available for download

The free demo version of GA Data Grabber now supports AdWords queries in addition to Google Analytics ones. This means you can now see the kind of data and visualizations this tool will provides before buying. The limitation with the demo version is that it only fetches data for January-March 2010. You can download the… Read more »

Excel functions for the Marchex API

We have developed a new solution for fetching pay-per-call advertising data from the Marchex API to Excel with a set of VBA functions. This provides a great deal of flexibility for pay-per-call campaign analysis, as you are no longer tied to the built-in Marchex reports. It’s also simple to combine the campaign metrics with data from other… Read more »

Fetch up to a million rows of GA data to Excel

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 data in… Read more »

Visualizing changes in popularity of site content

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 released back in… Read more »

AdWords API solution for Excel now available

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 automation tool for Googla Analytics, GA Data Grabber, you now have the option to… Read more »

AutomateAnalytics featured in the GA blog

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 Mihailovski of the GA API team – if he hadn’t shown… Read more »

Publish Excel data to the net via the Google Charts API

Publish Excel data to the net via the Google Charts API

I wrote a VBA function that creates a web chart of an Excel data range. With this, you can publish Excel data to the net instantaneously: just type the function, select the cells where the data is located, and you get the URL for the chart! The only required parameter is the data range, optionally… Read more »

GA Data Grabber – New version in 3D!

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 advantage of Excel’s charting capabilities, and lets you look at your data in… 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 course there’s some content not related… Read more »

Fetching tweets to Excel/Word/PPT/Google Docs

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 Twitter to Excel. There are lots of Twitter… Read more »

Google Analytics data to Google Docs

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 here. The functions for importing Google Analytics data to a… Read more »

GA Data Grabber – The most powerful tool for automating Google Analytics & AdWords reporting

GA Data Grabber – The most powerful tool for automating Google Analytics & AdWords reporting

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 do additional analysis and charting. GA Data Grabber is designed especially for people… Read more »

New version of the Google Analytics visualization tool

New version of the Google Analytics visualization tool

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 visualize Google Analytics data in many ways not possible through… Read more »

Tool for visualizing Google Analytics data in a new way

Tool for visualizing Google Analytics data in a new way

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 which fetches data from GA and creates charts out of that…. Read more »

Free Excel function for translating text with Google Translate

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 reliable than the old free solution. There’s a free trial so… Read more »

Magical self-updating Powerpoint (fetches data from Google Analytics)

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). Picture of wizard included.If you’re interested in getting a customized Powerpoint presentation… 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 fucntion you can fetch a list of the Analytics profiles to which the authenticated user has access rights. The only required input for the function is the… Read more »

Excel functions for fetching Google Analytics data

Excel functions for fetching Google Analytics data

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 Analytics blog describes. My approach is to use custom functions to achieve this, whereas the other… Read more »