Data Mismatch on metrics(Impressions and clicks) between keyword performance report and ad performance report, ad-group performance report,campaign performance report

Question

I was working on generating a fact table based on keyword performance report considering it as the lowest granular report and when having a data validation check i am comparing sum of impressions and clicks of keyword performance report with ad performance report and ad-group performance report and campaign performance report and there is a clear mismatch between these records and that is due to some of the campaign ID's are missing in Keyword performance report but these are present in the rest of reports(ad performance report and ad-group performance report and campaign performance report), So will keyword performance report only fetch the data of active campaigns

I was using the following script in the initial script to extract data from all campaigns irrespective of status

        report_request.Filter=reporting_service.factory.create('KeywordPerformanceReportFilter')
        report_request.Filter.CampaignStatus=['Active','Deleted','Paused','BudgetPaused','Suspended']