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.
Privacy: the file is read by JavaScript in this tab. Nothing is sent to a server or saved, and closing the tab clears it.
| Neg. | Search term | Campaign / ad group | Clicks | Cost | Conv. | Status |
|---|
| Neg. | Word or phrase | Searches | Clicks | Cost | Conv. | Cost / conv. | Status |
|---|
Your negative keywords
The CSV puts each exact negative in the ad group where the search appeared. Each phrase negative goes in every ad group where it would block a search with no conversions. Copy list gives [exact] and “phrase” lines to paste into a negative keyword list. Always check the Editor import preview before you post.
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.
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.
- 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.
- 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.
- 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.
- 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.
- 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.
| Column | Needed? | What the tool uses it for |
|---|---|---|
| Search term | Yes | The search to review and, if it wastes spend, to exclude |
| Clicks, Cost, Conversions | Yes | The wasted spend rule and every total on the page |
| Campaign and Ad group | Recommended | Places each negative in the right ad group in the Editor file |
| Added/Excluded | Optional | Skips searches that are already keywords or already excluded |
| Match type and Keyword | Optional | Shows which keyword and match type caught each search |
| Currency code | Optional | Labels 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.
| Label | Rule | What to do |
|---|---|---|
| Wasted | 0 conversions, and clicks or cost at or above your minimum | Pre-selected as a negative exact. Read it, then export |
| Watch | 0 conversions, below both minimums | Leave it running and check again next month |
| Converting | 1 or more conversions | Never suggested. Consider adding it as its own keyword |
| Brand | Contains a brand term you entered | Never suggested |
| Excluded | Marked as excluded or added in the report | Skipped |
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 keyword | Match type | Search term in the report | Worth paying for? |
|---|---|---|---|
| “emergency plumber” | Phrase | emergency plumber near me | Yes, high intent |
| plumber | Broad | plumber jobs near me | No, a job seeker |
| water heater repair | Broad | diy water heater flush | No, wants to do it alone |
| [drain cleaning service] | Exact | drain cleaning service | Yes, 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 type | Blocks the search when | Example it blocks | Example it does not block |
|---|---|---|---|
| Broad | The search has all the words, in any order | shoes running | running shoe |
| Phrase | The search has the words together, in the same order | blue running shoes | shoes running |
| Exact | The search is exactly those words, with nothing added | running shoes | blue 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.
How do you add the negatives with Google Ads Editor?
Download the CSV from the tool, then import it in Google Ads Editor with Account, then Import, then From file. Editor shows every row as a proposed change, so nothing reaches your live account until you review it and post.
- Download the file. It has four columns: Campaign, Ad group, Keyword and Criterion Type. Criterion Type holds Negative exact or Negative phrase, the match type names listed in Editor’s guide to adding keywords.
- Get recent changes first. Download the latest version of the account in Editor so the campaign and ad group names match.
- Import. Go to Account, then Import, then From file, as set out in Google’s CSV import steps. Check the column headers in the preview.
- Review and keep. Select Review imported changes, look at each negative, then keep the ones you want.
- Post. Post the changes to send them to Google Ads.
What are the limits on a negative keyword?
Google allows up to 10 words in a keyword, as stated in its add keywords help page. The Google Ads API documentation sets a limit of 80 characters per keyword. The tool warns you about any negative that breaks either limit and leaves it out of the export, because Google would reject it.
For more on list sizes and account-level negatives, read our guide to Google Ads negative keywords.
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.
| Pattern | Example search | Usually a negative? | Check before you block |
|---|---|---|---|
| Jobs and pay | plumber jobs near me, plumber salary | Yes | Skip this if you are hiring through ads |
| Learning and courses | plumbing course online | Yes | Keep it if you sell training |
| Do it yourself | how to unclog a drain, diy water heater flush | Often | Some how-to searches still book a service |
| Free | free plumbing estimate | Sometimes | Free estimate, free shipping and free trial can convert |
| Wrong product | plumber supplies store | Yes | Make sure you do not sell it |
| Locations you do not serve | A city outside your area | Yes | Check 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.
Built by Ishant Sharma, founder of Hustle Marketers, Google Partner agencyLast checked November 18, 2026








