Awesome-claude-corporate-skills qbr-builder

Create Quarterly Business Reviews with account health scores, usage analytics, ROI analysis, expansion opportunities, and risk mitigation

install
source · Clone the upstream repo
git clone https://github.com/w95/awesome-claude-corporate-skills
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/w95/awesome-claude-corporate-skills "$T" && mkdir -p ~/.claude/skills && cp -r "$T/11-customer-success/qbr-builder" ~/.claude/skills/w95-awesome-claude-corporate-skills-qbr-builder && rm -rf "$T"
manifest: 11-customer-success/qbr-builder/SKILL.md
source content

QBR Builder

Overview

Master Quarterly Business Reviews (QBRs) that showcase mutual value, identify expansion opportunities, mitigate churn risk, and align customer success with business objectives. Effective QBRs build strategic partnerships and unlock growth.

QBR Structure & Agenda

1. Pre-QBR Preparation (2 weeks before)

Gather Data:

  • Usage analytics (logins, features, sessions)
  • Health indicators (support tickets, satisfaction scores, NPS)
  • Financial data (spend, utilization, ROI)
  • Roadmap alignment (upcoming features, releases)
  • Risk assessment (contract renewal date, alternatives risk, budget constraints)

Stakeholder Coordination:

  • Schedule 60-90 minute meeting
  • Invite: Account Executive, CSM, Product Manager, Technical Lead
  • From customer: VP/Director, Key users, Finance (if expanding)
  • Confirm agenda 1 week prior

Prepare Customized Materials:

  • Account health summary (one-page overview)
  • Usage analytics dashboard (key metrics visualization)
  • ROI calculation (value delivered vs. investment)
  • Customer testimonial/case study (if available)
  • Executive summary (2-page deck)

2. Account Health Score

Build Health Scorecard (1-100 scale):

Health Category | Weight | Score | Calculation
-----------------|--------|-------|---------------------
Product Usage | 25% | 85 | Login frequency 4x/week; 8 of 10 features used
Engagement | 20% | 90 | Training attendance 100%; active in support
Support/NPS | 20% | 80 | NPS 50; 2 support tickets/month (norm)
Expansion Signals | 20% | 75 | Uses in 2 departments; growth interest unclear
Renewal Risk | 15% | 95 | Contract expires in 9 months; no churn signals
OVERALL HEALTH | 100% | 84 | HEALTHY (green zone: 70-100)

Health Zone:
- GREEN (80-100): Strong account; growth opportunity
- YELLOW (60-79): Adequate but monitor; may need intervention
- RED (<60): At-risk; immediate action needed

Usage Metrics Dashboard:

Metric | Target | Actual | Trend | Analysis
--------|--------|--------|-------|----------
Monthly Active Users | 50 | 42 | Down 5% | 1 power user on leave
Logins Per User/Mo | 15 | 12 | Flat | Normal usage pattern
Features Utilized | 8/10 | 8 | Up 1 | Using advanced reporting
Session Length (min) | 30 | 28 | Down | Still productive
Customer Health Score | 80+ | 84 | Up 4 | Trending positive

Health Score Red Flags:

  • Health score declined 10+ points quarter-over-quarter
  • Usage down 20%+ compared to previous quarter
  • Support ticket spike (indicating frustration)
  • NPS down significantly
  • Key user departed or reduced role
  • Expansion signals disappeared
  • Budget cuts mentioned in communications

QBR Agenda & Talking Points

60-Minute QBR Agenda:

0-5 min: OPENING
- Warm greetings; thank them for partnership
- Quick agenda review
- Expected outcome: Align on value, identify opportunities, remove blockers

