Tag Consolidation
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.
Mistakes to avoid when blending data with Google Data Studio
The goal is this article is to highlight and explain some subtleties of Data Studio Data blending. I hope it will help my readers avoid and understand the most common pitfalls. Only rows with matching keys are returned. The first thing to known when blending data is that only rows with a key from the primary data source matching a key from the second data source are passed into the blended data.
How to merge data from various sources in Google Sheets.
Here is a simple guide on how to merge data from various sources in Google Sheets. Let’s say you have two data source, for example, Facebook Ads and Google Ads, and that you want to sum their Impressions, Clicks, Conversions, and Cost. Here is a simple illustration made with Google Data Studio of what you will be able to achieve by following this guide. [caption id=“attachment_1524” align=“aligncenter” width=“616”] Google Data Studio Dashboard with individual and merged data sets[/caption]