📊 Growth Analytics and Dashboard Management
Version: 2.0.0
Last Updated: 2025-11-22
Priority: ⭐⭐⭐⭐ (P1 Level - Business)
Purpose: KPI framework, dashboard design, data-driven decision making
📋 Overview
We provide growth support through a KPI framework with 20+ metrics, dashboard design,
cohort analysis, and predictive analytics.
🎯 P0: Invocation Triggers
| Trigger |
Example |
| Metrics analysis |
"analyze our growth metrics" |
| CAC/LTV |
"what's our CAC/LTV?" |
| Dashboard |
"build a KPI dashboard" |
| Data analysis |
"data-driven decisions" |
| Cohort |
"cohort analysis" |
🔧 P1: KPI Category List
5 categories, 20+ metrics
| Category |
Metrics |
Priority |
Measurement frequency |
| Acquisition |
CAC, Traffic, Conversion |
High |
Weekly |
| Activation |
Time-to-Value, Onboarding Rate |
High |
Weekly |
| Revenue |
MRR, ARPU, LTV |
High |
Monthly |
| Retention |
Churn, NRR, DAU/MAU |
High |
Monthly |
| Referral |
NPS, Viral Coefficient |
Medium |
Quarterly |
🚀 P2: Dashboard Design
Dashboard Types
| Type |
Audience |
Update frequency |
Number of metrics |
| Executive |
Executives |
Weekly |
5-7 |
| Product |
PM/Development |
Daily |
10-15 |
| Marketing |
Marketing |
Daily |
8-12 |
| Sales |
Sales |
Real-time |
6-10 |
Pattern 1: Executive Dashboard
┌─────────────────────────────────────────────┐
│ Executive Dashboard │
├─────────────┬─────────────┬─────────────────┤
│ MRR │ Churn │ NPS │
│ ¥XXX万 │ 2.1% │ 42 │
│ ↑12% MoM │ ↓0.3% │ ↑5 pts │
├─────────────┼─────────────┼─────────────────┤
│ CAC │ LTV │ LTV/CAC │
│ ¥8,500 │ ¥85,000 │ 10.0x │
│ ↓5% │ ↑8% │ ↑1.2x │
└─────────────┴─────────────┴─────────────────┘
Pattern 2: Product Dashboard
Metrics:
- DAU/MAU (Stickiness)
- Feature Adoption Rate
- Time-in-App
- Error Rate
- Page Load Time
- User Journey Completion
⚡ P3: Analysis Methods
Cohort Analysis
| Month |
Week 1 |
Week 2 |
Week 3 |
Week 4 |
| Jan |
100% |
65% |
52% |
48% |
| Feb |
100% |
68% |
55% |
51% |
| Mar |
100% |
72% |
58% |
54% |
Interpretation: Retention improvement trend (+6% W4)
Funnel Analysis
Awareness : 10,000 (100%)
↓
Interest : 3,000 (30%) ← Drop: 70%
↓
Evaluation : 1,200 (12%) ← Drop: 60%
↓
Trial : 600 (6%) ← Drop: 50%
↓
Purchase : 300 (3%) ← Drop: 50%
Improvement points: Interest→Evaluation (60% drop)
A/B Testing Framework
| Element |
Details |
| Hypothesis |
"+10% CVR from changing CTA color" |
| Sample size |
1,000 per variant |
| Period |
2 weeks |
| Success criteria |
p < 0.05, +5% CVR |
📊 PDCA Cycle
4-week sprint
| Week |
Phase |
Action |
| Week 1 |
Plan |
Set KPIs, formulate hypotheses |
| Week 2 |
Do |
Execute initiatives, collect data |
| Week 3 |
Check |
Analyze, evaluate results |
| Week 4 |
Act |
Improve, prepare for next cycle |
🛡️ Predictive Analytics
Churn Prediction
リスクスコア =
ログイン頻度低下 × 0.3 +
機能利用減少 × 0.25 +
サポート問い合わせ × 0.2 +
契約更新近接 × 0.15 +
決済失敗履歴 × 0.1
| Score |
Risk |
Action |
| 0-30 |
Low |
Standard response |
| 31-60 |
Medium |
Proactive outreach |
| 61-100 |
High |
Emergency intervention |
Revenue Forecasting
予測MRR =
現在MRR × (1 - Churn%) +
New MRR (リード × CVR × ARPU) +
Expansion MRR (アップセル対象 × Rate)
✅ Success Criteria
| Metrics |
Target |
Measurement |
| LTV/CAC |
>3.0x |
Monthly |
| Churn |
<5% |
Monthly |
| NPS |
>40 |
Quarterly |
| DAU/MAU |
>30% |
Weekly |
🔗 Related Skills
- Market Research: Market data collection
- Sales CRM: Sales metrics
- Content Marketing: Marketing KPIs
- Business Strategy: Coordination with strategy planning
