Money type problem in the reports

[ra...@gogenchi.com]

Hey all, I saw couple people talking about this problem around here, and I wanted to know what are the solutions that exist for it.

For those  who don't know what I'm talking about, when you try to pull a report you get every thing that is related to cost in micro-millions(e.g 1.23$ will show as 1230000).

This could be a confusing thing for users who are unaware of this "gift", anyhow long story short what should I do?

Until now I thought about converting the ReportDownloadResponse object to csv & editing it but it's not fun and ugly & more importantly the method of saveToFile is obsolete.

I also thought on creating the csv & then editing it(but same reasons as above).

Is there a way to edit the ReportDownloadResponse object itself, I looked into it & haven't found the way but I could be missing stuff(hopefully....)

Anyhow the suggestions I saw online from Google rep's looks like they say to edit the value(divide by 1M), but they don't really say in what way.

So what is an ok solution for this problem? 

[Anthony Madrigal]

Hello,

You will need to parse and process the data, and perform the calculation accordingly within your application since this function is not available through AdWords API. 

Regards,

Anthony

AdWords API Team

[ra...@gogenchi.com]

Hello Anthony & thank you for answering.

No other way? Is there any thoughts on returning the header with the Money type, this process of parsing makes the entire save to file method completely useless....

[Anthony Madrigal]

Hello,

Unfortunately, there is no other way. AdWords v201406 removed the returnMoneyInMicros header. I will reach out to the team and see if there is any way to include the header in future versions.

Cheers,

Anthony

AdWords API Team