Open the CSV in Excel, or import it into Google Sheets and choose comma-separated values. Save your working copy in a controlled location. The CSV contains the rows below and space for your notes; it has no macros, formulas or live account connection. The separate Excel workbook contains editable example inputs and formulas that update the forecast.
How to use the template
Pull the report
In Google Ads go to Campaigns > Insights and reports > Search terms. Choose the last 30 days, add the Conversions column, download it and paste search term, campaign, match type, impressions, clicks, cost and conversions into the Search terms tab.
Edit the word list
On the Words tab, delete any word your customers use (a firm offering a free consultation keeps 'free'), add your own, and choose broad, phrase or exact for each. Plurals need their own row: negatives don't match close variants.
Check before you block
A word goes on the block list only if no search containing it converted. Words that did convert go to a check-first list, with the exact bad searches suggested as phrase negatives instead.
Apply and repeat
Paste the Negatives tab into a shared negative keyword list and apply it to your Search campaigns. Work through the review list, add the promoted terms as exact keywords, and repeat weekly for new campaigns, monthly for stable ones.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Theme | Starter words | Suggested negative match |
|---|---|---|
| Free and cheap | free, freebie, cheap, coupon | Phrase |
| Jobs and careers | jobs, job, salary, hiring, careers, career, internship, resume | Phrase |
| Learning | course, courses, certification, training, class, degree | Phrase |
| DIY and research | how to, diy, template, tutorial, what is | Phrase |
| Used and rental | used, rent, rental | Phrase |
| Review: no conversions | Any term with no conversions after 1 x target CPA | Phrase, for the exact search |
| Promote | 2+ conversions at or under target CPA, not already exact match | Add as an exact-match keyword |
| Watch | Converts, but at more than 2 x target CPA | None yet |
Worked review example
Fictional bookkeeping firm: 20 search terms cost $8,735 in 30 days for 80 leads ($109 each) against an $80 target. Terms containing flagged words with zero leads cost $2,240, or 25.6% of the search budget.
'Free bookkeeping consultation' brought 3 leads for $135, so 'free' goes to the check-first list and the block list gets 'free bookkeeping software' as a phrase instead. The block list: jobs, salary, course, certification, template and 'what is'. Three terms convert under target and get promoted to exact keywords. Had the $2,240 not been spent and every lead still come in, cost per lead would have been $81.
What this template does and does not establish
Google omits searches without enough query activity, so the report never shows all your spend. Word matching can't judge intent; read every check-first and review row. Conversions arrive late, so a term with none today may convert next week. The 1x review, 2x watch and 2-conversion promote rules are our starting points, not Google rules. Example data is fictional.
Primary references
- Google Ads Help: About the search terms report
- Google Ads Help: About negative keywords
- Google Ads Help: About negative keyword lists
- Google Ads Help: About account-level negative keywords
- Seer Interactive: Google Ads removes search terms for 28% of paid search budgets (2020)
- Webtonic: Negative keywords in Google Ads
