How to Find Wasted Search Ad Spend Using Search Terms and Lead Outcomes

A Google Ads campaign can look efficient in the dashboard and still waste a substantial part of its budget. Consider a Kolkata clinic receiving calls for procedures it does not offer, a packers-and-movers company paying for searches from outside its coverage area, or a digital agency receiving course and job enquiries instead of business leads. All three may show recorded conversions. None proves the advertising is bringing suitable customers.

To find the waste, compare the actual search terms with the enquiries that followed. The query tells you what the person wanted; the call note, form response and sales record tell you whether the business could help. The important decision is whether to exclude a search, improve the page or fix what happens after someone contacts you.

This article shows how to read both together. It also explains when a negative keyword is the right response—and when the real problem sits in the advertisement, landing page, tracking or follow-up process.

What wasted search ad spend actually looks like

Wasted spend is not limited to clicks that produced no form submission. A click can be expensive even when it becomes a recorded lead if the enquiry has no realistic commercial value.

Common examples include:

• A Kolkata service business receiving enquiries from locations it cannot serve.
• A digital agency paying for searches from people looking for courses, jobs or free advice.
• A clinic receiving enquiries for treatments it does not provide.
• A web developer attracting requests below its minimum project scope.
• Duplicate, spam or unreachable form submissions being counted as conversions.
• A relevant search producing a lead that is never followed up properly.

There are two separate questions to investigate:

1. Was the search relevant? Did the query show a need for the service you offer?
2. Was the outcome valuable? Did the enquiry become a valid lead, qualified opportunity, appointment, quotation or customer?

A campaign can fail at either point. It can attract the wrong searches, or attract suitable searches but lose those opportunities through a service landing page that fails to match the advertisement, weak forms or slow follow-up.

The data you need before making changes

Do not start by adding a large negative keyword list. First collect enough information to see patterns. At minimum, bring together these data points:

• Search term or query
• Date and campaign
• Ad group or keyword theme, where available
• Landing page
• Clicks and cost
• Recorded conversion action
• Lead name or reference number
• Location and service requested
• Lead status
• Reason for rejection, if rejected
• Quotation, appointment or sales outcome

The search terms report tells you what people typed. Google Ads keywords tell you what the account was intended to target. These are not the same thing, particularly when broader matching or automated campaign features are involved.

Your lead-quality audit using call and form conversion data supplies the second half of the picture. If your team records every enquiry as “good” or “bad” without a reason, the data will not be very useful. Use a small set of consistent categories such as:

• Valid and qualified
• Valid but not ready
• Wrong service
• Wrong location
• Outside budget or project scope
• Job, course or research enquiry
• Spam, duplicate or unreachable
• Converted customer

Where reliable attribution exists, compare search-term themes with recorded outcomes. Where it does not, use campaign-level patterns and label unknown sources clearly; do not assign a lead to a particular query by guesswork.

Build a search-term-to-outcome review

Reviewing individual queries is useful, but a grouped view helps you make better budget decisions. Create a simple table with one row for each search-term theme or important query.

The figures above are illustrative, not a benchmark. Use your own account data. The purpose of the table is to separate cheap activity from useful activity.

A search theme that generates fewer leads may deserve more attention if those leads are relevant and progress towards a quotation or sale. Conversely, a low-cost theme may be wasteful if it produces many unsuitable contacts.

Use the right calculations

Cost per lead is calculated as:

Cost per lead = advertising cost ÷ recorded leads

That is useful, but it treats every recorded lead as equal. For lead-generation campaigns, add two more calculations:

Cost per qualified lead = advertising cost ÷ qualified leads

Cost per sales opportunity = advertising cost ÷ sales opportunities

Suppose Campaign A spends ₹20,000 and produces 40 form submissions. Only 5 are qualified. Its cost per recorded lead is ₹500, but its cost per qualified lead is ₹4,000.

Suppose Campaign B spends ₹20,000 and produces 20 form submissions, of which 10 are qualified. Its cost per recorded lead is ₹1,000, but its cost per qualified lead is ₹2,000.

Campaign B looks more expensive if you judge only form volume. It may be the better campaign from a business point of view.

Where you have reliable sales data, go further:

Cost per customer = advertising cost ÷ customers acquired

Expected value per lead = qualified-lead-to-customer rate × average gross profit per customer

Use gross profit or contribution margin where possible rather than only revenue. A high-value sale may still be unattractive if the margin is low or the sales process consumes significant time.

Those numbers help reveal which themes deserve investigation. They do not, by themselves, tell you whether to exclude a query; intent still matters.

How to classify search terms without overreacting

1. Clearly relevant terms

These searches directly express a need for the service in a location the business can actually serve or customer category. They should normally remain active, although the landing page and ad message may need improvement.

A locally relevant search does not guarantee a qualified lead, but it is a reasonable starting point for reviewing the advertisement, landing page and follow-up.

2. Clearly irrelevant terms

These include searches for jobs, salaries, courses, free resources, unrelated products, DIY instructions or services you do not provide. Repeated patterns should usually become negative keywords.

Be precise. If “course” is irrelevant to your business, exclude the relevant course-intent pattern. Do not add a broad word that could block genuine searches unless you have checked how it is used in your market.

3. Relevant search, poor outcome

This is where many advertisers make the wrong decision. A search may be commercially relevant, but the enquiry may still be unsuitable because of price expectations, service limitations, poor follow-up or an unclear offer.

Do not immediately exclude the query. First ask:

