Product Health Dashboard Designer
by Ethical-AI-Syndicate
Use when defining product analytics requirements. Use after product live. Produces KPI definitions, dashboard specifications, alert thresholds, and measurement methodology.
Skill Details
Repository Files
1 file in this skill directory
name: product-health-dashboard-designer description: Use when defining product analytics requirements. Use after product live. Produces KPI definitions, dashboard specifications, alert thresholds, and measurement methodology.
Product Health Dashboard Designer
Overview
Design dashboards and metrics that tell the story of product health. Define KPIs, specify visualizations, and establish alerting that enables proactive product management.
Core principle: Measure what matters, not what's easy. A good dashboard enables decision-making, not just data display.
When to Use
- Product launching to production
- Redesigning existing analytics
- Onboarding new team to product metrics
- Quarterly health check methodology
Output Format
product_health_dashboard:
product: "[Product name]"
version: "[YYYY-MM-DD]"
audience: "[Who uses this dashboard]"
north_star:
metric: "[Primary success metric]"
definition: "[Exactly how it's calculated]"
data_source: "[Where data comes from]"
current: "[Current value]"
target: "[Goal value]"
refresh_rate: "[Real-time | Hourly | Daily]"
kpis:
- category: "[Acquisition | Activation | Engagement | Retention | Revenue]"
metrics:
- name: "[Metric name]"
definition: "[Calculation formula]"
data_source: "[Where from]"
visualization: "[Number | Chart type]"
healthy_range: "[X to Y]"
warning_threshold: "[Trigger for concern]"
critical_threshold: "[Trigger for action]"
trend_period: "[Days/weeks to show]"
dashboard_layout:
sections:
- section: "[Section name]"
purpose: "[What decisions this enables]"
components:
- type: "[Big number | Line chart | Bar chart | Table]"
metric: "[Metric name]"
size: "[Full | Half | Quarter]"
comparisons: ["[vs last period | vs target]"]
alerts:
- metric: "[Metric name]"
condition: "[When to alert]"
severity: "[Critical | Warning | Info]"
channel: "[Slack | Email | PagerDuty]"
recipients: ["[Team/person]"]
runbook: "[Link to response procedure]"
segments:
- segment: "[User segment]"
filter: "[How to identify]"
rationale: "[Why this matters separately]"
data_requirements:
events: ["[Event name: description]"]
properties: ["[Property: what it captures]"]
implementation_notes: "[Technical requirements]"
review_cadence:
daily: "[What to check daily]"
weekly: "[Weekly review focus]"
monthly: "[Monthly deep dive]"
KPI Framework: AARRR
Acquisition
| Metric | Definition | Healthy |
|---|---|---|
| New signups | Unique accounts created | Growing |
| Signup conversion | Signups / Landing page visitors | >2-5% |
| Cost per acquisition | Total spend / Signups | Decreasing |
| Channel attribution | Signups by source | Diversified |
Activation
| Metric | Definition | Healthy |
|---|---|---|
| Onboarding completion | Users completing setup / Signups | >60% |
| Time to first value | Time from signup to key action | Decreasing |
| Activation rate | Users performing key action / Signups | >40% |
Engagement
| Metric | Definition | Healthy |
|---|---|---|
| DAU/MAU | Daily active / Monthly active | >25% |
| Session frequency | Sessions per user per week | Stable/growing |
| Feature adoption | Users of feature X / Active users | Per feature target |
| Session duration | Average time in product | Appropriate for use case |
Retention
| Metric | Definition | Healthy |
|---|---|---|
| D1/D7/D30 retention | Users returning after N days | D1>40%, D7>20%, D30>10% |
| Churn rate | Users lost / Total users | <5% monthly |
| Cohort retention | Retention curves by signup cohort | Flattening curve |
Revenue
| Metric | Definition | Healthy |
|---|---|---|
| MRR | Monthly recurring revenue | Growing |
| ARPU | Revenue / Active users | Stable/growing |
| LTV | Lifetime value per customer | >3x CAC |
| Expansion revenue | Upgrades / Total revenue | >20% |
Dashboard Design Principles
Layout Hierarchy
┌────────────────────────────────────────────────────────────┐
│ NORTH STAR METRIC BIG │
│ [Primary success metric with trend] │
├────────────────────────────────────────────────────────────┤
│ KEY HEALTH INDICATORS │
│ ┌──────────────┐ ┌──────────────┐ ┌──────────────┐ │
│ │ Metric 1 │ │ Metric 2 │ │ Metric 3 │ │
│ │ [Trend chart]│ │ [Trend chart]│ │ [Trend chart]│ │
│ └──────────────┘ └──────────────┘ └──────────────┘ │
├────────────────────────────────────────────────────────────┤
│ DETAILED VIEWS │
│ [Segment breakdowns, cohort analysis, feature metrics] │
└────────────────────────────────────────────────────────────┘
Visualization Selection
| Data Type | Recommended | Avoid |
|---|---|---|
| Single value + trend | Big number + sparkline | Pie chart |
| Time series | Line chart | Bar chart for >7 periods |
| Category comparison | Horizontal bar | Pie chart |
| Distribution | Histogram | Line chart |
| Funnel steps | Funnel visualization | Line chart |
Alert Design
Threshold Setting
alert_thresholds:
approach: "Statistical"
method: "Mean ± 2 standard deviations over 30 days"
example:
metric: "Daily signups"
mean: 100
std_dev: 15
warning_low: 70 # Mean - 2σ
warning_high: 130 # Mean + 2σ
critical_low: 55 # Mean - 3σ
Severity Levels
| Severity | Criteria | Response |
|---|---|---|
| Critical | Business-impacting now | Immediate action, page on-call |
| Warning | Concerning trend | Investigate same day |
| Info | Notable but not urgent | Review in next meeting |
Alert Hygiene
alert_principles:
- "Every alert should be actionable"
- "If nobody acts, remove the alert"
- "Review alert fatigue monthly"
- "Each critical alert needs a runbook"
Segmentation Strategy
Common Segments
| Segment Type | Examples |
|---|---|
| User lifecycle | New (<7d), Active, Dormant, Churned |
| Plan tier | Free, Pro, Enterprise |
| Use case | By primary feature used |
| Size | SMB, Mid-market, Enterprise |
| Cohort | By signup month |
Segment Dashboard
segment_view:
primary_segment: "User lifecycle"
default_view: "Active users"
comparison: "Side-by-side segment comparison"
metrics_per_segment:
- "Segment size"
- "Key action rate"
- "Revenue contribution"
- "Trend vs previous period"
Implementation Checklist
Before Launch
- North star metric defined
- AARRR metrics specified
- Dashboard layout designed
- Alert thresholds set
- Data events specified
- Tracking implemented
After Launch
- Dashboard built and tested
- Alerts delivering correctly
- Team trained on interpretation
- Review cadence established
- Runbooks created for critical alerts
Common Mistakes
| Mistake | Problem | Fix |
|---|---|---|
| Too many metrics | Dashboard overload | Focus on 5-7 key metrics |
| Vanity metrics | Looks good, not actionable | Tie to decisions |
| No targets | Can't assess health | Set clear targets |
| Raw numbers only | Missing context | Add comparisons, trends |
| Alert flood | Fatigue, ignored | Reduce to truly actionable |
| No segments | Masked problems | At least lifecycle + tier |
Related Skills
Team Composition Analysis
This skill should be used when the user asks to "plan team structure", "determine hiring needs", "design org chart", "calculate compensation", "plan equity allocation", or requests organizational design and headcount planning for a startup.
Kpi Dashboard Design
Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use when building business dashboards, selecting metrics, or designing data visualization layouts.
Sql Optimization Patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
Senior Data Scientist
World-class data science skill for statistical modeling, experimentation, causal inference, and advanced analytics. Expertise in Python (NumPy, Pandas, Scikit-learn), R, SQL, statistical methods, A/B testing, time series, and business intelligence. Includes experiment design, feature engineering, model evaluation, and stakeholder communication. Use when designing experiments, building predictive models, performing causal analysis, or driving data-driven decisions.
Mermaid Diagrams
Comprehensive guide for creating software diagrams using Mermaid syntax. Use when users need to create, visualize, or document software through diagrams including class diagrams (domain modeling, object-oriented design), sequence diagrams (application flows, API interactions, code execution), flowcharts (processes, algorithms, user journeys), entity relationship diagrams (database schemas), C4 architecture diagrams (system context, containers, components), state diagrams, git graphs, pie charts,
Ux Researcher Designer
UX research and design toolkit for Senior UX Designer/Researcher including data-driven persona generation, journey mapping, usability testing frameworks, and research synthesis. Use for user research, persona creation, journey mapping, and design validation.
Supabase Postgres Best Practices
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
Kpi Dashboard Design
Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use when building business dashboards, selecting metrics, or designing data visualization layouts.
Sql Optimization Patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
Dashboard Design
USE THIS SKILL FIRST when user wants to create and design a dashboard, ESPECIALLY Vizro dashboards. This skill enforces a 3-step workflow (requirements, layout, visualization) that must be followed before implementation. For implementation and testing, use the dashboard-build skill after completing Steps 1-3.
