Blog

How to transfer google data studio ownership

Transferring Google Data Studio ownership is not as straightforward as it should. Firstly it is essential to understand that transferring ownership of a report is not the same as transferring ownership of a Data source. If you want to own a dashboard fully, you will need to own the report but also the Data Source….

Read More...

How to share Google Data Studio Reports and Data Sources

A lot of people are confused about sharing and managing access with Google Data Studio. I think that most of the confusion comes from the fact that you can share and manage access at Reports level or Data sources level. Understanding this distinction is crucial. It will help you bring much more granularity in the…

Read More...

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…

Read More...

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…

Read More...

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…

Read More...