function main() {
var spreadsheet = SpreadsheetApp.openByUrl(spreadsheetUrl);
var tabName = 'Placements Report';
var QUERIES = [{'query' : 'SELECT Url, CampaignName, Impressions, Clicks ' +
'FROM URL_PERFORMANCE_REPORT ' +
'DURING ' + 'YESTERDAY',
'reportVersion' : 'v201806'
}];
for(var i in QUERIES) {
var queryObject = QUERIES[i];
var query = queryObject.query;
var reportVersion = queryObject.reportVersion;
var sheet = spreadsheet.getSheetByName(tabName);
var report = AdWordsApp.report(query, {apiVersion: reportVersion});
report.exportToSheet(sheet);
}
}