← Back to all products

Product Metrics Dashboard Templates

$39

KPI tracking spreadsheets for product metrics: engagement, retention, conversion, revenue, and NPS with automated charts.

21 files
MarkdownJSONGoogle SheetsExcelTableau

Product Preview

Try the interactive reader and demo tools below, or get the full product with all content unlocked.

Interactive Reader (Free Preview) ⚙ Try Demo Tools Download Free Sample

File Structure 21 files

metrics-analytics-dashboard/ ├── LICENSE ├── README.md ├── examples/ │ ├── alert-thresholds.md │ ├── metrics-review-deck.md │ └── saas-startup-data.csv ├── frameworks/ │ ├── metrics-definitions-glossary.md │ ├── metrics-formulas-reference.md │ └── north-star-metric.md ├── free-sample.zip ├── guide/ │ ├── 01_dashboard-setup-guide.md │ └── 02_metrics-review-cadence.md ├── guides/ │ ├── dashboard-setup-guide.md │ └── metrics-review-cadence.md ├── index.html ├── interactive.html └── spreadsheets/ ├── conversion-funnel.csv ├── engagement-metrics.csv ├── nps-tracking.csv ├── retention-cohort.csv └── revenue-mrr.csv

Documentation Preview README excerpt

Product Metrics Dashboard Templates

By PM Toolkit Pro | $39

A complete metrics tracking system for product managers. Five CSV spreadsheet templates covering engagement, retention, conversion, revenue, and NPS — each pre-loaded with realistic sample data, formulas guidance, and ready-to-use headers. Includes a metrics definitions glossary, North Star framework, and dashboard setup guide.


What's Inside

Spreadsheet Templates (`spreadsheets/`)

FilePurposeSample Rows
engagement-metrics.csvDAU, WAU, MAU, session duration, feature adoption tracking30 days of data
retention-cohort.csvMonthly cohort retention analysis with 12-month lookback8 cohorts
conversion-funnel.csvMulti-stage funnel tracking from visitor to paid customer12 weeks of data
revenue-mrr.csvMRR, ARR, expansion, contraction, churn, LTV tracking12 months of data
nps-tracking.csvNPS survey results with score calculation and trend data6 quarters of data

Frameworks (`frameworks/`)

FilePurpose
north-star-metric.mdFramework for choosing, validating, and operationalizing your North Star metric
metrics-definitions-glossary.md50+ metric definitions with formulas, benchmarks, and common pitfalls

Guides (`guides/`)

FilePurpose
dashboard-setup-guide.mdStep-by-step guide to building dashboards from these templates in any BI tool
metrics-review-cadence.mdHow to run weekly, monthly, and quarterly metrics reviews

Examples (`examples/`)

FilePurpose
saas-startup-data.csvComplete dataset for a fictional SaaS startup — 12 months of blended metrics
metrics-review-deck.mdTemplate for a monthly metrics review presentation
alert-thresholds.mdRecommended alert thresholds for key metrics (when to worry)

Features

  • Five domain-specific spreadsheets with proper headers, formulas guidance, and realistic sample data you can use as a reference or replace with your own numbers
  • Metrics glossary with 50+ definitions — not just the name but the formula, what "good" looks like, and common calculation mistakes
  • North Star framework — a structured process for choosing the one metric that matters most, with examples from different product types
  • Dashboard setup guide that works with any BI tool (Looker, Metabase, Tableau, Google Sheets) — focuses on which charts to build and why, not tool-specific clicks
  • Realistic sample data based on typical SaaS patterns — use it to build practice dashboards or as a template for your own tracking

Quick Start

1. Pick your priority metric area — engagement, retention, conversion, revenue, or NPS

2. Open the corresponding CSV in spreadsheets/ — review the headers, understand each column using frameworks/metrics-definitions-glossary.md

3. Import into your tool (Google Sheets, Excel, your BI platform) — see guides/dashboard-setup-guide.md for recommended chart types

4. Replace the sample data with your real numbers (or use the sample data to practice)

... continues with setup instructions, usage examples, and more.

Content Sample examples/alert-thresholds.md

Alert Thresholds for Product Metrics

When should you stop what you're doing and investigate a metric? This guide provides recommended alert thresholds for key product metrics, organized by urgency level.

Urgency Levels

LevelResponse TimeWho Gets AlertedAction
CriticalWithin 1 hourOn-call engineer + product leadDrop everything, investigate immediately
HighSame business dayProduct lead + team leadPrioritize investigation, may need to pause other work
MediumWithin 48 hoursProduct managerInvestigate this week, track in next standup
LowWithin 1 weekAdded to weekly review agendaDiscuss at next weekly metrics review

Engagement Alerts

MetricAlert ConditionLevelLikely CausesInvestigation Steps
DAUDrops >20% from 7-day trailing averageHighOutage, broken deployment, seasonal effect, tracking bug1. Check uptime monitoring 2. Check recent deployments 3. Verify analytics tracking is working 4. Check for external events
DAUDrops >40% from 7-day trailing averageCriticalService outage, major bug, data pipeline failureImmediate: check system status. Is the product working? Is tracking broken?
WAU/MAU ratio (stickiness)Drops below 15%MediumReduced engagement quality, feature regression, competitor emergenceCompare feature usage trends, check recent changes, review support tickets
Avg session durationDrops >30% from monthly averageMediumPerformance issues, UX regression, broken workflowCheck page load times, review recent UI changes, check error rates
Bounce rateRises above 55% for 3+ consecutive daysMediumLanding page issue, broken onboarding, targeting mismatchCheck landing pages, verify onboarding flow, review traffic sources

Conversion Alerts

MetricAlert ConditionLevelLikely CausesInvestigation Steps
Visitor → SignupDrops below 2% for 5+ daysMediumPricing page change, landing page bug, traffic quality changeCheck for recent page changes, review traffic source mix, test signup flow
Signup → Onboarding completeDrops below 60%HighOnboarding bug, confusing new step, email delivery issueWalk through onboarding as a new user, check for errors, verify emails sending
Trial → PaidDrops below 12% for a monthly cohortHighValue delivery problem, competitor offer, billing flow bugCheck activation rates, review churned trial users, test payment flow
Any funnel stepSingle-step drop-off exceeds 50%HighBug at that step, UX regression, new friction pointWalk through the step manually, check error logs, compare to previous version

Revenue Alerts

MetricAlert ConditionLevelLikely CausesInvestigation Steps
Monthly MRR churnExceeds 5%HighProduct quality issue, competitor displacement, pricing concern, support failureRun churn analysis by segment, review cancellation reasons, check support satisfaction
Monthly MRR churnExceeds 8%CriticalSystemic product or market problemExecutive escalation, churn cohort deep-dive, customer outreach
Net MRRNegative for any month (lost more than gained)CriticalCompany is shrinking — business model riskAll hands on deck: churn analysis, expansion opportunities, acquisition strategy review
ARPUDrops >10% MoMMediumMix shift to lower-tier plans, discounting too aggressively, downgrade trendAnalyze plan distribution changes, check discount usage, review downgrade reasons

... and much more in the full download.