AWQL - INVALID_PREDICATE_VALUE

[Chirag]

Hello,

I am not able to perform this query on AWQL.

This will give me INVALID_PREDICATE_VALUE.

Is there any way where I can compare two fields in of a service?

SELECT AdGroupId, CampaignId, Id, Criteria, KeywordMatchType, CpcBid, FirstPageCpc FROM KEYWORDS_PERFORMANCE_REPORT 

WHERE CpcBid > FirstPageCpc

Thanks,

[Anthony Madrigal]

Hello,

Unfortunately, there is no way to write an AWQL query that compares two fields in the predicate. Please also don't forget to include a date range in your query.

Regards,

Anthony

AdWords API Team

[Chirag]

Yes, I am passing the date range.