CRO · Framework · Advanced · Saves 55+ hours
Revenue Funnel Analytics Framework
A framework for analyzing revenue funnel performance and identifying optimization opportunities.
What's included
- Funnel definition methodology
- Conversion analysis techniques
- Cohort analysis approach
- Bottleneck identification
- Optimization prioritization
- Forecasting integration
Best used when
- Analyzing funnel performance
- Identifying conversion issues
- Building cohort analysis
- Optimizing revenue engine
The template
The Template
FUNNEL DEFINITION
Standard B2B SaaS Funnel
REVENUE FUNNEL STAGES
AWARENESS (Top of Funnel):
• Website visitors
• Ad impressions
• Content views
ENGAGEMENT:
• Known leads (identified)
• Content downloads
• Event registrations
QUALIFICATION:
• MQLs (marketing qualified)
• SQLs (sales qualified)
• SALs (sales accepted)
OPPORTUNITY:
• Stage 1: Discovery
• Stage 2: Qualification
• Stage 3: Evaluation
• Stage 4: Proposal
• Stage 5: Negotiation
CUSTOMER:
• Closed Won
• Onboarding
• Adoption
• Expansion
Funnel Stage Definitions
| Stage | Definition | Entry Criteria |
|---|---|---|
| Lead | Known contact | Email captured |
| MQL | Marketing qualified | Score threshold + fit |
| SQL | Sales qualified | Meets BANT criteria |
| SAL | Sales accepted | Rep accepts lead |
| Opportunity | Active deal | Budget + timeline |
CONVERSION ANALYSIS
Conversion Rate Analysis
CONVERSION ANALYSIS TEMPLATE
STAGE: _______________
TIME PERIOD: _______________
VOLUME:
Entered stage: _____
Converted: _____
Lost/Disqualified: _____
CONVERSION RATE:
Current: ____%
Prior period: ____%
Change: +/- ____%
BREAKDOWN BY:
Source:
• Inbound: ____%
• Outbound: ____%
• Referral: ____%
Segment:
• Enterprise: ____%
• Mid-Market: ____%
• SMB: ____%
INSIGHTS:
_________________________________
_________________________________
Cohort Analysis Template
| Cohort | Lead → MQL | MQL → SQL | SQL → Opp | Opp → Won | Overall |
|---|---|---|---|---|---|
| Jan | % | % | % | % | % |
| Feb | % | % | % | % | % |
| Mar | % | % | % | % | % |
BOTTLENECK IDENTIFICATION
Funnel Bottleneck Analysis
BOTTLENECK IDENTIFICATION
STEP 1: Calculate conversion at each stage
Lead → MQL: ____%
MQL → SQL: ____%
SQL → Opp: ____%
Opp → Won: ____%
STEP 2: Compare to benchmarks
Stage with biggest gap: _______________
Gap vs. benchmark: _____% below
STEP 3: Root cause analysis
Why are we losing at this stage?
☐ Volume issue (not enough entering)
☐ Quality issue (wrong leads)
☐ Process issue (handoff problems)
☐ Timing issue (too slow)
☐ Skill issue (team capability)
STEP 4: Prioritize fixes
Impact if fixed: $_____
Effort to fix: Low/Med/High
Priority: P1/P2/P3
Leakage Analysis
| Stage | Expected | Actual | Leakage | Root Cause |
|---|---|---|---|---|
| Lead→MQL | % | % | % | |
| MQL→SQL | % | % | % | |
| SQL→Opp | % | % | % | |
| Opp→Won | % | % | % |
OPTIMIZATION PRIORITIZATION
Improvement Impact Calculator
OPTIMIZATION IMPACT MODEL
CURRENT STATE:
Leads: _____
MQL rate: ____%
SQL rate: ____%
Win rate: ____%
ACV: $_____
Revenue: $_____
IF WE IMPROVE [Stage] BY 10%:
New rate: ____%
Impact on revenue: +$_____
% increase: +____%
PRIORITY RANKING:
1. _______________: +$_____
2. _______________: +$_____
3. _______________: +$_____
Frequently asked questions
What is the Revenue Funnel Analytics Framework?
A framework for analyzing revenue funnel performance and identifying optimization opportunities.
Who is the Revenue Funnel Analytics Framework for?
It is built for CROs and their teams working on Revenue Operations. The AI coach adapts it to your company, stage, and goals.
How long does the Revenue Funnel Analytics Framework take to use?
It saves roughly 55+ hours versus building from scratch. Our AI coach can tailor the framework to your situation in minutes, then hand you a step-by-step plan.
Is the Revenue Funnel Analytics Framework free?
Yes. You can read the full framework and start getting coached through it for free. Sign in to save your tailored version and track your next steps.
How does the AI coach help with the Revenue Funnel Analytics Framework?
The coach teaches you the framework, asks a few questions about your business, tailors the framework to you, and gives you measurable next steps to execute.