Re: AWQL -- query only Records with Impressions, Clicks, or Conversions 0

2014-01-14 Thread Rasmus Ladekjær Pedersen
You can see the formal grammar here https://developers.google.com/adwords/api/docs/guides/awql under Formal Grammar. There is no support for OR i AWQL. A solution could be to use node-gawrhttps://github.com/ladekjaer/node-gawr to fetch the data and then filter with grep (on Linux/Mac OS X) or

Re: AWQL -- query only Records with Impressions, Clicks, or Conversions 0

2014-01-13 Thread Brandon Patrick
I finally realized for my specific case, I only need Impressions 0, because my ads will not have Clicks or Conversions if they don't have any Impressions. Duh. I'd still be interested to know whether there is an OR keyword in AWQL at all. So far it does not seem so. On Friday, January 10,

AWQL -- query only Records with Impressions, Clicks, or Conversions 0

2014-01-10 Thread Brandon Patrick
Using reporting, I only want to pull ads where one of these stats -- Impressions, Clicks, Conversions -- is greater than zero. In MySQL I would do something like this: SELECT Id, Impressions, Clicks, Conversions, Status FROM AD_PERFORMANCE_REPORT WHERE CampaignId = $remote_service_ID AND