Forecasting Next Quarter's Revenue From Blended ROAS And Planned Spend
A CFO-ready model that turns planned monthly paid spend and trailing-90-day blended ROAS into a defensible quarterly revenue forecast — with seasonality and channel-mix adjustments built in.
Quick answer
Forecast next quarter's revenue as: (planned monthly paid spend) × (trailing-90-day blended ROAS) × (seasonality index) × (channel-mix adjustment). Sum the three months. Trailing-90 blended ROAS is your base rate; seasonality and mix shift are the only knobs that should move the number.
Quarterly Revenue Forecast From Blended ROAS
A forecast model that multiplies planned monthly paid spend by trailing blended ROAS, adjusted for seasonality and channel-mix shift.
This is the artifact you hand a CFO when the media team needs next-quarter budget approval. Instead of summing channel-level ROAS projections — which double-count assisted conversions and collapse under iOS attribution gaps — you anchor on blended ROAS (total revenue ÷ total paid spend) over a trailing 90-day window, then forecast forward.
The model takes three inputs: planned paid spend by month, a trailing-90-day blended ROAS baseline, and two adjustment factors (seasonality index and channel-mix delta). It returns a monthly and quarterly revenue projection that survives finance review because every assumption is auditable.
Channel-ROAS forecasts break the moment a CFO asks the obvious question: if Meta reports 4.2× and Google reports 5.1×, why is total revenue only 3.6× of spend? Platform-reported ROAS overlaps, inflates, and ignores organic lift.
Blended ROAS — closely related to MER (Marketing Efficiency Ratio) — sidesteps that fight. It treats paid spend as one lever and total revenue as one outcome, which is the only framing finance trusts for a quarterly commitment.
The core forecast mechanic
Pull the trailing 90 days of total revenue and total paid spend across Meta, Google, TikTok, and any other paid channel. Divide. That's your baseline blended ROAS — call it 3.4× for an apparel store doing €600k/quarter on €180k spend.
Then take next quarter's planned monthly spend from the media plan. If you're planning €70k / €85k / €120k across the three months (a Q4 ramp), the naive forecast is spend × baseline ROAS: €238k, €289k, €408k. Total: €935k. That's your unadjusted number.
The unadjusted forecast is wrong on purpose
Submitting €935k as the forecast skips the two adjustments that always matter: seasonality (does November convert at the same rate as August?) and channel-mix shift (are you adding TikTok spend that hasn't shown up in the trailing 90-day blended ROAS?). Skip these and the model under- or over-shoots by 15-30%.
Adjusting for seasonality
Build a seasonality index from your prior two years of monthly revenue. Express each month as a ratio to the trailing-12-month average. For most apparel and beauty stores, November runs 1.4-1.7×, December 1.5-1.9×, and January 0.7-0.8×.
Multiply each month's unadjusted revenue by its seasonality index. The Q4 example: €238k × 1.15 (Oct) + €289k × 1.55 (Nov) + €408k × 1.75 (Dec) = €273k + €448k + €714k = €1.44M. The seasonality adjustment moved the forecast by 54%.
Two practical notes. Use revenue-weighted seasonality, not traffic-weighted — AOV swings too. And if you don't have two years of clean data, borrow vertical benchmarks for the first cut and replace them once you've banked a full cycle.
Adjusting for channel-mix shift
Typical trailing-90-day blended ROAS by vertical and order-value tier
| Vertical | AOV €40-80 | AOV €80-150 | AOV €150+ |
|---|---|---|---|
| Apparel & accessories | 2.8× - 3.6× | 3.2× - 4.2× | 3.8× - 5.0× |
| Beauty & personal care | 3.0× - 3.8× | 3.4× - 4.4× | 4.0× - 5.2× |
| Home & lifestyle | 2.5× - 3.2× | 3.0× - 3.8× | 3.5× - 4.6× |
| Consumer electronics | 2.2× - 2.8× | 2.6× - 3.4× | 3.0× - 4.0× |
| Food & supplements (subs) | 2.4× - 3.0× (first order) | 2.8× - 3.6× | 3.4× - 4.4× |
If next quarter's plan reallocates spend toward a channel that wasn't in the trailing 90-day baseline — adding €30k/month of TikTok when the baseline was Meta + Google only — your blended ROAS will drift. New-channel ROAS in the first 60 days typically lands 30-50% below your existing baseline as the algorithm learns and you test creative.
A worked apparel scenario
A Shopify apparel brand at €8M annual revenue, AOV €95, runs trailing-90 blended ROAS of 3.4×. Q4 plan: €70k Oct, €85k Nov, €120k Dec, with €15k/month of that being new TikTok spend. October seasonality 1.15, November 1.55, December 1.75.
Step one: baseline forecast = (70+85+120) × 3.4 = €935k. Step two: apply seasonality month-by-month → €1.44M. Step three: discount the new-channel portion. €45k of TikTok spend across the quarter at ~60% of baseline ROAS costs roughly €45k × 3.4 × 0.40 = €61k. Adjusted forecast: ~€1.38M.
What finance will push back on
Expect three questions. First: "what's the confidence interval?" Answer with a range — present the forecast as €1.25M-€1.50M with €1.38M as the point estimate, derived from the standard deviation of weekly blended ROAS over the trailing 90 days.
Second: "what happens if blended ROAS drops 10%?" Build a sensitivity row showing forecast at 0.9×, 1.0×, and 1.1× baseline ROAS. Third: "how does this reconcile to channel reports?" That's the bidding-on-channel-ROAS-while-forecasting-on-blended tension — name it explicitly so finance knows you've thought about it.
Frequently asked questions
Channel ROAS double-counts assisted conversions and over-credits last-click channels. Summing Meta's reported 4× and Google's reported 5× routinely overshoots actual revenue by 20-40%. Blended ROAS (total revenue ÷ total paid spend) is the only number that ties back to your P&L.
90 days is the sweet spot for most stores: long enough to smooth weekly noise and creative cycles, short enough to reflect current attribution reality (post-iOS, post-cookie deprecation). Use 30 days only if you've had a structural change — relaunch, new market — that makes older data misleading.
They're effectively the same metric framed differently. Blended ROAS = total revenue / total paid spend. MER (Marketing Efficiency Ratio) is the same ratio, sometimes calculated against total marketing spend including organic-content production. For forecasting paid revenue, use blended ROAS over paid spend only.
Discount the new-channel spend portion to 50-70% of your baseline blended ROAS for the first 60 days, then 80-90% for days 60-90. Don't assume parity in month one — algorithm learning and creative testing always cost ROAS upfront.
Monthly for the CFO-facing artifact. Weekly internally so you can spot drift early. If actual week-three revenue is 20% below the implied weekly forecast, you investigate before the month closes rather than explaining the miss after.
Use a vertical benchmark for the first quarter: apparel and beauty peak Nov-Dec at 1.4-1.8×, home goods peak Nov-Jan, food/supplements are flatter. Replace borrowed values with your own as soon as you've banked one full cycle. Document which months are estimated vs measured.
Highly vertical-dependent. Apparel at AOV €80-150 typically runs 3.2×-4.2× blended. Beauty runs similar. Electronics runs lower (2.6×-3.4×) because of thin margins and competitive bidding. Use the benchmark table above as a sanity check, not a target.
It won't, and that's fine. Platforms report on their own attribution model with their own lookback window; blended ROAS is a closed-loop ratio against your actual revenue. The reconciliation belongs in a separate document — see bidding on channel ROAS while forecasting on blended for the framing.
Keep it separate. The blended ROAS forecast covers paid-driven revenue. Organic (direct, SEO, email to existing list) should be forecast separately from cohort and list-size trends, then added to the paid forecast for the total revenue line.
Calculate the standard deviation of weekly blended ROAS over the trailing 90 days. Present the point estimate ± one standard deviation as the likely range. A finance audience prefers "€1.25M-€1.50M, most likely €1.38M" over a single false-precision number.
Track CAC, channels, and funnel conversion in one place
Metricuno connects ad spend, funnel events, and revenue so you can see CAC by channel, cohort, and campaign — without stitching together five tools.