Campaign performance report doesn't match web interface

[Liam O'Boyle]

Attempting to pull a campaign performance report (with no filters) results in a much lower impression count than that shown in the web dashboard.  Is there any reason that this should be the case?  The report is fetched using the following AWQL.

SELECT CampaignStatus, CampaignId, CampaignName, Labels, AverageCpc, Cost, CostPerConversion, Ctr, Impressions, Clicks, Conversions, TotalBudget, TotalCost
FROM CAMPAIGN_PERFORMANCE_REPORT
DURING 20140101,20140917

[Dorian Kind]

Total shot in the dark here, but could it be that the account in question also uses video campaigns? Because those aren't reported over the API.

[Ray Tsang (AdWords API Team)]

Liam,

Please compare the result and let me know if specific rows were missing, or that the counts are completely different between the UI and the API for the same campaign.

Thanks,

Ray

[Liam O'Boyle]

Hi Ray,

All of the campaigns match, and 196 of 199 campaigns match exactly on clicks, impressions and conversions.  Three campaigns show totally different impressions, clicks and conversions (one of them more than 100,000 impressions different).  Any ideas why this might be?

[Liam O'Boyle]

Aaaaaah, I'm an idiot.  The campaigns in question were set up a long time ago and most of the data was excluded by the DURING period specified in the query.

Thanks for prompting me to look more closely and spot the difference.

While I've got someone answering, can you possibly point me in the right direction to ask questions about the Webmaster API?  I've asked a question about an apparent bug in the verification API over in the forum but I've got a resounding silence.  Am I asking in the wrong place?

Cheers,

Liam 

[Ray Tsang (AdWords API Team)]

Liam,

No worries - glad that helped.  Are you referring to the Webmaster Tools API?  The forum seems to be right place.

Thanks!

Ray