Supermetrics Blog

Historical Quality Score Analysis and Reporting: the Complete Guide

Historical Quality Score Analysis and Reporting: the Complete Guide

QUALITY SCORE REPORTING · 11-MINUTE READ · By Supermetrics on July 26 2017. Back in June, we introduced AdWords’ newly-released metrics Historical Quality Score in this post. Historical Quality Score is a very valuable metric for marketers – it reflects how relevant your ad is to the user-specific search query. Quality Score, together with other… Read more »

Building an Adwords and Facebook Ads Dashboard in Data Studio

Building an Adwords and Facebook Ads Dashboard in Data Studio

ADWORDS AND FB ADS DASHBOARD · 8-MINUTE READ · By David Krevitt on July 18 2017. In this post we walk through how to build a FB Ads + Adwords dashboard in Google Data Studio. If you’d like to skip straight to the template, you can make a copy here. No one disputes that Data… Read more »

Mobile Measurement: Understanding the True Value of Mobile

Mobile Measurement: Understanding the True Value of Mobile

MOBILE MEASUREMENT IN GOOGLE ANALYTICS & ADWORDS · 5-MINUTE READ · By Tina Arnoldi on July 10 2017. The number of mobile users has surpassed the number of desktop users and will only continue to rise. Many people start their consumer journey on a mobile device, but may visit the same website on a desktop… Read more »

Six Tips to Better Leverage Supermetrics and Google Analytics

Six Tips to Better Leverage Supermetrics and Google Analytics

SUPERMETRICS TIPS, GOOGLE ANALYTICS · 7-MINUTE READ · By Paul Koks on July 4, 2017 In the past I didn’t like building reports, but with reporting automation everything changed in a positive way. Five years ago I was still exporting a lot of data from Google Analytics. You probably know this export CSV functionality in… Read more »

Google Analytics Enhanced E-commerce: Making Data Driven Decisions

Google Analytics Enhanced E-commerce: Making Data Driven Decisions

ENHANCED ECOMMERCE · 8-MINUTE READ · By Tina Arnoldi on June 27 2017. Google Analytics helps marketers make data driven decisions to improve business. It organizes raw data into informational summaries that provides a snapshot of the business. The role of the marketer is to then analyze that data and apply it to improve website… Read more »

Google Attribution: What Does It Mean for Marketers

Google Attribution: What Does It Mean for Marketers

GOOGLE ATTRIBUTION · 7-MINUTE READ · By Misty Faucheux on June 19 2017. In May, Google announced that it was doing away with last-click attribution. In its place, Google will now be offering a new reporting product, known as Google Attribution. The goal of this new product is to provide more sophisticated insights into overall… Read more »

New in Supermetrics: Adobe Analytics Connector

New in Supermetrics: Adobe Analytics Connector

ADOBE ANALYTICS REPORTING · 6-MINUTE READ · By Supermetrics on June 15 2017. We get unreasonably pumped every time we release a new connector. Each one of them gets us one step closer to cover all the data sources our users want to connect. With that in mind, you can imagine how excited we are… Read more »

7 Easy Tips for Getting Ranked High on Google

7 Easy Tips for Getting Ranked High on Google

GOOGLE RANK · 7-MINUTE READ · By Chris Hickman on June 12 2017. Every business wants to get a high ranking on Google. High rankings mean high visibility. High visibility means clicks, conversions, and sales. The vast majority of clicks only go to sites that are on the first page. So, how do you do… Read more »

Google’s New Releases: Adwords Historical Quality Score and Unique Reach

Google’s New Releases: Adwords Historical Quality Score and Unique Reach

HISTORICAL QUALITY SCORE · 6-MINUTE READ · By Misty Faucheux on June 05 2017. Google is always striving to make metrics more relevant to marketers. Recently, they released two new metrics focusing on ad performance: Historical Quality Score and Unique Reach. What is Quality Score? WordStream defines Quality Score as “Google’s rating of the quality… Read more »

Improvements to the Supermetrics Database Connector

Improvements to the Supermetrics Database Connector

We have made some great additions to the Supermetrics Add-on’s Database connector: You can now pull data from PostgreSQL and Amazon Redshift databases, and we have fixed the problems with connecting to SQL Server. PostgreSQL database can be either on-premises or in the cloud. When choosing the database type you will see supported cloud providers,… Read more »

Facebook Insights Template for Data Studio

Facebook Insights Template for Data Studio

