growth analytics and dashboard management
11
总安装量
0
周安装量
#28730
全站排名
安装命令
npx skills add https://github.com/shunsukehayashi/miyabi-claude-plugins --skill Growth Analytics and Dashboard Management
Skill 文档
ð Growth Analytics and Dashboard Management
Version: 2.0.0 Last Updated: 2025-11-22 Priority: ââââ (P1 Level – Business) Purpose: KPIãã¬ã¼ã ã¯ã¼ã¯ãããã·ã¥ãã¼ãè¨è¨ããã¼ã¿ããªãã³æææ±ºå®
ð æ¦è¦
20以ä¸ã®ã¡ããªã¯ã¹ã«ããKPIãã¬ã¼ã ã¯ã¼ã¯ãããã·ã¥ãã¼ãè¨è¨ã ã³ãã¼ãåæãäºæ¸¬åæãéããã°ãã¼ã¹æ¯æ´ãæä¾ãã¾ãã
ð¯ P0: å¼ã³åºãããªã¬ã¼
| ããªã¬ã¼ | ä¾ |
|---|---|
| ã¡ããªã¯ã¹åæ | “analyze our growth metrics” |
| CAC/LTV | “what’s our CAC/LTV?” |
| ããã·ã¥ãã¼ã | “build a KPI dashboard” |
| ãã¼ã¿åæ | “data-driven decisions” |
| ã³ãã¼ã | “cohort analysis” |
ð§ P1: KPIã«ãã´ãªä¸è¦§
5ã«ãã´ãªã»20+ã¡ããªã¯ã¹
| ã«ãã´ãª | ã¡ããªã¯ã¹ | åªå 度 | 測å®é »åº¦ |
|---|---|---|---|
| Acquisition | CAC, Traffic, Conversion | é« | 鱿¬¡ |
| Activation | Time-to-Value, Onboarding Rate | é« | 鱿¬¡ |
| Revenue | MRR, ARPU, LTV | é« | ææ¬¡ |
| Retention | Churn, NRR, DAU/MAU | é« | ææ¬¡ |
| Referral | NPS, Viral Coefficient | ä¸ | ååæ |
ð P2: ããã·ã¥ãã¼ãè¨è¨
Dashboard Types
| Type | 対象 | æ´æ°é »åº¦ | ã¡ããªã¯ã¹æ° |
|---|---|---|---|
| Executive | çµå¶å±¤ | 鱿¬¡ | 5-7 |
| Product | PM/éçº | æ¥æ¬¡ | 10-15 |
| Marketing | ãã¼ã± | æ¥æ¬¡ | 8-12 |
| Sales | å¶æ¥ | ãªã¢ã«ã¿ã¤ã | 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: åæææ³
Cohort Analysis
| æ | Week 1 | Week 2 | Week 3 | Week 4 |
|---|---|---|---|---|
| Jan | 100% | 65% | 52% | 48% |
| Feb | 100% | 68% | 55% | 51% |
| Mar | 100% | 72% | 58% | 54% |
è§£é: ãªãã³ã·ã§ã³æ¹åãã¬ã³ãï¼+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%
æ¹åãã¤ã³ã: InterestâEvaluation (60% drop)
A/B Testing Framework
| è¦ç´ | å 容 |
|---|---|
| 仮説 | ãCTAè²å¤æ´ã§+10% CVRã |
| ãµã³ãã«ãµã¤ãº | 1,000 per variant |
| æé | 2é±é |
| æååºæº | p < 0.05, +5% CVR |
ð PDCA ãµã¤ã¯ã«
4é±éã¹ããªã³ã
| é± | ãã§ã¼ãº | ã¢ã¯ã·ã§ã³ |
|---|---|---|
| Week 1 | Plan | KPIè¨å®ãä»®èª¬ç«æ¡ |
| Week 2 | Do | æ½çå®è¡ããã¼ã¿åé |
| Week 3 | Check | åæãçµæè©ä¾¡ |
| Week 4 | Act | æ¹åãæ¬¡ãµã¤ã¯ã«æºå |
ð¡ï¸ äºæ¸¬åæ
Churn Prediction
ãªã¹ã¯ã¹ã³ã¢ =
ãã°ã¤ã³é »åº¦ä½ä¸ à 0.3 +
æ©è½å©ç¨æ¸å° à 0.25 +
ãµãã¼ãåãåãã à 0.2 +
å¥ç´æ´æ°è¿æ¥ à 0.15 +
決æ¸å¤±æå±¥æ´ à 0.1
| ã¹ã³ã¢ | ãªã¹ã¯ | ã¢ã¯ã·ã§ã³ |
|---|---|---|
| 0-30 | ä½ | éå¸¸å¯¾å¿ |
| 31-60 | ä¸ | ããã¢ã¯ãã£ãé£çµ¡ |
| 61-100 | é« | ç·æ¥ä»å ¥ |
Revenue Forecasting
äºæ¸¬MRR =
ç¾å¨MRR à (1 - Churn%) +
New MRR (ãªã¼ã à CVR à ARPU) +
Expansion MRR (ã¢ããã»ã«å¯¾è±¡ à Rate)
â æååºæº
| ã¡ããªã¯ã¹ | ç®æ¨ | æ¸¬å® |
|---|---|---|
| LTV/CAC | >3.0x | ææ¬¡ |
| Churn | <5% | ææ¬¡ |
| NPS | >40 | ååæ |
| DAU/MAU | >30% | 鱿¬¡ |
ð é¢é£Skills
- Market Research: å¸å ´ãã¼ã¿åé
- Sales CRM: å¶æ¥ã¡ããªã¯ã¹
- Content Marketing: ãã¼ã±ãã£ã³ã°KPI
- Business Strategy: æ¦ç¥ç«æ¡ã¨ã®é£æº