Hi,
I try to find a way to filter results to only have the campaigns that appear on both the search network and the network display at the same time.
I tried several things but I can not find how to specify this.
Do you know how to do that?
The current formula displays the campaign that are on both networks but separately, I need to have a single result for campaigns that are on both networks at the same time.
Thanks for your help.
// Date range
$dateRange = sprintf('%d,%d', date('Ymd', strtotime('-90 day')), date('Ymd', strtotime('-1 day')));
// Select
$reportQuery = 'SELECT CampaignName, CampaignId, AdNetworkType1 FROM CAMPAIGN_PERFORMANCE_REPORT WHERE AdNetworkType1 IN [SEARCH,CONTENT] DURING '.$dateRange;