Adpulse Close Variant Checker – Google Ads Script & Instructions

function main() {
// Script provided by www.adpulse.app
// The purpose of this script is to add exact match negative keywords to the ad group for all search terms that do not match your keywords or the allowed phrases in that ad group. It works in a similar fashion to the www.adpulse.app “close variant manager” – see more here: https://support.adpulse.app/en/articles/9364164-close-variants-manager-explained
// User-defined inputs: Each campaign + ad group combo (and their respective allowed phrases) needs to be defined below. 

  var campaignsAndAdGroups = [
{
   campaignName: “Campaign 1”,
   adGroupName: “Ad Group 1”,
   allowedPhrases: [“allowed phrase 1”, “allowed phrase 2”] // Custom allowed phrases for this ad group.
},
{
   campaignName: “Campaign 2”,
   adGroupName: “Ad Group 2”,
   allowedPhrases: [“allowed phrase 3”, “allowed phrase 4”] // Custom allowed phrases for this ad group
}
  ];

  campaignsAndAdGroups.forEach(function(entry) {
var campaignName = entry.campaignName;
var adGroupName = entry.adGroupName;
var allowedPhrases = entry.allowedPhrases;

Logger.log(“Processing Campaign: ” + campaignName + ” Ad Group: ” + adGroupName);

var adGroupIterator = AdsApp.adGroups()
   .withCondition(‘CampaignName = “‘ + campaignName + ‘”‘)
   .withCondition(‘AdGroupName = “‘ + adGroupName + ‘”‘)
   .get();

if (adGroupIterator.hasNext()) {
   var adGroup = adGroupIterator.next();
   Logger.log(“Found Ad Group: ” + adGroup.getName());
   processAdGroup(adGroup, allowedPhrases);
} else {
   Logger.log(“Campaign ‘” + campaignName + “‘ or Ad Group ‘” + adGroupName + “‘ not found.”);
}
  });
}

function processAdGroup(adGroup, allowedPhrases) {
  var adGroupId = adGroup.getId();

  var reportQuery = “SELECT Query, QueryMatchTypeWithVariant, KeywordTextMatchingQuery ” +
“FROM SEARCH_QUERY_PERFORMANCE_REPORT ” +
“WHERE AdGroupId = ” + adGroupId +
” DURING LAST_30_DAYS”;

  Logger.log(“Querying Search Term Report for Ad Group ID: ” + adGroupId);

  var searchTermReport = AdsApp.report(reportQuery);

  var keywordsIterator = adGroup.keywords()
.withCondition(“Status = ENABLED”)
.get();

  Logger.log(“Processing keywords for Ad Group: ” + adGroup.getName());

  var keywords = [];
  while (keywordsIterator.hasNext()) {
var keyword = keywordsIterator.next();
var keywordMatchType = keyword.getMatchType();
Logger.log(“Found Keyword: ” + keyword.getText() + ” (Match Type: ” + keywordMatchType + “)”);
keywords.push({
   keywordText: keyword.getText().toLowerCase(),
   matchType: keywordMatchType
});
  }

  if (keywords.length === 0) {
Logger.log(“No enabled keywords found for Ad Group: ” + adGroup.getName());
return;
  }

  var rows = searchTermReport.rows();
  var foundTerms = false;

  while (rows.hasNext()) {
foundTerms = true;
var row = rows.next();
var searchTerm = row[“Query”].toLowerCase();
Logger.log(“Processing Search Term: ” + searchTerm);

if (isSearchTermAllowed(searchTerm, allowedPhrases)) {
   Logger.log(“Search term ‘” + searchTerm + “‘ contains an allowed phrase. Skipping.”);
   continue;
}

if (isSearchTermSafe(searchTerm, keywords)) {
   Logger.log(“Search term ‘” + searchTerm + “‘ matches an enabled keyword. Skipping.”);
   continue;
}

adGroup.createNegativeKeyword(searchTerm);
Logger.log(“Added negative keyword: ” + searchTerm + ” in Ad Group: ” + adGroup.getName());
  }

  if (!foundTerms) {
Logger.log(“No search terms found for Ad Group: ” + adGroup.getName());
  }
}

function isSearchTermAllowed(searchTerm, allowedPhrases) {
  for (var i = 0; i < allowedPhrases.length; i++) {
if (searchTerm.includes(allowedPhrases[i].toLowerCase())) {
   return true;
}
  }
  return false;
}

function isSearchTermSafe(searchTerm, keywords) {
  var keywordTypesToCheck = [“EXACT”, “PHRASE”, “BROAD”];

  for (var i = 0; i < keywords.length; i++) {
var keyword = keywords[i];
var keywordText = keyword.keywordText;

Logger.log(“Checking keyword ‘” + keywordText + “‘ with match type: ” + keyword.matchType);

if (!keywordTypesToCheck.includes(keyword.matchType)) {
   Logger.log(“Skipping keyword ‘” + keywordText + “‘ as it is of type: ” + keyword.matchType);
   continue;
}

// Exact match logic
if (keyword.matchType === “EXACT”) {
   if (searchTerm === keywordText) {
     Logger.log(“Exact match found for search term: ” + searchTerm + ” with keyword: ” + keywordText);
     return true;
   }