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.
