ImportRange (Sheets) + JOIN + CASE

Sorry for the language errors, I'm using Translator.

I have some advanced questions about Looker Studio.

I need to understand if:
1. Do I need to combine two different databases with the same metrics in a spreadsheet with importRANGE? Or can I merge the two bases using JOIN + the CASE function to recognize the platforms according to the name of the campaigns? Ex: Meta ads = campaigns_metads
Google ads = campaign_goads

What I need is a graph like this:visual que preciso lookerstudio.png

 

0 0 33