Blog

A beginner’s guide to Google Data Studio blending

As compared to tools like Tableau or Looker, Google Data Studio is pretty simple. However, for a lot of users, it will be their first confrontation with data manipulations like case formula or data blending. In this article, I’ll explain in detail how to blend data sources. It can be pretty intimidating, but don’t worry;…

Read More...

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...