Re: How to filter on repeated fields in AWQL

Hi Zweitze, I hope you're safe and doing fine. We've checked again your use case and can confirm that this cannot be done using CONTAIN ANY or CONTAINS NONE via Google Ads API query report. I've submitted a feature request for this. For now, you may continue to follow our blog for updates and

Re: How to filter on repeated fields in AWQL

Thank you. Obviously my wish is about something that one cannot do in the UI. So, if you don't know a way to achieve my wish (a condition-operator for repeated fields with 1 or more values, and a condition-operator for repeated fields without any value) - well please submit a feature request.

Re: How to filter on repeated fields in AWQL

Hello, Thank you for your answer. I am not sure if it is still the case, but 10, 15 years ago the Terms and Conditions stated that the client should not execute more requests than strictly necessary. To comply with such stipulations, one has to do as much filtering as possible. Let's assume th

Re: How to filter on repeated fields in AWQL

Hello Zweitze, Thank you for returning to our team. Regarding your question, please note that the reason why we are asking for the Google Ads UI screenshot is because you mentioned that you want to retrieve all keywords that have one or more final_urls set. We are asking for the Google Ads UI

Re: How to filter on repeated fields in AWQL

Hello, Do I really have to provide a screenshot of the "Search keywords" UI? Of course not. Anyway, for example use 371-225-2729 and clear any filter that may be present. Notice that this particular account has 162,011 search keywords, including deleted keywords. Also notice that some of them h

How to filter on repeated fields in AWQL

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 this is a R