Negative Keyword Conflict Checker
Flags potential conflicts where converting search terms may be blocked or constrained by existing negative keywords.
Script Code
Useful QA script to catch negative-keyword rules that can suppress valuable traffic.
Preview is public. Unlock full code with name and email.
/**
* ==========================================================
* Negative Keyword Conflict Checker
* ==========================================================
* Description: Compares converting search terms against
* negatives to find potential blocking conflicts.
*
* Copyright (c) 2026 TwoSquares. All Rights Reserved.
* Developed by Kiril Ivanov
*/
function main() {
var SPREADSHEET_URL = "";
var SHEET_NAME = "Negative Conflicts";
var LOOKBACK_DAYS = 60;
// ... preview shortened
}About This Script
Negative Keyword Conflict Checker compares converting search terms against account, campaign, and ad group negative keywords to find potential blocking conflicts. It helps prevent accidental suppression of valuable intent.
The script is deliberately conservative and outputs review candidates, not automatic changes. That keeps control with your PPC team while still surfacing high-risk conflicts quickly.
Output can be written to Google Sheets. If spreadsheet URL is blank, it auto-creates a new spreadsheet; if provided, it writes to that file and creates tab when missing.
Implementation Notes
- Set LOOKBACK_DAYS and MIN_CONVERSIONS to control how strict the converting-term set should be.
- Leave SPREADSHEET_URL blank for auto-create or provide an existing URL.
- Run manually and review flagged rows before removing negatives.
- Schedule monthly (or after major negative-list updates) as a QA check.
More Scripts In This Library
MCC Negative Keyword Conflict Checker
Runs across manager-account children, compares enabled keywords to campaign and ad group negatives, and exports likely conflicts into Google Sheets.
Search Term N-Gram Waste Finder
Aggregates expensive non-converting n-grams from search terms to speed up negative keyword decisions.
Search Term Waste Finder
Finds high-cost, non-converting search terms, prioritizes them by wasted spend, and can send an optimization digest by email.
Delete Disapproved Ads
Finds ads with non-approved policy status and removes them, with a dry-run mode enabled by default for safer review first.
Negative Keyword Conflict Checker FAQs
Common setup, usage, and troubleshooting questions for this script.