Customer Acquisition Dashboard

Funnel analysis, CAC trends & retention cohort performance
ON TRACK

Acquisition Funnel

Impressions
2,450,000
2.45M
100%
Clicks
1,176,000
1.18M
48%
App Opens
784,000
784K
32%
Registrations
441,000
441K
18%
First Booking
294,000
294K
12%
Repeat Customer
196,000
196K
8%

Customer Acquisition Cost (CAC) by Channel

Channel CAC Efficiency vs Avg
SEO Organic ₹180 -73% ✓
Referral Program ₹250 -65% ✓
Google Ads ₹650 Baseline
Meta Ads ₹780 +20% ↑
Influencer ₹420 -35% ✓

90-Day Retention Rate by Cohort

SEO Organic Cohort
68%
Referral Cohort
72%
Google Ads Cohort
31%
Meta Ads Cohort
28%
Influencer Cohort
52%
2.3x
Referral vs Paid CAC Ratio
Referral customers show 72% retention vs 28% for paid ads

Weekly Cohort Retention Curves

Predicted Lifetime Value (pLTV) Distribution

1,240
920
1,530
1,840
1,430
810
₹0-1K
₹1-2K
₹2-3K
₹3-4K
₹4-5K
₹5K+
Low Value (< ₹2K)
Medium (₹2-4K)
High (> ₹4K)
Segment Count Avg pLTV
Low Value 8,120 ₹1,245
Medium Value 7,800 ₹3,120
High Value 4,080 ₹6,840
Key Insight
Referral-acquired customers have 2.3x higher 90-day repeat rate than paid-acquired customers (72% vs 28%), justifying aggressive referral investment despite slightly higher unit CAC (₹250 vs ₹180 for organic, but far superior LTV). High-value customer segment (pLTV > ₹5K) represents only 24% of cohort but drives 68% of lifetime revenue. Recommend segmented marketing: nurture referral channel for repeat bookings, scale paid channels with focus on brand awareness rather than immediate conversion.