FACEBOOK INSIGHTS GOOGLE DATA STUDIO · 5-MINUTE READ · By Miguel Cedeno on May 29 2017. Facebook Insights Template for Data Studio Facebook Insights is a great tool – it allows you to understand the performance of your Facebook Page. Perhaps more importantly, it also uses diverse metrics to help you improve your overall Facebook… Read more »

6 Ways to Dramatically Improve Your Facebook Targeting Using Google Analytics

6 Ways to Dramatically Improve Your Facebook Targeting Using Google Analytics

FACEBOOK TARGETING WITH GOOGLE ANALYTICS · 10-MINUTE READ · By Jon Quinton on May 16 2017. Facebook offers an intimidating wealth of targeting options, putting new advertisers on a steep learning curve before they figure out what works for them. What if you could start that learning process with a head start, leading you to… Read more »

How to Copy Data Studio’s AdWords Template for Facebook, Bing and Twitter in 9 Minutes

How to Copy Data Studio’s AdWords Template for Facebook, Bing and Twitter in 9 Minutes

GOOGLE DATA STUDIO TEMPLATES · 10-MINUTE READ · By Supermetrics on May 8 2017. First things first. Let’s start with results. Here is the Adwords Overview template Google Data Studio offers. And these are the reports I copied for Facebook, Bing and Twitter. Facebook Ads https://datastudio.google.com/open/0BxGPgjQHCLwZOEloOGp2em5TRUU Data sheet here: https://docs.google.com/spreadsheets/d/19iGNmQGR14rWxKKZAFnBBnjkmQjbpXNpM52Jb1ufzxo/edit?usp=sharing Bing Ads https://datastudio.google.com/open/0BxGPgjQHCLwZQWlycnZqZHJaV28 Data sheet… Read more »

How To Use 6 Hidden Features in AdWords

How To Use 6 Hidden Features in AdWords

HIDDEN FEATURES IN ADWORDS · 8-MINUTE READ · By Tina Arnoldi on May 2 2017. Keyword bids, ad copy, quality scores, conversions and landing pages. These are all components of an AdWords campaign that advertisers are already familiar with. If you drill into your AdWords account, you will discover six hidden features that will enhance… Read more »

6 Tips to Go Beyond Google Analytics for Better Audience Insights

6 Tips to Go Beyond Google Analytics for Better Audience Insights

COMPLETE YOUR GOOGLE ANALYTICS DATA · 7-MINUTE READ · By Misty Faucheux on April 25 2017. Most of us rely on Google Analytics (GA) for many of our metrics – and for good reason. It’s free and easy to use, and most marketers care more about the statistics from Google over data from the other… Read more »

How to Make A Google Data Studio Dashboard for Adwords, Facebook, Twitter & Bing Data

How to Make A Google Data Studio Dashboard for Adwords, Facebook, Twitter & Bing Data

DATA STUDIO PAID CHANNEL MIX · 9-MINUTE READ · By Supermetrics on April 18 2017. How to Make A Google Data Studio Dashboard for Adwords,Facebook,Twitter & Bing Data In our last post, we showed how to make a Facebook Ads dashboard in Data Studio. We posted it on Supermetrics blog. After 4 hours it got… Read more »

Google Data Studio: Creating Reports With Calculated Metrics

Google Data Studio: Creating Reports With Calculated Metrics

GOOGLE DATA STUDIO REPORTS · 6-MINUTE READ · By Tina Arnoldi on April 11 2017. By now, we hope you have become familiar with Data Studio, still in Beta but available to anyone with a Google account. In an earlier post on our blog, you learned how to use Supermetrics for Google Sheets with Data… Read more »

Three Ways to Power Up Your Google Analytics Data

Three Ways to Power Up Your Google Analytics Data

POWER UP YOUR DATA · 6-MINUTE READ · By Tina Arnoldi on April 3 2017. Google Analytics is a powerful, free tool for measuring your marketing efforts. But it doesn’t deliver right out of the box. There are options for customization that you as a marketer need to be aware of so the data you… Read more »

DoubleClick Bid Manager and Adform Connectors Joining The Supermetrics Family

DoubleClick Bid Manager and Adform Connectors Joining The Supermetrics Family

NEW CONNECTORS · 6-MINUTE READ · By Supermetrics on March 29 2017. Supermetrics is happy to announce that not one but two new connectors have graduated from beta testing: DoubleClick Bid Manager and Adform. They’re all available to be selected from the data source list in our Google Sheets add-on’s sidebar. DoubleClick Bid Manager Connector… Read more »

Free Data Studio Template and Tutorial: Facebook Ads

Free Data Studio Template and Tutorial: Facebook Ads

