Google Ads Search Terms Report Filters That Surface Waste

The search terms report filter that finds the most waste is cost greater than your target CPA, conversions equal to 0, over the last 90 days. Each term it returns has already cost you a full conversion and given you nothing back. After that, run a watch list (cost above half your CPA, zero conversions, at least 3 clicks), then a word-count check on a spreadsheet export, because the Google Ads interface cannot filter by word count.
Sorting by cost alone shows you mostly your brand and core keywords, which are your best terms. Filters that use your CPA as the threshold show you the waste. Set the date range so it ends a week or two before today, so slow conversions have time to come in. Before you block anything, filter out terms that are already excluded.
Why "sort by cost" finds your best terms, not your waste
Sorting the search terms report by cost puts your highest-spending terms at the top. In most accounts those are your brand name and your core keywords, which are also the terms that convert. The standard advice ("open the report, sort by cost, look for anything irrelevant") isn't wrong. It just starts in the place where you're least likely to find anything to block.
Waste rarely sits in the top ten rows. It's spread across hundreds of terms that each cost $15, $40 or $70 and never converted. A cost sort ranks them below your winners, and on page three nobody is reading carefully any more. The pages that currently rank for this topic mostly stop at "sort by cost, then by conversions." That leaves you with two lists and no rule for deciding what counts as too much.
Filters give you that rule. If you tie each filter to a number you already know, usually your target CPA, the report returns only the rows that need a decision. The rest of this article covers six filter combinations, the order to run them in, and what none of them can show you.
All the examples below use a target CPA of $60. Use your own number. For an account that bids on value, swap CPA for a cost threshold based on your target ROAS. The logic stays the same.
Set the date range before you set any filter
Use the last 90 days, ending 7 to 14 days before today. A filter for zero conversions is only as good as the date range behind it, and the default ranges work against you.
Two things go wrong with short or recent date ranges:
- Conversion lag. Google Ads credits a conversion to the date of the click, not the date of the conversion. A term clicked yesterday that converts next Tuesday shows zero conversions today. If your sales cycle is longer than a few days, a "last 7 days" filter for zero conversions will flag terms that are still in progress. Ending the range a week or two back gives them time.
- Too little data per term. Over 7 days, almost every term has one or two clicks. Nothing crosses a CPA threshold, so the filter returns nothing and you decide the account is clean.
Ninety days also matches the rule PPCleaner uses: it never blocks a term that converted in the last 90 days. A term that converted 80 days ago and has been quiet since is not waste. It may be seasonal or low-volume, and it deserves a look before it gets blocked.
For very small accounts, where even 90 days gives most terms only a click or two, the per-term filters below will return little. In that case the word-count and modifier filters matter more. The article on low-volume terms that add up covers how to judge terms in groups instead of one at a time.
Filter 1: Cost above target CPA, conversions equal to 0
This is the filter to run first. Cost > $60 and Conversions = 0, over your 90-day window. Every row it returns has spent a full conversion's worth of budget and produced nothing.
In the Google Ads interface, open the search terms report, add a filter on Cost (greater than 60), then add a second filter on Conversions (equals 0). Both filters apply together.
Here's what this might return for a plumbing business:
| Search term | Clicks | Cost | Conversions |
|---|---|---|---|
| plumber salary | 21 | $64 | 0 |
| plumbing apprenticeship near me | 18 | $72 | 0 |
| how to fix a running toilet | 40 | $88 | 0 |
| plumbing supply store | 15 | $61 | 0 |
| water heater for sale | 19 | $95 | 0 |
| emergency plumber [competitor name] | 25 | $100 | 0 |
Six terms, $480 in total, and none of them are hard calls. Two are job searches, one is DIY, two are product searches from people who want to buy parts rather than hire someone, and one is a competitor's brand.
Before you block them, check the match type of each one. "plumber salary" is safe to block as a phrase negative on "salary". "how to fix a running toilet" is more delicate: blocking "how to" as a phrase would also catch "how to find an emergency plumber tonight". A single-term exact negative is the safer choice there. The guides on exact match negatives and phrase match negative examples explain how to choose.
What this filter misses: anything below one CPA. In most accounts, most waste sits there. That's what Filter 2 is for.
Filter 2: Half a CPA, zero conversions, at least 3 clicks
The second filter is a watch list: Cost between $30 and $60, Conversions = 0, Clicks ≥ 3. These terms haven't failed yet. They're on their way to failing.
The click minimum is what makes this filter useful. Without it, you get rows with one expensive click, and one click tells you almost nothing. Three or more clicks with no conversion is a pattern you can judge. If your conversion rate is low, raise the minimum to 5.
Don't block everything this filter returns. Sort it into three groups:
- Obviously off-intent. "plumbing jobs", "free plumbing estimate template", "plumber meme". Block these now. Waiting for them to reach $60 means paying $30 more to learn what you already know.
- Plausible but unproven. "tankless water heater repair cost". Someone researching a price can still hire you. Leave these and check again next month.
- Relevant, but your page or offer doesn't match. "commercial plumbing contractor" in a residential-only account. Usually block this. Sometimes it's a sign of a service you could add.
The second group is where you need to be careful. Question searches and price searches often sit there, and blocking them too early can cut off real demand. If you're unsure, the article on testing question searches before blocking them gives a way to decide.
Filter 3: Five words or more (export to a spreadsheet)
Long search terms are worth filtering on their own, because broad match and AI-driven matching tend to put your ads on long, specific queries that have little to do with your keyword. The catch is that the Google Ads interface has no word-count filter. You have to export the report.
Download the search terms report for your 90-day window as a CSV, open it in Google Sheets or Excel, and add a column with this formula (search term in column A):
=IF(LEN(TRIM(A2))=0,0,LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2)," ",""))+1)
It counts the spaces and adds one. Then filter the sheet to word count ≥ 5 and conversions = 0, and sort by cost.
Here's what this filter tends to show:
- Full questions: "can i replace a toilet flapper myself without tools"
- Very specific product searches: "kohler highline toilet tank lid replacement part"
- Searches meant for someone else: "plumber who fixed my sink last week review"
- Location strings outside your area: "emergency plumber open now springfield illinois", which leads into wrong-location clicks
Each of these terms usually costs very little. What this filter shows you is the overall pattern. When you read 80 long, non-converting terms in a row, the same words keep coming up: "myself", "diy", "part", "replacement", "review". Those repeated words are your phrase negatives. One term at a time, none of them would have looked worth blocking.
Don't block long terms just because they're long. In some accounts, especially B2B or high-ticket services, the five-word searches convert best because the buyer knows exactly what they want. That's why this filter also requires zero conversions.
Filter 4: One or two words with a high cost
At the other end, word count ≤ 2, cost > your CPA, conversions = 0 finds short, broad terms that bring in mixed intent at a high price. Use the same spreadsheet export and flip the word-count condition.
Terms like "plumbing", "toilets", "water heater" or "drain" bring in students, DIYers, shoppers, people looking for jobs and actual customers, all at the price of a broad commercial click. A one-word term with $150 of spend and no conversions doesn't always mean you should block it. More often it means a broad or phrase keyword is matching too widely.
What to do depends on the term:
- If the word is never useful alone ("toilets" for a service business), add it as an exact negative. That blocks the single word and leaves "toilet repair near me" alone.
- If it's sometimes useful, look at the keyword it matched. Use the keyword column or the match type column in the report. Tightening that keyword may fix the problem more cleanly than any negative.
Exact negatives are the right tool for short terms. A phrase negative on "drain" would block "drain cleaning service", which is probably one of your best searches.
Filter 5: Converted, but at more than twice your target CPA
Not every expensive term should be blocked. Conversions ≥ 1 and Cost / conv. > $120 (twice the $60 target) finds terms that work, but at a price that pulls your average up.
Don't add these as negatives. They converted, and PPCleaner won't block them for exactly that reason: a term with a recent conversion is evidence, even if it's expensive. Your options here are different:
- Add the term as its own exact-match keyword so you can set its bid or watch its CPA on its own.
- Check whether the landing page fits the query. "24 hour plumber" landing on a page that never mentions 24-hour service will convert badly however you bid.
- Accept it. A term at $130 per conversion that brings in high-value jobs may be worth more than three $40 conversions for small repairs. Without value data, you can't tell.
This filter is in the list because it keeps you from adding these terms as negatives by mistake. When you review Filter 1 and Filter 2 straight after a cost sort, expensive converters get mixed in with the waste. Separating them first means everything else you review is a real candidate for blocking.
Filter 6: "Contains" filters for known modifier words
The Search term filter in the interface supports contains. Add a contains filter for each high-risk modifier, combined with Conversions = 0, and you get a quick list without exporting anything.
Words that show up as waste in many accounts:
- Jobs and careers: salary, jobs, hiring, career, apprenticeship, course, certification, training
- DIY and information: diy, how to, myself, tutorial, video, youtube, manual, pdf
- Free and cheap: free, template, sample, cheap (be careful with "cheap": for some businesses it's a buying word)
- Wrong product: parts, for sale, wholesale, amazon, used
- Navigation to someone else: login, phone number, reviews, competitor names
Run each one separately rather than combining them. The interface joins filters with AND, so "contains salary" and "contains jobs" together only return terms with both words. One modifier per filter, then save each view.
Treat this list as a starting point, not something to paste in as negatives. "Training" is waste for a plumber and a buying word for a dog trainer. "Parts" is waste for a repair service and the main business of a parts retailer. If you sell something, check the modifier against your own catalogue first. If you serve several kinds of customer, the guide on negative keywords for service businesses by intent sorts them by buyer type.
Remove what you've already handled
Before acting on any of the filters above, filter out terms that are already excluded. Otherwise you'll spend half your review time re-deciding blocks you made last month.
The search terms report has an Added/Excluded column showing whether a term has already been added as a keyword, added as a negative, or neither. Filter it to show only terms that are neither. Your 90-day window still shows the cost a term ran up before you blocked it, so without this filter, last month's fixes keep appearing as if they were new problems.
A term that's already excluded but still shows recent cost is worth a closer look. Check the dates first. If it kept spending after you blocked it, the negative is probably at the wrong level (ad group instead of campaign), on the wrong match type, or on a campaign type where it doesn't apply the way you'd expect. The article on adding negatives from search terms without guessing covers the levels.
What these filters cannot show you
Filters work on the rows the report contains. Some of your spend isn't in those rows, and no filter will find it.
- Hidden terms. Google hides search terms that don't reach its privacy thresholds. Their cost counts toward your campaign totals but doesn't appear as rows. If the costs in your report add up to well under your campaign spend, that gap is why. See search terms hidden by privacy for what you can still do about it.
- Campaign types with no search terms. Search, Shopping and Performance Max report search terms (in the API, all three come from
campaign_search_term_view). Display, Video and App report none, so none of these filters apply to them. - Performance Max limits. The search terms Performance Max reports are more limited than those for Search, and its search term insights are grouped categories, not raw queries. The article on why search term insights are not queries explains the difference. When you do block PMax terms, remember that a Performance Max campaign accepts up to 10,000 campaign-level negative keywords and does not accept shared negative keyword lists. Standard Shopping accepts both, like Search.
- Bad clicks on good terms. "emergency plumber near me" with zero conversions doesn't mean the term is wrong. It may point to a slow page, a missed phone call or bad call tracking. A negative keyword won't fix any of that, and blocking a good term because the page failed makes things worse.
- Network. The default view combines Google Search and search partners. Add the network segment to see whether a term's waste comes from partners. The article on search partners wasted spend covers what to do if it does.
The zero-conversions filter also depends on conversion tracking. If a conversion action broke for two weeks, every term from those two weeks looks like waste. Check the conversions trend for the campaign before trusting any filter.
Save the filters and run them in order
Google Ads lets you save a set of filters and reapply it later. Build the six views once, name them clearly, and go through them in the same order each time:
- Already handled: Added/Excluded = none. Apply this to every view below.
- Over CPA: Cost > $60, Conversions = 0. Block almost everything.
- Watch list: Cost $30 to $60, Conversions = 0, Clicks ≥ 3. Block the obvious ones, note the rest.
- Modifiers: one saved view per high-risk word, Conversions = 0.
- Expensive converters: Conversions ≥ 1, Cost / conv. > $120. Change the keyword or page, don't add a negative.
- Word count, monthly: export, run the formula, review ≥ 5 words and ≤ 2 words.
The first five take a few minutes once they're saved. The export takes longer, so once a month is enough for most accounts. For a full review routine around these views, see how to analyze a search terms report in 20 minutes.
How often you run them matters as much as which ones you run. A term that reaches $60 with no conversions over a quarter cost you $60, but it also spent that quarter feeding non-converting clicks into Smart Bidding. That's covered in how junk queries skew your bids. Running the filters monthly catches less than running them weekly, and weekly catches less than daily.
This is the work PPCleaner automates. Every night it reads the search terms from your Search, Shopping and Performance Max campaigns, judges which ones were never going to convert, and adds them as negatives. It never blocks a term that converted in the last 90 days, and every block can be undone in one click for 90 days. It doesn't touch bids, budgets, ads or keywords, so Filter 5 (expensive converters) stays your decision. It also can't see the hidden terms Google leaves out of the report, which is true of every tool.
Frequently asked
Can you filter the Google Ads search terms report by number of words?
No. The interface has no word-count filter. Export the report to Google Sheets or Excel and add a column with =IF(LEN(TRIM(A2))=0,0,LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2)," ",""))+1). It counts the spaces and adds one, giving you the word count. You can then filter on it however you like.
What date range should I use for a zero-conversions filter?
Use the last 90 days, ending 7 to 14 days before today. Google Ads credits conversions to the click date, so recent clicks that are still going to convert show zero today. A short range like 7 days also gives each term too few clicks to judge.
Should I block search terms that converted but at a high CPA?
Usually not. A term that converted is working, just expensively. Add it as its own exact-match keyword so you can manage it on its own, check whether the landing page fits the query, or accept the cost if those conversions are worth more. PPCleaner never blocks a term that converted in the last 90 days.
Why does my search terms report not add up to my campaign cost?
Google hides search terms that don't meet its privacy thresholds. Their cost still counts toward campaign totals, but they don't appear as rows, so no filter can find them. The gap is usually biggest in accounts with many low-volume searches.
Can I combine several 'contains' filters for modifier words?
Not the way you'd expect. Filters in the interface are joined with AND, so 'contains salary' plus 'contains jobs' only returns terms that have both words. Create one saved filter per modifier instead.
Clean your search terms. Save time and money.
Every night, PPCleaner reviews the searches your campaigns actually paid for, groups them by intent, and excludes the ones that never convert. No spend threshold to wait for, nothing touched but negatives — and one click undoes any of it.
Start 7 days freeSearch, Shopping and Performance Max · Cancel in one click
Related articles

Google Ads Reviews Searches Wasted? Measure Before Blocking
The usual advice is to add "reviews" and "complaints" as negatives. Some of these searches come from people one step from buying, so measure what they assist before you block them.

Misspelled Search Terms in Google Ads and Which to Block
Close variants send you typos of the queries you want and typos of the ones you don't. Most misspellings are harmless and convert fine. A few are a different search altogether, and your negative list won't catch them.

Google Ads Search Terms Review Checklist in 15 Minutes
A weekly search terms review only works if every term gets the same decision every time. Here is a 15-minute checklist and a five-question decision tree for block, keep or add as keyword, including the borderline cases.
