How to add 2 metrics from different data source in Looker Studio ?

How to add 2 metrics from different data source in Looker Studio ?

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 :

  1. Quick blend 2 data sources
  2. Modify the formula and type

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.

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 !

More function to use with Looker Studio

DATE_DIFF
:
Understanding and Utilizing DATE_DIFF Function in Looker Studio: Syntax, Examples, Limitations and Tips
UPPER
:
Using the UPPER Function in Looker Studio for Text Modification and Data Presentation
CAST
:
Transform you data with the CAST function in Looker Studio
CURRENT_DATETIME
:
Taking advantage of the CURRENT_DATETIME function in Looker Studio
DAY
:
Exploring the DAY Function in Looker Studio: Maximising Insights from Your Date Data

Become a Looker Studio expert
for free

Learn all the secrets of data analysis and create beautiful and effective dashboards thanks to our 30-second video courses! Join Catchr's community on YouTube.

Get more video lessons

All your data on Looker Studio

Build Looker Studio dashboard easily with your marketing data from all platforms and track your essential KPIs! No-code integration.

Start free trial now!
Looker studio

Optimize your data analysis

Get free Looker Studio dashboard template among a large collection of +50 stunning template! Elevate your data visualization.

Get free templates!
Florian Cabirol
CEO of Catchr
As a web development expert, I am actively enhancing and developing Catchr connectors to optimize the processing and analysis of your marketing data.