Adako
IntegrationsUse casesDocsPricingBlog
Sign inGet started
Dashboard

無料Free tool

Find wasted spend in your Google Ads search terms

Drop the Search terms report you download from Google Ads. The page lists the search terms that spent money with no conversion, adds up the wasted spend and suggests a negative keyword with a match type for each. No sign-up. The file never leaves your browser.

The rule is the one Adako uses. Adako is an MCP server that connects Claude, ChatGPT and other assistants to Google Ads, where it runs this check on live data.

手順How to export

Download the Search terms report from Google Ads

  1. 1In Google Ads, open Campaigns, then Insights and reports, then Search terms.
  2. 2Pick a date range with enough traffic, such as the last 30 days.
  3. 3Click the download icon and choose CSV. "CSV for Excel" works too.
  4. 4Optional: download the Keywords report the same way and drop both files. It marks which terms are already keywords when the search terms file has no Added/Excluded column.

How it decides

The rule, step by step

  • Wasted: zero conversions and spend at or above the threshold. The default threshold is the cost of 10 average clicks across the file, rounded up to a billable unit of its currency.
  • Protected: every word of a search term that converted. None of them becomes a phrase negative.
  • Phrase negatives: words found in three or more wasted terms, the top 10 by spend.
  • Exact negatives: the other wasted terms not already excluded, the top 15 by spend.
  • Currency comes from the Currency code column. Accounts and currencies are checked separately and never added together.

安全Privacy

The file never leaves your browser

The page reads the file with JavaScript in this tab and runs the check in memory. There is no upload and no server step, and nothing is saved: reload or close the tab and the data is gone. If you accepted analytics cookies, Adako records that the check ran on this page. No search term, amount or file name is part of it.

質問FAQ

Questions about the check

What counts as wasted spend in Google Ads search terms?

A search term that recorded zero conversions and spent at least the threshold. By default the threshold is the cost of 10 average clicks in your file, so it means the same in every currency. You can set your own figure.

Is my Google Ads data uploaded anywhere?

No. The file is read and analysed by JavaScript in this browser tab. Nothing is sent to a server or stored, and closing the tab discards it. If you accepted analytics cookies, the page records that the check ran, with no numbers or words from the file.

How does the tool choose between phrase and exact match negatives?

A word that appears in three or more wasted search terms, and in none that converted, becomes a phrase negative (up to 10). Every other wasted term becomes an exact negative (up to 15), unless it is already excluded.

Will it suggest blocking my brand or searches that convert?

A word from any search term with a conversion is never suggested as a phrase negative, so a brand name that converts is safe. Check the exact negatives before you add them.

Which export formats does it read?

The Search terms report downloaded from Google Ads in English, as CSV or CSV for Excel. It refuses Excel and PDF files and exports in another interface language, because their column names and number formats differ.

Why do the totals differ from my campaign spend?

Google hides low-volume search terms from the report, so the search terms never add up to the full campaign cost.

Connect Google Ads and add these as negatives in one approval.

Adako runs the same check from Claude or ChatGPT on live data. Negatives are added only after you approve. See how negative keywords work in Adako.

Start free

関連Keep going

More on wasted spend in Google Ads.