If you're a SaaS founder, you probably know your MRR from memory. But do you know your net revenue retention? Your CAC payback period? Your 90-day logo churn? Most founders under $1M ARR track these in a spreadsheet they update monthly—if at all.
I get it. You're a 5-person team. Everyone is building, selling, or supporting customers. Nobody's job title is "data analyst." The metrics live in Stripe, maybe a spreadsheet you update on the first Monday of the month (or the second Monday, because you forgot), and your investor updates are assembled from memory plus a quick Stripe screenshot.
The problem isn't that you don't know metrics matter. The problem is that setting up proper tracking feels like a project that requires a data engineer you don't have and can't afford.
It doesn't have to be. Here's how to get automated SaaS metrics monitoring running in an afternoon—with alerts that tell you when something changes—without hiring anyone.
The 7 metrics you should monitor weekly
Before we talk about tooling, let's get specific about what to track and why. These are the seven metrics that, if monitored weekly, will catch problems before they become crises:
1. MRR (Monthly Recurring Revenue)
Formula: Sum of all active subscriptions, normalized to monthly amounts.
Why weekly: MRR is the heartbeat. A single week won't tell you much, but the trendline over 4-8 weeks tells you everything. You want to spot deceleration before it becomes stagnation.
2. Net New MRR
Formula: New MRR (new customers) + Expansion MRR (upgrades) - Contraction MRR (downgrades) - Churned MRR (cancellations).
Why weekly: This decomposes the "why" behind MRR movement. If MRR is flat, is it because new sales are offsetting churn (bad) or because nothing is moving (different kind of bad)?
3. Logo churn rate
Formula: (Customers who cancelled in period) / (Customers at start of period). Express monthly.
Why weekly: Logo churn is the leading indicator. Revenue churn lags because big customers churn slowly (they downgrade first). A spike in logo churn this week means revenue churn in 30-60 days.
4. Net Dollar Retention (NDR / NRR)
Formula: (Starting MRR + Expansion - Contraction - Churn) / Starting MRR. For a cohort over a period (typically monthly or annual).
Why weekly: NDR above 100% means you grow even without new customers. NDR below 100% means you're on a treadmill. This is the single metric investors care most about at Series A+, and you should care about it much earlier.
5. CAC (Customer Acquisition Cost)
Formula: Total sales + marketing spend / New customers acquired. Usually measured monthly.
Why weekly: Weekly CAC is noisy (one big ad campaign can spike it), but the rolling 4-week average tells you if you're getting more or less efficient. Combine with the next metric to understand unit economics.
6. CAC Payback Period
Formula: CAC / (Average Revenue Per Account * Gross Margin %).
Why weekly: This tells you how many months it takes to recover the cost of acquiring a customer. Under 12 months is healthy for most B2B SaaS. Over 18 months means you're either spending too much to acquire or not monetizing enough. If this creeps up over a few weeks, something structural is shifting.
7. LTV (Lifetime Value)
Formula: ARPA / Monthly churn rate (simplified). Or: ARPA * Average customer lifetime in months.
Why weekly: LTV changes slowly, but LTV:CAC ratio is the fundamental health metric of your business. You want this above 3:1. If it's trending down, either CAC is rising or retention is getting worse—both worth knowing immediately.
Three approaches to tracking without a data team
Approach 1: Spreadsheet + manual Stripe exports
How it works: Export Stripe data monthly (or use the dashboard). Calculate metrics in Google Sheets. Maybe you have some formulas set up.
Pros: Free. You understand every number because you calculated it yourself.
Cons: You forget. It takes 45 minutes every time. The formulas break when you add a new plan or change pricing. You never do it weekly—monthly if you're disciplined, quarterly if you're honest. And there are no alerts. When churn spikes in week 2, you don't find out until your monthly review in week 5.
Verdict: Works until about $10k MRR, then the pain of maintaining it exceeds the value.
Approach 2: Dedicated SaaS metrics tools
Tools like Baremetrics ($108/mo), ChartMogul ($99/mo), and ProfitWell (free tier available) connect directly to Stripe and calculate all standard SaaS metrics automatically.
Pros: Set-and-forget. Metrics are always current. Beautiful dashboards you can share with investors. ProfitWell's free tier is genuinely useful.
Cons: They only see Stripe data. They can't tell you anything about product usage, feature adoption, or activation rates. They can't correlate churn with "customers who stopped using feature X." They can't alert on compound conditions ("churn up AND signups down this week"). And they can't join with your product database to answer questions like "what's the LTV of customers who activate within 24 hours vs. those who take a week?"
Verdict: If all you need is standard subscription metrics from Stripe, these tools are excellent and fairly priced. If you need more context—especially product data alongside revenue data—they'll frustrate you.
Approach 3: Connect Stripe + your database to an AI analytics platform
This is the "unified view" approach. Instead of a tool that only sees billing data, you connect both Stripe (revenue) and your product database (usage, activation, feature adoption) to a single platform that can query across both.
Pros: You can ask questions that span revenue and product data. "What's the LTV of customers who create more than 3 projects in their first week?" becomes answerable. Alerts can trigger on compound conditions. You're not limited to pre-built reports.
Cons: More setup than a dedicated tool (though not dramatically more). Requires you to think about what questions matter, rather than just looking at a pre-built dashboard.
Verdict: Best for teams that are past the "just tell me my MRR" stage and into the "I need to understand WHY metrics are moving" stage.
Why the dedicated tools fall short for some teams
I want to be fair: for many startups, ChartMogul or Baremetrics is the right answer. They solve the "I don't have time to manually calculate this" problem cleanly.
But I keep hearing the same frustrations from founders who've been using them for 6+ months:
"I can see churn went up, but I can't see WHY." The dedicated tools show you that 5 customers churned last month. They can't show you that 4 of those 5 had stopped logging in three weeks before cancelling, or that they all used the same feature that had a bug. That requires product data.
"I can't set up the alert I actually want." You want "alert me when weekly logo churn exceeds 2% AND net new signups drop below 10." That's a compound condition. Most dedicated tools offer simple threshold alerts (MRR drops below X), not multi-metric conditions.
"I can't ask follow-up questions." You see a dip in NDR. You want to drill into which customer segment is contracting. The pre-built reports don't slice that way, and you can't write a custom query.
"I can't share a board with my investors that includes product context." Your investor wants to see MRR growth AND activation rates AND usage engagement. The billing-only tool shows one third of that picture.
The DIY approach with Fastero
Here's what I'd actually set up if I were a SaaS founder at $20k MRR with no analyst:
Step 1: Connect Stripe (5 minutes)
Fastero's Stripe integration pulls in subscriptions, invoices, customers, and events. Once connected, it automatically calculates MRR, churn, NDR, and the other standard metrics. This alone replaces the spreadsheet.
Step 2: Connect your product database (10 minutes)
If you're on Postgres, MySQL, or MongoDB, connect it as a data source. Now you have revenue data AND product data in one place. You can ask questions that span both: "show me churn rate for customers who logged in fewer than 3 times last month."
Step 3: Ask questions, save answers as dashboards
This is where the AI analytics layer pays off. Instead of building reports manually, you ask in natural language: "What's my net dollar retention by plan tier for the last 6 months?" Fastero translates that into the right query, runs it, and shows you the result. If it's useful, save it to a dashboard.
Within an hour, you'll have a dashboard with MRR trend, Net New MRR breakdown, logo churn, NDR, and whatever custom metrics matter to your business.
Step 4: Set up alerts via triggers
This is the part that makes it "monitoring" rather than just "reporting." Using Fastero triggers, set up automated checks:
- MRR drop alert: "If MRR drops more than 5% week-over-week, send a Slack message."
- Churn spike alert: "If more than 3 customers cancel in a single week, alert me."
- Failed payment alert: "If failed payments exceed $500 in a day, alert immediately."
- Weekly summary: "Every Monday at 9am, send me a Slack message with last week's MRR, net new MRR, and churn numbers."
These run continuously. You don't need to remember to check. The system tells you when something changes.
Step 5: Add product health metrics
Once the revenue side is automated, layer in product signals:
- Weekly active users trend
- Feature adoption rates (who's using what?)
- Activation rate (what % of signups hit your "aha moment"?)
- Time-to-value for new signups
Now you have a single view that shows business health AND product health. When churn spikes, you can immediately check whether it correlates with a drop in product usage—something no billing-only tool can tell you.
What I'd set up on day one (prioritized)
If you're starting from zero and want the highest-impact monitoring with the least effort, here's my priority order:
Priority 1: MRR trend alert (>5% weekly drop). This catches catastrophic problems early. If you're losing 5% of MRR in a single week, something is very wrong—a billing issue, a broken feature, a competitor poaching customers. You want to know within hours, not at your next monthly review.
Priority 2: Failed payment alert. Involuntary churn from failed payments is the easiest churn to prevent. A same-day alert means you can reach out to the customer before they even notice their service was interrupted. Most SaaS companies lose 2-5% of MRR monthly to failed payments that never get recovered simply because nobody noticed in time.
Priority 3: Logo churn weekly summary. Every Monday morning, a Slack message listing last week's cancellations with whatever context is available (plan, tenure, last login date). This keeps churn visible without requiring you to log into anything. Over time, you'll start noticing patterns: "all three of these customers were on our cheapest plan and hadn't logged in for 2 weeks before cancelling."
Priority 4: Weekly metrics Slack digest. A formatted summary every Monday: MRR, Net New MRR, logo churn count, NDR for the trailing 30 days, and signups. This replaces the spreadsheet ritual. It shows up whether or not you remember to check.
The total setup time for all four is realistically 2-3 hours—mostly because you'll want to customize the alert thresholds and Slack formatting. After that, it runs forever without maintenance.
The bottom line
You don't need a data team to track SaaS metrics properly. You don't even need to spend $100+/month on a dedicated tool (though those tools are perfectly fine if billing-only metrics are sufficient for your stage).
What you need is:
- Your data connected somewhere it can be queried automatically
- The right metrics calculated on a schedule
- Alerts that tell you when things change, so you're not relying on memory
The difference between "I track MRR in my head" and "I get alerted when metrics move unexpectedly" is the difference between finding problems in your monthly investor update and finding them when you can still do something about it.
If you're a SaaS founder who's been meaning to set this up "eventually," an afternoon is all it takes. Your future self will thank you the first time an alert catches something you would have missed.
Ready to automate your SaaS metrics? Start a free trial—connect Stripe, get your dashboard in 10 minutes, and set up alerts before lunch.
Related: SaaS metrics dashboard template | How to get Slack alerts when metrics change | Executive monitoring setup