-
1
1. Set the bookings target and back into pipeline coverage
A demand-gen model starts at the end. Pull the bookings target for the planning window from finance and split it by segment, product line, or motion. Divide the marketing-sourced share of bookings by the historical win rate on marketing-sourced opportunities to get the sourced-pipeline target. Then multiply by the pipeline coverage ratio your sales leader signs off on, usually three to four times for mid-market and four to six times for enterprise. That final number is the pipeline target your model has to deliver. Write it at the top of the plan and reference it on every tab. If the pipeline target does not reconcile to the bookings number through win rate and coverage, the rest of the model is fiction.
- Pull the bookings target by quarter and segment from finance.
- Apply marketing-sourced share and historical win rate to get sourced pipeline.
- Multiply by the coverage ratio sales leadership signed off on.
Tip: If sales will not commit to a coverage ratio in writing, the demand-gen model has no anchor and will be renegotiated every month.
-
2
2. Translate pipeline into the funnel stages above it
Once the pipeline target is locked, work backward through the funnel using your trailing conversion rates. Divide the opportunity target by SQL-to-opp conversion to get the SQL target. Divide SQLs by MQL-to-SQL to get the MQL target. Divide MQLs by lead-to-MQL to get the lead target. Divide leads by visitor-to-lead to get the traffic target. Do this per segment, not in aggregate, because enterprise and SMB funnels convert at very different rates and mixing them hides the real demand gap. Lay the whole thing out as a stage-by-stage table with target volumes by month so your channel plan has concrete numbers to hit, not vague growth language.
- Build the stage table per segment: visitor, lead, MQL, SQL, opp, won.
- Use trailing six-month conversion rates, not single-quarter noise.
- Flag any stage where the historical conversion rate is below the industry benchmark.
Tip: A single blended funnel is a comfort blanket. Segment funnels are the only ones a CFO can defend.
-
3
3. Allocate the lead and MQL targets across channels
Now split the lead and MQL targets across the channels that will produce them. For each channel, start from last quarter's actual sourced-lead and MQL volume, then set a realistic growth or decline rate per channel based on budget, saturation, and team capacity. Paid search can scale 20-40 percent with budget. Organic content scales on a lag of two to three quarters. Events produce bursty pipeline. Partner and co-marketing scale with partner activity, not your spend. Document the assumption behind every channel number in a column next to it. Nobody should be able to open the model six months later and wonder where a number came from.
- List every live channel and its trailing lead and MQL volume.
- Set growth or decline percentages per channel with a written assumption.
- Reserve 10-20 percent of the lead target for a new-channel experiment line.
Tip: If every channel in your plan grows next quarter, the plan is a wish. Real demand plans have winners, losers, and a line item for experiments.
-
4
4. Attach cost assumptions and compute cost per outcome
A demand-gen model that only shows volume gets killed in the first finance review. Add a cost column to every channel line: planned spend for the quarter, planned headcount cost if the channel is people-heavy, and planned agency or vendor fees. Divide spend by lead volume for cost per lead, by MQL volume for cost per MQL, by SQL volume for cost per SQL, and by opportunity volume for cost per opp. Compare the cost per opp against average deal size times gross margin. If a channel's cost per opp is more than 20-30 percent of the gross profit on the deal it is likely to close, it is a candidate for cuts, not growth. Show the math inline so finance can audit it.
- Enter planned spend, headcount, and vendor cost per channel.
- Compute cost per lead, MQL, SQL, and opp for every channel.
- Flag channels where cost per opp exceeds gross profit per deal.
Tip: Cost per MQL is a vanity number. Cost per opportunity, trued up against win rate, is the one finance will defend.
-
5
5. Build the channel mix across paid, content, events, and partner
Group the channel lines into four buckets so the model tells a story a leadership team can argue about: paid acquisition (search, social, display, retargeting), content and SEO (editorial, SEO, product-led content, lifecycle), events and field (owned events, trade shows, dinners, webinars), and partner and ecosystem (co-marketing, marketplace, integration partners, referrals). For each bucket, show total planned spend, total sourced pipeline, blended cost per opportunity, and share of the total pipeline target. Mature B2B teams usually land somewhere in the 30/30/20/20 range across these four buckets, with heavier content for product-led motions and heavier events for enterprise. Use the mix view to argue tradeoffs, not the line items.
- Group every channel line into paid, content, events, or partner.
- Build a one-row summary per bucket: spend, pipeline, blended cost per opp, share.
- Compare your mix to one benchmark you trust and note the gaps.
-
6
6. Pressure-test the model with sales and finance before you lock it
A demand-gen model you built alone is a draft. Walk the model through sales leadership first, line by line. They need to agree the MQL volume is accepted, the SQL definition still holds, and the pipeline target matches the capacity of the rep team. If reps cannot physically work the SQL volume you are planning to deliver, the plan has to shrink or sales has to hire. Then walk the model through finance. They need to accept the spend envelope, the cost per opportunity math, and the implied gross margin. Record every concession in the plan document so you can show the chain of trade-offs when someone questions a number in month two.
- Review MQL and SQL volume with sales leadership against rep capacity.
- Review spend, cost per opp, and gross margin math with finance.
- Log every negotiated change in a decisions section of the plan.
Tip: If no number changed during the pressure-test, nobody actually read the model. Push for pushback.
-
7
7. Instrument the model inside the CRM and marketing stack
A demand-gen model that only lives in a spreadsheet drifts the moment the quarter starts. Wire the plan numbers into the systems that produce the actuals. Push the monthly targets per channel into the CRM as campaign goals so sourced-pipeline reports can show planned versus actual. Build a dashboard that shows cost per outcome by channel using live spend from the ad platforms and live pipeline from the CRM. Set alerts for any channel that drops below 70 percent or runs above 130 percent of its monthly target. Strkr AI can watch the drift between planned and actual pipeline and surface the two or three channels that need attention first so the team is not reading seventeen charts to find a problem.
- Load monthly channel targets into the CRM as campaign goals.
- Build a plan-versus-actual dashboard for pipeline and cost per opp.
- Set alert thresholds at 70 percent and 130 percent of plan.
-
8
8. Review and reforecast on a quarterly cadence
A demand-gen model is a living document, not a one-time plan. Every quarter, pull actuals against plan at the channel and stage level, update conversion rates with the last 90 days of data, and rebuild the forward look. Kill channels that missed the cost per opp target twice in a row unless there is a documented strategic reason. Expand channels that beat plan if the capacity exists to scale them. Lock in a 60-minute review meeting with sales and finance for every quarter so the reforecast is a shared decision, not a marketing memo. Treat the model like a budget, not a dashboard, and the whole revenue team starts speaking the same language about demand.
- Pull actuals against plan by channel and stage; update conversion rates.
- Decide what to kill, what to expand, and what to leave flat.
- Hold a 60-minute quarterly review with sales and finance on the calendar.
Tip: A quarterly review that never kills a channel is a status update, not a planning meeting. Expect at least one line item to die every quarter.