Adding Return in script

[Yan Lahud]

Hello! I did a script and im trying insert returnMoneyInMicros: true for the cost be in current money. But don't work. Can help with this?


function main() {
 
  // Dados da planilha
  var spreadsheet = SpreadsheetApp.openByUrl('xxxxx');
  var sheet = spreadsheet.getSheetByName('xxxxx');
  returnMoneyInMicros: true
  var costToCheck = currentSetting.maxCost * 1000000;
 
  // Query com os dados
  const query = 'SELECT campaign.name, metrics.clicks, metrics.impressions, metrics.cost_micros FROM campaign WHERE segments.date >= \'2022-06-01\' AND segments.date < \'2022-06-04\'';
 
  var report = AdWordsApp.report(query);
 
  // Log de erro
  Logger.log(report);
 
  // Exportando dados para a planilha
  report.exportToSheet(sheet);

[Google Ads API Forum Advisor]

Hi Yan,

Thank you for posting your concern.

Please note that this forum is dedicated for the Google Ads API / AdWords API related concerns only. With this, since your concern is specific with the Google Ads scripts, then our team would not be able to provide support.

That said, I would suggest posting your concern here instead to get helpful support from the more equipped team, the Google Ads scripts team.

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2b6Aau:ref