O
O
Oleg2020-11-09 09:50:40
Google Ads
Oleg, 2020-11-09 09:50:40

How to unload by a script (from google ads) numerical data in the format accepted in the Russian Federation?

Good afternoon.
The essence of the problem is that now, when the script uploads data from google ads to a google sheet, numeric data is uploaded with a separator of an integer - a dot, thousandths - a comma (that is, accepted in the USA).
Is it possible to somehow configure the script so that the numbers are unloaded in the usual format (the integer separator is a comma, the thousandth separator is not used)? In the account settings, it is worth: the number format is RF.

function main() {
  
  var id_spreadsheet = 'id листа'
  var name_sheet = 'название листа'
  var spreadsheet = SpreadsheetApp.openById(id_spreadsheet)
  spreadsheet.getSheetByName(name_sheet).getRange('A:G').clear();
  var report = AdsApp.report("SELECT CampaignId, CampaignName, AdType, Date, Clicks, Cost, Conversions " +
                              "FROM AD_PERFORMANCE_REPORT "    +
                              "DURING YESTERDAY");
  report.exportToSheet(spreadsheet.getSheetByName(name_sheet)); 
  Logger.log("Report available at " + spreadsheet.getUrl());
}

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question