Script double values

[Róbert Lelkes]

Hello,

I noticed that my script (exporting landing page - either unexpanded or expanded) generate doubled values for cost and conversion values (not sure regarding other metrics, as I export only these). It is exactly double the value reported by Google Ads UI.

Script:

function main(){

var report = AdWordsApp.report("SELECT ExpandedFinalUrlString, Cost, ConversionValue FROM LANDING_PAGE_REPORT WHERE Cost > 0 DURING LAST_MONTH");

var spreadsheet = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/XXXXX');

var d = new Date();

d.setMonth(d.getMonth() - 1);

var dateString = (d.getMonth() + 1) + "-" + d.getFullYear()

spreadsheet.setSpreadsheetLocale('en');

var sheet = createOrGetSheet(spreadsheet,dateString,0);

report.exportToSheet(sheet);

}

 function createOrGetSheet(reportSpreadsheet, name, position) {

 var sheet = reportSpreadsheet.getSheetByName(name);

  if(sheet == null) {

    return reportSpreadsheet.insertSheet(name,position);

  } else {

    return sheet;

}

}

Thanks for any help!

Best,

Rob

[Google Ads Scripts Forum Advisor]

Hi Robert,

Can you please provide your CID and script name so that I can investigate directly in your account?

Thanks,
Matt
Google Ads Scripts Team

ref:_00D1U1174p._5001UXT9jB:ref