Blending Two Scorecards

Sometimes you might need to multiply,add, or divide the numbers in 2 scorecard and create new one. When data sources of those scorecards are different, things can get little bit challenging. But there is way and let me quickly explain it.

Lets say sessions are coming from GA4 source and transactions are coming from Google Ads. In this case, we are trying to calculate conversion rate by dividing transactions to sessions. To do that, click one scorecard and then press Ctrl, whilst holding press, click the other scorecard too. Now you selected both. Then right click, select “Blend data”.

Looker will automatically create 3rd scorecard. Edit the calculated field section. Adjust everything as it is seen below.

Now, Conversion rate card is avaliable correctly.

To sum up, this article was about blending data sources in Looker Studio. I hope this will be helpful in your tasks.