Interactive SaaS Performance Metrics Dashboard with Dynamic FiltersInteractive SaaS Performance Metrics Dashboard with Dynamic Filters
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Project Overview
Designed and developed an end-to-end, interactive SaaS Performance Metrics Dashboard to track €17.73M in annual revenue, subscriber retention, acquisition channels, and team performance across 12 months. Built on a robust backend data architecture powered by 23 interconnected Pivot Tables, enabling seamless dynamic filtering via Monthly and Account Manager slicers.
Key Business Metrics & Insights Tracked:
Revenue & Subscription Health: Monitored €17.73M Total Revenue (Peak: €1.71M/month, Avg: €1.48M/month) alongside 617 Active Subscribers (77% retention) vs. 23% Churn rate (183 subscribers) and 2,569 Active Products.
Customer Acquisition Channels: Analyzed ROI across 5 core channels—identifying Paid Social (€4.89M) and Organic Search (€4.15M) as top revenue drivers, followed by Affiliate (€3.22M), Website (€2.94M), and Email Campaigns (€2.51M).
Team & Account Manager Performance: Evaluated individual contributions, highlighting top-performing Account Manager (Sarah – €4.98M) and Top 5 Customer Success Representatives (CSR Leader: Adam – €1.66M).
Operational Efficiency & SLA: Tracked monthly Average Ticket Resolution Time (03:45 min avg, ranging from 03:30 to 04:03) to ensure high customer satisfaction and lower churn.
Product, Contract & Regional Breakdown: Visualized multi-dimensional trends across Subscription Plans (BE, CNI, FC, GK), Contract Types, Regional distribution (Radar Chart), and 5 Marketing Campaigns.
Technical Highlights:
Engineered a complex backend using 23 Pivot Tables and advanced formulas for automated calculations.
Designed a modern Dark Mode UI/UX with custom radial bar charts, line/area trends, radar charts, and dynamic KPI cards for executive-level storytelling.
Integrated interactive Monthly and Account Manager Slicers for instant drill-down analysis.
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started