Difference in the data between API 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 statistics that I retrieve via this query and the classic dashboards that are displayed when we click on the campaign or ad group (AdWords Interface). 

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.

[MarTec360 LLC]

I'm looking for similar answers.  Our main issue is conversion value data discrepancies.  Couple of thoughts or leads:

1) Is Adwords API Conversion Value based only on Last Click attribution or are Adwords UI attribution changes accounted for in the data (ie, Position-based, Decay, etc.)?

2) Our Adwords account is set to UTC-5, is Adwords API providing UTC-0 data?  (5 hours per day of differing data could help explain the discrepancies)

Thanks,

James Holt

BI Director

MARTEC360.com

[Bharani Cherukuri (AdWords API Team)]

Hello James, 

Please find my response below: 

1. The AdWords API Conversion Value depends on the current Attribution model type in the AdWords UI. Please refer to this guide for more information.

2. AdWords API stats will be returned based on the account time zone. This said, it takes up to 3 hours for the imported conversion statistics to appear in your account for Last-click attribution. For other search attribution models, it can take longer than 3 hours as mentioned in this guide. Please refer to the data freshness article on when these conversions will be updated every day.

Let me know if you have any other questions. 

Regards,

Bharani, AdWords API Team

On Wednesday, January 10, 2018 at 5:25:23 AM UTC-5, Pierre C wrote: