Yes, you are correct. The difference between
AdNetworkType1 and
AdNetworkType2 is AdNetworkType2 includes search partners. I am able to run below report queries.
"SELECT CampaignId, Impressions, Clicks, Cost FROM CAMPAIGN_PERFORMANCE_REPORT WHERE AdNetworkType1 IN [CONTENT,SEARCH] DURING YESTERDAY";
"SELECT CampaignId, Impressions, Clicks, Cost FROM CAMPAIGN_PERFORMANCE_REPORT WHERE AdNetworkType2 IN [CONTENT,SEARCH] DURING YESTERDAY";
If you want to get the data for specific campaign type (e.g. Seach, Display, Video etc.) you could use the
AdvertisingChannelType field.
Please provide the report request where you were getting the error (invalid where clause).