GOOGLE DATA STUDIO TUTORIAL · 10-MINUTE READ · By Supermetrics on March 28 2017. Google Data Studio is a lovely reporting tool for PPC and SEO. There are some great ways to use Data Studio to create beautiful reports. What’s even better, Google just made it globally available and free for everyone. We believe Data… Read more »

Measuring the Performance of Your YouTube Campaign: Google Analytics and Adwords

Measuring the Performance of Your YouTube Campaign: Google Analytics and Adwords

ADWORDS AND GOOGLE ANALYTICS VIDEO METRICS · 10-MINUTE READ · By Tina Arnoldi on March 21 2017. If you already have business videos or the capability to create video content, YouTube can bring you a lot of traffic for very little money. But keep in mind this audience will be different than those coming from… Read more »

Every Click Counts: Compare Success Across Facebook Ads, Twitter Ads and Other Platforms

Every Click Counts: Compare Success Across Facebook Ads, Twitter Ads and Other Platforms

ADVERTISING ON SOCIAL PLATFORMS · 10-MINUTE READ · By Misty Faucheux on March 13 2017. To ensure that we are reaching our audiences any place where they might be consuming media, marketers run paid campaigns on many different platforms. While individually we can tell the success of the campaigns, oftentimes we need to provide comprehensive… Read more »

Use Case: Automating KPI Reporting with Leadfeeder

Use Case: Automating KPI Reporting with Leadfeeder

SUPERMETRICS USE CASE · 9-MINUTE READ · By Pekka Koskinen on March 7 2017. Running a SaaS startup is like flying an airplane in the dark. By looking out of the window and using your senses you get some feedback on what’s happening, but the real trustworthy information comes from your instruments. We need to… Read more »

10 Reasons Why Google Analytics is Not Increasing Your Bottom Line

10 Reasons Why Google Analytics is Not Increasing Your Bottom Line

GOOGLE ANALYTICS TIPS · 7-MINUTE READ · By Paul Koks on February 27, 2017 Google Analytics is a fantastic tool, but in my experience more than 80% of the companies actively using it, are not getting everything out of it. Or even worse, are not able to increase their bottom line. There are a lot… Read more »

5 Tips To Improve Your E-Commerce

5 Tips To Improve Your E-Commerce

E-COMMERCE · 9-MINUTE READ · By Misty Faucheux on February 20 2017. Marketing efforts are typically considered a success only if they drive leads and sales. While brand awareness is important, your stakeholders most often want to know that you’re converting your budget into profit. Yet, surprisingly many marketers don’t fully track everything related to… Read more »

Use Case: How to Avoid Google Analytics’ Sampling

Use Case: How to Avoid Google Analytics’ Sampling

SAMPLING · 9-MINUTE READ · By Ruben Ugarte on February 13 2017. If you’re heavy user of Google Analytics, then you know about the dreaded “sampling issue”. If you don’t, then let’s see how Google themselves describe sampling: “Sampling in Analytics is the practice of selecting a subset of data from your traffic and reporting… Read more »

Measuring the performance of your YouTube Campaign: Tips

Measuring the performance of your YouTube Campaign: Tips

YOUTUBE CAMPAIGN · 8-MINUTE READ · By Tina Arnoldi on February 7 2017.   With traditional print ads, you don’t know how many people are actually viewing them. Even with pay-per-click advertising, you can view impressions but that still does not mean the ad registered with someone. According to Google, TrueView ads are “built on… Read more »

Use Case: How Reprise takes advantage of Supermetrics

Use Case: How Reprise takes advantage of Supermetrics

USE CASE · 6-MINUTE READ ·  By Pablo Contreras on January 30 2017. In this blogpost Pablo from Graphene (the company which is currently a part of Reprise Media) will tell about how Supermetrics is used in their team and provide you with hints on what tasks could be accomplished with JSON/CSV connector. What is… Read more »

Property Sets: Determine Your Overall Property Success

Property Sets: Determine Your Overall Property Success

PROPERTY SETS · 6-MINUTE READ ·  By Misty Faucheux on January 23 2017. It’s been nearly a year since Google introduced property sets. When Google released property sets back in spring 2016, marketers rejoiced since they could now see total clicks and impressions of their different properties. Property sets let you consolidate different sites, apps… Read more »

New Year, New Connector: Custom JSON/CSV

New Year, New Connector: Custom JSON/CSV

NEW CONNECTOR · 4-MINUTE READ ·  By Supermetrics on January 18 2017. Many of you have requested us to add data sources, that we don’t yet support. And there there’s a big variety in them: from SEO and A/B testing tools to companies’ own CRM systems as well as public data. While our engineers are… Read more »

