You don't need a BI tool, a data warehouse, or a full-time analyst to track the metrics that matter in your first 18 months. You need five numbers and a place to put them every week. The rest — the dashboards, the automations, the cohort slicing — is for companies that have already proven the business works.
Here's what those five numbers are, why they're the ones that will tell you whether your company is working before your runway runs out, and how to build the habit that actually makes them useful.
The wrong way to build a startup metrics dashboard
Spreadsheets with 40 columns. Mixpanel dashboards for product analytics that nobody opens. Auto-generated revenue reports from Stripe that nobody interprets. Charts that go up and to the right in a pitch deck but never get questioned in a team meeting.
The most common problem isn't that founders don't have data — it's that they have too much data and the wrong data. Tracking 30 metrics is the same as tracking zero. When everything is monitored, nothing is prioritized.
The five metrics that actually matter at seed stage
MRR (Monthly Recurring Revenue): You probably have this already. The question isn't just "what is it" — it's "what's driving this month's change?" New customers, churn, or expansion?
Net Revenue Retention (NRR): The single number that tells you whether you have a real business or a leaky bucket. NRR above 100% means you're growing even without new customers. NRR below 80% means growth is meaningless — you're filling a bathtub with the drain open.
CAC payback period: How many months of revenue does it take to recover the cost of acquiring a customer? The customer acquisition cost divided by monthly gross margin per customer. Above 18 months for SMB SaaS is a problem. Below 8 months, you likely have a scalable GTM motion.
Monthly churn rate: Monthly, not annual. Annual churn math hides problems for too long. A 5% monthly churn looks manageable until you realize that's 46% annually — meaning you need to replace nearly half your customer base every year just to stay flat.
Pipeline coverage: At what multiple of your monthly close goal is your current pipeline? 3x is the minimum. If you have a $100K/month close goal and $150K in pipeline, you're probably going to miss.
What not to track yet
Save these for later: LTV (you need longitudinal data to defend it), CAC breakdown by channel (you don't have enough channels), NPS (useful at scale, noise at seed), DAU/MAU unless you're product-led, and cohort analysis by acquisition channel.
LTV/CAC ratios matter at Series A. They're nearly impossible to defend at seed because you don't have the data to back them up. B2B SaaS metrics that require two years of retention data to be meaningful aren't the ones to optimize for when you're 9 months in.
How to build the dashboard
Google Sheets, updated manually, once per week. That's it. Pull your MRR from Stripe or your billing system, your pipeline from your CRM, calculate NRR from a simple cohort table, and put it in a shared tab with your co-founder.
The act of pulling these numbers manually is valuable at early stage — it forces you to look at each metric as a business decision, not a monitoring exercise. When you automate everything, the metrics start to feel like status indicators rather than thinking prompts.
When you're past $500K ARR and have more than one revenue source, consider Baremetrics, ChartMogul, or a lightweight RevOps stack. Until then, a shared Google Sheet is better discipline.
The weekly review that makes the dashboard matter
Pick one time per week — same time every week — to update the dashboard with your co-founder or leadership team. 30 minutes. Go through each of the five metrics. Answer one question per metric: "What does this number tell us about what we should do differently next week?"
That ritual is the point. Not the data — the decision. A metrics dashboard that no one uses to change their behavior is a reporting tool, not a management tool. The difference between the two is the weekly conversation that turns numbers into actions.
Operators who've run teams know this instinctively. The weekly ops review, the daily stand-up, the monthly P&L walk — the discipline of structured review is what makes data useful. Bring that same discipline to your startup metrics dashboard and you won't need a CFO to tell you when something is off.