A sales forecast answers a simple question: how much will we sell next month, quarter or season? For an eCommerce brand, the most useful forecasts split revenue into its drivers instead of drawing a line through last year’s total. The two main drivers are returning customers, who buy on a fairly predictable pattern, and new customers, who depend mostly on marketing spend and its cost per acquisition.
Seasonality, promotions, launches and stock levels then adjust the base. A good forecast is updated every month as real results come in.
Why it matters for eCommerce
Inventory and cash are where most stores get hurt. Under-forecasting causes stockouts on best sellers. Over-forecasting ties up cash in slow stock that later needs markdowns, which erodes margin. A driver-based forecast also shows which lever moves revenue: more spend, better retention or higher order value.
How to calculate it
Forecast revenue = returning customer revenue + new customer revenue. Returning customer revenue = active customers × expected repeat purchase rate × average order value. New customer revenue = planned acquisition spend ÷ expected CAC × first-order AOV.
Example (illustrative numbers): you have 20,000 active customers, a monthly repeat purchase rate of 5% and an AOV of $70, so returning revenue is 20,000 × 0.05 × $70 = $70,000. You plan $40,000 in acquisition spend at a $50 CAC, which brings 800 new customers at a $60 first-order AOV, or $48,000. The base forecast is $118,000 before seasonal adjustments.
Common mistakes
- Projecting total revenue growth without separating new and returning customers.
- Assuming CAC stays flat as spend rises, when marginal CAC usually climbs.
- Ignoring stock limits, so the forecast includes sales you cannot fulfill.
- Setting the forecast once a year and never comparing it with actuals.