Use Case: Why Supermetrics Is valuable for Digital Uncut and their Clients

Use Case: Why Supermetrics Is valuable for Digital Uncut and their Clients

SUPERMETRICS USER CASE · 5-MINUTE READ · By Sam Martin-Ross on January 16 2017. Over at Digital Uncut we use Supermetrics to streamline our internal processes, this frees up time to focus on more important and interesting aspects of our clients’ accounts.This means we can provide a level of service, account management and analysis beyond… Read more »

Analyze Your User ‘s Behavior In Depth: Cohort Analysis

Analyze Your User ‘s Behavior In Depth: Cohort Analysis

COHORT ANALYSIS • 6 – MINUTE READ • by Sumi Goonetilleke on January 2 2017 Do users really engage with your content? Use the right tool to find out! You often publish articles, run a campaign or post news worthy blog posts but you don’t really know how your readers engaged with the article or… Read more »

Five Analytics Tools Every Digital Marketer Should Use

Five Analytics Tools Every Digital Marketer Should Use

ANALYTICS TOOLS · 6-MINUTE READ · By Paul Koks on December 19, 2016 As a digital marketer you should not limit yourself to one or two analytics tools. Your understanding of your visitors and customers will start to explode once you combine the insights of multiple tools. A great marketer or analyst understands the value… Read more »

Monitoring AdWords’ Campaigns: 7 Tips To avoid Under- and Overspending

Monitoring AdWords’ Campaigns: 7 Tips To avoid Under- and Overspending

ADWORDS’ CAMPAIGN MONITORING · 6-MINUTE READ · By Tina Arnoldi on December 12 2016. With bid strategies and automated rules (in Google AdWords), you do not have to manually monitor every account every day. These are valuable tools for marketers who have multiple paid accounts. Setting some basic rules is a big time saver. However,… Read more »

Successful Holiday Campaigns: The Most Important Metrics To Analyze

Successful Holiday Campaigns: The Most Important Metrics To Analyze

HOLIDAY CAMPAIGNS’ METRICS · 6-MINUTE READ · By Misty Faucheux on December 5 2016. The holidays are here, and nearly every company is ramping up their marketing efforts to try and gain new customers – or encourage current customers to purchase again. With so much competition and higher CPCs and CPAs, marketers must use every… Read more »

Why Your Conversion Rate is Wrong and How to Fix it

Why Your Conversion Rate is Wrong and How to Fix it

CONVERSION RATE · 6-MINUTE READ · By Paul Koks on November 28 2016 The conversion rate is one of the most common metrics that companies rely on when they optimize their business. But how do you actually measure it; can you trust your numbers? We all have our own set of favorite metrics that we… Read more »

New Bing Ads: Campaign Creation Workflow and Expanded Text Ads

New Bing Ads: Campaign Creation Workflow and Expanded Text Ads

BING ADS NEW USER INTERFACE · 5-MINUTE READ · By Misty Faucheux on November 21 2016. Bing Ads has taken steps to better compete against AdWords and similar platforms. Microsoft has released a new version of the campaign creation workflow. The goal of this update is to make it easier for marketers to create effective… Read more »

How to Discover a Ton of Insights in Three Simple Google Analytics Segments

How to Discover a Ton of Insights in Three Simple Google Analytics Segments

GOOGLE ANALYTICS SEGMENTS · 6-MINUTE READ · By Paul Koks on November 14 2016 The truth lies far beneath the surface. What I mean here is that you really have to dig deep in your data to find the golden nuggets. I always get a bad feeling when people talk about average bounce rate or average… Read more »

How to Build An Insightful PPC Report in 5 Simple Steps

How to Build An Insightful PPC Report in 5 Simple Steps

PPC REPORTS· 4-MINUTE READ · By Misty Faucheux on November 9 2016.   Your PPC reports display the effectiveness of your campaigns to internal and external clients, and stakeholders. Yet, most marketers still don’t know what they should include in their reports, fearing providing either too much or too little information. So, what elements make… Read more »

Must-Have Metrics for Every PPC Report: Looking Beyond CPC & CTR

Must-Have Metrics for Every PPC Report: Looking Beyond CPC & CTR

PPC METRICS· 4-MINUTE READ ·  By Misty Faucheux on October 31 2016.     PPC metrics demonstrate the effectiveness of your campaigns. The wrong metrics, however, could be sending the wrong message to your stakeholders and clients. You need to showcase the right stats to illustrate how well your PPC campaigns are actually performing. Yet, many of… Read more »

