Managing your Site Disavow File

I am sure there are programs out there that can manage your site disavow file better than what I am about to tell you.

If you care about SEO, you probably have concerns about the number of unrequested backlinks that have come to Google Search Console’s attention.

The report shows 1000 referring domains that you can keep or disavow.

You can export that list, check each one of the referring domains and disavow the ones that suck.

The next time you check, you will notice that some of the referring domains that you check are now gone and that there are new ones.

Comparing the two sheets to see what the new referring domains are can be a pain in the *ss.

---

Script for Google Sheets

This script can compare two columns, the column with the referring domains you already check and the new referring domains from the latest Google Search Console.

The script will highlight in red the cells with the new domains.

function highlightUnmatchedCells() {
  // Get the active spreadsheet and the active sheet
  var spreadsheet = SpreadsheetApp.getActive();
  var sheet = spreadsheet.getActiveSheet();

  // Get the values from columns A and B
  var valuesA = sheet.getRange("A1:A10").getValues().flat();
  var valuesB = sheet.getRange("B1:B10").getValues().flat();

  // Convert all values to lowercase
  valuesA = valuesA.map(function(value) {
    return value.toLowerCase();
  });
  valuesB = valuesB.map(function(value) {
    return value.toLowerCase();
  });

  // Loop through the values in column B
  for (var i = 0; i < valuesB.length; i++) {
    // Check if the current value in column B is not in column A
    if (valuesA.indexOf(valuesB[i]) == -1) {
      // If not, highlight the cell in column B
      sheet.getRange(i + 1, 2).setBackground("red");
    } else {
      // If it is in column A, unhighlight the cell
      sheet.getRange(i + 1, 2).setBackground(null);
    }
  }
}