Skip to main content
Product Management/metrics-dashboard

Metrics Dashboard

You need a metrics framework connecting product, growth, and revenue with KPI hierarchy and review cadence.

Use this when helping a client define what to measure and how to structure their metrics for a product or initiative.


How it works

  1. You provide the client name, product or initiative, objectives, and relevant context
  2. The skill designs a metrics framework with North Star, input metrics, health guardrails, and business metrics
  3. It returns a client-ready metrics dashboard specification with definitions, targets, alert thresholds, and review cadence

Prompt

You are designing a metrics framework as part of Kate's strategic-comms-roadmapping engagement. Before writing, read knowledge/voice-tone-guide.md -- use the client-facing voice (clear, structured, professional -- this will be shared with the client's team).

Inputs I will provide:

  • Client: {{CLIENT}} (company name and engagement context)
  • Product: {{PRODUCT}} (the product, feature, or initiative being measured)
  • Objectives: {{OBJECTIVES}} (business goals, OKRs, or strategic priorities the metrics should track against)
  • Context: {{CONTEXT}} (current analytics setup, team maturity, tools in use, any constraints)

Step 1: Understand the measurement landscape

Before defining metrics, clarify:

  • What decisions will these metrics inform?
  • Who will be looking at this dashboard (executives, PMs, engineers, the whole company)?
  • What is the team's current data maturity (no analytics, basic events, mature pipeline)?
  • What tools do they have or are willing to adopt?

If any of these are unclear from the inputs, note them as [CLARIFY WITH KATE: ...].

Step 2: Pull relevant frameworks

Read knowledge/pm-execution-templates.md for metrics framework structures Kate uses with clients.

Read knowledge/pm-growth-frameworks.md, specifically:

  • North Star Metric methodology -- how to identify the single metric that captures core value delivery
  • AARRR / Pirate Metrics for acquisition-through-revenue coverage
  • Input metrics concept -- the levers that drive the North Star

Step 3: Design the metrics framework

North Star Metric

  • Metric: [name]
  • Definition: [exact calculation -- numerator, denominator, time window]
  • Why this metric: [how it captures core value delivery for {{PRODUCT}}]
  • Current baseline: [if known, or [NEEDS DATA]]
  • Target: [goal value with timeframe]

Input Metrics (3-5)

The levers that drive the North Star. For each:

MetricDefinitionData SourceTargetReview Cadence
[Name][Exact calculation][Where data comes from][Goal][Daily/Weekly/Monthly]

Health Metrics

Guardrails that ensure the team is not optimizing the North Star at the expense of product health:

MetricDefinitionThresholdAlert Condition
[e.g., Error rate][Calculation][Acceptable range][When to investigate]

Business Metrics

Revenue, cost, and unit economics the leadership team cares about:

MetricDefinitionTargetReview Cadence
[e.g., MRR, CAC, LTV][Calculation][Goal][Monthly/Quarterly]

Step 4: Capture baseline snapshot

Before designing the dashboard layout, document current-state measurements for each proposed metric. This establishes the "before" so the team can track improvement.

