Internal Safety Override
- Status: local-only unless explicitly opted into external access.
- Before using network tools, account connectors, browser automation, or APIs, state the destination, data scope, and credential source.
- Do not transmit repository files, secrets, credentials, or private documents by default.
- Audit categories: network.
Product Analytics
Define, track, and interpret product metrics across discovery, growth, and mature product stages.
When To Use
Use this skill for:
- Metric framework selection (AARRR, North Star, HEART)
- KPI definition by product stage (pre-PMF, growth, mature)
- Dashboard design and metric hierarchy
- Cohort and retention analysis
- Feature adoption and funnel interpretation
Workflow
- Select metric framework
- AARRR for growth loops and funnel visibility
- North Star for cross-functional strategic alignment
- HEART for UX quality and user experience measurement
- Define stage-appropriate KPIs
- Pre-PMF: activation, early retention, qualitative success
- Growth: acquisition efficiency, expansion, conversion velocity
- Mature: retention depth, revenue quality, operational efficiency
- Design dashboard layers
- Executive layer: 5-7 directional metrics
- Product health layer: acquisition, activation, retention, engagement
- Feature layer: adoption, depth, repeat usage, outcome correlation
- Run cohort + retention analysis
- Segment by signup cohort or feature exposure cohort
- Compare retention curves, not single-point snapshots
- Identify inflection points around onboarding and first value moment
- Interpret and act
- Connect metric movement to product changes and release timeline
- Distinguish signal from noise using period-over-period context
- Propose one clear product action per major metric risk/opportunity
KPI Guidance By Stage
Pre-PMF
- Activation rate
- Week-1 retention
- Time-to-first-value
- Problem-solution fit interview score
Growth
- Funnel conversion by stage
- Monthly retained users
- Feature adoption among new cohorts
- Expansion / upsell proxy metrics
Mature
- Net revenue retention aligned product metrics
- Power-user share and depth of use
- Churn risk indicators by segment
- Reliability and support-deflection product metrics
Dashboard Design Principles
- Show trends, not isolated point estimates.
- Keep one owner per KPI.
- Pair each KPI with target, threshold, and decision rule.
- Use cohort and segment filters by default.
- Prefer comparable time windows (weekly vs weekly, monthly vs monthly).
See:
references/metrics-frameworks.md
references/dashboard-templates.md
Cohort Analysis Method
- Define cohort anchor event (signup, activation, first purchase).
- Define retained behavior (active day, key action, repeat session).
- Build retention matrix by cohort week/month and age period.
- Compare curve shape across cohorts.
- Flag early drop points and investigate journey friction.
Retention Curve Interpretation
- Sharp early drop, low plateau: onboarding mismatch or weak initial value.
- Moderate drop, stable plateau: healthy core audience with predictable churn.
- Flattening at low level: product used occasionally, revisit value metric.
- Improving newer cohorts: onboarding or positioning improvements are working.
Anti-Patterns
| Anti-pattern |
Fix |
| Vanity metrics — tracking pageviews or total signups without activation context |
Always pair acquisition metrics with activation rate and retention |
| Single-point retention — reporting "30-day retention is 20%" |
Compare retention curves across cohorts, not isolated snapshots |
| Dashboard overload — 30+ metrics on one screen |
Executive layer: 5-7 metrics. Feature layer: per-feature only |
| No decision rule — tracking a KPI with no threshold or action plan |
Every KPI needs: target, threshold, owner, and "if below X, then Y" |
| Averaging across segments — reporting blended metrics that hide segment differences |
Always segment by cohort, plan tier, channel, or geography |
| Ignoring seasonality — comparing this week to last week without adjusting |
Use period-over-period with same-period-last-year context |
Tooling
scripts/metrics_calculator.py
CLI utility for retention, cohort, and funnel analysis from CSV data. Supports text and JSON output.
# Retention analysis
python3 scripts/metrics_calculator.py retention events.csv
python3 scripts/metrics_calculator.py retention events.csv --format json
# Cohort matrix
python3 scripts/metrics_calculator.py cohort events.csv --cohort-grain month
python3 scripts/metrics_calculator.py cohort events.csv --cohort-grain week --format json
# Funnel conversion
python3 scripts/metrics_calculator.py funnel funnel.csv --stages visit,signup,activate,pay
python3 scripts/metrics_calculator.py funnel funnel.csv --stages visit,signup,activate,pay --format json
CSV format for retention/cohort:
user_id,cohort_date,activity_date
u001,2026-01-01,2026-01-01
u001,2026-01-01,2026-01-03
u002,2026-01-02,2026-01-02
CSV format for funnel:
user_id,stage
u001,visit
u001,signup
u001,activate
u002,visit
u002,signup
Cross-References
- Related:
product-team/experiment-designer — for A/B test planning after identifying metric opportunities
- Related:
product-team/product-manager-toolkit — for RICE prioritization of metric-driven features
- Related:
product-team/product-discovery — for assumption mapping when metrics reveal unknowns
- Related:
finance/saas-metrics-coach — for SaaS-specific metrics (ARR, MRR, churn, LTV)
1---2name: product-analytics3description: Use when defining product KPIs, building metric dashboards, running cohort or retention analysis, or interpreting feature adoption trends across product stages.4---56## Internal Safety Override78- Status: local-only unless explicitly opted into external access.9- Before using network tools, account connectors, browser automation, or APIs, state the destination, data scope, and credential source.10- Do not transmit repository files, secrets, credentials, or private documents by default.11- Audit categories: network.1213# Product Analytics1415Define, track, and interpret product metrics across discovery, growth, and mature product stages.1617## When To Use1819Use this skill for:20- Metric framework selection (AARRR, North Star, HEART)21- KPI definition by product stage (pre-PMF, growth, mature)22- Dashboard design and metric hierarchy23- Cohort and retention analysis24- Feature adoption and funnel interpretation2526## Workflow27281. Select metric framework29- AARRR for growth loops and funnel visibility30- North Star for cross-functional strategic alignment31- HEART for UX quality and user experience measurement32332. Define stage-appropriate KPIs34- Pre-PMF: activation, early retention, qualitative success35- Growth: acquisition efficiency, expansion, conversion velocity36- Mature: retention depth, revenue quality, operational efficiency37383. Design dashboard layers39- Executive layer: 5-7 directional metrics40- Product health layer: acquisition, activation, retention, engagement41- Feature layer: adoption, depth, repeat usage, outcome correlation42434. Run cohort + retention analysis44- Segment by signup cohort or feature exposure cohort45- Compare retention curves, not single-point snapshots46- Identify inflection points around onboarding and first value moment47485. Interpret and act49- Connect metric movement to product changes and release timeline50- Distinguish signal from noise using period-over-period context51- Propose one clear product action per major metric risk/opportunity5253## KPI Guidance By Stage5455### Pre-PMF56- Activation rate57- Week-1 retention58- Time-to-first-value59- Problem-solution fit interview score6061### Growth62- Funnel conversion by stage63- Monthly retained users64- Feature adoption among new cohorts65- Expansion / upsell proxy metrics6667### Mature68- Net revenue retention aligned product metrics69- Power-user share and depth of use70- Churn risk indicators by segment71- Reliability and support-deflection product metrics7273## Dashboard Design Principles7475- Show trends, not isolated point estimates.76- Keep one owner per KPI.77- Pair each KPI with target, threshold, and decision rule.78- Use cohort and segment filters by default.79- Prefer comparable time windows (weekly vs weekly, monthly vs monthly).8081See:82- `references/metrics-frameworks.md`83- `references/dashboard-templates.md`8485## Cohort Analysis Method86871. Define cohort anchor event (signup, activation, first purchase).882. Define retained behavior (active day, key action, repeat session).893. Build retention matrix by cohort week/month and age period.904. Compare curve shape across cohorts.915. Flag early drop points and investigate journey friction.9293## Retention Curve Interpretation9495- Sharp early drop, low plateau: onboarding mismatch or weak initial value.96- Moderate drop, stable plateau: healthy core audience with predictable churn.97- Flattening at low level: product used occasionally, revisit value metric.98- Improving newer cohorts: onboarding or positioning improvements are working.99100## Anti-Patterns101102| Anti-pattern | Fix |103|---|---|104| **Vanity metrics** — tracking pageviews or total signups without activation context | Always pair acquisition metrics with activation rate and retention |105| **Single-point retention** — reporting "30-day retention is 20%" | Compare retention curves across cohorts, not isolated snapshots |106| **Dashboard overload** — 30+ metrics on one screen | Executive layer: 5-7 metrics. Feature layer: per-feature only |107| **No decision rule** — tracking a KPI with no threshold or action plan | Every KPI needs: target, threshold, owner, and "if below X, then Y" |108| **Averaging across segments** — reporting blended metrics that hide segment differences | Always segment by cohort, plan tier, channel, or geography |109| **Ignoring seasonality** — comparing this week to last week without adjusting | Use period-over-period with same-period-last-year context |110111## Tooling112113### `scripts/metrics_calculator.py`114115CLI utility for retention, cohort, and funnel analysis from CSV data. Supports text and JSON output.116117```bash118# Retention analysis119python3 scripts/metrics_calculator.py retention events.csv120python3 scripts/metrics_calculator.py retention events.csv --format json121122# Cohort matrix123python3 scripts/metrics_calculator.py cohort events.csv --cohort-grain month124python3 scripts/metrics_calculator.py cohort events.csv --cohort-grain week --format json125126# Funnel conversion127python3 scripts/metrics_calculator.py funnel funnel.csv --stages visit,signup,activate,pay128python3 scripts/metrics_calculator.py funnel funnel.csv --stages visit,signup,activate,pay --format json129```130131**CSV format for retention/cohort:**132```csv133user_id,cohort_date,activity_date134u001,2026-01-01,2026-01-01135u001,2026-01-01,2026-01-03136u002,2026-01-02,2026-01-02137```138139**CSV format for funnel:**140```csv141user_id,stage142u001,visit143u001,signup144u001,activate145u002,visit146u002,signup147```148149## Cross-References150151- Related: `product-team/experiment-designer` — for A/B test planning after identifying metric opportunities152- Related: `product-team/product-manager-toolkit` — for RICE prioritization of metric-driven features153- Related: `product-team/product-discovery` — for assumption mapping when metrics reveal unknowns154- Related: `finance/saas-metrics-coach` — for SaaS-specific metrics (ARR, MRR, churn, LTV)