RSA Quality Overview

Easily get an overview of all Responsive Search Ads in your account with associated rating.

Start Now!
Google Ads RSA overview with associated rating
RSA Quality Get started!

In Google Ads, all Responsive Search Ads are reviewed to determine the quality of the ads. Of course you want the ad to meet all of Google's requirements and the rating to be the best as possible. This ensures that the ad is suitable for generating as many impressions as possible in the adgroup. This script exports all Responsive Search Ads to a Google Sheet and includes the corresponding Google Ads rating. You can quickly see which ad in which campaign and adgroup needs attention and needs to be improved.

Quality of Responsive Search Ads

The quality of Responsive Search Ads is determined by several factors. Among other things, it has to do with the number of headlines and descriptions you add to an ad. But also whether the content of the headlines differs enough from each other to make the ad suitable for multiple searches. When you identify the underperforming ads in the generated overview of ads, you can then look them up in Google Ads and adjust them in such a way that the rating is adjusted by Google.

Settings

  • LOG: Indicate whether the script should report the intermediate steps, by adjusting the value to 'true'.
  • SPREADSHEET_URL: Make a copy of this spreadsheet (https://docs.google.com/spreadsheets/d/1WvNSbaZi2dz3Uu74AIniKy5YLHctZ_6c6i0Gp2DQ8ns/copy) and enter the URL here to deploy the results of the script.
  • SHEET_NAME: The name of the tab in the sheet you just copied.
The script
// 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()
Show whole script!
Loading Comments
The Experts
Tibbe van Asten Team Lead Search
Nils Rooijmans Water Cooler Topics
Martijn Kraan Freelance PPC Specialist
Bas Baudoin Teamlead SEA @ Happy Leads
How about you? JOIN US!
Sharing Knowledge
Caring

Sharing Knowledge

Adsscripts.com is all about sharing knowledge. In the current market, PPC specialists like to keep their knowledge and experience to themselves. We're convinced that sharing knowledge can ensure that everyone gets better at their work. We want to change this by sharing our knowledge about scripts with everyone.

Do you also want to contribute? We are open to new ideas and feedback on everything you find on Adsscripts.com.

Contact us

Training &
Workshop
Contact us!
Adsscripts Training & Workshop