Streamlines search-term review from a Google Sheet: mark each term to ignore, exclude, or add as a keyword, and the script applies your decisions on the next run.
by Charles Bannister (shabba.io)·shabba.io/google_ads_scripts/negative-keyword-manager
Reviews search terms and adds negative keywords automatically using AI-evaluated rules you configure in a companion admin panel, with email summaries of every change.
Uses Claude AI to analyze your search terms and recommend negative keywords with clear reasoning. Each term is evaluated for business relevance, intent, and conversion potential — then exported to a Google Sheet with actionable suggestions.
Sheet-driven negative keyword automation: define rules in a spreadsheet and the script adds negatives and emails alerts about irrelevant search terms without manual monitoring. Supports MCC.
Finds brand search terms leaking into non-brand campaigns (inflating their stats and misleading Smart Bidding) and generic traffic riding in brand campaigns — with the misrouted spend quantified.
Measures how much of your exact-match spend actually flows through close variants and lists the zero-conversion variants — the most surgical negative keyword candidates in the account.
Reads negative keywords and placement exclusions from a Google Sheet and syncs them to multiple campaigns via shared negative keyword and placement lists. Optionally filters to campaigns with a specific label.
Turns search-term triage into a spreadsheet workflow: the script exports qualifying terms into a sheet with dropdowns, you choose an action per row (ignore / exclude / add as keyword), and the next run executes those choices. Filters (up to six) control which terms surface. Good for teams that want a human in the loop.
| Variable | Default |
|---|---|
INPUT_SHEET_URL | YOUR_SPREADSHEET_URL_HERE |
INPUT_TAB_NAME | Settings |
EMAIL_DURING_PREVIEW | false |
NUMBER_OF_FILTERS | 6 |
Exported 120 new search terms to the sheet for review. Applied last run's decisions: 8 excluded, 3 added as keywords, 20 ignored. Email summary sent.
THIRD-PARTY DEPENDENCY: requires a copied shabba.io Google Sheet template that provides the review UI and dropdowns; the script self-reports run info to shabba by default. Most configuration happens in the sheet.