missing "total - all removed ads" in pulling using API

[ejay.o...@momentummedia.com.au]

Hi adwords Team,

Here is my code to get an Ad details per day

SELECT CampaignName, CampaignId, AdGroupId, Id,'

                . 'Impressions, Clicks, Ctr FROM AD_PERFORMANCE_REPORT '

                 . 'WHERE Id = '.$adwordsId.' AND Status IN [ENABLED, PAUSED] DURING '.$adwords_start_date.','.$adwords_start_date

But as i check the reporting in my system, it has missing clicks, and upon checking my database it is very close to the "Total - all but removed ads" of Google Adwords Interface

Question is, are you generating data from removed ads too? 

NOTE: I have no missing date or day in my dbase, so I am 100% sure that i'm pulling ad details daily. :)

Thanks,

Ejay

[Peter Oliquino]

Hi Ejay,

Removed ads can be retrieved by using the Status IN [DISABLED]. Doing so will have them included in the Ad Performance Report that you wish to generate. If you have further doubts and in order to better investigate your issue, could you provide your clientCustomerId, the complete screenshot of the AdWords UI view and the generated report file? You may reply using the Reply privately to author option.

Thanks and regards,

Peter

AdWords API Team

[Peter Oliquino]

Hi Ejay,

I wanted to follow up on your concern. Could you confirm if you still require assistance? If yes, feel free to write back and I'll be happy to assist you.