Difference in the data between API (CAMPAIGN_PERFORMANCE_REPORT) and Dashboard Interface

[Pierre C]

Hello,

I retrieve a set of statistics through CAMPAIGN_PERFORMANCE_REPORT.

Here's what I do via c #:

SELECT CampaignName, CampaignId, Cost, Impressions, Clicks

 FROM CAMPAIGN_PERFORMANCE_REPORT WHERE CampaignName = [CampaignName];

I noticed that I had differences between the statistic that I retrieve via this query and the classic dashboards that are displayed when we click on the campaign or ad group. 

I said that I have the problem in the dashboards of the new and old interface of Adwords.

Regarding the API to retrieve my data, I use the latest version of the AdWords API.

Does anyone have an answer to that? In some cases, there are substantial differences.

Thank you in advance for your answer.

Pierre C.

[Bharani Cherukuri (AdWords API Team)]

Hello Pierre, 

If the API report stats match with the old UI and you notice a discrepancy between the new UI and old UI metrics, it is more of a product related concern. I'd suggest that you post your question on Advertisers community forum and the product experts there will be able to take a look. If that's not the case, could you share us your clientCustomerId along with the dateRange, so I can take a look? Please use Reply privately to author to share the details. 

Regards,

Bharani, AdWords API Team 

[Bharani Cherukuri (AdWords API Team)]

Hello Pierre, 

Thank you for sharing the details. I was able to notice the issue you described. However, I was also able run reports for several other date ranges(LAST_MONTH and Yesterday) and the results matched with the UI. This indicates that the date range as All time, is not returning fresh stats. Some statistics that go into your reports may be calculated continuously, while others may be calculated once a day. In most of the cases, the clicks and impressions stats are usually delayed by less than three hours. Please refer to this guide for more information on data freshness.