How to forecast Shopify paid-media growth—with LTV in the picture
Connect Meta and Google budgets to revenue, customer value and the cash needed to scale. A practical forecasting guide for Shopify and DTC brands.
The reporting definitions below reflect Morpheus Reporting. All worked examples are fictional teaching examples, not client results or performance promises.
Start with the decision, then build the forecast.
A useful paid-media forecast answers three questions: What could this budget produce? What would make the plan miss? How much can we afford to invest before customer revenue turns into available cash?
Morpheus Reporting brings monthly Meta and Google projections together with Shopify revenue, marketing efficiency and a customer-value view. LTV adds context to first-order performance, helping assess whether more acquisition investment is justified. It does not turn future revenue into cash today.
1. Establish a comparable baseline
Bring together monthly Meta spend and conversion value, Google spend and conversion value, and Shopify revenue. Add the promotion calendar, stock constraints, product margins, refunds and customer counts. Keep currency, time zone, revenue definitions and sales-channel scope consistent.
In Morpheus Reporting’s projection view, closed months use actual platform and Shopify numbers. The current month is paced to a full month; future months use saved projections. These are different evidence types. A paced month is an estimate, not a completed result.
Use the corresponding month last year to preserve seasonal context, then account for what has changed: a product launch, stronger creative, a larger returning-customer base or an inventory gap. Do not spread an annual growth target evenly across months when the business is seasonal.
Meta and Google can both claim credit for the same order. Their combined conversion value is not automatically unique Shopify revenue or incremental revenue. Reconcile platform reporting with the store before using the forecast to make spending decisions. Shopify explains how attribution models assign credit.
2. Build monthly channel projections
Our projection interface lets us set spend and ROAS by channel, plus an organic-revenue percentage. It calculates channel conversion value, combined spend, estimated revenue and MER. Here is the calculation structure:
- Channel conversion value = channel spend × assumed channel ROAS.
- Combined conversion value = Meta conversion value + Google conversion value.
- Estimated revenue = combined conversion value ÷ (1 − assumed organic share).
- MER = total store revenue ÷ total ad spend. Use estimated revenue for a projected MER.
The dashboard’s “organic contribution” is a revenue reconciliation assumption, not contribution profit or proof of an organic channel’s incremental effect. Historical differences between Shopify revenue and platform-attributed conversion value can include attribution overlap and measurement differences. Validate that residual before carrying its percentage forward; do not automatically treat it as extra sales.
ILLUSTRATIVE PROJECTION / FICTIONAL DATA
A monthly plan you can interrogate
A simplified recreation of the metrics in Morpheus Reporting—not a client dashboard screenshot.
| Metric | Month 1 | Month 2 | Month 3 |
|---|---|---|---|
| Meta spend | $20,000 | $25,000 | $30,000 |
| Meta ROAS | 3.0× | 2.9× | 2.8× |
| Google spend | $10,000 | $15,000 | $20,000 |
| Google ROAS | 5.0× | 4.5× | 4.2× |
| Combined conversion value | $110,000 | $140,000 | $168,000 |
| Assumed organic share | 20% | 25% | 25% |
| Estimated revenue | $137,500 | $186,667 | $224,000 |
| Projected MER | 4.58× | 4.67× | 4.48× |
As spend rises in this example, channel ROAS falls. That is intentional: a forecast should test diminishing returns rather than assume every additional dollar performs like the average dollar already spent. A higher Google ROAS alone does not prove Google should receive all the budget; branded search and returning demand can have different roles from prospecting.
3. Put LTV and CAC in context
Morpheus Reporting’s customer-value view uses the last 12 full months and compares them with the preceding 12 months. It displays average order value, orders per customer, returning revenue and these estimates:
- 12-month value (labelled LTV) = 12-month revenue ÷ customers.
- Blended acquisition cost (CAC) = (Meta spend + Google spend) ÷ new customers.
- Revenue-based payback proxy = CAC ÷ first-order value.
Orders without an associated customer are excluded from the customer-value calculation. The displayed LTV is a historical revenue-per-customer estimate, not a prediction of every new customer’s full lifetime profit. Blended CAC includes the effects of the overall acquisition mix; it is not a channel-specific incremental CAC and does not include every marketing cost.
Use this view to identify headroom and questions to investigate. For a stronger scaling decision, examine acquisition cohorts over comparable ages: how much revenue and contribution did customers generate by day 30, 90 or 180? Shopify’s customer cohort reports group customers by first-order date and help separate retention from changes in customer mix.
ILLUSTRATIVE CUSTOMER ECONOMICS / FICTIONAL DATA
Revenue headroom is not the spending limit
Assume $200 revenue per customer, $100 first-order value and $60 acquisition cost.
The dashboard’s first-order payback signal compares revenue with CAC. In this example, $60 ÷ $100 = 0.60, yet first-order contribution does not recover acquisition cost. To calculate cash payback time, track when cumulative contribution actually covers CAC. A revenue ratio is not a number of months.
4. Set contribution and cash guardrails
Before raising spend, translate the revenue opportunity into an allowable acquisition cost. Start with net revenue after discounts and refunds, then subtract cost of goods, payment fees, fulfillment and other variable order costs. Avoid counting a cost twice.
For a simplified example with a 40% pre-ad contribution margin, a same-scope revenue-to-ad-spend break-even ratio is 1 ÷ 0.40 = 2.5×. This covers the modeled variable costs and ads only—not overhead, agency fees or a profit target. A platform ROAS and store-level MER use different revenue scopes, so do not apply that threshold interchangeably.
A practical acquisition ceiling is expected customer contribution within the chosen payback window, less a reserve for uncertainty and the profit the business needs to retain. Compare that ceiling with observed CAC and the likely cost of the next customers, not only the historical average.
More repeat purchase can justify higher initial CAC when the evidence, margins and cash reserves support it. Inventory deposits, slow repeat-purchase cycles and rising refund rates can make the same apparent LTV unaffordable. Set a maximum cash exposure and review period before committing to the next budget increase.
5. Test scenarios and review pacing
Build a base, downside and upside case. Change the assumptions that drive the decision: spend, channel ROAS, organic share, margin, repeat purchase and stock availability. Label assumptions explicitly; a scenario is not a probability estimate.
For Month 1 above, cutting both channel ROAS assumptions by 20% while holding spend and organic share constant reduces estimated revenue from $137,500 to $110,000 and MER from 4.58× to 3.67×. If the business cannot fund the downside case, the base case is not enough to approve the budget.
Morpheus Reporting supports reviewing projections alongside actuals and pacing. Use that comparison to investigate whether a miss comes from spend delivery, conversion efficiency, order value, retention or timing. Allow for conversion lag and promotions before extrapolating a few days across a month.
As an external cross-check, Google’s Performance Planner models eligible Google Ads campaigns using recent auction data and seasonality. It can inform a channel assumption; it is not a substitute for store revenue, margins or a cross-channel cash plan.
A useful forecast review ends with a decision
- Increase: the next spend increment fits the contribution, inventory and cash limits.
- Hold: the result is within range but evidence is immature or conversion lag is material.
- Revise: CAC, margin, customer quality or stock availability has changed enough to invalidate the assumptions.
Common forecasting questions
Should a Shopify brand forecast six months at once?
Use a monthly six-month planning horizon, with more confidence in near-term assumptions and explicit scenarios farther out. Update the plan as actuals arrive; keep the previous version so changes remain explainable.
Does a high LTV:CAC ratio mean we should scale immediately?
No. Confirm the LTV definition, customer mix, contribution margin and time to repeat purchase. The ratio can identify an opportunity, but the next customers may cost more or retain less well.
Can a forecast guarantee profitable growth?
No. It makes assumptions visible and creates a framework for adjusting spend. Profitability still depends on actual demand, costs, execution and cash timing.
YOUR NEXT STEP
Turn the growth target into a testable plan.
Bring your channel spend, store revenue, margin assumptions and repeat-purchase data. We can discuss what the numbers support and what needs validating before you scale.
Discuss your Shopify growth plan