Data Mismatch on metrics(Impressions and clicks) between keyword performance report and ad performance report, ad-group performance report,campaign performance report
I was working on generating a fact table based on keyword performance report considering it as the lowest granular report and while performing 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 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),I have checked the status od missing campaign some are paused, So will keyword performance report only fetch the data of active campaigns, So if keyword performance report can be considered the lowest granular report
I was extracting using the Bing ads python sdk and during the extraction i have tried using
report_request.Filter=reporting_service.factory.create('KeywordPerformanceReportFilter')
report_request.Filter.CampaignStatus=['Active','Deleted','Paused','BudgetPaused','Suspended']
I have tried to include all the campaigns irrespective of their status but still the data remains same
can some one advise on this