The Challenge:
SaaS businesses live and die by a handful of critical numbers Monthly Recurring Revenue, Annual Recurring Revenue, churn rate, and where new customers are actually coming from. But most SaaS teams are tracking these metrics in isolation, in spreadsheets, or worse, not tracking them at all until something goes wrong. The goal was to build a Tableau dashboard that gave complete, real-time visibility into revenue health, churn risk, and acquisition performance across all four plan types simultaneously.
- MRR Visibility Gap: Monthly Recurring Revenue was fluctuating across Basic, Enterprise, Free, and Pro plans throughout the year with no single view to track the trend, spot the drops, or understand which plan type was driving growth vs. dragging it down.
- Churn Flying Under the Radar: Churn was happening across all plan types but without a ranked, visual breakdown there was no way to see that Basic plan churn at 13.49% was significantly outpacing Pro churn at 8.2% — a gap that represented a massive retention opportunity hiding in plain sight.
- Acquisition Source Blindness: Customers were coming in through Direct, Organic, Paid, and Referral channels but there was no way to see which source was delivering volume, which was delivering quality, and where acquisition investment should actually go.
How We Managed It:
- MRR Trend Over Time: A multi-line time-series chart tracked Monthly Recurring Revenue across all four plan types from February through December, instantly revealing:
- Pro plan MRR spiking as high as $60K early in the year before normalizing — a growth signal that needed to be understood and replicated.
- All plan types converging toward the $20K–$25K range by year end — indicating market stabilization but also flagging potential growth plateau risk.
- Enterprise MRR showing the most consistent floor, making it the most predictable revenue stream in the portfolio.
- Churn Rate by Plan Type A ranked bar chart exposed average churn rates across all four plans with surgical precision. Basic led at 13.49%, followed by Enterprise at 11.11%, Free at 10.32%, and Pro at the healthiest rate of 8.2%. This single view immediately told the retention team exactly where to focus — Basic plan customers were churning at a rate 65% higher than Pro, and nobody had seen that clearly before.
- ARR by Plan Type Annual Recurring Revenue was broken down across all four tiers — Enterprise leading at $4,158,338, Free at $3,755,245, Basic at $3,638,910, and Pro at $3,630,876. The ARR view revealed that Free plan users were generating more annual revenue than Basic paying customers — a counterintuitive insight that completely reframed how the team thought about plan conversion strategy.
- Customer Acquisition Source Performance A count of customers by signup source — Direct, Organic, Paid, and Referral — was visualized side by side. All four channels were performing at near-equal volume around the 100–120 customer mark, indicating a healthy diversified acquisition mix but also highlighting that no single channel had broken out as a dominant growth engine yet.
The Results:
The Tableau Technology & SaaS Dashboard gave the revenue and growth teams a level of plan-level clarity that had never existed before.
- MRR Trend Visibility – Full year MRR tracked across all four plan types, exposing growth peaks, plateaus, and convergence patterns that were previously invisible.
- Churn Gap Exposed – Basic plan churn identified at 13.49% vs Pro at 8.2% — a 65% gap that immediately became the retention team’s number one priority.
- ARR Intelligence – Enterprise confirmed as the top ARR contributor at $4.15M, with Free plan ARR surprisingly outperforming Basic — a conversion strategy insight hiding in the numbers.
- Acquisition Source Clarity – All four signup channels tracked by customer volume, giving the growth team a baseline to optimize against and scale from.
In a Nutshell:
The challenge was a SaaS business with four active plan types, four acquisition channels, and no unified view of what was growing, what was churning, and where revenue was actually coming from. We built a Tableau Technology & SaaS Intelligence Dashboard that connected MRR trends, ARR by plan, churn rates, and acquisition performance into one real-time system. The result was complete revenue clarity with Basic plan churn exposed at 13.49%, Enterprise ARR leading at $4.15M, and the team finally equipped to make retention and growth decisions based on data instead of assumptions.
