I want data for search and display network in single query in AWQL

[Jaydeep More]

I used following query

SELECT CampaignName, Cost FROM  CAMPAIGN_PERFORMANCE_REPORT 

WHERE AdNetworkType1 = 'CONTENT' OR AdNetworkType1 = 'SEARCH' 

DURING 20170405, 20170405

but it shows exception

pls suggest me some of query changes to get both display network and search data

[Ivan Bautista]

Hi Jaydeep,

Currently, the OR condition is not supported in the AWQL syntax. However, for your query, you may use the IN operator to filter to both display network and search data. 

Below is a sample query you may use:

SELECT CampaignName, Cost FROM  CAMPAIGN_PERFORMANCE_REPORT 

WHERE AdNetworkType1 IN ['CONTENT', 'SEARCH'] 

DURING 20170405, 20170405

You may also refer here for other formal grammar guidelines for AWQL.

Regards,

Ivan 

AdWords API Team