Kevin, Thanks for your reply. The "problem" is that I import these reports into BigQuery which doesn't allow on-the-fly manipulation of data, therefore there is no way to import the conversion values as floats or integers. The result of that is that I can't run any mathematical functions on the data such as SUM() or AVG().
An additional parameter that leaves out the comma would help in my case, though I am not sure if this would help others. Tjeerd On Tuesday, May 15, 2012 5:48:35 PM UTC+2, Kevin Winter wrote: > > Hi Tjeerd, > The Conversion values are not actually money values and are therefore > not affected by this header. As mentioned in the referenced thread, we've > conveyed this to the core engineers, but we don't currently have a solution > in mind. > > - Kevin Winter > AdWords API Team > > On Wednesday, May 9, 2012 2:03:23 PM UTC-4, Tjeerd Kramer wrote: >> >> I am experiencing similair behaviour as the topic starter, so I guess >> this "issue" has not been solved yet? I am sending the >> "returnMoneyInMicros" header and most fields come back in this format, but >> TotalConvValue, ValuePerConversion and ValuePerConversionManyPerClick do >> not (returned example: 1,782.72). >> >> This is causing issues for me as I want to export the downloaded report >> CSV directly into BigQuery, which does not support this format (unless I >> put it as a string, which is not what I want). >> >> Any way to solve this? >> >> Kind regards, >> Tjeerd >> >> On Wednesday, January 5, 2011 12:04:19 AM UTC+1, mm wrote: >>> >>> Hey guys - >>> According to the documentation - both via getReportFields api and the >>> online doc - TotalConvValue/ConversionValue in the >>> KeywordPerformanceReport is a long. However, when running reports >>> containing this value, a decimal value is returned. Is it safe to >>> assume that this is actually a currency value (which makes more sense >>> anyway)? >>> >>> Thanks - >>> mm >> >> -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
