At a glance
Spend on keywords and search terms that produced clicks but zero conversions over the period. The “money down the drain” number, every pound here is, by definition, untracked or unproductive. Typical neglected Microsoft Ads accounts run 5, 15% of total spend as wasted; well-managed accounts sit below 5%.
| What it counts | SUM(Spend) for keywords (and matched search terms where exposed) where Conversions = 0 over the 30-day window. Includes spend on broad-match queries that triggered a click but no measured conversion. |
| Why it’s “wasted” | Either (a) the keyword genuinely doesn’t convert (real waste, prune it), or (b) UET tracking failed for those clicks (not real waste, but invisible to Microsoft’s optimiser, which will under-bid and under-deliver future similar traffic). Either way, this spend earns no measurable return. |
| Cost basis | Same as Total Spend, gross media cost post-Click-Quality-filter. |
| Currency | Account currency. |
| Conversion attribution | UET-based, default last-click cross-device. View-through is excluded by convention. A click counts as “no conversion” if no primary conversion fired in the click attribution window (default 30-day click + 1-day view). |
| Attribution window | Default 30-day click + 1-day view. Recent clicks (last 1, 2 days) may still produce delayed conversions; this card excludes the most recent 2 days from “wasted” classification to avoid false positives. |
| Bot / invalid traffic | Pre-filtered by Click Quality. Wasted spend is real human clicks that didn’t convert. |
| Time window | 30D. Keyword-level granularity. |
| Alert trigger | >$0 on any zero-conversion keyword that is still active. Practically, a non-zero number is normal; investigate when total wasted spend exceeds 8% of total Microsoft Ads spend. |
| Roles | owner, marketing, finance |
Calculation
Calculated automatically from your Microsoft Ads (Bing) data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A UK home-and-garden retailer running Microsoft Ads imported from Google. The 30-day window covers 03 Apr 26 to 02 May 26.| Tier | Spend | Conversions | Wasted (this card) | % of spend |
|---|---|---|---|---|
| Top 10 keywords by spend | £2,180 | 92 | £0 | 0% |
| Mid-tail (next 50 keywords) | £1,400 | 64 | £180 | 13% |
| Long-tail (>200 keywords) | £450 | 8 | £310 | 69% |
| Microsoft Audience Network placements | £820 | 11 | £540 | 66% |
| Search Partner Network terms | £290 | 5 | £165 | 57% |
| Total | £5,140 | 180 | £1,195 | 23% |
- 23% wasted is high. Healthy accounts sit at 5, 8%. This account has a serious cleanup opportunity, roughly £1,200/month going to clicks that don’t convert.
- Microsoft Audience Network is the biggest single offender. £540 of the £1,195 wasted (45%) is MSAN. This is a textbook MSAN-on-by-default-after-Google-import problem. Action: pause MSAN entirely on this account or cap its share at 15% with a strict negative-placement list.
- Search Partner Network at 57% wasted is also poor, but smaller scale. SPN includes Yahoo, AOL, and small Bing-syndication sites; quality varies wildly. Either disable SPN or accept that the lower-cost clicks subsidise the search ROAS.
- Long-tail (£310 wasted across 200+ keywords) is the classic “should never have been imported” tail. Microsoft inherited these from the Google account where they had volume; Bing/Yahoo audience just doesn’t search for them. Pause keywords with zero conversions in 60 days.
- The top 10 keywords are clean. £2,180 spent, zero waste. Don’t touch what’s working.
- Tier 1 (5 minutes): Disable Microsoft Audience Network if not earning. Saves £540/month, that’s £6,500/year on this account alone.
- Tier 2 (30 minutes): Audit Search Partner Network. Disable or cap.
- Tier 3 (60 minutes): Add the worst-converting search terms as account-level negatives (use the Search Terms Report).
- Tier 4 (recurring weekly): Pause individual keywords with zero conversions and 60+ days of spend.
Sibling cards merchants should reference together
| Card | Why pair it with Wasted Spend |
|---|---|
| Microsoft Ads Zero-Conversion Spend | Campaign-level cousin. This card is keyword/term level; that one is whole-campaign level. Different action paths. |
| Microsoft Ads Search Terms Report | The forensic view. Open this to find the actual queries triggering wasted spend, then add them as negatives. |
| Microsoft Ads CPA by Keyword | Keywords with infinite CPA (zero conversions) are flagged here; this card surfaces just the spend without the CPA noise. |
| Microsoft Ads Quality Score Distribution | Low-quality-score keywords often correlate with wasted spend, you’re paying a CPC penalty for poor relevance. |
| Microsoft Ads CTR by Keyword | The leading indicator. CTR collapse precedes wasted-spend rise by 1, 2 weeks (creative or relevance fatigue). |
| Microsoft Ads Total Spend | The denominator for “wasted as % of total”. |
| Microsoft Ads ROAS | Wasted spend is a direct drag on ROAS. Cutting wasted spend lifts ROAS proportionally. |
| Google Ads Wasted Spend | Compare across platforms; Microsoft accounts post-Google-import almost always run a higher waste %. |
Reconciling against the vendor’s own dashboard
Where to look in Microsoft Advertising: Microsoft does not natively expose a “wasted spend” metric. The closest reconciliations are:- Microsoft Advertising → Reports → Performance → Keyword performance, filter to
Conversions = 0and sum the Spend column. The total should match this card to within 1, 2%. - Microsoft Advertising → Search terms, same filter for the search-term-level view.
| Reason | Direction of divergence |
|---|---|
| Recent-click exclusion. We exclude the last 2 days of clicks because conversions take time to fire (default 30-day click + 1-day view). A manual filter in Microsoft will include those recent clicks as “zero conversion” prematurely. | Ours lower than naive UI filter |
| View-through exclusion. This card uses primary conversions only. If the Microsoft UI filter includes “all conversions” (which adds view-through), some “wasted” keywords will look like they did convert. | Ours higher than the all-conversions view |
| Real-time ingestion lag. Microsoft conversions ingest with 1, 6 hour delay. | Ours higher for “today” |
| Currency. Both use account currency. | None |
| Card | Expected relationship |
|---|---|
google_ads.gads_wasted_spend | Same conceptual card on Google. Microsoft waste % usually exceeds Google waste %, especially on accounts within 6 months of import. |
facebook_ads.fac_wasted_spend | Same conceptual card on Meta, different mechanics (audience-level, not keyword-level). Don’t compare absolute numbers; compare waste % as a discipline metric. |