none
Google script to MS scripts RRS feed

  • General discussion

  • Hi, I am trying to run my google ads script in ms ads script.  I am not finding a solution to my problem.  SpreadsheetApp is not used and I run into a problem with AdsApp.report. It is not a type to AdsApp.  I can't find documentation on either.  Any suggestions?
    var SPREADSHEET_URL = 'https://docs.google.com/spreadsheets/d/1yPvuhXeM4h-Sn8WBn1JQrviWevy4KaD4j8NvWm7Vn4k/edit#gid=0'; 
    function main() {   
      var accountSelector = AccountsApp.accounts();    
      accountSelector.executeInParallel('processAccount'); 
    } 
    function processAccount() { 
      var account = AdsApp.currentAccount(); 
      var spreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL); 
      var sheet = spreadsheet.getSheetByName(account.getName()); 
      if(!sheet){ 
        spreadsheet.insertSheet(account.getName()); 
        sheet = spreadsheet.getSheetByName(account.getName()); 
      } 
      spreadsheet.setActiveSheet(sheet); 
      var report = AdsApp.report( "SELECT Account, Campaign, Ad group, Keyword ID, Bid match type, Ad Distribution, Current maximum CPC, Quality Score, Impressions, Clicks, CTR, Avg.CPC, Spend, Avg. position, Conversions, Conversion rate, CPA " + 
                                     "FROM KEYWORDS_PERFORMANCE_REPORT " + 
                                     "DURING LAST_30_DAYS"); 
      report.exportToSheet(sheet); 
    }

    • Changed type Bill_Stewart Thursday, September 5, 2019 9:30 PM
    • Moved by Bill_Stewart Thursday, September 5, 2019 9:30 PM Off-topic
    Tuesday, May 28, 2019 2:31 PM

All replies

  • This is not the right forum for your question. This is a Windows OS admin scripting forum.

    -- Bill Stewart [Bill_Stewart]

    Tuesday, May 28, 2019 3:28 PM