Category Supermetrics
4 reasons why you want to use Supermetrics for Google Sheets in 2019
I’ve been using Supermetrics regularly for over four years. I installed it for the first time in July 2015, when I started my first job as a data analyst. My first task was to create a report with Google Analytics and Facebook data. I had the template to fill manually, but I didn’t see myself spending days copying and pasting data from various interfaces. I was lucky enough to have some previous experiences working with twitter API, so I look for a way to automate all this, and then I find Supermetrics.
How to consolidate Google Analytics properties with Supermetrics for Google Sheets
There are many available options to consolidate Google Analytics properties. Here is a recipe using Supermetrics for Google Sheets and a Google Sheets formula. In this guide, I will extract data from various Google Analytics property in separate sheets using Supermetrics and consolidate them into a master sheet using a Google Spreadsheet formula. Before starting you will need to have Supermetrics installed and being familiar with it. If not, you can read my beginner’s guide.
How to pull Google Analytics data to Google Sheets with Supermetrics
This article is a simple guide on how to pull Google Analytics data into Google Sheets using Supermetrics for Google Sheets. Firstly I will detail how to create a simple query step-by-step. Secondly, I will share a few query examples. Finally, I’ll give some tips to help you use Google Analytics correctly when extracting data. I will consider that you have Supermetrics already installed and you’ve already created your first Supermetrics Queries.
How to start with Supermetrics : the complete beginner's guide
What is Supermetrics? Supermetrics is a reporting automation tool. It can pull data from a lot of sources (Facebook, Twitter, Google Ads, Google Analytics, etc…) and imports them into a Spreadsheet, a data visualization tool like Google Data Studio and a database like BigQuery. Once you have all your data imported, you can easily visualize them and/or perform specific calculations. The importation can be fully automated. This article is mostly about Supermetrics for Google Sheets.