1. 📊 Dashboard Structure / Table Layout (Notion Table Format) Month MRR Active Users Paid Users Free-to-Paid % Feature Usage % Churn Rate CAC Support Tickets Jan $2,300 7,800 230 2.9% 62% 7.1% $28 96 Feb $2,950 8,400 300 3.5% 70% 5.8% $26 77 Mar $3,750 9,100 385 4.2% 75% 4.4% $30 58 --- 2. 📘 Definitions of Key Metrics MRR (Monthly Recurring Revenue): Monthly income from subscriptions. Active Users: Total users who opened or used the product in the last 30 days. Paid Users: Total number of Pro users. Free-to-Paid %: % of free users converting to paid each month. Feature Usage Rate: % of users engaging with the core paid feature set. Churn Rate: % of paid users who cancel. CAC (Customer Acquisition Cost): Average cost of converting a new user to paid. Support Tickets: Number of help requests received in the month. --- 3. 📐 Formulas Free-to-Paid % = (Paid Users This Month ÷ Active Users This Month) × 100 Feature Usage % = (Users Who Used Core Features ÷ Active Users) × 100 Churn Rate = (Users Canceled ÷ Paid Users at Start of Month) × 100 CAC = Total Marketing Spend ÷ New Paid Users MRR = Paid Users × Average Monthly Plan Cost (e.g., $10) --- 4. 📌 Example Data (Feb): Paid Users: 300 × $10 = MRR: $2,950 Free-to-Paid: (300 ÷ 8,400) × 100 = 3.5% Feature Usage: (5,880 ÷ 8,400) × 100 = 70% Churn: (18 ÷ 310) × 100 = 5.8% CAC: $7,800 spend ÷ 300 new paid users = $26 Support Tickets: 77 (use to monitor user pain points) --- 5. 🎨 Visualization / Color-Coded Suggestions (for Notion) Metric Color Indicator Rules MRR Green ↑ MoM; Red ↓ MoM Free-to-Paid % Green if >3%, Yellow 2–3%, Red <2% Feature Usage Green >70%, Yellow 50–70%, Red <50% Churn Rate Red >6%, Yellow 4–6%, Green <4% Support Tickets Highlight high ticket volume or trends 📊 Widgets to Include in Notion: Progress bars for conversion rate and feature usage Trend lines for MRR & churn Monthly summary board with emojis for “🔥 growing” or “⚠️ alert” --- 6. 🧠 Summary Insights for Founders/Investors (March) MRR up 27% thanks to a viral video and better upgrade funnel. Free-to-paid conversion increased to 4.2%, highest yet — onboarding tweaks worked. Churn dropped to 4.4%, a good sign of stronger retention. Feature usage at 75% shows users are actively engaging with AI video tools. Support tickets down — onboarding + UI improvements reduced user friction. --- 🔑 Bonus Tip > You can embed free tools like DataBox, Tability, or Chartbrew into Notion for automatic updates from your Airtable/Google Sheet. Use a Kanban board in Notion to track churn reasons and tag high-priority issues. ---