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%.
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.
What’s interesting:
- 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
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.
Edge case. delayed conversions:
If your conversion goal has a long lag time (e.g. consideration purchases that close 3, 14 days after the click), the 2-day exclusion isn’t enough. For those goals, the wasted-spend number is overstated. Two options: (a) extend the lag exclusion in your Vortex IQ settings, or (b) treat this card as an upper-bound and discount it by your typical conversion lag.
Cross-connector reconciliation: