How much is your Google Ads account wasting on search terms?

Upload your Search terms report and this estimator adds up what you spent on search terms that never converted, projects that waste over 12 months, and lists the recurring words behind it. It runs the same analysis as the Solimarketer grade, needs no sign-in, and does not keep your file.

What this can't tell you

It only sees the date range and campaigns in your file, and cannot tell whether a term converted later or offline.
It cannot see Performance Max or AI Max terms that Google hides from the report.
It cannot tell whether your conversion tracking works. If tracking is broken, every term looks like waste.
It cannot track changes over time. Connecting your account does that every week.

How to fix it in Google Ads

In Google Ads, open Campaigns, then Insights and reports, then Search terms.
Select the terms that are not relevant to what you sell.
Choose Add as negative keyword, pick the campaign, and use phrase match for the recurring words above.
Check again after a week that the terms stopped showing up.

Questions

How do I export the search terms report?

In Google Ads, open Insights and reports, then Search terms, choose a date range, then Download and CSV. Use the English interface.

What counts as waste?

Search terms with no conversions that cost more than your average cost per conversion, or that got 10 or more clicks when the account had no conversions.

Is my file stored?

No. The file is read in memory to compute the estimate and then discarded. Only an anonymous count of estimator runs is kept.

Get the real number every week.

Connect Google Ads read-only and Solimarketer checks waste, hidden spend, auto-applied changes and tracking for you.