AWQL Queries

302 views
Skip to first unread message

ja

unread,
Jul 17, 2012, 9:38:48 AM7/17/12
to adwor...@googlegroups.com
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";

Kevin Winter

unread,
Jul 24, 2012, 4:30:25 PM7/24/12
to adwor...@googlegroups.com
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
Reply all
Reply to author
Forward
0 new messages