RSA Quality Overview

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.

Author

Tibbe van Asten

Contact me!

Difficulty

Category
Google Ads Scripts

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.

// 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()