A few days ago, I started getting a bunch of errors from my scripts that looked like this:
Exception: Invalid reporting query: INVALID_PREDICATE_ENUM_VALUE: ACTIVE
If anyone else is seeing this issue, it has to do with an update to the reporting API. Previously, ACTIVE used to be a valid enum value for CampaignStatus, which was always sort of an anomaly since everything else used ENABLED. It has been updated to match the other Status values but in the process, broke any script that was using the ACTIVE status. Here is an example:
...
var query = ['select',cols.join(','),'from',report,
'where CampaignStatus = ACTIVE',
'and AdGroupStatus = ENABLED',
'and Status = ACTIVE',
'during','TODAY'].join(' ');
...
This should be changed to:
...
var query = ['select',cols.join(','),'from',report,
'where CampaignStatus = ENABLED',
'and AdGroupStatus = ENABLED',
'and Status = ENABLED',
'during','TODAY'].join(' ');
...
I am trying to go back and update my previous scripts but it might take some time.
Thanks,
Russ
