Hi Dannison, Thank you for your message, Could you please help with the query?
When i do something like this with my master MCC: 'SELECT customer_client.client_customer, customer.manager FROM customer_client' I get customer.manager = true for all accounts. So this particular query doesn't solve the issue. But i wonder if you meant to use customer.manager in some other way? Thanks, Alex On Friday, 5 April 2019 03:12:17 UTC+1, googleadsapi-forumadvisor wrote: > > Hi Alex, > > You could use a filter for the field customer.manager > <https://developers.google.com/google-ads/api/docs/fields/customer#customermanager> > > and set this to *FALSE* to return only client accounts in your query. Let > me know if this helps. > > Regards, > Dannison > Google Ads API Team > > > =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ > Also find us on our blog and discussion group: > https://ads-developers.googleblog.com/search/label/google_ads_api > https://developers.google.com/adwords/api/community/ > =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ > > Was your question answered? Please rate your experience with us by taking > a short survey. > If not -- reply to this email and tell us what else we can do to help. > > Take Survey > <https://support.google.com/google-ads/contact/survey_transactional?caseid=9-1026000026232&hl=en&ctx=1> > > Also find us on our blog and discussion group: > http://googleadsdeveloper.blogspot.com/search/label/adwords_api > https://developers.google.com/adwords/api/community/ > On 04/04/19 22:29:58 dju...@gmail.com <javascript:> wrote: > > Hello there, > Ive got a tree-like mcc structure, such as that mcc of multiple levels on > top of each other. > > What is the best way to get a list of non-mcc customer ids in order to be > able to query stats for them (it is not possible to query for mcc account)? > > > This code return all accounts under master mcc including mcc: > query = SELECT customer_client.client_customer FROM customer_client > response = ga_service.search(customer_id = MASTER_MCC, query = query) > > I wonder what is the best way to get non-mcc accounts on all levels? > > Thanks, > Alex > > -- > -- > =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ > Also find us on our blog: > https://googleadsdeveloper.blogspot.com/ > =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ > > You received this message because you are subscribed to the Google > Groups "AdWords API and Google Ads API Forum" group. > To post to this group, send email to adwords-api@googlegroups.com > To unsubscribe from this group, send email to > adwords-api+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/adwords-api?hl=en > --- > You received this message because you are subscribed to the Google Groups > "AdWords API and Google Ads API Forum" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to adwords-api+unsubscr...@googlegroups.com. > Visit this group at https://groups.google.com/group/adwords-api. > To view this discussion on the web visit > https://groups.google.com/d/msgid/adwords-api/b579b039-4785-404c-909e-251d5ae755a4%40googlegroups.com > > <https://groups.google.com/d/msgid/adwords-api/b579b039-4785-404c-909e-251d5ae755a4%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/5bf7c98f-114c-45b0-8b7a-9b78f3bfd51c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.