w95/qbr-builder
Create Quarterly Business Reviews with account health scores, usage analytics, ROI analysis, expansion opportunities, and risk mitigation
npx skills add https://github.com/w95/awesome-claude-corporate-skills --skill qbr-builderMaster 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.
Gather Data:
Stakeholder Coordination:
Prepare Customized Materials:
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:
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
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]
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
Assess Expansion Potential (3 dimensions):
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
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
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
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)
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
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]
10. Document Everything: Send written summary; create action items
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.
Take w95/qbr-builder from the repository into ~/.claude/skills for personal
use, or into .claude/skills inside a project.
The agent identifies a skill by the name field in its header. Two skills with the
same name cannot sit side by side — one of them will be ignored.