Breaks Standard Shopping search terms into 1-, 2- and 3-word n-grams with aggregated metrics, for reporting, alerts, or building negative keywords around wasteful patterns.
by Charles Bannister (shabba.io)·shabba.io/google_ads_scripts/search-term-ngrams-shopping
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.
Aggregates Standard Shopping search-term performance by word combination (n-grams) so systemic waste and opportunity show up as patterns rather than one-off queries. Results land in a Google Sheet. Use it to find recurring words that drive spend without conversions and turn them into negatives.
| Variable | Default |
|---|---|
INPUT_SHEET_URL | YOUR_SPREADSHEET_URL_HERE |
INPUT_TAB_NAME | Settings |
Parsed 3,500 Shopping search terms into n-grams. Top waste 1-gram: "free" — $240 spend, 0 conv. Aggregated 1/2/3-word tables written to the sheet.
THIRD-PARTY DEPENDENCY: requires a copied shabba.io Google Sheet template; the script self-reports run info to shabba by default. Filters/config live in the sheet.