Reporting Metric ConversionValue is returning readable Number Fomats(comma's in between)

[edduenas...@gmail.com]

Hi,

we are trying to pull Reports(URL Performance), as per documentation ConversionValue field type is double, so I am trying insert this value directly into Teradata DB, but we are facing NumberFormat Exception.

This due to value for ConversionValue is retrieved as 1,228.02 instead of 1228.02. Comma is coming in between.

I have gone through earlier forum posts,

https://groups.google.com/forum/#!searchin/adwords-api/reporting$20conversion$20value$20fields/adwords-api/QvluyAyaRzw/k6SvrYC2x4wJ

I am wondering is this feature implemented, are there any solutions to get around this. Please advice

Thanks.

[Michael Cloonan (AdWords API Team)]

Hello,

Can you please give an example SOAP request/response where the value includes a comma? Since this is a numeric value, I don't think it makes sense to include commas, which should only be included in string values. If you can provide evidence that this is happening, I will file a bug with the team to see if we can get this changed.

For now, however, it might be best to write some sanitization code that can handle both numbers with and without commas.

Regards,

Mike, AdWords API Team