Interview Questions › Root Cause Analysis

SaaS expansion slowed, renewals down, usage depth down

Your enterprise product line experienced a concurrent decline across Net Revenue Retention (NRR fell from 122% to 104%), Gross Renewal Rate (down from 94% to 86%), and Weekly Active Power Users per account (down 24%). Perform an executive-level diagnostic.

Context

Sales teams report increasing buyer pushback during contract renewals regarding "shelfware" and unused seat licenses.

Clarifying questions to ask first

• Is the renewal decline concentrated in specific company size tiers or industries?
• Are customers replacing the tool or simply downsizing their seat licenses?

How to approach it

1. Analyze Account Seat Utilization: Paid Seats vs Provisioned Seats vs Weekly Active Users (Shelfware Ratio)
2. Evaluate Product Usability & Modern Alternatives: Legacy UI complexity vs modern lightweight competitors
3. Examine corporate IT budget consolidation (CFO mandate to cut software redundancy)
4. Design a customer success and product activation strategy to defend enterprise accounts

Framework: Seat Utilization & Shelfware Audit -> Product UX & Workflow Complexity vs Modern Competitors -> Procurement & CFO Budget Scrutiny -> Account Recovery Playbook

Sample answer

• CFO-mandated seat audit: enterprises cutting unused licenses from 1,000 to 400 seats upon renewal
• End-users bypassing complex CRM workflows to use modern intuitive AI tools
• Lack of proactive Customer Success touchpoints for at-risk accounts

1. Telemetry data reveals: Only 35% of purchased seats were logged into in the last 60 days; during annual renewals, procurement teams cut licensing costs to match actual active usage

Shelfware crisis driving contract downsizing; introduced consumption-based flex licensing, embedded AI automated data entry to boost daily end-user utility, and established automated health alerts for CSM intervention.

What interviewers look for

• Net Revenue Retention (NRR %)
• Seat Utilization Ratio (%)
• Daily Active User / Monthly Active User (DAU/MAU)
• Feature Adoption Depth