How can i blend Search Ads 360 with Google Ads on Looker Studio

[shamayel]

Hi Guys, 

I have connected 2 data sources on Looker Studio. These are Search Ads 360 and Google Ads. I wanted to blend (add) the "click" metric from these two sources to get 1 final number.

I have a Scorecard widget for Clicks as seen in the image below. The 1st scorecard is for Google Ads, the 2nd scorecard underneath is for Search Ads 360 and the 3rd scorecard is for the blended value.

I have blended the 2 clicks together but the 3rd scorecard underneath isn't showing the additions. Its only picking up the 1st scorecard value of 1063. It needs to show 1,274 (1063 + 211).

I have tried all combinations of joins i.e. cross over - left outer, right outer etc., but nothing seems to work.

Any help would be greatly appreciated.

Thanks