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 -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/d80b17aa-a357-4b9b-aa30-4bf1256f9d3b%40googlegroups.com.