How iProspect Leverages Supermetrics Solutions for its Clients’ Benefits

How iProspect Leverages Supermetrics Solutions for its Clients’ Benefits

SUPERMETRICS USER CASE· 3-MINUTE READ ·  By Axel Queffeulou on October 24 2016. As a leader in digital marketing, iProspect has a large and diversified client portfolio. When faced with such a large number of clients and projects, agencies must constantly find new ways to make their processes more efficient, regardless of the type of… Read more »

4 Brilliant TED Talks That Will Make You a Better Data Analyst

4 Brilliant TED Talks That Will Make You a Better Data Analyst

DATA ANALYSIS · 6-MINUTE READ · By Oscar Santolalla on October 17 2016   Think of your favorite artist. Think of an inventor you admire. For them, new ideas are essential, like their everyday’s meal. Without new ideas, they could not create anything great.   In their process to create things, they must solve numerous… Read more »

Five Custom Filter Types Every Business Owner Should Set Up

Five Custom Filter Types Every Business Owner Should Set Up

CUSTOM FILTER · 6-MINUTE READ · By Paul Koks on October 10 2016    Google Analytics collects data at the property level, but you have the powerful option to create separate reporting views. Most often the difference between what data is being collected in each view is made through setting up a set of filters…. Read more »

How to Explain Data Discrepancies Between Facebook and Google Analytics

How to Explain Data Discrepancies Between Facebook and Google Analytics

FACEBOOK  & GOOGLE ANALYTICS · 10-MINUTE READ · By  Kayla Eide-Hall on October 3 2016   Are you struggling to reconcile Facebook analytics data with third-party data from Google Analytics? Not sure how to present both sets of data to your client? Wondering how to explain the discrepancies?   You’re in luck. Whether you’re trying to… Read more »

How to DIY PPC Budget Pacing Report in 10 Minutes (by Lunametrics)

How to DIY PPC Budget Pacing Report in 10 Minutes (by Lunametrics)

BUDGET PACING · 3-MINUTE READ · By Andrew Garberson on September 27 2016   Saying goodbye to expensive advertising reporting tools was easy. No more sales calls. No more closed code report limitations. Way more budget for other fun tools. But I really missed the budget pacing calculator. Budget pacing calculators help digital advertisers meet ad spend… Read more »

How to Measure Conversion After The Retirement of Converted Clicks

How to Measure Conversion After The Retirement of Converted Clicks

ADWORDS’ RETIRING CONVERTED CLICKS · 8-MINUTE READ ·  By Misty Faucheux on September 23 2016    If you’ve been in AdWords lately, you’ve seen the notification that Google is retiring Converted Clicks. In fact, it will no longer support the metric starting on September 21st. Google is forcing all marketers to use what it considers the more comprehensive… Read more »

Advanced Reporting Template for Client Budget Tracking (It’s Free!)

Advanced Reporting Template for Client Budget Tracking (It’s Free!)

PPC BUDGET TRACKING & PACING · 3-MINUTE READ ·  By Stephen Dawson on September 19 2016    Your clients spend should be a key consideration when it comes to PPC management. Without a budget order, you don’t have the ability to place monthly caps on spend in AdWords. If it’s important to them, the line ‘Why are… Read more »

A Step-by-Step Guide to PPC Account Structure: Campaign or Ad Group

A Step-by-Step Guide to PPC Account Structure: Campaign or Ad Group

  PPC ACCOUNT STRUCTURE · 6-MINUTE READ · By Lindsay Shugerman on September 12 2016  You need to add a new group of words to your Pay Per Click account. But should they become the newest Ad Group or do you need to create a whole new campaign? And the answer is…(drum roll, please!), it depends. Not what… Read more »

New AdWords Features Every Marketer Should Know

New AdWords Features Every Marketer Should Know

RESPONSIVE DISPLAY ADS & PRICE EXTENTIONS · 5-MINUTE READ · By Tina Arnoldi on September 7 2016  Responsive Display Ads and Price Extensions are two new AdWords features that can result in more dynamic ads.  Visually appealing ads along with more room for your messaging will result in a better ROI.  If you are unfamiliar with… Read more »

How to Make An Insightful AdWords Lead Campaign Report

How to Make An Insightful AdWords Lead Campaign Report

ADWORDS REPORTING TEMPLATE · 6-MINUTE READ · By Ana Kostic on August 30 2016. As a PPC campaign manager, I must choose the right amount of data to report and then present it in a visually helpful form. It’s hard to find the balance between the amount of data I need as the account manager… Read more »

