Growth Model — Advisory

Growth Model - Integrated Revenue Planning and Capacity Modeling

1) Project Overview

What is the name of this project?

Growth Model - Integrated Revenue Planning and Capacity Modeling

What is the purpose of this project?

A Growth Model reverse-engineers your revenue funnel to meet a future growth goal. You work backwards from an exit ARR target to determine the bookings needed, pipeline required, SQLs and MQLs to create, and resources needed to fund that growth plan.

Core Transformation: From disconnected planning across sales, marketing, and CS operating in silos to a single integrated model where every function's targets, hiring timelines, and budgets are mathematically tied to the company's revenue goals.

What Growth Model Unlocks

Before	After
Unclear headcount needs - "We need to hire some reps"	Know exactly how many sales reps and CSMs needed by quarter with specific hiring dates
Vague marketing budget - "Increase spend"	Precise marketing spend per channel tied to pipeline goals
Disconnected goals - Each team sets own targets	All bookings, pipeline, SQL, and MQL goals mathematically tied together
No hiring timeline - Hire when capacity feels tight	Clear hiring schedule accounting for ramp time and sales cycle
Guessing at pipeline needs - "More pipeline is better"	Know pipeline requirements per rep to ensure effectiveness
Risks identified too late	Risks surface early through bottom-up validation of targets
Missed opportunities	Functional teams identify growth and efficiency opportunities

AI-First Benefits

Traditional Approach	AI-First Approach
Manual CRM analysis taking hours	GTM Analyst Agent analyzes CRM exports in minutes
Walk into Meeting 2 without a draft	Walk into Meeting 2 with a tailored v0 draft ready
20-30 hours per engagement	~15 hours per engagement
Only experienced architects can deliver	Any architect can deliver with playbook + agent guidance
Manual data validation	Agent outputs provide quality checks and red flag detection
Insights limited to what you manually find	Agent surfaces unexpected patterns in the data

What business outcomes does this project drive?

Primary Outcomes:

• Clear new business bookings goal mathematically tied to ARR target
• Headcount plan for sales reps by quarter with specific hiring timing
• CSM headcount plan by quarter with ramp timing
• Marketing budget by channel with SQL targets
• Quarterly SQL and MQL targets accounting for sales cycle offset

Secondary Outcomes:

• Foundation for tracking execution vs plan throughout the year
• Risk identification framework (attrition, underperformance, market shifts)
• Budget justification for board and leadership presentations
• Alignment between executive targets and functional team capacity
• Data to adjust plan as assumptions prove true or false

Who in the Org can benefit from this project?

Executive Leadership: CEO, CFO, CRO - Sets strategic targets, approves final plan, uses model for board presentations and investor discussions

Functional Leadership: VP Sales, VP Marketing, VP Customer Success - Receives targets tied to overall revenue goals, validates bottom-up capacity, identifies risks and opportunities

Operations: RevOps Manager, Sales Ops, Marketing Ops - Builds and maintains the model, tracks execution vs plan, runs scenario analysis

Finance: FP&A, Controller - Validates assumptions, aligns to financial model, approves budget allocations

Board: Uses model to understand path to revenue targets and resource requirements

Pain Points this Project Solves

Pain Point	What Growth Model Enables
"We keep missing our targets but don't know where the breakdown is"	Integrated model connecting revenue goals to headcount, pipeline, and budget - when one metric slips, you know exactly which lever is off
"We hire reps but still miss bookings"	Bottom-up capacity planning that accounts for ramp time (avg 7 months to full productivity) [1] and attrition (avg 30% turnover) [2] - not just headcount math
"Marketing and sales point fingers at each other"	Single source of truth connecting SQL targets to bookings targets with explicit conversion rates and timing offsets
"We planned for growth but ran out of cash before we got there"	Full GTM budget integration (sales, marketing, CS) tied to hiring timing and pipeline requirements
"Board wants 50% growth but our team says it's impossible"	W Method aligns top-down targets with bottom-up capacity reality - identifies gaps before execution begins
"Our finance model and sales model use different bookings definitions"	Definitions repository creates alignment on ARR, bookings, churn, and conversion metrics across departments
"We don't know when to hire CSMs"	CSM carry model ties hiring timing to forecasted ARR/logo growth with ramp time accounted for
"Departments plan in silos and nothing connects"	Integrated model where sales capacity feeds marketing pipeline targets, which feed SQL goals, which feed brand/awareness strategy

