Re: Syntax for REGEXP_MATCH

[Google Ads API Forum Advisor Prod]

Hi Deborah,

You can use the Query Builder here to check if you queries are valid, including 
the LIKE and NOT LIKE operators.

Regards,
Anthony
Google Ads API Team
ref:_00D1U1174p._5001UHH7Hf:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/9yab90PYIDJ400f0fkWmwdR_SP6yhTuSZf5A%40sfdc.net.

Re: Syntax for REGEXP_MATCH

[Deborah Perez]

Hi,
I am also wondering if I can use the LIKE operator to filter by 
campaign.name to include the terms 'Brand' or 'Core' or 'Exact'. Not 
necessarily all three terms at once in the name. Is there such a thing as 
WHERE campaign.name LIKE '%Brand% or '%Core%' or '%Exact%'? This is why I 
was looking to use CONTAINS ANY or CONTAINS ALL or CONTAINS NONE with a 
list of terms.

Thank you for your help

On Wednesday, September 18, 2019 at 4:40:33 PM UTC-4, adsapiforumadvisor 
wrote:
>
> Hi Deborah,
>
> Can you please send me through *reply privately to author *the error 
> message you are getting? The only valid operators for Google Ads API are 
> the ones listed here 
>  and it 
> doesn't include REGEXP_MATCH or NOT REGEXP_MATCH.
>
> Regards,
> Anthony
> Google Ads API Team
>
> ref:_00D1U1174p._5001UHH7Hf:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/965f4aad-01ff-4dda-8ad3-cd885f181f53%40googlegroups.com.

RE: Syntax for REGEXP_MATCH

[Google Ads API Forum Advisor Prod]

Hi Deborah,

Can you please send me through reply privately to author the error message you 
are getting? The only valid operators for Google Ads API are the ones listed 
here and it doesn't include REGEXP_MATCH or NOT REGEXP_MATCH.

Regards,
Anthony
Google Ads API Team
ref:_00D1U1174p._5001UHH7Hf:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/GQggo0PY1O32003fOvH1ckToqlJd3t4JkZKA%40sfdc.net.

Syntax for REGEXP_MATCH

[Deborah Perez]

Hi I am using Python 3.7 and Google Ads API Beta v2.

In building a query, I attempted to use the operator CONTAINS ALL  with the 
WHERE clause for campaign.name. I received this error: "CONTAINS ALL is not 
a valid operator to use with 'campaign.name' in WHERE clause. Valid 
operators: =, !=, LIKE, NOT LIKE, IN, NOT IN, IS NULL, IS NOT NULL, 
REGEXP_MATCH, NOT REGEXP_MATCH."

The LIKE operator does not take a list and I will be using a list. It seems 
REGEXP_MATCH may be helpful but I can't find documentation on how to use 
REGEXP_MATCH. Can someone give me an example so that I can see the proper 
syntax?

Thank you for your help

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/f74f3453-3603-4d1d-8500-6fae23b8a80c%40googlegroups.com.