Back to prompts
Data & AnalysisPremiumintermediate
4.7

Choose the Right KPIs for Any Business Dashboard

Stop tracking vanity metrics — get a focused dashboard with KPIs that actually drive decisions

Copy & Paste this prompt
I need to build a dashboard for [DEPARTMENT/TEAM/PRODUCT].

Business context:
- Company type: [B2B SaaS / E-COMMERCE / MARKETPLACE / AGENCY / OTHER]
- Team using this: [ROLE — CEO, marketing, product, ops, sales]
- Key business goal right now: [PRIMARY OBJECTIVE]
- Current stage: [STARTUP / GROWTH / MATURE / TURNAROUND]
- Reporting cadence: [DAILY / WEEKLY / MONTHLY]

Design my dashboard:

1. PRIMARY KPIs (3-5 max)
   For each:
   - Metric name and exact formula
   - Why it matters for my specific goal
   - Target/benchmark range
   - Data source (where does this number come from?)
   - Red/yellow/green thresholds

2. SUPPORTING METRICS (5-8)
   - Metrics that explain WHY primary KPIs move
   - Group them by the primary KPI they support

3. VANITY METRICS TO REMOVE
   - Metrics that feel important but do not drive decisions
   - Why each one is misleading

4. DASHBOARD LAYOUT
   - What goes at the top (glanceable health)
   - What goes in the middle (trends and context)
   - What goes at the bottom (drill-down details)

5. ALERT RULES
   - 3 conditions that should trigger an alert/notification
   - Severity level for each

The test of a good KPI: if it moves, does someone DO something differently? If not, it does not belong on the dashboard.
#data#analytics#choose#right#kpis

Works with

chatgptclaudegemini

💡 Pro Tips

  • •The "so what" test: for every metric ask "if this number changes, what action do we take?"
  • •Mix leading indicators (predict the future) with lagging indicators (confirm results)
  • •Start with 3 KPIs max — you can always add more, but cluttered dashboards get ignored

✨ Example Output

Dashboard for: SaaS Product Team (Growth Stage)
Goal: Reduce churn from 8% to 5% monthly

PRIMARY KPIs:
1. Monthly Churn Rate = (Customers lost ÷ Customers at start) × 100
   - Target: <5% | Yellow: 5-7% | Red: >7%
   - Source: Stripe/billing system
   - Why: Direct measure of the goal

2. Net Revenue Retention (NRR) = (MRR start + expansion - contraction - churn) ÷ MRR start
   - Target: >105% | Yellow: 95-105% | Red: <95%
   - Source: Revenue system
   - Why: Shows if growth outpaces losses

3. Product Engagement Score = Weighted average of key feature usage
   - Target: >65 | Yellow: 45-65 | Red: <45
   - Source: Product analytics (Mixpanel/Amplitude)
   - Why: Leading indicator — low engagement predicts churn 2-4 weeks ahead

VANITY METRICS TO REMOVE:
❌ Total registered users (includes dead accounts)
❌ Page views (activity ≠ value)
❌ NPS alone (lagging, infrequent, and gameable)

🧠 Why This Works

This prompt applies the principle of metric hierarchies—distinguishing input metrics, output metrics, and health metrics—to prevent dashboard bloat. It forces alignment between business objectives and what you actually measure, eliminating vanity metrics that look good but don't drive decisions.

📅 When to Use This Prompt

Use when building a new dashboard, redesigning an existing one that nobody checks, or when leadership asks 'what should we be tracking?' Perfect for SaaS companies defining north star metrics, e-commerce teams setting up analytics, or any team drowning in data but starving for insight.

🎯 What You'll Get

You receive a prioritized KPI framework with 5-8 primary metrics tied to business goals, supporting metrics for diagnosis, recommended alert thresholds, and a suggested dashboard layout that tells a coherent story from top-level health to actionable detail.

🔗 Related Prompts

Data & AnalysisPremium

Data Visualization Advisor

Choose the right chart type and design for any data story with implementation guidance.

data-visualizationchartsdashboards
★4.5
intermediate
Data & AnalysisPremium

Revenue Forecast Model Builder

Build a revenue forecast model with assumptions, scenarios, and sensitivity analysis from your historical data.

revenueforecastingfinancial-modeling
★4.8
advanced