• Did the advertisement set the right expectation?
• Did the landing page explain who the service suits?
• Was the location clear?
• Did the form collect useful information?
• Was the lead contacted quickly?
• Was the rejection caused by the search or by the sales process?

4. Ambiguous terms

Some searches can mean different things. A broad phrase may produce both service enquiries and research traffic. These terms should be reviewed using enough data to identify a pattern. Consider separating them into their own campaign or ad group rather than excluding them immediately.

When should you add a negative keyword?

Add a negative keyword when the unwanted intent is clear, repeated and unlikely to become commercially useful. Good candidates often include:

• Employment terms such as job, vacancy, salary or career.
• Training terms such as course, class, certification or tutorial, if you do not provide training.
• Free or DIY terms, when your business sells a professional service.
• Unserved locations that repeatedly consume budget.
• Products or treatments outside your actual offering.
• Clearly unrelated meanings of an abbreviation or broad phrase.

Before applying an exclusion, check the search term in context. “Affordable” may be unsuitable for a premium service, but it may still represent a viable prospect for another business. “Near me” may be valuable for a local clinic but irrelevant for a company that works only with national B2B clients.

Use shared negative lists only for genuinely common exclusions. Different campaigns may serve different customers, so a term excluded from one campaign may be useful in another.

Even a carefully chosen negative list cannot repair a broken enquiry journey. That is why the lead record deserves as much attention as the query.

Lead outcomes can reveal problems the search terms cannot

Search terms show the beginning of the journey. They do not explain everything that happens after a form submission or call.

For example, a relevant search may produce poor results because:

• The landing page sends every visitor to the homepage.
• The contact number is not answered during advertised hours.
• The form fails on mobile.
• The quotation process takes too long.
• The business cannot handle the type of enquiry being advertised.
• The sales team marks a valid enquiry as poor because follow-up was delayed.

Connect lead records with later stages wherever practical: validated lead, consultation, quotation, appointment, sale and lost opportunity. The system does not need to be complicated at the start. A shared spreadsheet with consistent fields is better than a sophisticated CRM containing incomplete or inconsistent data.

Why search-term reports and CRM records may not match perfectly

Do not assume that every lead can be traced back to a visible search term. Google Ads does not expose every query in its search terms report, and a phone call or later enquiry may not carry the same identifier as the original ad click. Privacy settings, consent choices, cross-device journeys and incomplete tagging can also create gaps. Treat missing attribution as unknown, not automatically as wasted spend.

Before deciding that a search theme has failed, compare the data at three levels: the visible query, its ad group or campaign, and the lead record. Where individual-level matching is unavailable, analyse campaign-level trends and keep your conclusions appropriately cautious.

Minimum tracking checks before a budget decision

• Confirm that the lead form and click-to-call events are firing correctly, without duplicate conversions.
• Separate enquiries from genuinely qualified leads in your CRM or spreadsheet.
• Keep the same reporting date range, time zone and attribution definitions when comparing datasets.
• Record the source and reason when a lead is rejected, rather than assigning a generic “bad lead” label.
• Check whether imported offline conversions are counted once and associated with the correct conversion action.

For businesses with reliable CRM outcomes, review how to audit Google Ads lead quality using call and form data before excluding queries based only on form counts.

A decision table for reducing waste without losing good enquiries

Use the evidence available, not an arbitrary minimum-click rule. A repeated job-search pattern with no relevant prospects warrants a different response from a relevant local-service query that produced one poorly handled enquiry.

If the problem is repeated across multiple campaigns, review the overall performance marketing strategy rather than trying to solve every issue with negative keywords.

A practical monthly waste-audit process

1. Export the search terms. Select a meaningful review period and include cost, clicks and conversion information.
2. Join the lead outcomes. Match forms and calls with the search term or campaign where tracking allows it.
3. Group similar queries. Separate service, location, research, job, course and unrelated themes.
4. Calculate qualified performance. Compare cost per recorded lead with cost per qualified lead and sales opportunity.
5. Apply only clear exclusions. Add negative keywords for repeated, proven poor-fit intent.
6. Fix non-keyword problems. Improve ad wording, landing pages, forms, location settings or response handling.
7. Record the change. Note what was excluded or changed and why.
8. Review the next period. Check whether wasted spend fell without removing useful search demand.

Do not make dozens of changes at once if you want to understand what improved. Prioritise the largest recurring waste patterns first.

After changes go live, resist judging the outcome by the first drop in form submissions. Look at what happened to qualified opportunities.

What to do when lead volume falls after optimisation

A reduction in leads is not automatically a failure. If irrelevant enquiries fall while qualified opportunities remain steady, the campaign may have improved.

Check four measures together:

• Total advertising cost
• Recorded leads
• Qualified leads
• Sales opportunities or customers

If all four fall, the account may have become too narrow, or demand may have changed. Review the excluded queries and compare them with the lead records. If recorded leads fall but qualified leads do not, the change may be positive. If qualified leads fall sharply, restore or test the relevant search theme with better messaging instead of simply reopening everything.

Conclusion

When a search campaign underperforms, it is tempting to look for one quick setting to change. In practice, wasted spend usually leaves a trail across several places: the words someone searched, the promise made in the ad, the page they reached and what happened when they called or submitted a form. The search terms report is the beginning of that investigation, not the verdict.

Start with a recent period and take the ten query themes that consumed the most money. For each one, ask whether the search was relevant, whether the resulting enquiry was qualified and whether the sales team had a fair chance to convert it. Exclude the unmistakably wrong searches. For the relevant ones that failed, examine the offer, location, form and response process before cutting them off.