Hi, I am looking to query report keyword_view, and retrieve all keywords that have one or more final_uls set. I wonder how to do that? According to the docs of ad_group_ad.ad.final_urls <https://developers.google.com/google-ads/api/fields/v13/ad_group_ad#ad_group_ad.ad.final_urls> this is a REPEATED STRING field, unfortunately the language grammar guide <https://developers.google.com/google-ads/api/docs/query/grammar> does not state which operators apply to them. (Actually the language grammar guide lacks documentation on field types and the conditions that may apply to them...)
When trying to add a condition on this field in the Google Ads Query Builder, three operators are offered: CONTAINS ALL, CONTAINS ANY, and CONTAINS NONE. But then I have to enter a value. What possible value could I enter? When I type NULL, Google Ads Query Builder takes that as a string value. And I can't leave the value empty... How does one get all keywords with one or more final_urls? The use case: Some accounts have 100,000s of keywords, and less than 0.1% of them have one or more final_urls - I am interested in these keywords, not the ones without final_urls. The workaround is to retrieve all of them and filter on the client side, but that wastes resources of both Google and us. And it's not just keyword_view, the same applies to audiences. I also need the opposite version, get all keywords without final_urls. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/8fe970a7-b339-4dba-be52-01307f871072n%40googlegroups.com.
