Executive Summary
๐ŸŸข 15 / 25 metrics healthy โš ๏ธ 6 need attention Simulated ยท April 2026
โญ North Star Metric
Monthly Recurring Revenue
$2,250
โ†‘ 40% MoM ยท Day 90 target
Communities
25
โ†‘ 67% MoM
Trial โ†’ Paid
22%
โ†‘ from 18%
Churn
3.2%
โ†“ from 4.1%
ARR Run Rate
$27K
โ†‘ tracking
Revenue Metrics
MRR
$2,250
โ†‘ 40.6% MoM
Day 90 target: $2,250 โœ“ On Track
ARR Run Rate
$27,000
โ†‘ 40.6% MoM
18-mo target: $54K On track
New MRR This Month
$630
โ†‘ 7 new communities
Need $667/mo to hit 6-mo target Close
Churned MRR
$81
โ†“ 1 community lost
Target: <$45/mo Watch
Growth Metrics
Paying Communities
25
โ†‘ 7 this month
Day 90 goal25 / 25 โœ“
Goal met
Trial-to-Paid Rate
22%
โ†‘ from 18% last month
Target: 25%22 / 25%
Healthy
Monthly Churn Rate
3.2%
โ†“ Improving from 4.1%
Target: <5%3.2% โ€” ok
Alert if >5% Below threshold
Net Revenue Retention
106%
โ†‘ Expansion > churn
Target: >100%106% โœ“
Premium Support upsell driving expansion Excellent
Milestone Progress โ€” Day 90 Targets
Quarterly OKRs
25 paying communities25 / 25 โœ“
$2,250 MRR$2,250 / $2,250 โœ“
CAC < $100$88 โœ“
Trial โ†’ Paid โ‰ฅ 20%22% โœ“
1 PM firm conversationIn progress
18-Month Trajectory
MonthCommunitiesMRRStatus
Month 13$270โœ“ Done
Month 325$2,250โœ“ Done
Month 670$6,300In progress
Month 12200$18,000Target
Month 18500$45,000+Target
Acquisition Funnel
Monthly Acquisition Funnel โ€” April 2026
Website visitors
2,500 visitors
2,500
โ€”
Pricing page view
1,200
1,200
48%
Trial checkout start
350
350
29%
Trial completed ($49)
320
320
91%
Bylaws uploaded
275
275
86%
Paid subscription
70
70
25%
โš ๏ธ Biggest drop: Checkout start โ†’ Trial completed (91% ok) ยท Watch: Trial โ†’ Bylaws uploaded โ†’ focus for onboarding tour
Acquisition Metrics by Channel
ChannelTrials This MonthConversionsConv. RateSpendCACStatus
Reddit (organic)12325%$0$0Best
Facebook groups (organic)8225%$0$0Excellent
Facebook Ads (paid)311032%$720$72Healthy
Google Search (paid)18528%$450$90Watch
LinkedIn (outreach)4125%$0$0Pipeline
Direct / referral6233%$0$0Growing
TOTAL792329%$1,170$51On target
Blended CAC Trend
CAC โ€” Month 1
$125
Above target at launch
Target: <$100 Was watch
CAC โ€” Month 2
$105
โ†“ Improving
Near target Watch
CAC โ€” Month 3 (now)
$88
โ†“ Below $100 target
Target: <$100 โœ“ Healthy
Payback Period
5.5 mo
โ†“ Improving from 7.5
Target: <8 months Excellent
Retention Overview
Monthly Churn Rate
3.2%
โ†“ from 4.1% last month
Alert if >5% Below threshold
Net Revenue Retention
106%
โ†‘ Expansion beats churn
Target: >100% Excellent
Bylaws Upload Rate
84%
โ†’ Stable (target 85%)
Alert if <70% Watch
Premium Support Attach
18%
โ†‘ from 12% last month
Target: 20% Near target
Cohort Retention Analysis
Trial-to-Paid Cohort Retention (% of trials still active)
Each row = communities who started their trial in that month. Columns = months after trial start.
CohortMonth 0 (Trial)Month 3 (Conv.)Month 6Month 9Month 12
January (n=8)100%25%21%18%โ€”
February (n=12)100%22%19%โ€”โ€”
March (n=20)100%24%โ€”โ€”โ€”
April (n=27)100%pendingโ€”โ€”โ€”
๐Ÿ“Š Key insight: Communities that upload bylaws within 48hr of signing up convert at 28% vs 12% for those who don't. This is the #1 activation lever โ€” track and trigger email if bylaws not uploaded in 24hr.
Product Usage Health
Usage SignalThis MonthLast MonthTargetStatus
Communities with bylaws uploaded21 / 25 (84%)82%โ‰ฅ85%Watch
Avg resident questions/community/mo4738>20Healthy
Auto-resolution rate (no human needed)81%79%โ‰ฅ80%On target
Guard portal entries logged/mo342 total201>10/communityGrowing
Review queue reviewed within 24hr73%68%โ‰ฅ70%Healthy
Communities active 2+ days/week19 / 25 (76%)14 / 18โ‰ฅ80%Watch
Unit Economics Dashboard
Customer LTV
$185
Sub $9 ร— 18mo + $49 trial
With Premium upsell: ~$211 Growing
Blended CAC
$88
โ†“ Improving monthly
Target: <$100 โœ“ Healthy
LTV:CAC Ratio
2.1x
โ†‘ from 1.6x at launch
Target: >2.0x โœ“ Healthy
Payback Period
5.5 mo
โ†“ from 7.5 at launch
Target: <8 months Excellent
Revenue Breakdown by Stream
Revenue StreamCommunitiesUnit PriceMonthly Revenue% of MRRTrend
Base Subscription25$9/mo$22510%โ†‘ Growing
Trial Revenue (amortized)79 trials$49/3mo$1,28757%โ†‘ Growing
Premium Support ($5/mo)4 communities$5/mo$201%โ†‘ New
Consultation (ad hoc)โ€”$100/hr$71832%โ†’ Stable
TOTAL MRRโ€”โ€”$2,250100%โ€”
Gross Margin Analysis
Cost Structure
CostMonthlyPer Community
AI API costs (Anthropic/OpenAI)~$45$1.80
Supabase (DB + Auth + Storage)$25$1.00
Vercel hosting$20$0.80
Sentry + PostHog (monitoring)$30$1.20
Stripe fees (~2.9% + $0.30)~$65$2.60
Total COGS~$185~$7.40
Margin Summary
MRR$2,250
COGS (infra + fees)โˆ’$185
GTM spendโˆ’$1,170
Gross Profit$895
Gross margin: 40% โ€” improving as COGS/community decreases at scale
At 500 communities, COGS/community drops to ~$4.50 โ€” gross margin expands to 50%+
AI Quality Metrics
Auto-Resolution Rate
81%
โ†‘ from 79% last mo
Target: โ‰ฅ80% โœ“ On target
AI Response Time (p95)
4.1s
โ†“ from 5.2s last mo
Target: <5s โœ“ Healthy
Flagged for Review Rate
8.3%
โ†’ Stable
Alert if >15% Healthy
DL Scan Success Rate
87%
โ†‘ from 83% (mobile)
Target: โ‰ฅ85% mobile โœ“ Healthy
Technical Health
MetricCurrentTargetAlert LevelStatus
Uptime (30-day)99.8%โ‰ฅ99.5%<98%Excellent
Edge function error rate0.3%<1%>3%Healthy
Stripe webhook success rate99.7%โ‰ฅ99.5%<98%Excellent
Page FCP (first contentful paint)1.8s<2.5s>4sFast
OCR completion rate (scanned PDFs)93%โ‰ฅ90%<80%Healthy
Support response time2.1hrs avg<4hrs>12hrsFast
P0 errors (crashes, blank screens)0 this month0Any P0โœ“ Clean
Portal Usage Breakdown
Admin Portal
25 active
100% of paying communities
Avg session: 8 min/week Engaged
Guard Portal
14 active
56% of communities (gated only)
Target: all gated communities Expected
Resident Chat
1,175 queries
โ†‘ 47/community avg/mo
Target: >20/community Active
Interactive calculators for every key HOAHelper metric. Edit the inputs to see live results.
Core SaaS Formulas
Monthly Recurring Revenue (MRR)
MRR = (communities ร— $9) + (premium_subs ร— $5)
Communities
Premium subs
MRR = $245ARR = $2,940
Customer Acquisition Cost (CAC)
CAC = total_spend รท new_customers
Monthly spend ($)
New customers
CAC = $50.87Target: <$100
Customer Lifetime Value (LTV)
LTV = (ARPU ร— margin%) รท monthly_churn
ARPU ($/mo)
Margin %
Churn % (mo)
LTV = $230.63+ $49 trial revenue
LTV:CAC Ratio & Payback Period
LTV:CAC = LTV รท CAC
Payback = CAC รท (ARPU ร— margin%)
LTV ($)
CAC ($)
LTV:CAC = 2.6xPayback = 11.9 mo
MRR Growth Rate
Growth% = ((current_MRR - prev_MRR) รท prev_MRR) ร— 100
Current MRR ($)
Previous MRR ($)
Growth = 40.6% MoMTarget: >20% MoM
Net Revenue Retention (NRR)
NRR = (start_MRR + expansion - churn - contraction) รท start_MRR ร— 100
Start MRR ($)
Expansion ($)
Churned ($)
NRR = 96.2%Target: >100%
Traffic light thresholds for every key metric. Green = healthy, yellow = watch, red = immediate action required.
๐ŸŸข Green โ€” All Good
Paying Communities
Current: 25
Green: โ‰ฅ monthly target ยท Yellow: 80โ€“99% of target ยท Red: <80% of target
Blended CAC
Current: $88
Green: <$100 ยท Yellow: $100โ€“$150 ยท Red: >$150 for 2 consecutive weeks
Monthly Churn Rate
Current: 3.2%
Green: <5% ยท Yellow: 5โ€“8% ยท Red: >8% โ€” investigate immediately
AI Response Time
Current: 4.1s p95
Green: <5s ยท Yellow: 5โ€“8s ยท Red: >8s โ€” check AI provider status
Stripe Webhook Success
Current: 99.7%
Green: โ‰ฅ99.5% ยท Yellow: 98โ€“99.5% ยท Red: <98% โ€” check Stripe dashboard now
Edge Function Error Rate
Current: 0.3%
Green: <1% ยท Yellow: 1โ€“3% ยท Red: >3% โ€” check Sentry, escalate immediately
โš ๏ธ Yellow โ€” Watch These
Bylaws Upload Rate
Current: 84% (target 85%)
Green: โ‰ฅ85% ยท Yellow: 70โ€“84% ยท Red: <70% โ€” trigger concierge onboarding campaign
Communities Active 2+ Days/Wk
Current: 76% (target 80%)
Green: โ‰ฅ80% ยท Yellow: 60โ€“79% ยท Red: <60% โ€” churn risk signal
Facebook Ad CTR
Current: 1.3% (target 1.5%)
Green: >1.5% ยท Yellow: 0.5โ€“1.5% ยท Red: <0.5% at 500 impressions โ€” pause creative
Google Search CPC
Current: $9.20 (target <$8)
Green: <$8 ยท Yellow: $8โ€“$15 ยท Red: >$15 โ€” switch to manual bidding, tighten keywords
Trial โ†’ Paid Conversion
Current: 22% (target 25%)
Green: โ‰ฅ25% ยท Yellow: 10โ€“24% ยท Red: <10% โ€” activation funnel broken, call non-converters
DL Scan Success Rate
Current: 87% (target โ‰ฅ85%)
Green: โ‰ฅ85% ยท Yellow: 70โ€“84% ยท Red: <70% โ€” UX issue in guard portal, check camera permissions
๐Ÿ”ด Red Alert Protocols
TriggerThresholdResponse RequiredTime to Act
Monthly churn rate>8%Call every community that churned within 24hr. Identify root cause. Founder-level priority.Same day
Trial-to-paid conversion<10%Halt paid acquisition spend. Fix activation funnel before spending another dollar on ads.48 hours
Blended CAC>$150 for 2 weeksPause all paid campaigns. Shift to organic channels only. A/B test new creative before relaunching.48 hours
Stripe webhook success<98%Check Stripe dashboard immediately. Manually reconcile any failed payments. Email affected customers.1 hour
Edge function error rate>3%Check Sentry for error type. If AI provider outage: switch AI_PROVIDER env var. Notify customers if downtime >30 min.30 minutes
P0 error (crash / blank screen)Any occurrenceAll-hands fix. Rollback deploy if needed. Post status update to hoahelper.app/status within 15 minutes.15 minutes
Structured review rhythm. Each cadence has a specific purpose, specific metrics, and a specific output decision.
Daily
5 min
Morning Pulse Check โ€” "Is anything on fire?"
Stripe: new payments? Sentry: any P0 errors? Support inbox: urgent? PostHog: yesterday's signups Reddit: any mentions?
Output: Nothing (unless red alert) ยท Tool: Stripe dashboard + Sentry + email
Weekly
45 min
Monday Weekly Review โ€” "What changed and what should we do about it?"
MRR vs. last week New trials started Trial โ†’ paid conversions Churn events (if any) Ad CTR + CAC estimate Bylaws upload rate AI error rate Support tickets
Output: 1 decision (pause ad, fix drop-off, send email, etc.) ยท Tool: This dashboard + PostHog funnel
Monthly
2 hours
Monthly Deep-Dive โ€” "Are we winning, and where should we focus next month?"
Full MRR reconcile CAC by channel LTV:CAC trend Cohort retention analysis Funnel conversion by stage NPS or CSAT data Content performance Ad creative A/B results PM outreach pipeline
Output: 1-page written recap with 3 decisions for next month ยท Tool: Full dashboard + Stripe export + PostHog
Quarterly
Full day
Quarterly Strategy Review โ€” "Is the plan still right or do we need to change direction?"
Actual vs. plan for the quarter CAC payback period trend Churn root cause analysis Customer interview synthesis Competitive landscape update v1.2 feature prioritization Channel ROI comparison PM partnership pipeline status 18-month trajectory update
Output: Updated roadmap for next quarter ยท Major pivot decision if metrics warrant it ยท Board/investor update if applicable
Leading vs. Lagging Indicator Map
Leading Indicatorโ†’ PredictsLagging OutcomeLag Time
Bylaws uploaded within 48hr of signupโ†’Trial-to-paid conversion rate90 days
Resident questions asked (monthly)โ†’Renewal rate at trial end60โ€“90 days
Facebook ad CTRโ†’CAC this month14โ€“30 days
Health check call completedโ†’Churn rate next month30โ€“60 days
LinkedIn PM conversations startedโ†’B2B deals closed60โ€“120 days
Guard portal entries loggedโ†’Guard portal retention (product stickiness)30โ€“60 days
New MRR this monthโ†’ARR 12 months from now12 months