The Data Behind the Problem

Problem Area	Data Point	Source
Business failure rates	20% of businesses fail in first 2 years; 45% fail in 5 years; 65% fail in 10 years	Bureau of Labor Statistics [3]
IPO achievement	Less than 1% of startups ever reach IPO or strategic acquisition	CB Insights [4]
Root cause	Poor planning is the primary driver of failure - not product, not market	CB Insights [5]
Sales/marketing misalignment	Costs companies 10% of annual revenue on average; 96% of teams report alignment issues	Demandbase, Jifflenow [6][7]
Sales capacity planning errors	New B2B reps take average of 7 months to reach full productivity (Forrester)	Forecastio [1]
Attrition ignored	Average B2B sales rep attrition is 30% - rarely factored into headcount plans	CaptivateIQ [2]
Quota attainment crisis	Only 30% of B2B reps hit quota in 2024; down from 44% in 2022	Salesforce State of Sales [8]
Forecasting accuracy	Only 7% of organizations achieve >90% forecast accuracy; fewer than 50% of sales leaders trust their forecasts	Gartner [9]
VC-backed outcomes	75% of venture-backed companies never return cash to investors	CB Insights, Scale Finance [4][10]

Companies with disconnected planning - where sales, marketing, CS, and finance operate from different assumptions - are significantly more likely to miss targets, burn cash, and fail to achieve their strategic goals.

Key Metaphors or Frameworks

The W Method

A planning framework that creates alignment between executive leadership and functional teams through iterative cycles:

1. Top-Down Guidance (First Down): Executive team provides strategic initiatives, growth goals, key metrics
2. Bottom-Up Plan (First Up): Functional teams create comprehensive plan including capacity model, CS carry model, marketing budget
3. Executive Review (Second Down): Leadership reviews, potentially adjusts assumptions based on bottom-up reality
4. Final Bottom-Up Plan (Second Up): Functional teams create updated plan aligned with refined guidance
5. Final Approval: Executive team approves comprehensive plan for implementation

When to use: When building a growth model that requires both strategic alignment AND operational realism. When board/executive targets need validation against actual capacity.

When NOT to use: Quick planning cycles where time doesn't allow for multiple iterations. Situations where one direction is already fixed (e.g., non-negotiable board mandate or purely bottom-up capacity constraint).

Reverse-Engineer the Funnel

Start from the end goal and work backwards:

1. Revenue target (anchor point)
2. Net retention effect on existing base
3. New business bookings required
4. Pipeline needed (at conversion rate)
5. SQLs needed (with sales cycle offset)
6. MQLs needed
7. Brand and awareness activities

This framework ensures every metric is mathematically connected to the revenue goal.

Target Motion

Primary Fit: Sales-led growth (SLG) with meaningful deal sizes ($25K+ ACV) and defined sales cycles

Also Fits:

• Hybrid motions with both inbound and outbound
• Companies with enterprise, mid-market, and SMB segments
• Hardware-enabled SaaS with install lag between booking and revenue recognition

Not a fit for:

• Pure PLG with no sales involvement (growth comes from self-serve)
• Transactional sales with no pipeline or capacity constraints
• Very early stage with no historical data to build assumptions

Growth Context

Most relevant when:

• Marching toward IPO - Need to demonstrate predictable growth and resource efficiency
• Preparing for acquisition - Need clear path to revenue targets for valuation
• Raising capital - Investors want to see capacity math behind growth projections
• Scaling team - Need to know when to hire and what each hire should produce
• Board pressure - Need to defend hiring and budget requests with data
• New fiscal year planning - Annual planning cycle requiring integrated targets

---

2) Tools & Systems

