Search Terms Report Analyzer: Free Google Ads Negative Keyword Tool

Free tool · Google Ads · No sign-up

Find the search terms wasting your Google Ads budget

Drop in your Google Ads search terms report. The analyzer shows which searches spent money without a conversion, adds them up into word patterns, and builds exact and phrase negative keywords ready for Google Ads Editor. Your file is read in this browser tab and never uploaded.

  • Search terms report CSV
  • Wasted spend by term and by word
  • Exact and phrase negatives
  • Conflict check against converting searches
  • Google Ads Editor CSV
  • Free, no login

Key Observations

  • Search term vs keyword: a search term is what a person typed. A keyword is what you bid on. The search terms report shows the gap between the two, with cost attached.
  • Where to find it: in Google Ads, open Campaigns, then Insights and reports, then Search terms, and download the table as CSV.
  • How a term is flagged: zero conversions plus at least your minimum clicks or minimum cost. By default the cost line is your own average cost per conversion in the file.
  • Safe negatives: Google does not match negatives to plurals or close variants, and this tool never suggests a word that appears in a search that converted.
  • Hidden spend: Google leaves low-volume searches out of the report for privacy, so it never adds up to your full spend. The tool shows the hidden share when your export includes it.
or paste the rows

Privacy: the file is read by JavaScript in this tab. Nothing is sent to a server or saved, and closing the tab clears it.

Want the whole account checked, not just search terms?

Our Google Ads team reviews your search terms, match types, bidding and conversion tracking, then tells you what to fix first.

Get Free Audit Worth $500

How do you use the search term analyzer?

Export the search terms report from Google Ads, drop the file into the box above, check the flagged rows, then download the negatives as a Google Ads Editor file. Every step runs in this browser tab, so there is no account connection and no sign-up.

  1. Export the report. In Google Ads, open Campaigns, then Insights and reports, then Search terms, as described in Google’s search terms report guide. Pick a date range with enough clicks, such as the last 30 or 90 days, and download it as CSV or CSV for Excel.
  2. Drop the file in. Title rows and total rows are skipped for you. If a column name is not recognized, the tool asks you to match it from a list.
  3. Set your thresholds. Minimum clicks starts at 10. Leave minimum cost blank to use your average cost per conversion in the file. Add your brand names so they are never flagged.
  4. Review the two tabs. Search terms lists every row by cost. Word patterns adds up every one, two and three word phrase across all your searches.
  5. Export. Download the Google Ads Editor CSV, or copy the list and paste it into a negative keyword list in Google Ads.

Which columns does the file need?

Four columns are required and the rest make the output more useful. Google hides the Keyword column by default, so add it from the columns menu before you download if you want to see which keyword caught each search.

ColumnNeeded?What the tool uses it for
Search termYesThe search to review and, if it wastes spend, to exclude
Clicks, Cost, ConversionsYesThe wasted spend rule and every total on the page
Campaign and Ad groupRecommendedPlaces each negative in the right ad group in the Editor file
Added/ExcludedOptionalSkips searches that are already keywords or already excluded
Match type and KeywordOptionalShows which keyword and match type caught each search
Currency codeOptionalLabels the amounts in your account currency

How does the tool decide a search term is wasted?

A search term is flagged as wasted when it has zero conversions and has passed either your minimum clicks or your minimum cost. A search with some spend but fewer clicks is marked Watch instead, because a handful of clicks is not enough to judge it.

The default cost line is your average cost per conversion in the same file. If a search has already cost what one conversion usually costs and still has nothing to show, it has had a fair chance. You can type your own figure if your target cost per acquisition (CPA) is different.

LabelRuleWhat to do
Wasted0 conversions, and clicks or cost at or above your minimumPre-selected as a negative exact. Read it, then export
Watch0 conversions, below both minimumsLeave it running and check again next month
Converting1 or more conversionsNever suggested. Consider adding it as its own keyword
BrandContains a brand term you enteredNever suggested
ExcludedMarked as excluded or added in the reportSkipped

How are word patterns flagged?

A word pattern is flagged when it appears in two or more searches and has no conversions across all of them. It must also pass the same threshold, and none of its words can appear in a search that converted. That last check matters. Google’s negative keyword rules block any search that contains a negative phrase, so one careless phrase negative can switch off traffic that was selling.

The sample report shows why. The word free appears in a search for a free plumbing estimate that converted. So the tool keeps free off the phrase list, even if other searches with free in them never convert.

Search term vs keyword: what is the difference in Google Ads?

A search term is the exact phrase a person typed into Google. A keyword is the word or phrase you add to an ad group to tell Google which searches your ads may show for. One keyword can match many different search terms, depending on its match type.

Google explains the difference with a simple example in its search terms report help page. The report also has a Match type column that describes how closely each search matched the keyword that triggered it.

Your keywordMatch typeSearch term in the reportWorth paying for?
“emergency plumber”Phraseemergency plumber near meYes, high intent
plumberBroadplumber jobs near meNo, a job seeker
water heater repairBroaddiy water heater flushNo, wants to do it alone
[drain cleaning service]Exactdrain cleaning serviceYes, ready to book

The examples come from the sample report built into the tool, not from a client account.

Should a negative keyword be exact, phrase or broad match?

Use negative exact to block one specific search you never want, and negative phrase for a word or short phrase that can never describe what you sell. Negative broad blocks any search that contains all of its words in any order, which is the widest net and the easiest to get wrong.

