Skip to main content
All articles
Business IntelligenceMarch 23, 20266 min read

How to Build a Business Dashboard That Actually Drives Decisions

Most dashboards show 50 metrics and drive 0 decisions. Here's how to build one with the 7 metrics that actually change how you run your company.

You have a dashboard. You check it every morning. You see numbers. You feel informed.

But when was the last time your dashboard actually changed a decision you made that day?

For most founders, the honest answer is: rarely. Dashboards become rituals — something you look at to feel productive, not something that drives action. The problem isn't that you lack data. It's that you're tracking 50 metrics when only 7 of them actually matter.

The Dashboard Trap

Here's what most business dashboards look like:

  • 12 charts across 3 tabs
  • 47 individual metrics
  • Data from 4 different sources, manually updated
  • Last refreshed: 3 days ago

Nobody makes a decision from 47 metrics. They scan for something that looks wrong, don't find anything obvious, and move on. The dashboard provided comfort, not insight.

A good dashboard does one thing: tells you what needs your attention today. Everything else is noise.

The Only 7 Metrics You Need

Metric 1: Net Revenue (This Week vs Last Week)

Not gross revenue. Net revenue: collected revenue minus returns, chargebacks, and failed payments. And compare week-over-week, not just cumulative month-to-date.

Why it drives decisions: A 15% week-over-week drop in net revenue is an immediate signal. Something changed — ad performance, conversion rate, refund rate, or payment failures. The trend tells you to investigate now, not during the monthly review.

Metric 2: Cash Position + 30-Day Forecast

Your current bank balance and where it will be in 30 days based on recurring revenue, known expenses, and upcoming payables.

Why it drives decisions: "Can I hire that contractor?" "Can I increase ad spend?" "Should I push that supplier payment?" These are daily decisions that require knowing your cash position — not your revenue.

Metric 3: Real ROAS by Channel

Collected revenue attributed to each ad channel divided by that channel's spend. Updated daily.

Why it drives decisions: When Google ROAS drops below 2x, you pause or restructure that campaign today — not next week when you notice the monthly average shifted. Real ROAS tracking catches waste in hours, not weeks.

Metric 4: Customer Health Score (Top 10 Accounts)

A composite score based on login frequency, feature usage, support tickets, and payment status for your highest-value customers.

Why it drives decisions: If your #2 customer's health score dropped from 85 to 62 this week, you call them today. Not next quarter during the QBR. By then they've already decided to leave.

Metric 5: Pipeline Coverage Ratio

Total pipeline value divided by your revenue target for the period. Shows whether you have enough deals in motion to hit your number.

Why it drives decisions: At 2x coverage, you need every deal to close. At 5x, you can be selective. Below 2x in the first half of the quarter? Start prospecting immediately.

Metric 6: Refund/Return Rate (7-Day Rolling)

Percentage of revenue that was refunded or returned in the last 7 days.

Why it drives decisions: A spike from 3% to 8% means something specific broke — a bad product batch, a misleading ad, a checkout error, a shipping problem. The 7-day window catches it while you can still act.

Metric 7: Failed Payment Count

Number of subscription payments that failed this week, with total revenue at risk.

Why it drives decisions: 15 failed payments at $200/each = $3,000 at risk this week. If your recovery automation isn't running, that's $3,000 you need to manually chase today.

Building the Dashboard

What Not to Build

  • Don't build it in a spreadsheet (it'll be stale by Wednesday)
  • Don't use Tableau or Looker (they need a data engineer)
  • Don't build a custom React dashboard (you'll spend weeks on it)

What to Use

Option 1: Your existing tools. Stripe Dashboard for revenue + HubSpot Reports for pipeline + Google Ads for ROAS. Check 3 tabs every morning. Takes 15 minutes. Works until ~$500K revenue.

Option 2: A connected platform. One dashboard pulling from all your tools automatically. Updates in real time. Alerts you when metrics cross thresholds. This is what NuMoon provides — 7 KPI cards on one screen, connected to 41+ tools via OAuth.

The Alert System (More Important Than the Dashboard)

Here's the truth: you shouldn't need to check a dashboard. A well-configured alert system tells you when something needs attention:

  • Net revenue down 15%+ week-over-week → Slack alert
  • Cash forecast below 60-day runway → Email alert
  • Real ROAS below target on any campaign → Immediate alert
  • Customer health score dropped 20+ points → Account manager notified
  • Failed payments exceeding 10 in a day → Urgent alert

If nothing is alerting, everything is fine. You can spend your time on strategy instead of monitoring.

The Anti-Vanity Metric Test

Before adding any metric to your dashboard, ask: "If this number changed by 20%, would I do something different tomorrow?"

  • Page views? No — more views don't mean more revenue.
  • Social media followers? No — followers don't pay bills.
  • Email list size? No — list size without engagement is vanity.
  • MRR? Yes — a 20% drop means something is very wrong.
  • Failed payments? Yes — that's revenue to recover immediately.

If the answer is no, it's a vanity metric. Keep it off your dashboard.

Frequently Asked Questions

How often should I check my dashboard?

Once per day, in the morning, for 5-10 minutes. If you're checking it multiple times per day, your alert system isn't configured properly. Let alerts surface problems; use the dashboard for the daily snapshot.

What if I don't have enough data yet?

If you're pre-revenue or very early, track just 3 metrics: cash position, weekly signups, and activation rate (% of signups who complete a key action). Everything else is premature.

Should my team see the same dashboard?

Your team should see the metrics relevant to their function. Marketing sees ROAS and pipeline. Engineering sees product usage and support tickets. Finance sees cash position and P&L. The CEO sees all 7 — that's the executive dashboard.

Your Dashboard Should Make You Uncomfortable

A good dashboard doesn't just confirm things are fine. It surfaces the one thing that needs attention right now. If your dashboard never makes you uncomfortable, it's not showing you enough truth.

Build the 7-metric dashboard. Set up alerts. Stop monitoring — start acting.

Take the free health scan to see which of these 7 metrics you're currently missing.