Identify 'cancelled' accounts from customer_client

[Ian Campbell]

So,

I can get all client accounts my manager account can access and build an account hierarchy by querying customer_client

i.e. 
               SELECT
                    customer_client.id,
                    customer_client.currency_code,
                    customer_client.time_zone,
                    customer_client.descriptive_name,
                    customer_client.manager
                FROM
                    customer_client

But...I can't see a way to identify which of those accounts are 'CANCELLED' and therefore cannot be accessed via the api. Is there a way to do this?

or is there an other way of finding all the accounts my master account has access to that are not cancelled?

[Google Ads API Forum Advisor]

Hi Ian,

Thank you for reaching out to our API support team.

Unfortunately, it is currently not possible via the Google Ads API to identify which accounts are cancelled or inactive. A feature request was already previously raised for this to be supported. For now, you may keep an eye on our blog for updates and announcements.

That said, if any account returns an error due to being cancelled or inactive, you may try and filter them out using != or NOT IN operators, so they would be excluded in the results of your query. Also, you may opt to temporarily unlink them from your hierarchy and link them back once they have been identified for reactivation.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2W3dD8:ref