Invalid reporting query: ACCOUNT_PERFORMANCE_REPORT. (file Code.gs, line 23)
I know it's a script for Single Account but I can not turn it into an MCC...
var QUERIES = [{'query' : 'SELECT AccountDescriptiveName, Clicks, Impressions, Cost, Ctr, AverageCpc, AveragePosition, AllConversions, CostPerAllConversion ' +
'FROM ACCOUNT_PERFORMANCE_REPORT ' +
//'WHERE Device = DESKTOP ' +
'DURING LAST_30_DAYS',
'spreadsheetUrl' : '[HIDDEN]',
'tabName' : 'option',
'reportVersion' : 'v201809'
}
];
function main() {
for(var i in QUERIES) {
var queryObject = QUERIES[i];
var query = queryObject.query;
var spreadsheetUrl = queryObject.spreadsheetUrl;
var tabName = queryObject.tabName;
var reportVersion = queryObject.reportVersion;
var spreadsheet = SpreadsheetApp.openByUrl(spreadsheetUrl);
var sheet = spreadsheet.getSheetByName(tabName);
var report = AdWordsApp.report(query, {apiVersion: reportVersion});
report.exportToSheet(sheet);
}
}