How to Effectively Use Naming Conventions in Google Analytics

How to Effectively Use Naming Conventions in Google Analytics

GOOGLE ANALYTICS NAMING CONVENTIONS · 9-MINUTE READ · By Paul Koks on August 22 2016  Naming conventions can make the difference between collecting easy to understand data and data that is very hard to use. Not only web analysts, but also digital marketers need to understand how the different sections in Google Analytics are structured…. Read more »

Why every SEO analyst should use Google Search Console

Why every SEO analyst should use Google Search Console

Google Search Console · 4-MINUTE READ · By Tina Arnoldi on August 16 2016 · Webmaster Tools naturally sounds like it’s for the web developer on your team, not you as a marketer or SEO analyst. When it was renamed to Google Search Console in 2015, it became clearer that the tool was not just for web… Read more »

How to Make the Most of Google AdWords’ Expanded Text Ads

How to Make the Most of Google AdWords’ Expanded Text Ads

Google Adwords Expanded Text Ads · 6-MINUTE READ · By Misty Faucheux on August 8 2016 · Leveraging the Potential Power of Double Headlines and Longer Descriptions. After months of  announcement, Google has finally released the Expanded Text Ads (ETA) for AdWords campaigns, and now marketers have more room to advertise their goods and services. You, however, need to… Read more »

10-point checklist for a Perfect Google Analytics Setup

10-point checklist for a Perfect Google Analytics Setup

GOOGLE ANALYTICS SETUP · 11-MINUTE READ · By Paul Koks on August 03 2016  In the last 10 years I have audited dozens, or probably even hundreds of Google Analytics accounts. Most setups are far from collecting meaningful and reliable data. This post will equip you with tools and tips to improve your setup in… Read more »

How to Build a Bot with Supermetrics and Google Sheets

How to Build a Bot with Supermetrics and Google Sheets

PPC/SEO SLACK BOT  · 8-MINUTE READ · By  Matthew Guay on July 28 2016   Ever wished you could pull up your spreadsheet data right inside your favorite chat app? Perhaps you’re discussing this month’s sales with your boss, or are trying to remember what a recently popular Tweet said during a team chat. Supermetrics… Read more »

3 Common Mistakes In Presenting Your PPC/SEO Data (And How To Fix Them)

3 Common Mistakes In Presenting Your PPC/SEO Data (And How To Fix Them)

  You’re very proud of the insights you just obtained from your PPC/SEO work, and you can’t wait to show them to your stakeholders or customers on your coming presentation.   Will you just copy and paste your data graphs on your slides or will you take the extra time to create tailor-made charts and… Read more »

AdWords Conversion Tracking: 7 Major Factors That Impact Performance

AdWords Conversion Tracking: 7 Major Factors That Impact Performance

  As marketers we all rely on some form of AdWords conversion tracking to optimize campaign performance.  We get our heads stuck in data for hours trying to make the best possible decision. We argue over low-performing keywords with clients and colleagues.  In the end our decisions are based on conversion data that is reported… Read more »

How to Jumpstart Your Reporting with Supermetrics Template Gallery

How to Jumpstart Your Reporting with Supermetrics Template Gallery

We’re really lucky to have such great reporting templates from places like Google Analytics Solutions Gallery to help our own reporting and analysis of digital marketing initiatives. This got us thinking … What if you could have the same easy and useful templates for your reports with Supermetrics as well? So our team worked very… Read more »

How to Quickly Improve Your Google Analytics Skills

How to Quickly Improve Your Google Analytics Skills

IMPROVE GOOGLE ANALYTICS SKILLS · 9-MINUTE READ · By Paul Koks on June 30 2016   What steps do you take to master Google Analytics? Relying on one strategy is not your best choice. Take a structured, well-balanced approach to boost your Google Analytics skills. Google Analytics is a tool that is used by the majority of… Read more »

Supermetrics now connects with Twitter Ads (And How to Get It Running With 5 Clicks)

Supermetrics now connects with Twitter Ads (And How to Get It Running With 5 Clicks)

Today, we’re happy to announce Supermetrics is now fully integrated with Twitter Ads. Another step that lets you gain a more comprehensive view on your mix of paid marketing channels. With this new connector, you can easily import Twitter Ads data into Google Sheets and Excel to analyze your cross-channel campaign performance data, in conjunction with Adwords, Facebook Ads and… Read more »

10 Ways to Segment Google Analytics Data for Greater Insights