Primary Tools

Spreadsheet Software (Google Sheets or Microsoft Excel)

The foundational tool for building growth models. All model construction uses spreadsheet format with multiple tabs for annual summary, top-down planning, bottom-up departmental plans, and a definitions repository.

Required capabilities:

• Formula support for linked calculations across tabs
• Collaboration features for team input (Google Sheets preferred for real-time collaboration)
• Version history for tracking model iterations
• Export to PDF/presentation formats for board/leadership delivery

CRM System (Salesforce or HubSpot)

The primary source of truth for historical performance data that drives model assumptions:

• SQL to Closed-Won conversion rates by segment
• Sales cycle length by segment and deal size
• MQL to SQL conversion rates by channel
• Quota attainment history by rep
• Average deal size (ACV) by segment

Marketing Automation Platform (HubSpot Marketing Hub or Marketo)

Source of marketing performance data for the pipeline production plan:

• MQL volume by channel and source
• Cost per SQL by channel
• Campaign attribution data
• Channel efficiency metrics (budget-to-pipeline ratios)

Integration note: Marketing automation data must align with CRM opportunity data to calculate accurate funnel metrics. A typical benchmark for MQL-to-SQL conversion is 13% across B2B.

Secondary Tools (Optional)

Revenue Planning Platforms

For ongoing tracking and scenario modeling after initial model build:

Platform	Best For	Notes
Vasco	B2B SaaS $1M-$100M ARR	Tracks funnel metrics, headcount, plan vs actuals with green/yellow/red status. Includes AI copilot for insights.
Pigment	Enterprise financial planning	More intuitive than Anaplan, natively sparse engine, AI analyst capabilities
Anaplan	Large enterprises with complex modeling	Most mature ecosystem, Hyperblock engine for large datasets, but steeper learning curve

BI Dashboard Tools

For visualizing growth model outputs and tracking actuals vs plan:

Tool	Best For	Key Feature
Tableau	Interactive visualizations	Drag-and-drop dashboard creation, geographic mapping
Looker	Metric consistency at scale	Semantic layer (LookML) ensures single source of truth for metrics
Mode	SQL-native teams	dbt Semantic Layer integration for governance

Customer Success Platforms

For CSM capacity data and retention metrics feeding the CS component of the growth model:

Platform	Best For	CS Capacity Feature
Gainsight	Enterprise CS at scale	Advanced health modeling, renewal forecasting
ChurnZero	Mid-market SaaS	Real-time churn detection, automated playbooks

Note: AI-driven CS platforms can help teams handle 5-10x more accounts per CSM without reducing engagement.

---

3) Stakeholders & Roles

Client-Side Stakeholders

Executive Sponsor (CEO or CRO)

• Required for: Top-down guidance setting, bottom-up plan review, final approval
• Responsibilities:
  • Set strategic growth targets (IPO timeline, fundraising goals, acquisition positioning)
  • Approve or refine revenue targets from board
  • Make trade-off decisions when bottom-up capacity doesn't match top-down goals
  • Sign off on final model for implementation

Finance Lead (CFO or VP Finance)

• Required for: Definition alignment, model validation, budget approval
• Responsibilities:
  • Align on critical definitions: ARR, bookings, churn, net retention
  • Validate growth model ties to operating plan and financial model
  • Approve marketing and sales budgets derived from model
  • Set payment term targets (upfront vs monthly) with impact on cash flow
  • Review commission scenarios and cost assumptions

Sales Leader (VP Sales or CRO)

• Required for: Sales capacity planning, quota validation, hiring timeline approval
• Responsibilities:
  • Provide historical quota attainment data by rep and segment
  • Validate ramp time assumptions (training + pipeline build + first close)
  • Approve segment-based quota expectations (Enterprise vs Mid-Market vs SMB)
  • Commit to hiring timeline and attrition assumptions
  • Confirm win rates, average deal sizes, and sales cycle by segment

Marketing Leader (VP Marketing or CMO)

