Goal of the analysis:
Quantify and improve the percentage of contracts that successfully renew at end of term, both by count and by value. For executives, renewal rate is a direct proxy for revenue protection (customer contracts), continuity of supply (vendor contracts), and legal/compliance health (notice periods, obligations, and approvals). The analysis reveals where renewals stall, which segments churn or downgrade, and how process rigor, pricing, and service quality influence outcomes. It enables proactive intervention on high-value accounts/suppliers, better forecasting, and tighter governance of renewal timelines.
Data required:
- Contract master and key dates:
- Contract ID, type (customer, supplier, partner), status (active, renewed, expired, terminated).
- Effective date, initial term end, next renewal date, term length, auto-renew flag, renewal term.
- Notice period requirements, notice sent date, extension/amendment history.
- Commercial and financial terms:
- ARR/ACV/TCV (customers) or annualized spend/commitments (suppliers).
- Price changes at renewal (increase/decrease), discounts, indexation/escalators, minimum commitments.
- Revenue attribution or spend category, product/service mix tied to the contract.
- Lifecycle and workflow metadata:
- Renewal initiation date, legal review start/complete, approvals required/obtained, negotiation rounds.
- Owner assignments (account owner, procurement lead, legal reviewer) and RACI.
- Blocking reasons (pricing approval pending, counterparty delay, missing documents, data errors).
- Counterparty and segmentation attributes:
- Customer or supplier tier, industry, region, size band, strategic/criticality rating.
- Template source (our paper vs counterparty), governing law/language, deal band.
- Performance and relationship signals:
- Product usage/consumption, SLA attainment, incident history, service credits.
- CSAT/NPS/health score, executive sponsor engagement, QBR cadence.
- Systems and mapping:
- CLM (e.g., Icertis, Ironclad, DocuSign CLM), CRM (Salesforce), ERP (SAP/Oracle), P2P (Coupa/Ariba).
- Unique keys linking contracts to accounts/vendors, products, and financial records.
- Internal targets and external benchmarks for renewal KPIs.
Detailed step-by-step instruction on how to conduct the analysis:
- Define measures and cohort rules.
- Eligible cohort: contracts whose renewal date falls within the analysis period (e.g., quarter), excluding terminated-for-cause where renewal is not permitted.
- Outcome taxonomy:
- Renewed – Same terms; Renewed – Expanded (value up); Renewed – Reduced (value down).
- Auto-renewed (no material change) vs Negotiated renewal.
- Churned/Not renewed (expired or terminated without replacement).
- Superseded (migrated to new contract replacing the old one).
- Extract and unify data.
- Pull contract metadata and dates from CLM; financials from CRM/ERP; supplier spend from P2P.
- Normalize statuses and align amendments to parent agreements; ensure the signed latest version is used.
- Standardize product/service mapping and segment attributes (BU, region, tier, size band).
- Resolve denominators and numerators.
- Denominator (by count): number of eligible contracts in period.
- Denominator (by value): sum of ARR/ACV (customers) or annualized spend (suppliers) of eligible contracts.
- Numerators:
- Renewed (count/value) including expanded/reduced variants.
- On-time renewals: renewed on or before renewal date, or within policy grace window.
- Calculate core KPIs.
- Renewal Rate (count) = Renewed contracts / Eligible contracts.
- Gross Renewal Rate (value) = Value renewed excluding expansions / Eligible value.
- Net Renewal Rate (value, optional) = Value renewed including expansions − downgrades / Eligible value.
- On-time Renewal Rate = On-time renewed / Renewed.
- Churn Rate (count/value) = Not renewed / Eligible.
- Auto-Renew Share = Auto-renewed / Renewed.
- Median Lead Time to Renewal = Renewal date − initiation date (days).
- Segment and compare.
- By contract type (customer vs supplier), BU/region, product/service, tier, deal size, term length, and template source.
- By owner and counterparty industry; auto-renew vs negotiated; presence of price increase.
- Trend and cohort views.
- Monthly/quarterly trends for Renewal Rate (count and value), On-time, and Churn.
- Cohorts by start year or first term vs subsequent terms to isolate learning effects and lifecycle differences.
- Driver analysis.
- Correlate renewal outcomes with usage/consumption, SLA attainment, incidents, and CSAT/NPS.
- Assess impact of price increases or term changes on renewal likelihood and downgrade probability.
- Identify process bottlenecks from workflow timestamps (late initiation, legal queue, approvals).
- Validate edge cases.
- For “superseded” contracts, ensure the replacement contract is marked as renewal (avoid double counting).
- For evergreen/auto-renew, confirm notice compliance and classify as renewed only if the term actually rolled and invoicing continued.
- Reconcile to financials (invoicing/revenue/spend) for high-value contracts.
- Size risk and forecast.
- Value at Risk (VaR) next 30/60/90/180 days = sum of eligible value × renewal probability.
- Use health scores or historical renewal rates by segment to assign probabilities and build a renewal forecast.
- Set targets and alerts.
- Define thresholds by tier (e.g., Tier 1 customer renewal by value ≥95%; Tier 1 supplier on-time ≥99%).
- Automate alerts for T−120/T−90 initiation, missed notice windows, and high-risk accounts.
Format of the output of analysis:
- Executive KPI summary: Renewal Rate (count/value), On-time rate, Churn rate, Auto-renew share, median lead time, and Value at Risk for upcoming cohorts.
- Funnel or Sankey diagram: Eligible → Renewed (expanded/reduced) → Churned, by value.
- Segment heatmaps by BU/region/product/tier and owner scorecards with traffic-light thresholds.
- Trend charts (monthly/quarterly) for renewal and churn rates; cohort charts for first-term vs later-term renewals.
- Driver charts: renewal rate vs usage/CSAT/SLA attainment; price change vs renewal likelihood.
- Top 20 upcoming high-risk renewals with owner, renewal date, notice status, next action, and expected impact.
- Methodology and definitions appendix to ensure consistent interpretation.
How to interpret results:
- High renewal by value with moderate renewal by count indicates losses concentrated in smaller contracts; prioritize scalable automation for the long tail.
- Low renewal by value despite healthy count implies attrition of large or strategic contracts—an executive risk requiring bespoke save plans.
- High on-time rate correlates with disciplined processes and fewer revenue/supply gaps; low on-time suggests poor initiation and approvals management.
- Auto-renew dominance can inflate renewal rates while masking missed re-pricing or unfavorable terms; review notice compliance and “missed renegotiation opportunities.”
- Downgrades at renewal may preserve count but erode value; track expanded vs reduced renewals separately.
- Segment differences matter: weak regions, products, or owners reveal capability gaps or product-market fit issues; performance/SLA shortfalls often precede churn.
- Trends over time should improve with playbook and system changes; volatility points to inconsistent execution or seasonality to plan for.
Steps a company can take to improve on this measure:
- Process and governance:
- Institutionalize a renewal calendar with SLA milestones (initiate T−120/T−90, legal review T−60, approvals T−30).
- Define clear RACI; require named owners for all Tier 1 and high-value contracts and weekly pipeline reviews.
- Standardize renewal playbooks including negotiation positions, fallback clauses, and commercial offers.
- Data and systems:
- Create a single “renewal record of truth” by integrating CLM, CRM, ERP/P2P; enforce structured fields for renewal date, notice period, and value.
- Automate alerts for notice windows and aging; surface renewal pipeline in CRM dashboards for sellers/owners.
- Ingest usage/SLA/CSAT signals into a health score to prioritize outreach and forecast probability.
- Commercial and product levers:
- Offer multi-year incentives, value-based pricing, or bundling to increase stickiness; preempt price increases with ROI storytelling and success plans.
- For suppliers, consolidate spend and negotiate rate cards and performance credits; maintain alternates to create leverage.
- Address chronic SLA gaps or feature gaps that correlate with churn; align roadmap commitments before renewal.
- Capability and incentives:
- Train sales/procurement and legal on renewal tactics, clause fallbacks, and approval pathways.
- Align incentives to renewal by value and on-time rates, not just bookings or PO issuance.
- Use executive sponsors for top-tier renewals and structured QBRs to surface value delivered.
- Scenario guidance:
- If renewal count is high but value is low: focus on preventing downgrades, review discounting and packaging.
- If renewal count is low but value is high: automate long-tail outreach and approvals; consider default auto-renew with favorable terms.
- If on-time is low: trigger early-initiation policies and fast-track approvals for near-term expiries; deploy legal ops capacity for peak months.
- If auto-renew share is high: run a “missed renegotiation” review to capture indexation and terms improvements.
Benchmark comparisons:
General benchmarks:
- Customer contracts (subscription/services):
- Gross Renewal Rate (value): best-in-class 90–97%; typical 80–90%.
- Renewal Rate (count): best-in-class 85–95%; typical 75–85%.
- On-time Renewal Rate: best-in-class ≥90% within policy windows.
- Supplier agreements:
- Strategic/critical suppliers: renewal by value ≥95% unless a deliberate strategic switch; on-time ≥95%.
- Tail suppliers: renewal by count 60–85% depending on consolidation and rationalization strategies.
- Auto-renew portfolios:
- Auto-renew share ≥50% is common in SMB portfolios; notice compliance should be ≥95%.
Segment- or industry-specific benchmarks:
- B2B SaaS: GRR 85–95%; NRR 100–120% (contextual; include only if measuring net value effects).
- Managed services/outsourcing: renewal by value 90–96% with multi-year terms and high on-time adherence.
- Industrial maintenance/repair: 80–92% by value; seasonal patterns around shutdown windows.
- Public sector frameworks: on-time compliance near 100% due to statutory requirements; renewal rates depend on rebid cycles.
If external benchmarks are limited, build internal ones: compare BUs/regions and top-quartile performers, maintain 12-month rolling cohorts to smooth seasonality, and set tier-based thresholds (e.g., Tier 1 customers ≥95% renewal by value; Tier 1 suppliers ≥99% on-time). Track continuous improvement against these baselines and update targets annually.
