The Analytics Stack for a $1M ARR SaaS Company

By Emily Redmond, Data Analyst at Emilytics · April 2026

TL;DR: Essential: GA4, billing system, spreadsheet. Recommended: Mixpanel or Amplitude. Skip: Expensive BI tools until $5M+ ARR.

Most SaaS founders build huge analytics stacks that nobody uses.

They buy Mixpanel, Amplitude, Tableau, Looker, and a custom data warehouse. It costs $5k/month. Nobody looks at it. Decisions are still made on gut feeling.

Here's what a $1M ARR SaaS company actually needs.

The Minimum Stack ($200–$500/month)

1. Google Analytics 4 (GA4) — $0

Tracks website and top-of-funnel
Free tier handles 10M+ events/month
Sufficient for: traffic, signup funnel, conversion rates

Setup: ~4 hours Ongoing: Update events monthly

What it's good for:

How many visitors?
Which pages/campaigns convert best?
Where do signups come from?

What it's not good for:

Deep product behavior
Retention curves
Feature adoption

2. Your Billing System (Stripe, Chargebee, etc.) — $0–$500/month

You need it for payments, so use it for analytics:

MRR tracking
Churn analysis
Expansion revenue
Customer LTV

What to extract:

Daily MRR
Monthly churn
Customer expansion (plan upgrades, additional users)
Cohort retention (customers by signup date)

Setup: Export historical data to Google Sheets (1–2 hours), then automate with Zapier or API

Ongoing: 30 min/week manual updates, or automated daily via Zapier

3. Google Sheets (Your Data Warehouse) — $0

Where you combine data from GA4, billing, and manual inputs:

Week	MRR	Signups	Trials	Conversions	Activation %	Churn %
Week 1	$83,500	145	58	9	34%	2.1%
Week 2	$84,200	152	62	11	36%	1.9%

What to include:

MRR and growth rate
Customer count
Trial signups
Trial-to-paid conversions
Activation rate (% of new users completing aha moment)
Churn rate
CAC by channel
Estimated LTV

Setup: 2–3 hours to create template Ongoing: 1 hour/week to update

4. Google Sheets Dashboard (Data Viz) — $0

Create simple charts:

MRR trend (line chart)
New customers by week (bar chart)
Funnel completion (waterfall chart)
Churn cohort matrix (heatmap)

What it looks like:

MRR: Rising from $80k to $85k (good)
Signups: Steady at 140–160/week
Activation: Stable at 34–36%
Churn: Declining from 2.2% to 1.8% (good)

Setup: 2–3 hours for charts Ongoing: 30 min/week to refresh

Total for this stack: $200–$500/month (billing system only)

The Recommended Stack ($700–$1,500/month)

Add Mixpanel or Amplitude for product analytics:

5. Mixpanel or Amplitude — $500–$1,000/month

What it adds:

User behavior tracking (which features are used?)
Retention curves (which cohorts retain best?)
Funnel analysis (where do users drop off?)
Cohort segmentation (compare user groups)

Use it for:

Feature adoption: % of users using Feature X
Activation funnel: Signup → first action → aha
Retention: % of users active 30, 60, 90 days later
Churn predictors: Which behaviors predict who will leave?

Setup: 4–6 weeks (define events, implement tracking, build reports) Ongoing: 2–3 hours/week analyzing

When to buy: When you're at $100k+ MRR and need to diagnose retention problems.

When to Add More Tools

Google Looker (BI Tool) — $2,000–$5,000/month

When: $3M+ ARR What it does: SQL dashboards, automated reporting, team access to live data Why wait: Overkill until you have:

50+ custom metrics
5+ people using dashboards
Need for SQL-based analysis
Large event volumes (>100M/month)

Segment or Rudderstack (Event Pipe) — $1,000–$3,000/month

When: $500k+ ARR and you need data in multiple tools What it does: Pipes GA4 events to Mixpanel, Amplitude, BigQuery, etc. Why wait: Manual event setup is fine until you need scale

BigQuery (Data Warehouse) — $500–$2,000/month

When: $2M+ ARR and you need complex joins/analysis What it does: SQL database, unlimited custom queries Why wait: Google Sheets is sufficient for simple metrics

Tools to Skip at $1M ARR

Tableau ($2k/month+) - Overkill. Google Sheets charts work fine.

Metabase ($500/month) - Nice, but Looker is better if you're going to buy a BI tool.

Mixpanel + Amplitude both - Pick one. Amplitude has better cohort analysis. Mixpanel has better feature adoption. Pick based on what you need.

Custom data warehouse - Skip until $3M+.

Business intelligence for every team member - Keep it tight. One analyst + CFO access is enough at $1M.

The Actual Weekly Review Process (30 minutes)

Every Monday morning:

Update Google Sheet with latest data (10 min)
- Pull MRR from billing system
- Manually count signups from GA4
- Grab trial starts from GA4
- Calculate activation rate
Review Mixpanel (if you have it) (10 min)
- Check retention curve: Are cohorts improving or degrading?
- Check feature adoption: % using core feature?
- Check activation funnel: Where's the cliff?
Review your sheet's trend (5 min)
- Is MRR growth rate 5%+ week-over-week? ✓ Good
- Is activation stable or improving? ✓ Good
- Is churn flat or declining? ✓ Good
- Any red flags?
One action (5 min)
- If activation is declining, implement one onboarding fix
- If churn spiked, investigate one cohort
- If trial-to-paid is down, test one pricing change

Common Overbuying Mistakes

Mistake 1: Buying too many tools

At $1M ARR, you probably need: GA4, Mixpanel, and Sheets. Everything else is nice-to-have.

Mistake 2: Paying for data science you don't need

Predictive churn models are cool but unnecessary if your churn is obvious from cohort analysis.

Mistake 3: Separate dashboards for every team

Sales team dashboard, product team dashboard, executive dashboard. Creates inconsistency. Keep one source of truth in Sheets.

Mistake 4: Too many custom metrics

Track 6 metrics. Ignore the rest. Simplicity > completeness.

Mistake 5: Waiting for the "perfect" tools before making decisions

Some founders wait for Tableau setup before they even look at data. Wrong. Start with Sheets. Upgrade tools later.

The Budget Breakdown

Tool	Cost	Priority
GA4	$0	Essential
Billing system	$0–$500	Essential
Google Sheets	$0	Essential
Mixpanel or Amplitude	$500–$1,000	Recommended (at $500k+ ARR)
Total	$500–$1,500/month	—

Frequently Asked Questions

Q: Should I use Mixpanel or Amplitude?

A: Mixpanel for feature adoption and retention. Amplitude for cohort analysis. Both have free tier—use both for a month, then pick.

Q: Can I use Google Sheets for everything?

A: Yes, until $500k+ ARR. After that, queries get complex enough that a BI tool helps.

Q: What if we have more than one analyst?

A: Keep Sheets as source of truth. Use Looker (or similar) for self-serve dashboards so everyone can explore.

Q: Should we build a data warehouse?

A: Not until $2M+ ARR. Until then, Sheets + Mixpanel is sufficient.

Q: What's the ROI on analytics tools?

A: Hard to calculate, but rule of thumb: analytics tools should save you $10k/month in bad decisions (fixing churn, optimizing CAC, etc.). Under that ROI, wait.

The Bottom Line

Start with GA4 + Sheets. Add Mixpanel at $500k ARR. Add BI tools at $3M+ ARR.

More tools don't equal better decisions. Simplicity and focus beat complexity every time.

Emily Redmond is a data analyst at Emilytics — AI analytics agent watching your GA4, Search Console, and Bing data around the clock. 8 years experience. Say hi →