Forecasting isn’t just about plugging numbers into a spreadsheet — it’s the foundation of every strategic decision a brand makes. And when done right, it gives you a real map to grow by — one that reflects your business realities, risk tolerances, and opportunities to scale.
Most brands operate in silos. Marketing has its KPIs. Finance has its own. Ops is off running a different playbook. But growth doesn’t work in silos. Real forecasting connects every function to a shared outcome — and gives each team a lens into what levers they can pull to move the business.
At Aplo, we build forecasts that bridge these gaps. They align paid media strategy with cash flow needs. They turn email performance into next quarter’s growth plan. And they help you plan for real life — not just best-case spreadsheets.
The #1 forecasting mistake we see? Brands blending all revenue into one bucket. But the economics of acquiring a new customer versus retaining an existing one are radically different. Your forecast needs to reflect that.
New customer revenue is harder to predict — it relies on volatile channels like paid ads, fluctuating performance, and conversion rates that swing with market sentiment.
Returning customer revenue is more stable — especially when driven by email, SMS, and brand loyalty.
Why this matters: If you acquire at breakeven (or even a loss), but earn back your margin over months of repeat purchases, you need to forecast how those dollars compound. Otherwise, you risk making ad spend decisions blind to your real profit engine.
Model Revenue in Two Cohorts
When forecasting, break out:
First-time customer AOV (often lower, more promotional, or driven by top-of-funnel SKUs)
Returning customer AOV (often higher, with better margins and LTV dynamics)
Also factor in differences in:
By modeling these as distinct revenue streams, you can build more accurate CAC and contribution margin assumptions — and budget growth more responsibly.
Let’s be clear: contribution margin isn’t revenue. It’s not even gross margin. It’s the dollars left after variable costs — and it’s the only thing that pays the bills.
We always recommend tracking:
Pre-ad spend contribution margin (especially when analyzing cohort performance)
And yes — ad spend is variable. Even if you “set a budget,” you need flexibility to spend more when efficiency is high… and protect margin when it’s not.
This is a tricky one. Ads do drive some returning customer revenue, even with exclusions in place. But attribution here is murky. At Aplo, we usually default to assigning ad spend value to new customer acquisition only — unless a significant portion of spend clearly supports retention.
For most mid-7 to high-8 figure brands, the marginal lift from return customers via ads isn’t material enough to model precisely. But if you're running a massive remarketing engine, you’ll need to get more nuanced.
Forecasting COGS and Variable Costs
COGS should be forecasted with either:
SKU-level landed costs pulled from Shopify or ERP systems (ideal for accurate seasonal or category-level forecasting)
Brands with high SKU velocity or category expansion should be extra cautious. New products introduce LTV uncertainty and forecasting risk. Use initial performance data to recalibrate frequently — and avoid overcommitting to inventory without proven sell-through.
Fixed costs are where a lot of brands quietly bleed margin. Whether it’s headcount, software, or warehousing, these overheads need to scale carefully with revenue.
Our benchmarks:
Sub-10% of sales = healthy for most DTC brands buying finished goods
10–13% = acceptable, especially in growth mode or high-margin categories
Your forecast isn’t just a QBR document — it should inform daily decisions. If your sales are off, your costs are creeping, or your CAC is spiking, you need to see that in real time. And your forecast should help you ask: “What changed? And what can I do about it?”
If you don’t know how to do this yourself, bring in help — from your marketing team, finance team, or a partner like Aplo. The best forecasts are built collaboratively, updated frequently, and grounded in the metrics that matter most!