10 Ways to Segment Google Analytics Data for Greater Insights

Segment Google Analytics · 9-MINUTE READ · By Paul Koks on May 31 2016 One of the keys in finding actionable insights, is to segment your data and visitors. Raw data without context doesn’t tell much. But wait a second… Before even thinking about analyzing your Google Analytics data, you should always define a business question… Read more »

Google Data Studio 360: How to get Facebook, Bing & Twitter data in 3 minutes

Google Data Studio 360: How to get Facebook, Bing & Twitter data in 3 minutes

Think Google Data Studio 360 only supports Google Analytics and AdWords? Think twice! Google recently released a really cool dashboarding tool called Google Data Studio, which lets you easily gather all of your marketing data into one place and build great-looking, interactive dashboards (see for example this web analytics dashboard). It’s a major step forward… Read more »

How I Save My PPC Reporting Time By 70%

How I Save My PPC Reporting Time By 70%

PPC REPORTING· 9-MINUTE READ · By Ana Kostic on May 20 2016   Reporting is a huge time sink for PPC managers. We all try to optimize it and make it as painless as possible. The main problem is despite actual report and data visualization are the key points in our everyday job, report building… Read more »

10 Reasons Why Digital Marketers Should Love Report Automation

10 Reasons Why Digital Marketers Should Love Report Automation

REPORT AUTOMATION · 7-MINUTE READ · By Paul Koks on April 25 2016   Do you spend hours of your time creating reports each and every month? Or do you automate every single piece of it? A lot of companies still spend too much time manually creating and updating reports. Report automation is key in a digital world… Read more »

Get more than 90 days of Google Search Console data

Get more than 90 days of Google Search Console data

Google Search Console has an annoying limitation of only providing data for the last 90 days. While there’s no way to get around that limitation, we’ve just added a new feature to our system that makes it super simple to get longer time series by automatically stitching together results fetched at different times. With our… Read more »

New Super Pro version with DoubleClick and hourly triggers released

New Super Pro version with DoubleClick and hourly triggers released

There’s now a new, powerful Super Pro version available for our Google Drive add-on. The new version is targeted to digital marketing agencies and other companies with a major focus on online marketing. While most features will continue to require just the old Pro version, some new features will be only available for Super Pro users…. Read more »

Yahoo Gemini added to Supermetrics

Yahoo Gemini added to Supermetrics

Reporting in spreadsheets The latest addition to our ever-expanding data source list is Yahoo Gemini. This means you can now do reporting on all your search marketing campaigns on Yahoo Gemini as well as on Google AdWords and Bing Ads, and also include your social media campaigns from Facebook (and soon Twitter). Yahoo Gemini is… Read more »

Pricing changes for our Google Drive add-on

Today we’re announcing a new pricing structure for our Google Drive add-on. First some background. When Google was planning to launch add-ons for Google Drive, they selected us among just a few dozen of companies for early access to add-on development. When add-ons were released in March 2014, we published Supermetrics for Google Drive. It has been a… Read more »

MailChimp connector added to Supermetrics

MailChimp connector added to Supermetrics

We’re constantly expanding the data sources available in our tools. Our newest addition is MailChimp, which has been one the most requested APIs among our users. With the MailChimp connector, you can easily fetch email marketing metrics such as email delivery rates, open rates and click rates into Google Sheets and Excel. You’re no longer… Read more »

AdWords TrueView video reporting now available in Supermetrics tools

Google’s latest update to the AdWords API provides access to YouTube TrueView video campaigns, and we’ve now updated all our reporting tools to support it. This means TrueView campaign data is now automatically included in all your campaign reporting, and you can also fetch video-specific metrics including: Video impressions Video views & view percentage Percentage… Read more »

Supermetrics now connects to Google Search Console (formerly Webmaster Tools)

Supermetrics now connects to Google Search Console (formerly Webmaster Tools)

We’re happy to announce our new connector for Google Search Console, after having to remove our old Webmaster Tools connector due to Google changes last spring. The new connector lets you fetch your sites’ organic search data, and it’s even better than the old one, as you can more freely combine dimensions. You can now… Read more »

We’ve added Google BigQuery

We’ve added Google BigQuery

  Our Google Drive add-on now connects to BigQuery, Google’s tool for analyzing large datasets. This is especially useful for Google Analytics Premium users, who can export their raw GA session data into BigQuery, can now easily analyze it using the Supermetrics in Google Sheets. This allows for much more complex analysis than using the Google Analytics API…. Read more »

Getting an Excellent Analytics login error?

Getting an Excellent Analytics login error?

