Hi all,

Does the Distinct concept exist in GAQL when not segmenting by date or 
similar?

For instance, if we had an account that had 100,000 CALL AdGroup 
Extensions, we could run this query to get all the ad_group resource names 
but it performs slowly because it's examining each 
ad_group_extension_setting record:

SELECT ad_group_extension_setting.ad_group FROM ad_group_extension_setting 
WHERE ad_group_extension_setting.extension_type = 'CALL' ORDER BY 
ad_group_extension_setting.extension_type DESC

What I really want is:

SELECT distinct( ad_group_extension_setting.ad_group ) FROM 
ad_group_extension_setting WHERE ad_group_extension_setting.extension_type 
= 'CALL'

and I would want hat 2nd query to be very performant.

Is it possible to query for distinct resource_names?

Thanks
Pete

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/ec40af54-e222-49a5-af9a-2b637ffb94f3n%40googlegroups.com.

Reply via email to