Tag Query
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 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]
5 tips and formula to blend data in Google Spreadsheet
You have a spreadsheet full of data. It’s messy and you don’t really know how to merge and organize all this. In this blog post, I will give you a quick overview of the best tips and formula blend data in Google Spreadsheet. If you have read my article about using Supermetrics these tips and formulas will be definitively useful. I hope it will lead my readers to the path for more efficiency.