Finds high-performing search terms not yet added as keywords, using fuzzy matching to skip terms already effectively covered, so you surface genuinely new keyword opportunities.
by Charles Bannister (shabba.io)·shabba.io/google_ads_scripts/keyword-discovery-fuzzy
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.
Scans search terms for strong performers that are not already keywords, using fuzzy matching to ignore near-duplicates of existing keywords and an ignore-list to suppress ones you have already reviewed. Surfaces candidates in a Google Sheet with a preview email. Use it to expand coverage on proven queries.
| Variable | Default |
|---|---|
INPUT_SHEET_URL | YOUR_SPREADSHEET_URL_HERE |
INPUT_TAB_NAME | Settings |
NUMBER_OF_FILTERS | 6 |
OVERRIDE_PREVIEW_EMAIL | false |
Reviewed 900 search terms against existing keywords (fuzzy). 41 new keyword candidates surfaced (not near-duplicates, not ignored). Candidates written to the sheet; preview email sent.
THIRD-PARTY DEPENDENCY: requires a copied shabba.io Google Sheet template that drives filters and the ignore-list. Detects MCC vs single-account automatically. Config lives in the sheet.