Re: KeywordPerformanceReport - datatype for TotalConvValue?
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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
Re: KeywordPerformanceReport - datatype for TotalConvValue?
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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
Re: KeywordPerformanceReport - datatype for TotalConvValue?
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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
Re: KeywordPerformanceReport - datatype for TotalConvValue?
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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
Re: KeywordPerformanceReport - datatype for TotalConvValue?
Hi, Right now, report fields that are monetary values are returned as currency values (decimal) rather than as micros (long) by default. You can get the micro values by sending returnMoneyInMicros: true as http headers when downloading the report. See this blog post for more details: http://adwordsapi.blogspot.com/2010/11/change-to-currency-formatting-in-report.html Cheers, Anash P. Oommen, AdWords API Advisor. On Jan 5, 4:04 am, mm margaret.a.mar...@gmail.com 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
Re: KeywordPerformanceReport - datatype for TotalConvValue?
Hey Anash - I do have that header set in my request, and the other monetary values that I requested (Cost, MaxCpc MaxCpm) are returned as longs. Only TotalConvValue is not. Thanks - mm On Jan 6, 2:25 am, AdWords API Advisor adwordsapiadvi...@google.com wrote: Hi, Right now, report fields that are monetary values are returned as currency values (decimal) rather than as micros (long) by default. You can get the micro values by sending returnMoneyInMicros: true as http headers when downloading the report. See this blog post for more details: http://adwordsapi.blogspot.com/2010/11/change-to-currency-formatting-... Cheers, Anash P. Oommen, AdWords API Advisor. On Jan 5, 4:04 am, mm margaret.a.mar...@gmail.com 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en
KeywordPerformanceReport - datatype for TotalConvValue?
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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en