Back to all insights
Growth Modelling · 12 min read

Forecast-led marketing: the spreadsheet every growth partnership should start with.

A walkthrough of the unit-economics model we build before touching a single campaign — and why most retainers fail without one.

Clixii Strategy Team March 14, 2026

The question that ends most agency relationships

"We've been working together for six months. What is the revenue impact of what you've done?" Most agencies can't answer it — not because the work wasn't valuable, but because the engagement was never set up to measure value. Without a forecast, every conversation becomes subjective.

What a forecast model actually is

A financial document that answers one question before any work begins: "If this program works as designed, what will it add to pipeline and revenue — and by when?" It isn't a guarantee. It is a model of the math that can be tested against reality month by month.

Component 1: The funnel baseline

  • Monthly sessions to target pages, by channel
  • Conversion rate from session to lead, by channel and page
  • Conversion rate from lead to qualified opportunity
  • Conversion rate from opportunity to closed revenue
  • Average deal or order value
  • Average sales cycle length

Component 2: The channel economics model

For SEO: keyword clusters with volume, intent tier, CTR at target position, time-to-rank, projected sessions at 3/6/9/12 months. For Google Ads: keywords with CPC, Quality Score, target impression share, landing page CVR, target CPL. For paid social: CPM by platform, target CTR, target CAC vs blended LTV.

Component 3: The pipeline value calculation

Pipeline value = projected sessions × CVR to lead × lead-to-opportunity × deal value. A service business with $2,000 deal value, 4% CVR and 35% close rate earns $28/session of pipeline. 400 incremental sessions = $11,200/month. Against a $599 retainer, 18.7x at month six — before compounding.

Component 4: The leading indicators

Revenue lags. Leading indicators tell you whether the program is on track. SEO: crawl coverage, topical impressions, ranking velocity, backlinks. Google Ads: Quality Score, impression share, CTR vs benchmark, landing page CVR vs forecast.

Component 5: The investment case

Every investment has a break-even point. Presenting this calculation before asking a client to sign is the single most powerful trust signal an agency can offer.

Component 6: The model governance process

We update the model monthly with actuals. Where they lag, we diagnose the specific variable — volume, conversion or deal value — rather than guess at "more content."

Why most retainers fail without this

The reason most retainers end in frustration isn't mismatched expectations — it's mismatched measurement. A forecast model creates a shared language. If you're in a retainer with no forecast behind it, ask for one. The answer will tell you everything.

Put it to work

Want this framework applied to your business?

Book a 30-minute strategy call and we'll show you what this looks like inside your funnel — not in the abstract.