• Required for: Pipeline production planning, channel allocation, budget commitment
• Responsibilities:
  • Provide historical cost-per-SQL and budget-to-pipeline ratios by channel
  • Allocate SQL targets across channels (Paid, Events, Inbound, SDR, Partners)
  • Commit to channel-specific efficiency assumptions
  • Identify which channels are elastic (scalable with investment) vs capped
  • Align on lead time for marketing initiatives producing SQLs

Customer Success Leader (VP CS or CCO)

• Required for: Retention targets, CSM capacity planning, expansion assumptions
• Responsibilities:
  • Provide net retention rate and churn/contraction expectations
  • Validate CSM carry ratios (ARR per CSM, logos per CSM)
  • Commit to CSM hiring timeline based on new logo projections
  • Define expansion and upsell contribution to revenue targets
  • Provide referral forecast (CS contribution to SQL pipeline)

RevOps / Operations Lead (Director RevOps or VP Revenue Operations)

• Required for: Data provision, model maintenance, tracking implementation
• Responsibilities:
  • Pull historical performance data from CRM (conversion rates, sales cycles, pipeline)
  • Validate data quality and identify gaps requiring assumptions
  • Load approved model into tracking platform
  • Maintain model with actuals vs plan tracking
  • Provide ongoing funnel metrics reporting (green/yellow/red status)

Stakeholder Involvement by Phase (W-Method)

Phase	Executive Sponsor	Finance	Sales	Marketing	CS	RevOps
Top-Down Guidance	A	C	I	I	I	I
Bottom-Up Build	I	C	R	R	R	R
Executive Review	A	C	C	C	C	I
Final Approval	A	A	I	I	I	I
Ongoing Tracking	I	I	I	I	I	R

A = Accountable, R = Responsible, C = Consulted, I = Informed

Board Involvement

The board is typically involved in setting high-level growth targets, particularly when tied to strategic outcomes:

• IPO timeline requirements
• Acquisition positioning targets
• Fundraising round expectations
• Efficiency parameters (burn rate, CAC payback, LTV/CAC)

The board provides constraints but does not participate in model-building workshops. The Executive Sponsor translates board requirements into actionable top-down guidance for the W-Method process.

---

4) Scoping

Scoping Factors

The following factors determine how to scope a Growth Model engagement. Use these during discovery to understand complexity and approach.

Factor	Key Question	Impact
CSM Capacity Model	Revenue-based or logo-based?	Determines CS headcount calculation
Sales Cycle Length	Same-quarter, one-quarter, or multi-quarter?	Determines pipeline timing offset
Sales Ramp Time	How long to full productivity?	Affects hiring timeline
Quarterly Weighting	Even or back-weighted?	Affects budget/hiring timing
Channel Mix	Linear (SDR, Paid) or non-linear (Partners, Content)?	Affects marketing budget strategy
Firmographic Segmentation	Enterprise, Mid-market, SMB, or multi-segment?	May need separate models
Geographic Segmentation	Single region or multi-region?	May need regional models
Industry Segmentation	Single vertical or multi-vertical?	Segment-specific conversion rates
Product Line Segmentation	Single product or multi-product?	May need per-product models
Payment Terms	Upfront annual or monthly?	Affects cash flow modeling
Install Lag	Hardware-enabled SaaS?	Adds bookings-to-ARR complexity
Quota Attainment	What's realistic attainment?	Use expected, not assigned quota
Attrition Rate	Historical turnover?	Build buffer hires into plan

Planning Approaches

Three approaches for building a Growth Model, depending on context:

Approach	When to Use	Time Required
Top-Down	Board has set firm targets; limited time (<2 weeks)	Fast
Bottom-Up	Strong historical data; team buy-in critical	Moderate
W Method	Need strategic + operational alignment; 4+ weeks available	Comprehensive

---

5) Discovery Questions

Questions for Project Kickoff

Business Context:

• What is your revenue target for next year and how was it set? (board mandate vs internal goal)
• What growth rate does this represent and how does it compare to this year?
• Are there any strategic milestones this plan needs to support? (fundraising, acquisition, IPO)

