How to calculate wasted ad spend

A working formula for wasted ad spend, the inputs it needs, and a worked example you can run against last month.

By T.J. Muro

Published

Updated

Short answer: Wasted ad spend is the portion of media cost that could not have produced an outcome. Price it directly: multiply the clicks that were invalid, unqualified, or off-target by what you paid for them.

Wasted spend = (invalid clicks + off-target clicks + non-converting placement clicks) x average cost per click

The three inputs

1. Invalid clicks. Automated or duplicate traffic — zero-duration sessions, data-center sources, repeated identical behavior.

2. Off-target clicks. Real people outside your market: wrong country, wrong company size, wrong role, wrong intent. Common with broad match and audience expansion left on by default.

3. Non-converting placements. Individual sites, apps, or placements that have spent past your cost-per-acquisition threshold with nothing booked.

A worked example

A campaign spends $40,000 in a month at a $4.00 average cost per click — 10,000 clicks.

  • 900 clicks show no measurable session: $3,600
  • 1,400 clicks come from outside the target region or segment: $5,600
  • Three placements spent $4,200 combined with zero pipeline: $4,200

Wasted spend: $13,400 — 33.5% of the month.

That number is not a scandal. It is a starting inventory. The useful follow-up is what the remaining $26,600 produced, and what it would produce if the $13,400 were redeployed into the placements that actually converted.

How to run it monthly

  1. Export clicks, cost, and conversions by campaign and placement.
  2. Join to sessions and engagement from your analytics.
  3. Flag the three buckets above with fixed, written rules so the number is comparable month to month.
  4. Report waste as a percentage of spend, not a dollar figure alone — dollars move with budget, the percentage tells you whether anything improved.
  5. Recheck after exclusions and record the delta.

What to do with the number

Take it to the network as a dispute where the traffic was invalid. Redeploy the rest. And set a threshold — most teams that measure this land somewhere between 15% and 40% before cleanup, and the goal is a curve that trends down each month, not a single clean quarter.

Related reading