Getting all campaigns from client accounts accessible from a manager account

[Felipe Ferri]

Hello,

I have a manager account with a lot of accounts underneath.

I would like to obtain all campaigns with non-zero impressions accessible from this manager account. If I try to query the manager account with something like this:

SELECT

campaign.id,

campaign.name,

campaign.status,

customer.id,

customer.currency_code

FROM campaign

ORDER BY campaign.id

passing the manager's customer_id, I receive an empty list of campaigns. I found out that I have to individually call the above query for each client account underneath the manager account, passing the client id as customer_id and the manager id as login_customer_id.

This is not ideal; the manager account can have lots of client accounts (over 100), and many of these client accounts don't have active campaigns; having to query each one of these accounts will take a lot of time (and requests) and will be mostly redundant, as most client accounts won't necessarily have active campaigns. But I have to query all client accounts because I don't know when they might become active.

Is there a better way of querying *all* campaigns and their performance metrics from a given manager account without having to iterate over every client account?

Thank you

Felipe

[Google Ads API Forum Advisor]

Hi Felipe,

Thank you for reaching out to the Google Ads API team.

Moving forward, as per this documentation, kindly note that Manager accounts are Google Ads accounts that are used for administrative purposes and not for serving ads. They act as single points of access for the accounts they manage, so are used in setting up consolidated billing and other features across multiple accounts.

Having said that, you can use the Parallel report Download code sample. However, kindly note that using this, it still needs you to individually call the above query for each client account and the difference is, it iterates your client accounts.

Regards,

Carmela Google Ads API Team

ref:_00D1U1174p._5004Q2bCYgI:ref