Free editable template

Negative keyword review template

Turn search-term observations into specific exclusion decisions. This worksheet helps you record why a query is irrelevant, which scope the proposed negative affects and what useful demand it might accidentally block.

By GaaS editorial · Sources checked · 16 worksheet rows

Download the editable CSV

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.

How to use the template

Review intent before imposing a cost threshold

A search can be irrelevant even before it has enough clicks for a performance judgment. Conversely, a relevant query with no mature conversions is not automatically waste. Record both the business relevance and the reporting maturity so the proposed action has a clear reason.

Specify text, match type and scope

Those three fields define the exclusion. Google documents different behavior for negative broad, phrase and exact match. Negative terms do not expand in the same way as positive keyword close variants. Read the current provider examples before assuming a proposed rule covers every unwanted query.

Look for useful demand the rule could block

Compare the proposal with products, services and campaign intent elsewhere in the account. A term that is irrelevant to one ad group can be valuable to another. Shared lists and account-level settings widen the effect, so record their actual assignment before approval.

Verify configuration and later outcomes separately

After the authorized change, confirm the saved text, match type and scope. Use a subsequent compatible reporting window to inspect the resulting query mix. A saved negative proves a configuration change; it does not by itself prove improved profitability or complete exclusion coverage.

Preview the worksheet

Every row shown here is included in the download. Scroll the table horizontally on a small screen.

Review fieldWhat to recordIllustrative example
Review scopeAccount, campaign and mature date rangeOne Search campaign; complete reporting window
Observed queryExact search term from the reportchair repair manual
Matched contextCampaign and ad group where it appearedA fictional shop selling finished office chairs
Business relevanceWhat the searcher wants and whether you supply itRepair instructions; shop does not sell repairs or manuals
Spend evidenceCompatible cost and outcome scopeRecord actual totals, not invented benchmarks
MaturityWhether useful outcomes had time to arriveDocument the conversion lag allowance
Intent decisionKeep, investigate or propose exclusionPropose exclusion based on irrelevant intent
Proposed negativeExact text under considerationchair repair manual
Match typeNegative broad, phrase or exactExact proposed for this query; review coverage separately
ScopeAd group, campaign, list or account eligibilityThis campaign only, subject to review
Useful-query checkRelevant searches that could be excludedCheck whether useful repair-related products exist elsewhere
Existing exclusionsRelated negatives and shared-list assignmentsInspect current scope before adding another rule
VariantsSeparate relevant language and term variantsDo not assume negative matches expand like positive keywords
ApprovalPerson and exact change authorizedText, match type, scope and reason
ReadbackActual saved exclusion configurationVerify the correct negative and applied scope
Later reviewWhat subsequent comparable queries showSeparate pre-change from post-change dates

Worked review example

A fictional office-chair retailer sees chair repair manual in a Search report. If it sells only finished chairs, the intent is a plausible exclusion candidate. The worksheet records the exact query, the business mismatch and a proposed exact negative for the reviewed campaign.

If another campaign sells chair parts, a broad account-wide exclusion around repair could block useful demand. The useful-query check changes the scope decision. The example is not a recommended negative keyword for every retailer.

What this template does and does not establish

This is a review brief for one proposal; duplicate the block for additional findings. It is not a universal negative-keyword list or a Google Ads import file. It does not inspect your account, automatically exclude terms or guarantee that a query will stop serving.

Primary references

Continue the work