Google AdWords XML Reports Missing Decimals

Jan 30, 2009 • 1:55 am | comments (2) by twitter Google+ | Filed Under Google AdWords
 

Confirmed reports at a Google AdWords Help thread show that if you use the XML format for Google AdWords reports, you will be missing decimal values in the report.

The advertiser who reported this noticed the discrepancy when he generate duplicate reports, one in Excel format and one is XML format. The advertiser said:

When I generate reports in excel format, I get the right number for avg cpc with decimasl, and when I generate an xml format it gives me a different one without the decimal. e.g. In Excel it is avgcpc = 1.50 while in XML avgcpc= 1478393. I think there is a bug in the reports when converted to XML format.

AdWordsPro Stephen confirmed the issue and said he will follow up on why this is the case and let us know if it is a bug or a 'feature.'

Forum discussion at Google AdWords Help.

Previous story: Google Invites More Advertisers To Test Beta AdWords Interface
 

Comments:

Tim Dineen

01/31/2009 06:58 pm

Thanks for pointing this out. Whether its a bug or a feature, Google should not change it. Those of us who use XML reports would have to alter current methods. Anyone capable of using the data in XML format should also be able to add a decimal point programmatically if necessary.

Tim Dineen

02/05/2009 07:03 pm

not a bug, confirmed by AdWordsPro Stephen

blog comments powered by Disqus