I want to get the enable customer ID that under my mmc account by GAQL

36 views
Skip to first unread message

Automated Analytics API

unread,
Aug 8, 2022, 7:07:17 AM8/8/22
to Google Ads API and AdWords API Forum
I'm very new to this  

I just copied this from example 

$query = 'SELECT customer_client.client_customer, customer_client.level,'
            . ' customer_client.manager, customer_client.descriptive_name,'
            . ' customer_client.currency_code, customer_client.time_zone,'
            . ' customer_client.id FROM customer_client WHERE customer_client.level <= 1';

But its get all customer ID I want only enable customer ID

Google Ads API Forum Advisor

unread,
Aug 8, 2022, 9:58:40 AM8/8/22
to aa...@automatedanalytics.co.uk, adwor...@googlegroups.com
Hi,

Thank you for raising this concern to our team. This is Carmela from the Google Ads API team.

Moving forward to your concern,  for you to get the customers with ENABLED status, you may try adding the customer.status = 'ENABLED' or customer_client.status = 'ENABLED' in the WHERE clause of the query.

Regards,
Google Logo
Carmela
Google Ads API Team
 


ref:_00D1U1174p._5004Q2dIOzx:ref

Automated Analytics API

unread,
Aug 10, 2022, 2:54:08 AM8/10/22
to ads...@forumsupport.google, adwor...@googlegroups.com
Thank you for your response. 
And other thing i would like to know if the customer id type is not manager account
> Automated Analytics confidentiality statement This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. The views and opinions included in this email belong to their author and do not necessarily mirror the views and opinions of the company. Our employees are obliged not to make any defamatory clauses, infringe, or authorize infringement of any legal right. Therefore, the company will not take any liability for such statements included in emails. In case of any damages or other liabilities arising, employees are fully responsible for the content of their emails. Automated Analytics Sidings Court 2A Doncaster DN4 5NU, UNITED KINGDOM, Tel: 01302 636 278

Google Ads API Forum Advisor

unread,
Aug 10, 2022, 9:03:32 AM8/10/22
to aa...@automatedanalytics.co.uk, adwor...@googlegroups.com

Hi,

Thank you for the reply. Allow me to assist you here. 

Regarding your concern, could you confirm what you meant by "And other thing i would like to know if the customer id type is not manager account"? Could you confirm if what you are talking about is, using the customer_client report, you want the accounts that will return if it is specified whether it is a manager account or not?

 

Best regards,

Google Logo
Anthony Cyril
Google Ads API Team
 


ref:_00D1U1174p._5004Q2dIOzx:ref
Reply all
Reply to author
Forward
0 new messages