The definitions below follow Google’s guide to negative keywords, using the negative running shoes as the example.

Negative match typeBlocks the search whenExample it blocksExample it does not block
BroadThe search has all the words, in any ordershoes runningrunning shoe
PhraseThe search has the words together, in the same orderblue running shoesshoes running
ExactThe search is exactly those words, with nothing addedrunning shoesblue running shoes

A few rules from the same Google page decide how safe a negative is:

  • No close variants. Negatives do not match plurals, synonyms or other close variants, so add each form you want to block.
  • Casing and misspellings are handled. Google says negatives already account for casing and misspellings, so you do not need to add those.
  • The 16 word rule. If a search is longer than 16 words and your negative comes after the 16th word, the ad can still show.
  • Symbols. Characters such as commas, question marks, brackets and the at sign are not allowed in negatives. The tool removes them before export.

This analyzer suggests negative exact for single searches and negative phrase for word patterns. It does not suggest negative broad, because a phrase negative is easier to predict.

Why doesn’t the search terms report add up to your total spend?

Google leaves out searches that too few people used, to protect user privacy, so the rows in the report never add up to the campaign total. Google confirms this on its search terms report help page, and says search terms insights groups those low-volume searches into themes without showing the searches themselves.

When your export includes the total rows, the tool reads the Other search terms line and shows how much spend sat outside the visible rows. You cannot negate those searches one by one, but you can still reduce the risk:

  • Fix the patterns you can see. The words that waste money in visible searches usually show up in hidden ones too, so phrase negatives on those words also block hidden searches that contain them.
  • Check which keywords cause the waste. Sort the Search terms tab by cost and look at the Keyword column. A broad keyword that keeps pulling in junk may need a tighter match type.
  • Compare date ranges. Searches can cross the visibility threshold later, so a review every few weeks finds terms that were hidden before.

Can you analyze Performance Max search terms?

Yes. Google now shows search terms for Performance Max campaigns. Open the search terms report and choose Search terms and landing pages for Performance Max from the dropdown, as described in Google’s Performance Max search terms guide. The same page says the data starts from March 2023.

Download that view and drop it into the analyzer. If the column names differ from a Search campaign export, match them when the tool asks. For Search and Shopping inventory in Performance Max, Google says negatives are added at the account or campaign level, not the ad group level. So use Copy list and paste the negatives into a negative keyword list or your account-level negatives, rather than the ad group CSV.

Our Performance Max negative keywords strategy covers where each type of negative belongs.

What should you look for when you review search terms?

Look for searches that show a different need from the one your ad and landing page serve. Google’s own advice in its negative keywords guide is to watch for searches that look like your keywords but come from people who want a different product.

PatternExample searchUsually a negative?Check before you block
Jobs and payplumber jobs near me, plumber salaryYesSkip this if you are hiring through ads
Learning and coursesplumbing course onlineYesKeep it if you sell training
Do it yourselfhow to unclog a drain, diy water heater flushOftenSome how-to searches still book a service
Freefree plumbing estimateSometimesFree estimate, free shipping and free trial can convert
Wrong productplumber supplies storeYesMake sure you do not sell it
Locations you do not serveA city outside your areaYesCheck your location targeting first

Before every export, read the conflict box under the results. It lists any negative that would block a search that converted in the same file, with a button to remove it.

To review the rest of the account in the same pass, use our free Google Ads audit checklist. To turn the searches that do convert into new keywords with the right match types, use the Keyword Wrapper.

Is your search terms data safe in this tool?

Yes. The search term analyzer reads your file with JavaScript inside this browser tab and does all the maths there. It makes no network request with your data, saves nothing to the server, and keeps nothing after you close or reload the tab.

That also means there is nothing to connect. You do not sign in with Google, grant account access or share a login. The download is built in your browser too.

FAQs

Is this negative keyword tool free?

Yes. The search term analyzer is free, needs no sign-up and has no row limit. The only limit is a file size of 30 megabytes (MB), which is far larger than a typical search terms export.

Where is the search terms report in Google Ads?

Open Campaigns in the left menu, then Insights and reports, then Search terms. Use the download icon above the table to save it as CSV or CSV for Excel.

Do I need to add plural versions of a negative keyword?

Yes. Google says negative keywords do not match close variants such as plurals and synonyms, so add each form you want to block. Casing and misspellings are handled for you.

How many clicks should a search get before I add it as a negative?

The tool starts at 10 clicks, or your average cost per conversion, whichever comes first. Raise the click minimum for low-cost clicks and lower it when each click is expensive.

Why is a word that never converted not suggested?

If any of its words appear in a search that converted, the tool keeps it off the phrase list. A phrase negative on that word could block searches that sell.

Does it work with a Microsoft Advertising search terms report?

Usually, yes. If the export has search term, clicks, spend and conversions columns, the tool reads it or asks you to match the columns. The CSV download is formatted for Google Ads Editor, so use Copy list for Microsoft Advertising.

Can I upload an Excel file?

Not as .xlsx. Download the report from Google Ads as CSV or CSV for Excel instead. Both formats work as they are, so there is no need to open and save the file first.

More free Google Ads tools

Seeing more waste than you expected?

Send us the account. We check search terms, match types, bidding and tracking, and give you a prioritised fix list.

Get Free Audit Worth $500

Built by Ishant Sharma, founder of Hustle Marketers, Google Partner agencyLast checked November 18, 2026

Scroll to Top