Search Term N-Grams (Standard Shopping)
2 installs
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.
n-grams
search terms
shopping
negative keywords
reporting
by Charles Bannister (shabba.io)·shabba.io/google_ads_scripts/search-term-ngrams-shopping
Overview
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.
Setup
- 1Copy the Google Sheet template linked on the source page.
- 2In Google Ads, go to Tools → Bulk Actions → Scripts.
- 3Click + to create a new script and paste the code below.
- 4Set INPUT_SHEET_URL and confirm INPUT_TAB_NAME.
- 5Authorize, preview, then schedule weekly.
Configuration Variables
| Variable | Default |
|---|---|
INPUT_SHEET_URL | YOUR_SPREADSHEET_URL_HERE |
INPUT_TAB_NAME | Settings |
Expected Output
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.
Notes
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.