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)