Re: Multiple Contains-Statements in Awql-Request

2018-02-08 Thread bastien rabaute 
Hi,

You can use contains with CampaignName. It works for me.

WHERE Cost > 0 AND CampaignName contains 'FR'

Bastien

Le vendredi 9 septembre 2016 09:52:00 UTC+2, ferry Ardhana a écrit :
>
> Hi,
>
> Today is 2 year after your answer, i just want to make sure does 
> CONTAINS_* operators only available for Labels field?
> I've try using CampaignName, but it seems not work
>
> Thanks
>
> On Wednesday, July 16, 2014 at 9:12:10 PM UTC+7, Danial Klimkin wrote:
>>
>> Hello,
>>
>>
>> CONTAINS_* operators apply to stringlists only, currently it's only 
>> Labels.
>>
>> There is "IN" operator though, you should be able to do "Id IN (123,456)" 
>> or "KeywordText IN ('foo', 'bar')".
>>
>>
>> -Danial, AdWords API Team.
>>
>>
>> On Wednesday, July 16, 2014 4:47:00 PM UTC+4, testmc...@unister.de wrote:
>>>
>>> Ok, how is the syntax for this? Seems that CONTAINS_ANY isnt in the 
>>> documentation.
>>>
>>> I have tried it over "AND KeywordText CONTAINS_ANY [string1, string2]" 
>>> and get following error-message:
>>>
>>> SelectorError.INVALID_PREDICATE_OPERATOR @ query; trigger:'KeywordText'
>>>
>>>
>>> Regards,
>>> Kai
>>>
>>> Am Mittwoch, 16. Juli 2014 13:57:18 UTC+2 schrieb Jason Stedman:

 AWQL doesn't support the OR keyword, but does have a CONTAINS_ANY 
 condition that according to the grammar should accept a STRINGLIST value.

 https://developers.google.com/adwords/api/docs/guides/awql



-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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 Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/86bc1a48-15fa-41b9-9400-75549fbcb860%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Multiple Contains-Statements in Awql-Request

2016-09-19 Thread 'Shwetha Vastrad (AdWords API Team)' via AdWords API Forum 
Hi,

Yes, the CONTAINS_* predicate operator is only available for Labels 
. You can use 
the IN operator as suggested in the previous post. Please keep an eye on 
our blog  for 
any updates. 

Regards,
Shwetha, AdWords API Team. 

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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 Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/b1bb0773-f5d3-4fc0-821f-c59028de605c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Multiple Contains-Statements in Awql-Request

2016-09-09 Thread ferry Ardhana 
Hi,

Today is 2 year after your answer, i just want to make sure does CONTAINS_* 
operators only available for Labels field?
I've try using CampaignName, but it seems not work

Thanks

On Wednesday, July 16, 2014 at 9:12:10 PM UTC+7, Danial Klimkin wrote:
>
> Hello,
>
>
> CONTAINS_* operators apply to stringlists only, currently it's only Labels.
>
> There is "IN" operator though, you should be able to do "Id IN (123,456)" 
> or "KeywordText IN ('foo', 'bar')".
>
>
> -Danial, AdWords API Team.
>
>
> On Wednesday, July 16, 2014 4:47:00 PM UTC+4, testmc...@unister.de wrote:
>>
>> Ok, how is the syntax for this? Seems that CONTAINS_ANY isnt in the 
>> documentation.
>>
>> I have tried it over "AND KeywordText CONTAINS_ANY [string1, string2]" 
>> and get following error-message:
>>
>> SelectorError.INVALID_PREDICATE_OPERATOR @ query; trigger:'KeywordText'
>>
>>
>> Regards,
>> Kai
>>
>> Am Mittwoch, 16. Juli 2014 13:57:18 UTC+2 schrieb Jason Stedman:
>>>
>>> AWQL doesn't support the OR keyword, but does have a CONTAINS_ANY 
>>> condition that according to the grammar should accept a STRINGLIST value.
>>>
>>> https://developers.google.com/adwords/api/docs/guides/awql
>>>
>>>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords 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 Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/3b1c7fb2-5025-4fad-86cd-5bb0a3b974a9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Multiple Contains-Statements in Awql-Request

2014-07-16 Thread Kai steudten 
Hello,

is it possible to have multiple contains-statements in one awql-request? 

In my case, i want to request all keywords from an account which contains 
several strings.
So there should be selected all keywords which contains for example 
string1 *or* string2.

Dont think that this is possible with awql or?


Regards,
Kai

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups AdWords 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 Forum group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Multiple Contains-Statements in Awql-Request

2014-07-16 Thread Jason Stedman 
AWQL doesn't support the OR keyword, but does have a CONTAINS_ANY condition 
that according to the grammar should accept a STRINGLIST value.

https://developers.google.com/adwords/api/docs/guides/awql

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups AdWords 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 Forum group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Multiple Contains-Statements in Awql-Request

2014-07-16 Thread testmcclevel1 
Ok, how is the syntax for this? Seems that CONTAINS_ANY isnt in the 
documentation.

I have tried it over AND KeywordText CONTAINS_ANY [string1, string2] and 
get following error-message:

SelectorError.INVALID_PREDICATE_OPERATOR @ query; trigger:'KeywordText'


Regards,
Kai

Am Mittwoch, 16. Juli 2014 13:57:18 UTC+2 schrieb Jason Stedman:

 AWQL doesn't support the OR keyword, but does have a CONTAINS_ANY 
 condition that according to the grammar should accept a STRINGLIST value.

 https://developers.google.com/adwords/api/docs/guides/awql



-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups AdWords 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 Forum group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: Multiple Contains-Statements in Awql-Request

2014-07-16 Thread Danial Klimkin 
Hello,


CONTAINS_* operators apply to stringlists only, currently it's only Labels.

There is IN operator though, you should be able to do Id IN (123,456) 
or KeywordText IN ('foo', 'bar').


-Danial, AdWords API Team.


On Wednesday, July 16, 2014 4:47:00 PM UTC+4, testmc...@unister.de wrote:

 Ok, how is the syntax for this? Seems that CONTAINS_ANY isnt in the 
 documentation.

 I have tried it over AND KeywordText CONTAINS_ANY [string1, string2] and 
 get following error-message:

 SelectorError.INVALID_PREDICATE_OPERATOR @ query; trigger:'KeywordText'


 Regards,
 Kai

 Am Mittwoch, 16. Juli 2014 13:57:18 UTC+2 schrieb Jason Stedman:

 AWQL doesn't support the OR keyword, but does have a CONTAINS_ANY 
 condition that according to the grammar should accept a STRINGLIST value.

 https://developers.google.com/adwords/api/docs/guides/awql



-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups AdWords 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 Forum group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.