By Sean Clarke Founder Pacific IQ and EcomIQ

ROAS dropped 30% on Meta. The agency wants to pause. The founder wants to pause. Half the time, pausing is the right call. Half the time, MER is fine, the channel has just shifted, and pausing would cost six figures.

Without a blended view, you can't tell which half you're in. And most operators don't have one.

Not because they don't want one. They've all started building one. There's a half-finished marketing tracker sitting in a Drive folder somewhere. Started as a Q1 budget, sprouted four extra tabs, then got rebuilt from scratch the next time someone joined a new brand.

I reckon the tracker itself isn't usually the problem. The problem is it lives in your head, in a Slack thread, in three CSV exports, and in last quarter's board deck, but not in one place the team can open and make a decision from. So when Meta wobbles, nobody actually knows whether it matters.

Four questions the tracker has to answer

A tracker that earns its keep answers these in under thirty seconds.

How's MER tracking against target. Marketing efficiency ratio is total revenue divided by total ad spend. If the target is 3.5x and you're sitting at 3.1x for the month, something needs attention. Most brands don't have this on hand. They've got ROAS by channel, which is useful, but it's not the same number.

Are we pacing on annual spend. Planned $300K for the year, $40K in by end of February, you're under-pacing. Maybe that's deliberate, maybe Q1 was soft and you'll catch up. Either way, you should know without doing math on a Friday.

Where is the spend actually going. Most operators allocate by gut. Meta gets 60% because Meta has always got 60%. That works until an iOS update, creative fatigue, or channel saturation hits, and that 60% starts returning 2.1x instead of 4.1x.

What did we learn this month that should change next month. This one almost never lives in the spreadsheet, which is exactly why teams keep making the same call twice. A tracker without the why is just number storage.

If your current setup covers all four, you're set. Most don't.

The six numbers actually worth tracking

Forget thirty-KPI dashboards. The operators I see making consistently good calls track these.

Contribution margin per order. What's left after COGS, fulfilment, and ad cost. Cleanest signal that the unit economics work.

Months of runway. Cash on hand divided by burn. Tight runway changes every other decision you make.

GP after CAC by channel. Gross profit once acquisition cost is subtracted, split out by channel. This is where you find out which channel actually pays for itself versus which one looks good on ROAS but is quietly eating margin.

Gross margin. Revenue minus COGS as a percentage. Trending the wrong way means a discount problem, a freight problem, or a product mix problem. All three are worth catching early.

New customer percentage. Share of orders that are first-timers. Drives the long-term shape of the business. 80% repeat, you're probably under-spending on acquisition. 80% new, you're probably over-discounting.

Breakeven orders per month. How many orders to hit zero net cash. Below it you're burning, above it you're building.

Spend, MER, and ROAS all sit on top of these six.

Why most trackers fail

Three patterns repeat.

It gets too clever. Twelve assumptions, four sensitivity tables, a goal-seek model. Looks impressive in the build. Takes forty minutes to update each month, so nobody updates it.

No narrative layer. Numbers without notes are useless three months later. "September up 18%" tells you nothing if you don't remember September was the bundle launch plus an influencer push.

It lives somewhere only one person looks. Usually the person who built it. They get pulled into a launch or move on, the tracker dies, and three months later someone rebuilds it.

The fix is the same in all three. Keep the structure tight, log the context inline, put the file where everyone on the marketing call can pull it up.

What good actually looks like

Three views, no more.

Setup. Annual revenue target, target MER, target channel mix. These don't shift much inside a year, so they sit in one place and feed everything else.

This month. Spend by channel logged weekly, pacing live. The pacing matters more than the totals, because by the time you notice you're $30K under-spent in October, October is over.

Dashboard. YTD revenue, YTD spend, YTD MER, pacing against annual targets. Someone asks how the year is going, you open this tab and read it off.

More than five minutes a week to maintain, it's too complicated. Can't answer the four questions from it, it's too thin.

Four things to do once it's set up

Structure is half the battle. The other half is how you actually use it.

Set a target MER you'd actually defend. Most operators set their target where they'd like to be, not where they need to be. Work backwards from gross margin. A brand at 65% margin needs a higher MER than one at 80%. Default to 3.5x if you don't know, but yours might be 2.8x or 4.2x. Set it intentionally, not by guess.

Log spend weekly, not monthly. The biggest leak in DTC marketing isn't bad creative. It's spending money in October that you should have spent in September. Block 20 minutes every Friday, drop in the week's spend, glance at pacing. Three months of this and you'll never be surprised by a month-end number again.

Remember blended MER hides what's happening inside. A 3.5x blend could be Meta at 4x and Google at 2.5x, or Meta at 2x and email at 8x carrying the rest. Same number, completely different decisions. If your MER drops next month and you can't tell which channel caused it, that's your next thing to figure out.

A note on the Lite version

We've built a Lite version of the tracker we use with our coaching clients. Three tabs, Setup, This Month, Dashboard. It's the same structure as above, sample data filled in so you can see how it works before you log anything of your own.

The Lite version shows you the top-line ratio, enough to know if you're on track. But a 3.5x blend could be Meta at 4x and Google at 2.5x, or Meta at 2x and email at 8x carrying the rest. Same number, completely different decisions. The full version our clients use breaks it out by channel so you can see where the leaks are.

For now, if your MER drops next month and you can't tell which channel caused it, that's your next thing to figure out.

The point

Most operators don't need more sophisticated tooling. They need consistent tooling. One tracker, kept current, that the whole team trusts.

Crawl, walk, run. Get the basics logged weekly before you go building forecasts.

If you've been meaning to rebuild yours, take this as the sign.

Want operator-led insights delivered before anyone else?

Subscribe to our mailing list and get all our articles, strategies, and real numbers straight to your inbox, before they're published anywhere else. No fluff, just what's working right now for brands in the trenches.