RSA Kwaliteit overzicht

// Copyright 2021. Increase BV. All Rights Reserved.
//
// Created By: Tibbe van Asten
// for Increase B.V.
//
// Created: 15-06-2021
// Last update: 
//
// ABOUT THE SCRIPT
// This script will export the ad strength of all RSA's in your
// account to a Google Sheet. The sheet will contain the campaign,
// adgroup, ad id and ad strength.
//
////////////////////////////////////////////////////////////////////

var config = {
  
  LOG : true,
  
  // Make a copy of this script and copy the URL: https://docs.google.com/spreadsheets/d/1WvNSbaZi2dz3Uu74AIniKy5YLHctZ_6c6i0Gp2DQ8ns/copy
  SPREADSHEET_URL : "https://",
  SHEET_NAME : "RSA"
  
}

////////////////////////////////////////////////////////////////////

function main() {
  
  if(config.SPREADSHEET_URL == "https://"){
    throw Error("Make a copy of the sheet and paste the URL in the config \nhttps://docs.google.com/spreadsheets/d/1WvNSbaZi2dz3Uu74AIniKy5YLHctZ_6c6i0Gp2DQ8ns/copy");
  }  
    
  var ss = SpreadsheetApp.openByUrl(config.SPREADSHEET_URL);
  var sheet = ss.getSheetByName(config.SHEET_NAME);
  
  var report = AdsApp.report(
    "SELECT CampaignName, AdGroupName, Id, AdStrengthInfo " +
    "FROM AD_PERFORMANCE_REPORT " +
    "WHERE AdType = RESPONSIVE_SEARCH_AD " +
    "AND CampaignStatus = ENABLED " +
    "AND AdGroupStatus = ENABLED " +
    "AND Status = ENABLED"
  )
  
  // Export data and clean up sheet
  sheet.clearContents();
  report.exportToSheet(sheet);
  sheet.autoResizeColumns(1, sheet.getLastColumn());
  
  if(sheet.getMaxColumns() - sheet.getLastColumn() != 0){
    sheet.deleteColumns(sheet.getLastColumn() + 1, sheet.getMaxColumns() - sheet.getLastColumn());
  }
  
  if(config.LOG === true){
    
    var rows = report.rows();
    while(rows.hasNext()){
      var row = rows.next();

      Logger.log("Campaign: " + row["CampaignName"] + " - Adgroup: " + row["AdGroupName"] + " - " + row["AdStrengthInfo"]);
    } // rowIterator
    
  }
  
  Logger.log("Export completed");
  
} // function main()