If you are having problems logging in to Excellent Analytics (invalid username / password), that’s because Google has just shut down the ClientLogin authentication method that EA uses. This means the free Excellent Analytics Excel plugin will now longer work, and the same goes for several other old Google Analytics API tools, such as the… Read more »

Supermetrics Uploader featured on the Google Analytics Blog

We’re very happy to see one of our products, Supermetrics Uploader, featured on the official Google Analytics Blog: Bringing more of your cost data into Google Analytics.  Even though less well-known than our other products, Supermetrics Uploader is extremely useful to anyone doing online marketing, as it let’s you get all your marketing data into Google… Read more »

Removing spam referral traffic from Google Analytics data

Removing spam referral traffic from Google Analytics data

Fake referral traffic from sites such as semalt.com has been increasing lately, which causes serious and growing data quality problems with Google Analytics. One way to combat the issue is using view filters in Google Analytics (see instructions of applying those manually or automatically via the API). While it’s recommended to do this, there are… Read more »

SEMrush & Moz data to Google Sheets

SEMrush & Moz data to Google Sheets

         One of the most common use cases of our reporting tools is search engine marketing and optimization. To make our products even better for this kind of analysis, we’ve now added a SEMrush connector to Supermetrics for Google Drive. With this new integration, you can fetch super-useful data such as: Domains: search… Read more »

Excellent Analytics and the old GetGAData function will stop working on April 20

When the Google Analytics API was published in 2009, the first solution to get GA data into Excel that was releasesd was Excellent Analytics. Soon thereafter, Supermetrics founder Mikael Thuneberg released a set of VBA functions that also retrieved GA data into Excel: getGAdata, getGAauthenticationToken, getGAprofiles and getGAaccountData. Google detailed these in a blog article… Read more »

See your Facebook Ads cost & ROI in Google Analytics reports

See your Facebook Ads cost & ROI in Google Analytics reports

Supermetrics Uploader is a must-have product for online marketers that love to use Google Analytics reporting: it lets you see your advertising cost in GA reports, so you have the cost and results in the same place. Up to now, Supermetrics Uploader has offered automatic daily transfers from Bing Ads into GA, and the option… Read more »

Supermetrics partners with BBC Worldwide to deliver YouTube Content Owner reporting

Supermetrics partners with BBC Worldwide to deliver YouTube Content Owner reporting

Today we’re announcing a major improvement in our YouTube reporting capabilities: our tools now include support for YouTube Content Owner (CMS) accounts. This makes it simple for YouTube partners to run reporting on all of their channels and videos, including both content uploaded by the Content Owners themselves and claimed content uploaded by 3rd parties…. Read more »

Facebook Ads now available in our tools

Facebook Ads now available in our tools

Facebook Ads has been the top choice for the most needed new data source in all the user surveys we’ve done during the last few years. Facebook restricts access to ads data so it’s taken a while to add it, but we’re happy to announce they have now granted us access, and we have integrated… Read more »

Stripe payments data into Excel & Google Sheets

Stripe payments data into Excel & Google Sheets

We recently added Stripe as a payment option on our site and were so happy with their well-designed API that we decided to add Stripe also as a data source to our reporting tools. To our knowledge, there are no other spreadsheet add-ons currently connecting with Stripe, so our integration should be quite handy for… Read more »

We’ve added scheduled refreshing & emailing to Supermetrics for Google Docs

We’ve added scheduled refreshing & emailing to Supermetrics for Google Docs

With Supermetrics for Google Docs, you can build online dashboards combining data from social media, web analytics and online marketing platforms. Unlike other online dashboarding tools in the market, the data processing happens inside Google spreadsheets, so you have complete control over everything: you can fetch exactly the data you want and add your own… Read more »

New visualization options in our Google Sheets add-on

New visualization options in our Google Sheets add-on

We’ve added a nice new visualization option to Supermetrics for Google Sheets: it can now colour code your results so it’s easier to spot the largest and smallest values. To use the feature, simply go to the Options tab and select a colour format from the “Higlight values with colours” dropdown menu.   When you… Read more »

Easily duplicate your Google Sheets dashboards for multiple accounts

Easily duplicate your Google Sheets dashboards for multiple accounts

We’ve added a great new feature to Supermetrics for Google Docs: there’s now an easy interface for duplicating the spreadsheets you’ve built for many accounts. Just select “Duplicate file for another account” from the Add-ons menu or from the Supermetrics sidebar, and follow the instructions displayed. The tool will ask you to pick a new… Read more »

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… 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 »