Wasted retail media spend rarely announces itself with a tiny alarm bell. Shame, because that would be adorable and useful. Instead, it hides inside campaigns that look efficient in the ad console but lose money after product costs, marketplace fees, fulfillment, discounts, returns and stock issues.
This guide shows how to find wasted spend by SKU, campaign and marketplace so budget can move from “busy” to profitable. We are aiming for less drama, more margin. Very chic.
Step 1: Export campaign performance
Start with campaign, ad group, keyword or placement performance for the last 30 days. Include spend, attributed sales, clicks, impressions, CPC, conversion rate, ROAS and ACOS. If you work across Amazon, bol, Mirakl or Walmart, keep marketplace and country as separate columns.
Required fields:
marketplace, country, campaign, ad_group, target, sku,
spend, attributed_sales, clicks, orders, acos, roasStep 2: Add SKU-level economics
Join every promoted SKU with product cost, marketplace commission, fulfillment, storage, average discount, return rate and refund cost. This is the bit where ROAS stops feeling so smug.
contribution_margin_after_ads = revenue
- product_cost
- marketplace_fees
- fulfillment_cost
- discounts
- return_cost
- ad_spendStep 3: Calculate break-even ACOS
Break-even ACOS should be calculated per SKU, not averaged across the account. Use contribution margin before ads as the maximum ad spend percentage the product can absorb.
| SKU | Margin before ads | Current ACOS | Status |
|---|---|---|---|
| A | 34% | 22% | Safe to test scale |
| B | 18% | 26% | Margin leak |
| C | 42% | 48% | Strategic only with cap |
Step 4: Flag the four waste patterns
- Negative margin winners: campaigns with good sales but negative contribution margin.
- Stockout spend: campaigns pushing SKUs with less than 14 days of stock.
- Return-heavy spend: campaigns sending demand to products with high return rates.
- Paid dependency: spend rising while total revenue or organic sales stay flat.
Step 5: Decide what to do next
Do not simply pause everything red. Some campaigns are launch investments. The trick is to give every campaign a job, a margin rule and a review date.
| Finding | Action | Owner |
|---|---|---|
| ACOS above SKU break-even | Lower bids, tighten targets or cap budget | Advertising |
| High return rate | Review product page, sizing, claims and targeting | Marketplace + content |
| Low stock cover | Shift spend to substitutes or replenished SKUs | Inventory |
| Negative contribution margin | Pause scaling until price, fees or costs improve | Finance + marketplace |
Common pitfalls
Do not use account-average ACOS as a bid ceiling. Do not ignore coupons and returns. Do not judge launch campaigns with the same window as harvest campaigns. And please, lovingly, do not optimize keywords while the SKU is out of stock. That is spreadsheet cosplay.
What to check before calling it done
- Every promoted SKU has a contribution margin before and after ads.
- Break-even ACOS is calculated per SKU.
- Campaigns are tagged defend, harvest, build or fix.
- Red campaigns have an owner and next action.
- Budget moved from margin leaks to profitable or strategic campaigns.
FAQ
How often should I run this audit?
Weekly for active accounts and daily during peak retail events.
Should I pause all negative-margin campaigns?
No. Launch tests may stay live with a cap and success date. Mature negative-margin campaigns need action fast.
What is the best first report?
Spend by SKU with contribution margin after ads, stock cover and return rate.
Can this work for bol and Mirakl too?
Yes. The fields differ, but the logic is the same: connect retail media spend with SKU economics.
How does FiveX help?
FiveX combines retail media, marketplace profitability, inventory and returns so wasted spend is visible before it eats the month.
Need the shortcut? FiveX shows where ad spend is helping profit and where it is just being expensive in a nice outfit.