Hi Tjeerd, I definitely see your point here - others have also brought it up in the past. I filed a feature request to see if we can get the comma removed, or ideally get these fields treated as Money and respect the returnMoneyInMicros header.
In the meantime, since you can't go directly from reports -> BigQuery, I suggest added logic to process the report results between the download from AdWords reporting and the upload to BigQuery. - Kevin Winter AdWords API Team On Wednesday, May 16, 2012 3:32:47 AM UTC-4, Tjeerd Kramer wrote: > > 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
