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.
Script Code
Use this when you want a manager-account level negative-keyword QA script with spreadsheet output and optional email alerts.
Preview is public. Unlock full code with name and email.
/**
* ==========================================================
* MCC Negative Keyword Conflict Checker
* ==========================================================
* Description: Runs across child accounts in an MCC and
* exports likely negative keyword conflicts to Google Sheets.
*
* Copyright (c) 2026 TwoSquares. All Rights Reserved.
* Developed by Kiril Ivanov
*/
const CONFIG = {
SPREADSHEET_URL: 'YOUR_SPREADSHEET_URL',
COPY_SPREADSHEET: false,
RECIPIENT_EMAILS: [],
CLIENT_IDS: [],
CAMPAIGN_LABEL: '',
MAX_POSITIVES: 250000,
MAX_NEGATIVES: 50000,
API_VERSION: 'v22'
};
// ... preview shortened
}About This Script
MCC Negative Keyword Conflict Checker is built for manager accounts that need a scalable way to review likely blocking conflicts between enabled positive keywords and existing negative keywords. It is designed as a review workflow, not an auto-fix tool.
The script runs across selected child accounts using executeInParallel, collects enabled positive keywords plus campaign and ad group negatives, then applies conservative text-matching rules to surface likely conflicts. Results are written into a Google Sheet with account, campaign, ad group, and conflict scope context.
This version updates the older pattern to current Google Ads Scripts conventions and avoids outdated field naming. It also fixes several practical issues in the original draft, including spreadsheet copy handling, row batching, account-context handling, and missing ad group references on positive keyword entries.
Implementation Notes
- Replace YOUR_SPREADSHEET_URL with a real Google Sheet URL, or keep a dedicated template sheet for copying.
- Optionally add recipient emails, child account IDs, and a campaign label filter.
- Paste the script into a manager-account Google Ads Script, not a single account script.
- Run manually once to validate spreadsheet permissions, account selection, and output volume.
- Schedule it monthly or after major negative-keyword updates so conflicts are reviewed before they suppress useful traffic.
More Scripts In This Library
Campaign Underspending Alert
Flags campaigns and shared budgets that are underspending against expected budget pace, with support for yesterday or intraday checks.
Negative Keyword Conflict Checker
Flags potential conflicts where converting search terms may be blocked or constrained by existing negative keywords.
Paused Keyword Export
Exports paused keywords with campaign and ad group context into a Google Sheet for quick account cleanup and review.
Account Anomaly Detector
Compares today’s account performance against the same weekday across previous weeks and alerts when impressions, clicks, conversions, or cost move outside expected bounds.
MCC Negative Keyword Conflict Checker FAQs
Common setup, usage, and troubleshooting questions for this script.