Receber por email
← Voltar para o catálogo

qbr-builder

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

72estrelas
Atualizado há 8 meses

Ver no GitHub ↗ Licença: MIT

Como adicionar

/plugin marketplace add w95/awesome-claude-corporate-skills

O comando exato pode variar conforme o repositório. Confira o README no GitHub.

Para o autor da skill

Cole no README do seu repo

Mostra que sua skill está catalogada na Skillteca, gera backlink e tráfego rastreável.

[![Skillteca](https://www.skillteca.com.br/api/badge/qbr-builder/svg)](https://www.skillteca.com.br/skills/qbr-builder)
#ai

Skills relacionadas

Ver todas de Dados e Análise →

Alerta por categoria

Receba novas skills de Dados e Análise toda segunda

1 email curto, só com as skills novas de Dados e Análise. 4 minutos de leitura, sem spam, cancela com 1 clique.

Você confirma o email no primeiro envio. Sem spam. Cancela com 1 clique.

Ler descrição completa

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 analyt
Compartilhar X LinkedIn