"removed" campaigns don't show up in Campaign Performance Report

[Maria Ravander]

Hi, 

I wonder if campaigns with a "removed" campaign status are supposed to be left out in Campaign Performance Reports when adding the Date Segment? 

When requesting the report without the Date segment, "removed" campaigns are included in the report.  

Using the Adwords API.

AWQL: SELECT CampaignName, Date, CampaignStatus FROM CAMPAIGN_PERFORMANCE_REPORT DURING 20191101,20191130

Thanks,

Maria

[Google Ads API Forum Advisor Prod]

Hi Maria,

By default, removed entities will not appear on reports unless you explicitly filter for them. You can add the WHERE clause "CampaignStatus IN [ENABLED,PAUSED,REMOVED]" to your report query.

Regards,
Anthony
Google Ads API Team 

ref:_00D1U1174p._5001UZV88M:ref

[Maria Ravander]

Hi Anthony,

it did not work out with the WHERE clause. After some more troubleshooting I realised the wrong timespan had been used in the DURING clause. When I change the timespan, removed campaigns are now include in the report although there is no WHERE clause? So should removed campaigns really be left out by default or not? If yes why are they now included in the report?

Still using the same AWQL as before but with a changed timespan:

SELECT CampaignName, Date, CampaignStatus FROM CAMPAIGN_PERFORMANCE_REPORT DURING 20180613,20180613

AWQL with a WHERE clause which gives the exact same response:

SELECT CampaignName, Date, CampaignStatus FROM CAMPAIGN_PERFORMANCE_REPORT WHERE CampaignStatus IN [ENABLED,PAUSED,REMOVED] DURING 20180613,20180613

Thanks,

Maria

[Google Ads API Forum Advisor Prod]

Hi Maria,

The field CampaignStatus is an attribute so the data reflected will always be the current state, regardless of date range. Removed entities shouldn't return by default. If you want me to take a look into the behavior, please reply privately to author your CID, and report results.