Free editable template

Google Search terms audit and negative-keyword sheet

Stop paying for searches that will never buy. Paste the search terms report and the workbook flags every term containing a word from an editable starter list, checks whether any search with that word converted, writes the block list in Google's syntax ready for a shared negative keyword list, lists the terms to review by hand, and finds terms that convert cheaply enough to promote to exact-match keywords.

By GaaS editorial · Sources checked · 8 worksheet rows

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.

ThemeStarter wordsSuggested negative match
Free and cheapfree, freebie, cheap, couponPhrase
Jobs and careersjobs, job, salary, hiring, careers, career, internship, resumePhrase
Learningcourse, courses, certification, training, class, degreePhrase
DIY and researchhow to, diy, template, tutorial, what isPhrase
Used and rentalused, rent, rentalPhrase
Review: no conversionsAny term with no conversions after 1 x target CPAPhrase, for the exact search
Promote2+ conversions at or under target CPA, not already exact matchAdd as an exact-match keyword
WatchConverts, but at more than 2 x target CPANone 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

Continue the work