Hi,
It's not terribly clear (I've filed a request to improve this), but to
specify a list of strings, you need to specify your query like so:
SELECT CampaignName,CountryCriteriaId,Conversions,TotalConvValue FROM
GEO_PERFORMANCE_REPORT WHERE CampaignName IN ['Taj Mahal Palace','Taj
Mahal Palace'] DURING 20120708,20120714
- Kevin Winter
AdWords API Team
On Tuesday, July 17, 2012 9:38:48 AM UTC-4, ja wrote:
>
> Hi,
> I am using the following query to get my stats for all the campaigns whose
> campaign names are lised in array.
> But its giving me a an error as "!!!2|||-1|||[INVALID_WHERE_CLAUSE]???"
> I am unable to use IN Operator where as I Get results If I use = Operator
> and pass one campaign name
>
>
> "SELECT CampaignName,CountryCriteriaId,Conversions,TotalConvValue
> FROM GEO_PERFORMANCE_REPORT WHERE CampaignName IN array('Taj Mahal
> Palace','Taj Mahal Palace') DURING 20120708,20120714";
>
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords 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
