assuming mysql, I would go with "SELECT count(*) as count from CustomerApiUser group by customer_id"
That assumes the customer_id column is within the CustomApiUser group. On Tuesday, January 22, 2013 8:35:30 PM UTC-5, Sittichai Jiampojamarn wrote: > > Hi, > > I'd like to find all customer ids (CIDs) who use AdWords API managing > their campaigns. I was wondering if we can find that information from > either from F1 ads database, sstable, bigtable, etc. I was trying to dig a > bit in F1. One table name looks like it is > F1:CustomerApiUser but then it contains only 37k customers -- > > select count(distinct(info.customer_id)) from CustomerApiUser > > does it sound right? > > Any pointer would be appreciated. > > Thank you, > Sittichai > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