5-15 min: CUSTOMER SUCCESS (What they've accomplished)
- Celebrate wins and milestones
- Share customer testimonials or case studies
- Recognize power users or engaged teams

15-30 min: PERFORMANCE REVIEW (How they're using product)
- Usage analytics dashboard
- Feature adoption trends
- Comparison to industry benchmark
- Highlight positive trends

30-40 min: BUSINESS IMPACT (Value delivered)
- ROI calculation (cost savings, revenue impact, efficiency gains)
- How competitors are doing (benchmarking)
- Cost avoidance (if applicable)
- Reference to contract objectives

40-50 min: ROADMAP & EXPANSION (Opportunities ahead)
- Product roadmap (next quarter features)
- Expansion opportunities (new departments, use cases)
- Training/enablement roadmap
- Emerging needs identification

50-55 min: RISK MITIGATION & SUPPORT (Removing blockers)
- Address any support gaps
- SLA performance review
- Risk assessment (renewal, budget, alternatives)
- Mitigation plan if concerns exist

55-60 min: CLOSING
- Recap action items
- Confirm next steps
- Schedule follow-up QBR
- Get renewal signal (if applicable)

TONE: Collaborative partnership, not sales pitch

ROI Calculation Template

Calculate Total Value Delivered:

CUSTOMER: ACME Corp
REPORTING PERIOD: Q1 2024 (Jan-Mar)
PRODUCT: Analytics Platform
Annual Contract Value: $50,000

COST BASELINE (What they were doing before):
Method: Manual reporting in Excel
Team: 2 FTE data analysts @ $100K each
Hours per week: 40 hours/week
Monthly cost: (80 hours × $50/hour) = $4,000/month
Annual cost: $48,000/year

COST WITH OUR SOLUTION:
Time spent on reporting: 15 hours/week (vs. 40)
Monthly cost: (30 hours × $50/hour) = $1,500/month
Annual cost: $18,000/year

COST SAVINGS (Hard ROI):
Annual savings: $48,000 - $18,000 = $30,000/year
Minus our annual contract cost: $30,000 - $50,000 = -$20,000
ROI: Negative in Year 1; positive in Year 2+

BUT ALSO CONSIDER:
Productivity gain value: 25 hours/week × $50/hour × 52 weeks = $65,000
Time to insight improvement: Reduced from 2 days to 2 hours (faster decisions)
Revenue impact from insights: Estimated $40K additional revenue this year

TOTAL VALUE CALCULATION:
Hard savings: $30,000
Productivity value: $65,000
Revenue impact: $40,000 (conservative estimate)
Total value delivered: $135,000
Less investment (ACV): $50,000
Net value Year 1: $85,000
ROI: 170%
Payback period: 4.4 months

Present ROI Clearly:

ROI SUMMARY SLIDE:

INVESTMENT: $50,000/year
RETURN: $135,000 year-over-year value
NET VALUE: $85,000 (170% ROI)
PAYBACK: 4.4 months

[Chart showing cost avoidance before/after]
[Table showing value components]

INVESTMENT RECOMMENDATION: Expand to [adjacent business unit]

Usage Analytics & Benchmarking

Present Usage Dashboard:

ACME CORP - Q1 2024 USAGE ANALYTICS

ADOPTION:
Seats Purchased: 50
Active Users: 42 (84% adoption)
Monthly Active Users: 38 (76% regular usage)
Trend: UP 8% quarter-over-quarter

FEATURE ADOPTION:
Dashboard Creation: 95% of users
Real-time Alerts: 60% of users (room to grow)
API Integration: 12% of users (advanced feature)
Custom Reports: 78% of users

ENGAGEMENT:
Logins Per User: 12/month (2.4 per week)
Session Length: 28 minutes average
Peak Usage: Tuesday-Thursday 10-11 AM
Total Usage Hours: 3,200 hours/quarter

BENCHMARK COMPARISON:
Your adoption (84%) vs. Industry (70%): EXCELLENT
Your feature usage (78% custom reports) vs. Industry (45%): EXCELLENT
Your engagement (12 logins/month) vs. Industry (8): EXCELLENT

GROWTH OPPORTUNITY:
Real-time alerts only 60% adopted. If increase to 80% (industry average):
- 12 more users enabled
- Estimated 15% additional value realization
- Simple training intervention required

Expansion Opportunity Identification

Assess Expansion Potential (3 dimensions):

Dimension 1: Department Expansion

Currently using: Finance Department (40 users)
Potential expansion: Operations, Marketing, HR

OPPORTUNITY - Operations Department:
- Size: 30 people
- Challenge: Manual process tracking
- Use case: Supply chain visibility, cost analysis
- Estimated value: $60K/year
- Implementation: 4 weeks, 3 team training sessions
- Probability: 70% (strong fit)
- Recommendation: Propose in Q2; quick win opportunity

Dimension 2: Product/Feature Expansion

OPPORTUNITY - Real-time Alerts (currently 60% adoption):
- Gap: 18 users not using alerts
- Barrier: Lack awareness of capability
- Value: $20K/year (faster decision-making)
- Intervention: 1-hour training session
- Probability: 85% (low effort, high adoption)
- Recommendation: Conduct webinar; show use cases

OPPORTUNITY - Custom API Integration:
- Gap: Only 12% using API
- Barrier: Requires technical implementation
- Value: $50K/year (automation, integration)
- Requirement: Developer resources (theirs)
- Probability: 40% (high effort, executive buy-in needed)
- Recommendation: Propose with success plan; offer technical enablement

Dimension 3: Upsell Opportunity (Workflow)

OPPORTUNITY - Advanced Analytics Module:
- Current: Descriptive analytics (what happened)
- Upsell: Predictive analytics (what will happen)
- Investment: Additional $25K/year
- Value: $100K/year (better forecasting, risk mitigation)
- Timeline: 60-day implementation
- ROI: Strong (4x return)
- Recommendation: Propose for Q3 implementation; joint success plan

EXPANSION REVENUE POTENTIAL:
Year 1 upsells + expansions: $85K additional ACV (up from $50K)
Probability of close: 60% (requires execution)
Conservative estimate: $51K additional revenue

Risk Mitigation Framework

Assess Renewal Risk:

RENEWAL RISK ASSESSMENT - ACME CORP

Renewal Date: September 1, 2024 (6 months away)
Contract Value: $50,000/year
Renewal Probability: 85% (high confidence)

RISK FACTORS ANALYSIS:
Factor | Status | Risk Score | Mitigation
--------|--------|-----------|----------
Product fit | Strong | Low | Clear use cases; 84% adoption
Stakeholder satisfaction | Positive | Low | Active engagement; no complaints
Budget availability | Confirmed | Low | Finance confirms budget
Alternative solutions | Limited | Low | Switching cost high; no better options
Support satisfaction | 4/5 NPS | Low | 2 support tickets/quarter; resolved quickly
Contract terms | Favorable | Low | Current terms acceptable to both parties
Executive sponsor | Engaged | Low | VP Finance uses daily; strong advocate
Change risk | Minimal | Low | No planned reorganization mentioned

OVERALL RISK: LOW (Green zone)

RENEWAL STRATEGY:
- Begin renewal conversation: August 1 (3 months before)
- Proposal with expansion: August 15
- Renewal signature: August 25 (1 week buffer)

IF RISK WERE HIGH:
- Escalate to executive sponsor
- Understand root cause (product, pricing, service)
- Develop mitigation plan (product roadmap, pricing adjustments)
- Monthly check-ins (vs. quarterly)
- Build competitive moat (expand usage, tie to mission-critical)

QBR Presentation Deck Structure

Typical 15-20 Slide Deck:

Slide 1: Title + Customer Logo + Date
Slide 2: Agenda (what we'll cover)
Slide 3: Account health scorecard (1-page summary)
Slide 4: Congratulations + key achievements this quarter
Slide 5: Usage analytics dashboard (adoption, engagement)
Slide 6: Feature adoption (what's being used, what's not)
Slide 7: Benchmark comparison (how they compare to peers)
Slide 8: ROI calculation (value delivered)
Slide 9: Customer testimonial or case study (internal proof)
Slide 10: Support + SLA performance (how we've supported them)
Slide 11: Product roadmap (upcoming features Q2-Q3)
Slide 12-14: Expansion opportunities (departments, features, products)
Slide 15: Expansion proposal (specific recommendation with ROI)
Slide 16: Risk assessment + renewal strategy
Slide 17: Action items (who, what, by when)
Slide 18: Q&A / Discussion
Slide 19: Closing (thank you, confirm next steps)
Slide 20: Contact + Follow-up Information

QBR Post-Meeting Deliverables

Send within 24 hours:

QBR FOLLOW-UP EMAIL

Subject: ACME Corp - Q1 2024 QBR Follow-Up

Hi [Customer],

Thank you for a productive QBR today. We really appreciate your partnership
and engagement. Here's a summary of what we discussed:

ACCOUNT HEALTH:
- Overall health score: 84/100 (Healthy - Green)
- Usage trend: Up 8% quarter-over-quarter
- Adoption rate: 84% (excellent vs. 70% industry average)

VALUE DELIVERED (Year-to-date):
- Hard cost savings: $30,000
- Productivity gains: $65,000
- Revenue impact: $40,000
- Total value: $135,000 (170% ROI)

EXPANSION OPPORTUNITIES:
1. Operations Department Expansion: $60K value opportunity
   - Owner: [Sarah Kim, Operations VP]
   - Timeline: 4 weeks to implement
   - Next step: Scoping call on [Date]

2. Real-Time Alerts Training: $20K value opportunity
   - Owner: [John Chen, Finance Team]
   - Timeline: 1-hour webinar + hands-on training
   - Next step: Webinar scheduled [Date]

3. Predictive Analytics Upsell: $100K value opportunity
   - Owner: [Finance Leadership]
   - Investment: $25K/year
   - ROI: 4x return
   - Next step: Detailed proposal [Date]

ACTION ITEMS:
[Table with owner, action, due date]

RENEWAL CONVERSATION:
- Current contract expires: September 1, 2024
- Renewal strategy: Begin discussion August 1
- Expansion plan: Include expansion opportunities in proposal

Next QBR: June [Date] - Q2 Results Review

Let's stay in touch. Feel free to reach out with any questions.

Best regards,
[Your name]
Account Executive
[Company]

Best Practices

  1. Be Data-Driven: Back every claim with metrics
  2. Personalize: Customize for their industry/use case
  3. Celebrate Wins: Start with what's going well
  4. Listen: QBR is 50% conversation, 50% presentation
  5. Honest Assessment: Acknowledge challenges; propose solutions
  6. Actionable Recommendations: Specific expansion opportunities with ROI
  7. Executive Presence: Include senior leadership if high-value account
  8. Follow Through: Complete action items before next QBR
  9. Schedule in Advance: QBR is not a surprise; scheduled 4-6 weeks prior
  10. Document Everything: Send written summary; create action items

QBR Frequency & Timing

Account Tier | QBR Frequency | Attendees | Duration
--------------|--------------|-----------|----------
Enterprise | Quarterly | VP, Finance, Product, Tech | 90 min
Mid-Market | Quarterly | Director, CSM, Account Exec | 60 min
SMB | Annually or Bi-annually | CSM, Account Rep | 45 min
Strategic | Monthly executive update | Executive sponsor | 30 min

BEST TIMING: After month-end (have full quarter data) but before end of next quarter
Example: Q1 QBR should happen in late April (not early April)

Use this skill to: Deepen customer relationships, identify expansion opportunities, prevent churn, and drive strategic growth.