Hi guys,
I noticed that some campaigns were missing in the result and found that these are the ones with the status "limited by budget". I would expect this to be counted as an Active account, but as by default only enabled and paused are returned, I decided to make sure this wasn't counted as "removed" or something and added a filter to fetch all campaigns that were either Enabled, paused or removed. This gave me the same result however, the campaign was still missing.
The query:
SELECT CampaignID, CampaignName, AdvertisingChannelType
FROM CAMPAIGN_PERFORMANCE_REPORT
WHERE CampaignStatus IN ['ENABLED', 'PAUSED', 'REMOVED']
I can provide some more info on which account(s) we tested with, which campaigns are missing, etc. in a private reply!
Thanks,
Tiana