Connecting Multiple Google Ads Accounts under the Same Resource to Lookerstudio

[Cagdas_Kutlu]

Hello everyone,

There are about 20 accounts that we want to add to our dashboard under a Google Ads MCC in Lookerstudio. I want to connect these accounts from a single source at the same time. While this feature is available in the DV360 connector, I cannot do this in Google Ads. Are there any different methods you know about this?

Kind regards,

[ArkadyZagdan]

@Cagdas_Kutlu 
You can connect them with BigQuery and create a Query which will automatically query all accounts using wildcards and union data into one table.

For this you may find thhis tutorial useful:

https://cloud.google.com/bigquery/docs/querying-wildcard-tables

I hope it helps.
Arkady Zagdan

[Cagdas_Kutlu]

Hi Arkady,

First of all, thank you very much for your reply.

This method requires to create 20 BigQuery tables and union them together, right? There is no joining as an account? Do I understand correctly?

Thank you,

[ArkadyZagdan]

@Cagdas_Kutlu I believe they will be extracted as datasets. But pretty much yeah. After you push all data into a BQ you can then also add a GAds account id and shholw all together while allowing filtering by a single accounnt.