Help me for turn a single account to MCC | message error Invalid reporting query: ACCOUNT_PERFORMANCE_REPORT. (file Code.gs, line 23)

44 views
Skip to first unread message

Nathan Alfa

unread,
Aug 23, 2019, 10:33:45 AM8/23/19
to Google Ads Scripts Forum
Hello,

When I start my script, I have the next message of error:
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...


Thank


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);
    }
}
Reply all
Reply to author
Forward
0 new messages