Awesome-claude-corporate-skills qbr-builder
Create Quarterly Business Reviews with account health scores, usage analytics, ROI analysis, expansion opportunities, and risk mitigation
git clone https://github.com/w95/awesome-claude-corporate-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"
11-customer-success/qbr-builder/SKILL.mdQBR 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
- Be Data-Driven: Back every claim with metrics
- Personalize: Customize for their industry/use case
- Celebrate Wins: Start with what's going well
- Listen: QBR is 50% conversation, 50% presentation
- Honest Assessment: Acknowledge challenges; propose solutions
- Actionable Recommendations: Specific expansion opportunities with ROI
- Executive Presence: Include senior leadership if high-value account
- Follow Through: Complete action items before next QBR
- Schedule in Advance: QBR is not a surprise; scheduled 4-6 weeks prior
- 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.