Hello,
Unfortunately "OR" is not supported. The best approach I can suggest is to use "STARTS_WITH_IGNORE_CASE" and filter out unneeded entries on the client side. Alternatively, you can run N reports, one per keyword, and merge them. Also, check out if AwReporting<https://developers.google.com/adwords/api/docs/demo-apps#aw_reporting>can help you here, you can download all the data and query SQL database locally. -Danial, AdWords API Team. On Friday, April 18, 2014 7:10:29 PM UTC+4, Launchpad McQuack wrote: > > Hi there, > > I am trying to pull a "branded keywords by matchtype" report. > > > I read some posts in this group while I was trying to find a way to get > the OR operator in the WHERE condition. > Nearly 100% of provided answers suggest to use the IN operator. > Unfortunately, I also need to couple the OR operator to > the CONTAINS_IGNORE_CASE matching condition. > > SELECT KeywordMatchType, Impressions, Clicks, Ctr, Cost, AverageCpc, > AverageCpm, Conversions > FROM KEYWORDS_PERFORMANCE_REPORT > WHERE > Impressions > 0 AND ( > KeywordText CONTAINS_IGNORE_CASE 'brand name' OR > KeywordText CONTAINS_IGNORE_CASE 'brandname' OR > KeywordText CONTAINS_IGNORE_CASE 'brand-name' ) > DURING LAST_30_DAYS > > > I also tried to use the "brand.?name" expression, without success (obviously). > > > Thus, is the only solution to generate 3 separate queries and aggregate > results? > > Does someone have a better solution? > > > Thanks. > > > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 [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 Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