MetricCurrent ValueSourceConfidenceMeasurement Gap
(metric name)(value or [NO DATA])(tool/system)High / Med / Low(what's missing)

If the team has no baseline for a metric, that's critical to surface now -- you can't measure improvement without a starting point. Flag each gap with [NEEDS INSTRUMENTATION]. If more than half the metrics have no baseline, recommend an instrumentation sprint before dashboard design.

Step 5: Specify the dashboard layout

Provide a visual layout recommendation:

  • Top row: North Star with trend indicator
  • Second row: Input metrics with sparklines
  • Third row: Health guardrails
  • Bottom row: Business metrics

Include which visualization type suits each metric (line chart, bar, single number, funnel).

Step 6: Define the operating rhythm

Review Cadence

  • Daily: which metrics to check and who checks them
  • Weekly: which metrics to review in team standups
  • Monthly: which metrics to present in leadership reviews
  • Quarterly: strategic recalibration -- are these still the right metrics?

Alert Rules

For each alertable metric:

  • What threshold triggers investigation
  • Who gets notified and through what channel
  • Expected response time

Revenue Attribution Layer

For each input metric, estimate the financial impact so the dashboard connects operational movement to business outcomes:

  • Sensitivity analysis: For each input metric, estimate: "If this metric improves by 10%, the expected revenue impact is approximately $X/month." Ground estimates in the client's unit economics where available, or flag as [NEEDS DATA: revenue sensitivity estimate requires baseline conversion and ARPU figures].
  • Unit economics integration: Map where CAC, LTV, and payback period sit in the metric hierarchy. Input metrics should ladder up: acquisition inputs drive CAC, retention inputs drive LTV, and the ratio between them determines payback period. If the dashboard does not make this connection visible, flag it.
  • Financial leading indicators: Identify which input metrics predict revenue 30, 60, and 90 days out. Activation and engagement metrics typically lead by 30-60 days; retention and expansion metrics lead by 60-90 days. Label each input metric with its revenue lead time.
  • Threshold annotations: For each alertable metric, add a financial annotation: "If [metric] drops below [threshold], expected revenue impact is $X/month based on [assumption]." This turns operational alerts into business urgency.
Input Metric10% Improvement → Revenue ImpactRevenue Lead TimeUnit Economics Link
[Name][Estimated $X/month or [NEEDS DATA]][30/60/90 days][Drives CAC / LTV / Payback]

Step 7: Validate metric quality

For each metric in the framework, check against these criteria:

  1. Understandable -- does it create a common language across the team?
  2. Comparative -- can it be tracked over time, not just as a snapshot?
  3. Ratio or rate -- is it a ratio (more revealing) or a raw number (less useful)?
  4. Behavior-changing -- if this metric moves, will the team actually do something different?

Flag any metric that fails these checks:

For defining the North Star Metric that anchors this dashboard, use the north-star-metric skill. For setting OKRs around these metrics, use okr-workshop.


Example Output

Input

  • Client: Mosaic Health — Series B digital health company offering an app-based chronic condition management platform (diabetes, hypertension); Kate engaged to support go-to-market metrics alignment ahead of a Q3 board review
  • Product: Mosaic Engage — the core member engagement layer of the app, including personalized check-ins, care coach messaging, and medication adherence reminders
  • Objectives: Increase 90-day member retention to 75% (from current ~52%); demonstrate clinical engagement sufficient to support payer partnership conversations; reduce care coach workload per active member
  • Context: Mixpanel for product events (mature setup, 18 months of history), Salesforce for B2B pipeline, Stripe for billing; no current unified dashboard — PMs pull from Mixpanel, finance pulls from Stripe, and leadership gets ad hoc exports; team of 3 PMs, data-mature but no dedicated analyst

Output (abbreviated)

Metrics Dashboard Specification

Client: Mosaic Health | Initiative: Mosaic Engage Prepared by: Kate's Strategic Comms & Roadmapping Engagement | Version: 1.0


North Star Metric

  • Metric: Weekly Clinically-Engaged Members (WCEM)
  • Definition: Count of distinct members who complete ≥1 clinically meaningful action (check-in submission, medication log, or care coach response) in a rolling 7-day window, divided by total active members (enrolled and not churned), expressed as a percentage
  • Why this metric: Captures whether Mosaic is delivering its core value — sustained behavior change in disease management — not just app opens. It is the leading signal for both 90-day retention and the clinical utilization data payers require
  • Current baseline: 38% (Mixpanel, 30-day avg as of last pull)
  • Target: 62% by end of Q3 (12 weeks)

Input Metrics

MetricDefinitionData SourceTargetRevenue Lead Time
Day-7 Activation Rate% of newly enrolled members who complete their first check-in within 7 days of enrollmentMixpanel (event: checkin_submitted, cohorted by enroll date)68% (from 51%)30 days
Care Coach Response Rate% of coach-initiated messages receiving a member reply within 48 hoursMixpanel + in-app messaging events55% (from 39%)30 days
Medication Log Streak ≥3 Days% of active members with ≥3 consecutive days of medication logging in past 7 daysMixpanel (event: med_log_submitted)44% (from 29%)60 days
Personalized Reminder CTR% of push notifications clicked / total sent, segmented by condition typeMixpanel (push events)18% (from 11%)30 days
30-Day Re-engagement Rate% of members dormant 8–21 days who complete a clinically meaningful action after a re-engagement nudgeMixpanel (dormancy + event sequence)32% (from 19%)60 days

Health Metrics

MetricDefinitionThresholdAlert Condition
Care Coach Utilization RateActive members per care coach per week≤ 85 members/coach> 90 members/coach for 2 consecutive weeks → flag for hiring review
App Crash RateCrashes per 1,000 sessions (mobile)< 2.0> 3.5 for any 48-hour period → P1 eng escalation
Member-Reported Satisfaction (CSAT)Post-check-in 5-point rating, 30-day rolling average≥ 4.1< 3.8 for 2 consecutive weeks → PM + care ops review
Data Completeness Rate% of check-in submissions with all required clinical fields populated≥ 92%< 88% → investigate form UX or onboarding gap

Business Metrics

MetricDefinitionTargetReview Cadence
Net Revenue Retention (NRR)(MRR at end of period – churned MRR + expansion MRR) / MRR at start of period≥ 108%Monthly
B2B Contracted Member CACTotal sales & marketing spend / new contracted members added≤ $220Quarterly
Member LTV (12-month)ARPM × avg months retained before churn, 12-month cohort≥ $610Quarterly
Payer-Ready Clinical Utilization Rate% of active members meeting payer-defined engagement threshold (≥4 check-ins/month)58% by Q3Monthly (board reporting)

Baseline Snapshot

MetricCurrent ValueSourceConfidenceMeasurement Gap
WCEM38%MixpanelHighNone — events mature
Day-7 Activation Rate51%MixpanelHighNone
Care Coach Response Rate39%MixpanelMed48-hr window not yet a tracked event property — needs event update
Medication Log Streak ≥3 Days29%MixpanelHighNone
Personalized Reminder CTR11%MixpanelMedCondition-type segmentation not currently applied to push events — [NEEDS INSTRUMENTATION]
30-Day Re-engagement Rate19%MixpanelLowDormancy definition not standardized; funnel requires new Mixpanel cohort setup — [NEEDS INSTRUMENTATION]
Care Coach Utilization Rate~74/coach (est.)Manual Salesforce exportLowNo automated pull; requires Salesforce–Mixpanel join — [NEEDS INSTRUMENTATION]
NRR[NO DATA]StripeLowStripe data not yet modeled for cohort NRR — [NEEDS DATA]
Member LTV[NO DATA]StripeLowCohort retention × ARPM model not built — [NEEDS DATA]

⚠ Instrumentation Note: 3 of 9 metrics require new event instrumentation or data modeling before the dashboard can go live. Recommend a 2-week instrumentation sprint prior to dashboard launch. Priority order: (1) re-engagement cohort, (2) condition-type push segmentation, (3) coach utilization automation.


Revenue Attribution Layer

Input Metric10% Improvement → Revenue ImpactRevenue Lead TimeUnit Economics Link
Day-7 Activation Rate~$18K/month — based on 10% lift in activated members × 12-month LTV of $610 × avg monthly cohort size30 daysDrives CAC efficiency; activated members reduce wasted acquisition spend
Care Coach Response Rate~$12K/month — higher response rate correlates with +8 pts retention (internal cohort data); modeled at current ARPM30 daysDrives LTV; retained members extend payback window
Medication Log Streak ≥3 Days~$21K/month — 3-day streak members show 2.1× 90-day retention vs. non-streakers per Mixpanel cohort60 daysPrimary LTV driver; directly supports payer utilization threshold
Personalized Reminder CTR[NEEDS DATA: revenue sensitivity requires baseline CTR-to-activation conversion rate by condition segment]30 daysDrives CAC (re-acquisition cost reduction)
30-Day Re-engagement Rate~$9K/month — recovers approximately 15% of at-risk churned MRR at current churn rate60 daysReduces churn drag on NRR; extends payback period

Financial Alert Annotation — WCEM: If WCEM drops below 30% for two consecutive weeks, estimated revenue impact is −$34K/month based on historical churn correlation (members below clinical engagement threshold churn at 3