Renewal Pipeline & Contract Expansion Velocity

Meridian Analytics • B2B SaaS Data Infrastructure • ARR $18.4M • 847 Accounts

Active Renewal Pipeline
$8.2M
312 accounts • 90-day window
Pipeline Coverage
0.94x
-22%
Funnel Conversion
74%
+3%
Avg Deal Velocity
38d
-9d
Win Rate (0-10%)
82%
+5%
Expansion Attach
34%
+8%
Forecast Accuracy
91%
-4%

Renewal Pipeline Funnel — 90-Day Window

Stage Breakdown: Identified → Engaged → Proposal → Negotiation → Closed Won. Coverage crisis in Q3 2024 due to CSM restructure delayed engagement by avg 18 days.

Renewal ARR Win Rate by Discount Band

Higher discounts (>20%) correlate with 31% lower win rate vs. 0-10% band.

Avg Deal Velocity by Segment (Days)

Enterprise deals avg 52d; Mid-Market 38d; SMB 21d. Velocity improved 19% QoQ in Mid-Market.

Days-to-First-Touch by Segment

Median lead time: Enterprise 87d, Mid-Market 64d, SMB 42d before contract expiry.

Expansion Attach Rate by Quarter

Q4 2024 expansion attach hit 34%, up from 26% in Q1. Driven by usage-based upsell motions.

Expansion Capacity Score Distribution (Usage Headroom)

Accounts scored 0-100 based on current usage vs. plan limits. Scores 70+ indicate high expansion opportunity.
0-20
21-40
41-60
61-80
81-100
Enterprise
12
18
24
31
19
Mid-Market
28
42
56
48
34
SMB
67
89
112
74
51
High-capacity accounts (61-100 scores): 257 accounts, $4.1M expansion opportunity. Prioritize for upsell.

Forecast Accuracy Waterfall (Q4 2024)

Predicted $7.8M vs. Realized $7.1M ARR. -9% variance driven by late-stage slippage in Enterprise.

Competitive Displacement Rate by Quarter

Q4 displacement rate: 8.2% to named competitors (DataFlow, AnalytixHub). Up from 5.1% in Q2.

Active Renewal Pipeline — Top 10 by ARR

Account Segment Renewal ARR Stage Days in Stage Forecast Category Expansion Opp Owner
TechForward Inc Enterprise $420K Negotiation 12 Commit $85K A. Chen
Vertex Solutions Enterprise $380K Proposal 8 Commit $62K L. Rivera
DataSync Corp Mid-Market $215K Negotiation 19 Best Case $38K M. Patel
Insight Analytics Mid-Market $198K Proposal 5 Commit $44K K. Johnson
CloudMetrics Ltd Enterprise $185K At Risk 34 Pipeline $0 A. Chen
Quantum Insights Mid-Market $172K Proposal 11 Best Case $29K T. Nguyen
Nexus Data Group Mid-Market $164K Negotiation 7 Commit $51K L. Rivera
Precision Analytics SMB $147K Closed Won — Closed $22K S. Kim
Streamline Ops Mid-Market $139K Proposal 14 Best Case $18K M. Patel
FlowState Tech SMB $128K Negotiation 6 Commit $15K K. Johnson

Renewal ARR by Segment (12-Month Trend)

Total renewal ARR $18.4M, up 12% YoY. Enterprise segment represents 58% of base.

Net Expansion Rate by Quarter

Q4 net expansion: 118% (gross expansion 22%, contraction -4%). Target: sustain ≥115%.