Hi I am trying to get the information to SORT but FieldName Cost ...perferable descending. I have not been able to figure out the proper code to sort - any help is very much appreciated. THANKS!
{'query' : 'SELECT CampaignName, AdGroupName, OfferId, Clicks, Impressions, Ctr, AverageCpc, Cost, Conversions ' + 'FROM SHOPPING_PERFORMANCE_REPORT ' + 'WHERE Cost > 300000000 ' + //Fields of type Money are returned in micro currency units (micros) but may be prefixed with "auto: " or may simply be the string "auto" if automatic bidding is used. For example, $1.23 will come back as 1230000 (1.23 x 1,000,000). Micro amounts always refer to the account's local currency. 'DURING LAST_30_DAYS', 'spreadsheetUrl' : 'insertgoogleurl', 'tabName' : 'PLACheckSpend', * 'OrderBy' : 'Cost',* 'reportVersion' : 'v201802' -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads 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 and Google Ads 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 https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/a9c134f2-7e17-4031-850b-10ce2e3228f2%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.