Current State:

• What is your current ARR and net retention rate?
• How many quota-carrying reps do you have today?
• What was average quota attainment last year by segment?
• What is your current marketing budget and how is it allocated across channels?
• How many CSMs do you have and what is their average book of business?

Data Availability:

• Where does your funnel data live? (Salesforce, HubSpot, spreadsheet)
• How far back can we access reliable conversion data?
• Do you have segment-level metrics or only aggregate?
• What definitions do you use for ARR, bookings, MQL, SQL?

Timing & Constraints:

• What is your timeline for having this plan complete?
• Who needs to approve the final plan?
• Are there any constraints we should know about? (hiring freeze, budget cap, territory restrictions)

Information to Gather Before Implementation

CRM Data Export:

• Last 12-24 months of opportunity data with close dates, amounts, and stage progression
• Win rates by segment and sales cycle duration
• Rep-level performance data for capacity modeling

Marketing Data:

• MQL and SQL volume by channel for past 12 months
• Cost per SQL by channel
• Budget allocation by channel

Finance Data:

• Current ARR and retention metrics
• Operating budget parameters
• Payment term mix targets

HR/Sales Ops Data:

• Historical ramp times for new hires
• Attrition rates by team
• Planned hiring timelines already committed

---

6) Common Objections

Common objections you'll hear during Growth Model scoping, with brief reframes:

Objection	Reframe
"We need perfect data first"	You need documented assumptions and monitoring cadence, not perfect data
"We already do capacity planning"	Capacity planning is one component; growth modeling integrates 6 functions
"We just need one more rep"	That's headcount math, not capacity math — factor in ramp and attrition
"We'll figure out pipeline as we go"	Pipeline must be built one sales cycle BEFORE target bookings period
"The board sets targets, we execute"	Bottom-up validates what it takes to hit top-down; surfaces gaps early

---

7) Metrics Impact & Success Measurement

Power 10 Metrics Impacted

Power 10 Metric	Impact Direction	Expected Magnitude	Notes
Pipeline Production	↑ Increase	+15-30%	Clearer targets lead to better resource allocation
Opp→CW Conversion	→ Maintain	-	Not directly impacted; may improve with better rep/pipeline matching
Quota Attainment	↑ Increase	+10-20%	More realistic quotas tied to actual capacity
CAC Payback	↓ Decrease (improve)	-15-25%	Better channel allocation reduces wasted spend
Gross Retention	→ Maintain	-	Indirectly supported by CSM capacity planning
Net Retention	→ Maintain	-	Indirectly supported by CSM capacity planning

Expected Outcomes

Metric	Before	After	Source
Target miss variance	20-40% off target	<10% off target	Industry benchmarks
Hiring timing	Reactive (hire when overwhelmed)	Proactive (hire 1-2 quarters ahead)	Capacity planning
Cross-functional alignment	Each team plans independently	All targets mathematically connected	W Method framework
Assumption documentation	Informal or none	Formal register with monitoring	Best practices

How to Measure Success

Leading Indicators (Week 1-4 post-plan):

• All stakeholders can articulate their quarterly targets
• Hiring plan approved and recruiting initiated
• Marketing budget allocated by channel
• Tracking dashboard or Vasco instance configured

Lagging Indicators (Quarter 2-4 post-plan):

• Quarterly target variance <15%
• Hiring on schedule vs plan
• Pipeline production meeting SQL targets
• No surprise gaps discovered mid-year

---

References

[1] Forecastio - Sales Capacity Planning: Strategic Guide for 2025

[2] CaptivateIQ - Sales Capacity Planning Guide

[3] Bureau of Labor Statistics - Business Employment Dynamics

[4] CB Insights - The Venture Capital Funnel

[5] CB Insights - Top Reasons Startups Fail

[6] Demandbase - B2B Sales & Marketing Alignment

[7] Jifflenow - Sales and Marketing Alignment Statistics

[8] Salesforce State of Sales Report

[9] Gartner - FP&A Transformation Research

[10] Scale Finance - The Venture Capital Secret