To add to the above. I *can* use the LIKE operator for exact match (result:
1 campaign row returned):
SELECT
campaign.name,
metrics.clicks
FROM campaign
WHERE campaign.name LIKE 'abc'
On Friday, 15 January 2021 at 10:05:21 UTC+1 Stijn van Lieshout wrote:
> I am fetching the google ads api (v6) in my python project.
>
> The following call returns the expected campaign:
>
> SELECT
> campaign.name,
> metrics.clicks
> FROM campaign
> WHERE campaign.name = 'abc'
>
> But when I try to use LIKE I get no results back (whereas I should get
> them back since the string "abc" contains "a"):
>
> SELECT
> campaign.name,
> metrics.clicks
> FROM campaign
> WHERE campaign.name LIKE 'a'
>
> I also tried CONTAINS and REGEXP_MATCH without success. Why can I filter
> by exact match (= operator) while all the others fail?
>
>
>
>
>
>
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 [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
---
You received this message because you are subscribed to the Google Groups
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/4920d941-4bdf-4fab-9eef-748283f95133n%40googlegroups.com.
