Negative Keyword Manager
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
Overview
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.
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 matches your settings tab.
- 5Preview to populate the sheet, mark your decisions, then schedule daily to apply them.
Configuration Variables
| Variable | Default |
|---|---|
INPUT_SHEET_URL | YOUR_SPREADSHEET_URL_HERE |
INPUT_TAB_NAME | Settings |
EMAIL_DURING_PREVIEW | false |
NUMBER_OF_FILTERS | 6 |
Expected Output
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.
Notes
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.