If you need more informations, you can follow the tutorial. You can also find a template for at the end of the page.
Looker Studio allows you to manipulate your data as you wish, you can explore and display in multiple ways !
One thing that can be frustrated is to add some metrics from different data sources, but there is a simple way to do it !
Follow these steps to add 2 metrics from different data source :
Quick blend 2 data sources
Modify the formula and type
How to add 2 metrics from different data source in Looker Studio ?
Quick blend 2 data sources
There is an easy way to blend 2 data sources : select 2 components from 2 different data sources and do a right-click then Blend Data.
Here is an example of the investment in Google Ads and Facebook Ads :
Once your blended data sources is created, you have a new component in your report. You need to modify the formula and type to get your sum.
{{cta-template-looker}}
Modify the Formula and Type
You can now select the new component that appears when you create the blended data source. As you can see, Looker Studio try to divide one metric by the other, but we can modify the formula so instead of having this :
SUM(Investment Google Ads) / SUM(Investment Facebook Ads)
We will do this :
SUM(Investment Google Ads) + SUM(Investment Facebook Ads)
And we will modify the type from Percent to Currency (Euro) :
And you are ready to go !
This tutorial in video :
Feel free to ask any question you have in the chat =)
Empower your Marketing data analysis
Discover +50 connectors to import your Marketing data into your favorite dashboard tool! Unlock instant data integration with Catchr's no-code feature – no IT team required!
.png)
.png)
