Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 API)

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 (2)
1 Reply
DaveChannon
Employee
Employee

Hi @EduardoOliveira if you haven't already, you should consider posting this to the data and connectivity forum for more 👀https://community.qlik.com/t5/Connectivity-Data-Prep/bd-p/qlik-sense-data-connectivity