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.

Reply via email to