Investor Insights & Metrics

In the fast-paced world of recurring revenue, what you don’t know can hurt you. A business was scaling its subscription-based offering but lacked clear visibility into performance. With fragmented reports and inconsistent definitions of core KPIs like MRR, NRR, and CAC, the leadership team struggled to tell a cohesive story to their board, much less to potential investors.

The Challenge: No Single Source of Truth for Growth and Retention

Despite a healthy stream of recurring income, the business had no unified view of how customer acquisition, retention, and expansion were really performing. Metrics such as Net Revenue Retention (NRR), Customer Acquisition Cost (CAC), and Lifetime Value (LTV) were calculated manually, if at all, and reporting varied between teams. This made it difficult to benchmark performance, spot churn risks early, or demonstrate growth potential in a credible way to investors.

The Solution: A Centralised, Executive-Grade Dashboard for Subscription Analytics

I designed and built an investor-ready dashboard focused on subscription economics, turning scattered data into a unified performance narrative.

Key features of the solution included:

• Cohort-Based Revenue Breakdown: ARR and MRR were segmented by acquisition cohort, product line, and contract type to reveal patterns in growth and churn.

• Retention & Churn Tracking: Clear visualisation of gross and net revenue retention, customer churn rates, and revenue expansion.

• Customer Value Analytics: LTV/CAC ratios, contribution margin calculations, and forecast scenarios for various retention and acquisition strategies.

• Customer Concentration Monitoring: Highlighted reliance on top-tier clients and helped quantify revenue risk exposure.

• Investor-Ready Styling: The dashboard was designed with clean visuals and export-ready formats tailored for board packs and funding discussions.

The Result: Clearer Decisions, Stronger Investor Conversations

The dashboard was adopted into the organisation’s monthly reporting cycle and board packs. It enabled leadership to:

• Monitor retention curves with consistent, trusted metrics

• Compare CAC efficiency across customer segments

• Simulate revenue growth under different retention and acquisition strategies

• Track customer concentration risk with visibility for both leadership and investors

• Tell a stronger, data-backed story to external stakeholders with clarity and confidence

Skills & Tools Applied

• Power BI & Excel (data modelling, interactive dashboards)

• LTV/CAC analytics and contribution margin modelling

• ARR/MRR forecasting logic

• Subscription metrics benchmarking

• Executive communication and investor UX design

Conclusion

This project highlights how turning recurring revenue metrics into a strategic asset isn’t just about dashboards. It’s about empowering smarter, faster, and more confident decisions across the business. When data becomes clear, opportunities become actionable.