Merge 2 dimensions from 2 Google ads sources

[LauraCAB]

Hello,

I want to create a blended data to merge all Google Ads MCC account's.

But this create severals columns for the campaign names, can we create only one field that merge all campaign names of all account ?

Thank you

[ArkadyZagdan]

@LauraCAB 
It is definitely doable by exporting accounts data into BigQuery and wrangling a Query to automatically union all tables for all Clients Accounts.
From Looker Studio point of view I dont think so, unfortunately.

Regards
Arkady Zagdan
Bigglo.pl

[Mehdi_Oudjida]

Hey @LauraCAB 

You can mimic UNION ALL operator using the trick described in this article.

https://how.withlookerstudio.com/data-sources/20220222-how-to-mimic-union-all-operator-with-google-d...

I hope it helps.

Feel free to tell me if you need more info, otherwise you can accept this answer as a solution. 

Mehdi 

[ArkadyZagdan]

@Mehdi_Oudjida 
Original work-around but not scaleable.
What if we have more than 5 accounts? 

[Mehdi_Oudjida]

Right @ArkadyZagdan . You have to do it outside of Looker Studio if you need to merge more than 5 accounts. Now, read the question of Laura 🙂

[ArkadyZagdan]

You are correct @Mehdi_Oudjida  - your solution will work in this particular case. I just always look for a scalable solution  for everyone to use not only an original poster. Doing similar analysis for multiple accounts are often a case with marketing agencies hence I would rather point to a scalable and bulletproof solution with data BQDTS and simple query. Not to mention it drastically improve our LS report ferformance and overall report capabilities 🙂