Hello,
I am having an issue where I cannot get the API to return data on a specific campaign where the advertising_channel_type is 'DISCOVERY'.
I have 2 discovery campaigns running for the account in question and I can see both campaigns in the Google Ads UI, but one of them is returned by the API but the other is not.
Here is the query I am using:
SELECT segments.date,
campaign.id, metrics.clicks, metrics.impressions, metrics.cost_micros,
campaign.name, campaign.advertising_channel_type, campaign.advertising_channel_sub_type"
FROM campaign
WHERE segments.date BETWEEN '2023-08-01' AND
'2023-08-09'
AND campaign.advertising_channel_type IN (DISCOVERY)
I have also tried filtering on these campaign's IDs but still only 1 campaign shows up in the results returned by the API:
SELECT segments.date,
campaign.id, metrics.clicks, metrics.impressions, metrics.cost_micros,
campaign.name, campaign.advertising_channel_type, campaign.advertising_channel_sub_type
FROM campaign
WHERE segments.date BETWEEN
'2023-08-01' AND '2023-08-09'
AND
campaign.id IN ('
19724922933', '19747927598')
The Campaign that shows up is: 19747927598
If anyone can help shed some light on this it would be very much appreciated.
Thanks!