Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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?

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