Skip to main content
Product Management/metrics-dashboard

Metrics Dashboard

Build 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 the practitioner'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?
  • Is their data warehouse-native (Snowflake, BigQuery, Databricks, Redshift) with a composable-CDP / reverse-ETL setup, or copied into a siloed analytics tool? In 2026 the warehouse is increasingly the source of truth (Hightouch-style), and the dashboard should read governed metrics from there rather than a parallel copy.
  • Do they have an AI-insights layer (Amplitude auto-recommendations, Mixpanel Spark AI) that surfaces anomalies and churn predictions without being asked? If so, the dashboard plugs into it; if not, flag the gap.

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 This skill 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 6.5: Wire in the AI-insights layer and semantic-layer handoff

In 2026 the dashboard is not just a wall of numbers the team pulls and reads. Warehouse-native platforms ship an AI layer that surfaces anomalies, predicts churn, and answers natural-language questions (Amplitude auto-recommendations, Mixpanel Spark AI) without anyone framing the right query first. That changes the human's job. The team's work is no longer "pull the report." It is "validate, contextualize, and decide on what the AI already surfaced." Design the dashboard for that reality.

For each section of the framework, specify two things:

  1. What the AI watches. Which metrics get auto-anomaly detection and predictive alerts (for example, churn-risk scoring on retention inputs, spike/drop detection on activation). The AI surfaces the signal. Do not make a human eyeball the line chart to catch it.
  2. What the human validates. For every AI-surfaced insight, name the validation step: is the anomaly real or an instrumentation artifact, what is the business context, what decision does it trigger? The dashboard should route each AI alert to an owner who confirms or dismisses it, not let it auto-act.
MetricAI Watch (anomaly / prediction)Human Validation StepDecision It Triggers
[Name][e.g., churn-risk score, spike detection][Confirm signal vs. artifact, add context][What the team does next]

Semantic-layer handoff. A metric defined three different ways across three dashboards is worse than no metric. Hand off each metric definition from Step 3 to the client's semantic layer (dbt Semantic Layer, Cube, or the platform's governed metrics store) so the AI and every dashboard read the same governed definition. This is now competitive infrastructure: it is what keeps AI-surfaced insights trustworthy and consistent. If the client has no semantic layer, flag it: [NEEDS SEMANTIC LAYER: metric definitions live only in this doc and will drift -- recommend a governed metrics store before AI insights can be trusted].

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); the practitioner 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: the practitioner'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

Run this now

0/4000

Part of these Playbook topics