Mario, You'll have to parse and process the data, and perform the calculation accordingly.
Thanks, Ray On Saturday, September 13, 2014 12:33:04 AM UTC-4, Mario Young wrote: > > I have this query in AWQL and I get the response in CSV format using the > ReportUtils::DownloadReportWithAwql > <http://googleads.github.io/googleads-php-lib/AdWords/files/AdWords.Util.ReportUtils.html#%5CReportUtils::DownloadReportWithAwql()> > > > select Date, Clicks, Cost from ACCOUNT_PERFORMANCE_REPORT during LAST_30_DAYS > > I need to convert the *Cost data in the CSV from micros to the currency* in > the account (Cost / 1000000). > > Also I need to be able to convert any the *Cost* data in the response > using *any* AWQL query, for example the solution has to work for this > query also: > > SELECT CampaignName, KeywordText, Cost, CostPerConversion, QualityScore FROM > KEYWORDS_PERFORMANCE_REPORT DURING LAST_7_DAYS > > As of v201406, the returnMoneyInMicros header is no longer valid and > values are always returned as micros. > https://developers.google.com/adwords/api/docs/guides/reporting-concepts#money > > I make the 2 query and the result are here > <https://gist.github.com/mayeco/1904e3d8243c62a129ea> now imagine you > have cost1 in a $variable1 and cost2 in $variable2. how do I divide by > 1000000 the Cost and Cost/conversion columns in the variables using the > same function? in PHP > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/f2c4cec2-18c9-44f2-963d-b8440580f795%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
