Filter AdGroupAds by final URL with GAQL

[Akil]

Hello,

I'm trying to filter AdGroupAds to ads where the final URL does not contain a particular string. e.g. doesn't have www in the URL. I'm trying the following but it's not working:

SELECT ad_group_ad.ad.id, ad_group_ad.ad.final_urls

FROM ad_group_ad

WHERE ad_group_ad.ad.final_urls CONTAINS NONE ('www')

I was hoping for this query to return only ads with URLs like "https://custom.mysite.com" but it's returning ads with URLs like "https://www.mysite.com".

How can I get what I want using GAQL?

Thanks!

Akil

[Google Ads API Forum Advisor Prod]

Hi Akil,

Thank you for writing to us. With regards to your concern, it is not possible to filter a part of URL or a particular string from the URL field via Google Ads Query language. Please refer to this guide for more details on the query language. Let us know if you have any additional concerns.

Regards,
Nikisha Patel, Google Ads API Team

ref:_00D1U1174p._5001UOF8r7:ref

[Tadhg Deeney]

Hi team,

I am also trying to do something similar, is this still the case?

From reading the documentation, I gathered that final_urls are now filterable, however, my script doesn't appear to be filtering out responses based on urls.

I am using the v9 python client for Google Ads API

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

To investigate the issue further, could you please provide us with the complete logs (request and response with request-id) via the Reply privately to the author option?

Thanks,

Nirmita Patel Google Ads API Team

ref:_00D1U1174p._5001UOF8r7:ref