Using Or with Where statement

[Ns sh]

Could you please help me to correct this statement:

.Where("Impressions" Or "Clicks" Or "Conversions").GreaterThan(0)

I go an error "'Conversion from string "Impressions" to type 'Long' is not valid'".

Thanks.

[Dannison Yao (AdWords API Team)]

Hi,

The Impressions, Clicks, and Conversions field only accept Long data types. Could you try casting the value "0" into a Long data type?

Let me know if this helps.

Regards,

Dannison

AdWords API Team

[Ns sh]

Hi Dannison,

I still have the same error after conversion:

Where("Impressions" Or "Clicks" Or "Conversions" Or "AllConversions").GreaterThan(CLng(0))

[Dannison Yao (AdWords API Team)]

Hi,

My apologies for missing this out in my previous response. It appears that you are using an OR operator, this is not supported in the AWQL. You may refer to this guide for further details.

Regards,

Dannison

AdWords API Team

[Ns sh]

Cloud you please help me about using something instead of  'Or' to get my query like :  if Impressions> 0 or Clicks >0 or Conversions>0

[Dannison Yao (AdWords API Team)]

Hi,

Logically speaking, you may omit the conditions Clicks > 0 and Conversions > 0 because once an impression has been generated, it means that there is also a Click or a Conversion generated. With this said, you may retain the Impressions > 0 only in your condition and it would still retrieve the same result.

Regards,

Dannison

AdWords API Team