Admin Dashboard Rebuilt · Real-Time Data & Analytics

The VoiceCoach AI admin dashboard has been completely rebuilt from the ground up.

What Changed

The previous dashboard used client-side Supabase queries that were blocked by Row-Level Security policies, resulting in missing data. The new version uses server-side API routes with the Supabase service role key for complete data access.

New Features

📊 Real-Time Overview

• Total users, new today, new this week
• Active users (practiced today)
• Paid conversion rate
• Auto-refresh every 30 seconds

💰 Financial Overview

• MRR (Monthly Recurring Revenue)
• Active Pro & Premium subscribers
• LAUNCH50 coupon activations
• Revenue breakdown & P&L

📈 User Attribution

• Paid (Meta Ads) vs Organic breakdown
• Campaign-level attribution
• Daily signup source chart
• UTM parameter tracking

🏁 Conversion Funnel

• Signup → Activated → Hit Limit → Paid
• Cohort retention rates
• Coupon redemption tracking

👥 User Management

• Full user table with sessions, source, plan
• Lead status pipeline (New → Contacted → Demo → Converted)
• Search, filter, and CSV export
• Plan updates and WhatsApp outreach links

🔔 Smart Alerts

• New paid subscriber notifications
• Inactive paid user warnings
• Churn risk identification

All data flows through authenticated API routes · no more client-side RLS issues.