Value format

[Johan de Groot]

HI,

When I download a report (e.g. campaign performance or criteria performance) via the PHP api library the values returned of ConversionValue and AllConversionValue have a thousands-separator.

Example: "2,432.74" 

Because this data is uploaded to a Mysql database this isn't very useful; "2432.74" (without thousands-separator) would be more usefull and reliable. 

I couldn't find any option or parameter changing this - does anyone know how to change this?

Kind regards,

Johan de Groot

[Michael Cloonan (AdWords API Team)]

Hello,

This has been mentioned before on other threads, and I agree that these fields should definitely be plain old numbers instead of adding extra characters that require parsing on your end. I have already filed a feature request on this in the past, and have added your voice to it.

In the meanwhile, unfortunately, you will have to add an additional parser to sanitize the data before you put it into your SQL table, by removing the commas.

Regards,

Mike, AdWords API Team