Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
EduardoOliveira
Partner - Contributor
Partner - Contributor

How to list all ad accounts linked to a google ads account using a GAQL query (Google Ads Connector)?

Hello, I would like to ask for your help. 

I am trying to bring data from a GAQL query, in order to list all ad accounts linked to my Google ads account. However, it is noted that to perform a GAQL query using the Google Ads API, it is necessary to inform an ad account id (example: customers/1234567890), which limits the search to a single account. In that case, how could this general listing be made?

*(I note that in the api interface itself, such functionality is presented in the accounts part, but limiting the choice to only 1 account as well).

 

The GAQL search query from that part would be this one correct, but how would this listing be done?

SELECT   

  customer_client.client_customer, 

  customer_client.id, 

  customer_client.level, 

  customer_client.manager, 

  customer_client.status, 

  customer_client.time_zone, 

  customer_client.descriptive_name 

FROM customer_client

 

Thank you for your attention!

Labels (1)
0 Replies