Checking of money report field for null value

[Nick Vilenski]

Hi,

I'm trying to get Product Partition report with filtering by null values of 'CpcBid' field. Tried to use predicate 'CpcBid > 0', but it didn't bring me any result (I got the same report with Null values).

How can I filter such values for Money type?

[Josh Radcliff (AdWords API Team)]

Hi,

I see what you're saying - the filtering doesn't seem to be working as expected for that field. I'll follow up with the reporting team and ask them to investigate.

In the meantime, since only UNIT partitions can have bids, could you filter by PartitionType = UNIT AND IsNegative = false instead?

Thanks,

Josh, AdWords API Team

[Josh Radcliff (AdWords API Team)]

Hi,

I realize this is a very old issue at this point, but I came across it today and tried out the report request again, and filtering for rows with CpcBid > 0 now excludes rows without a CpcBid, as expected.

Cheers,

Josh, AdWords API Team