Adword Campaigns of all accounts in one list

Support
#1

Hi,

I have several accounts on google adwords and need to get a list of KPI to monitor them. My AWQL statement works perfectly for one account but getting all of them in one list is a struggle. Selecting the manager account won't bring any results (campaigns are only in the client's accounts) and selecting more than one account is not possible.

I tried it via VBA (running the statement for one account after another in the same columns) but I can't seem to get figured out how to wait for each query to end before starting the next one. Does anyone have an idea how to solve this?

Cheers

#2

Perhaps try the "Disable Async" method which makes it easier to identify when requests are completed:
https://seotoolsforexcel.com/working-with-vba/

If the request times are regular, what about inserting a delay via VBA?