📊
Clickstream Intelligence
Customer Behavioral Analytics · Sudip Biswas
● LIVE
70,000 Sessions
Device
Source
Region
Total Revenue
$52.50M
▲ 18.4% vs prev period
Sessions
70,000
▲ 12.1% session volume
Conversion Rate
29.9%
▲ 2.3pp above benchmark
Cart Abandonment
63.1%
▼ Needs attention
Avg CLV
$99.7K
▲ High tier leading
Revenue by Day of Week
Tue & Wed peak. Thu is softest.
Device Revenue Split
Near-equal distribution
Geographic Revenue
Canada leads. India = emerging market.
Traffic Source Revenue
Organic carries 75.4% of total revenue
Session Length → Purchases
Long sessions convert 7× more
CLV Tier Revenue
High CLV = 49.4% of total revenue
Network Type
4G/5G dominate mobile sessions
Browsing
2,941
4.2% of sessions
In Cart
26,532
37.9% of sessions
Checkout
19,584
28.0% of sessions
Converted
20,943
29.9% CVR 🎯
Conversion Funnel
Drop-off analysis across all stages
⚠️
Cart → Checkout Drop: 26.2%Sessions stuck in cart — prime retargeting opportunity worth ~$3.2M
Cart Abandonment by Source
% sessions that abandoned cart per source
Exit Page Distribution
Where users leave the platform
Funnel Stage by Device
Device-wise stage distribution
Checkout Abandonment by Source
27.98% overall checkout abandonment
Funnel Stage Distribution by Customer Type sessions per stage
How each customer segment moves through the purchase funnel
Customer DNA — Segment Comparison normalised 0–1
CVR · CLV · High Intent · Cart Abandon · Coupon Usage across segments
User Segment Revenue
Lifecycle segment performance
🏆 Loyal Member
$13.17M
30% CVR · At-Risk: 275
✨ New Member
$13.24M
30% CVR · At-Risk: 0
🔄 Repeat Guest
$13.13M
30% CVR · At-Risk: 240
👤 New Guest
$12.95M
30% CVR · At-Risk: 0
Engagement Tier Distribution
Sessions by engagement level
Repeat vs New Visitors
~50/50 split by revenue
High Intent Flag
Sessions with purchase intent signals
Multi-Channel Revenue
Multi-channel drives 99.6% of revenue
At-Risk Sessions by Segment
515 flagged — Loyal & Repeat only
Geo Market Deep Dive
Revenue, CVR & purchases per market
| Market | Revenue | CVR | Purchases | Share |
|---|
🚨
Critical: 63.1% Cart Abandonment = $33.1M Left on TableRecovery of just 10% would add $3.3M in revenue. Immediate retargeting workflow recommended.
⚡
515 At-Risk Users IdentifiedLoyal Members & Repeat Guests at churn risk — avg CLV $98K each = $50.4M exposure
🛒
Revenue Recovery
Cart Abandonment: 63.1% — $33M Opportunity
44,123 sessions abandoned carts. Paid & Direct show the highest rates (63.5% & 63.4%). A triggered email + exit-intent popup sequence on cart-stage sessions can recover $3.3M–$5.5M with 5–10% recovery rate.
⚠️
Retention Risk
515 High-Value Users Showing Churn Signals
At-risk flag triggered for 275 Loyal Members and 240 Repeat Guests. Combined avg CLV ~$98K per user = $50.5M lifetime value at risk. Declining engagement patterns detected.
⏱️
Engagement Optimization
Long Sessions Generate 7.1× More Purchases Than Short Sessions
Long sessions: 13,252 purchases vs Short: 1,849. Better recommendations, guided navigation, and interactive content extend session depth and directly amplify revenue.
📅
Timing Strategy
Tuesday & Wednesday Are Peak Revenue Days (+8.6% over Monday)
Tue ($7.90M) and Wed ($7.80M) outperform Thu ($7.28M, weakest). Schedule paid campaigns, flash sales, and email blasts on Tue–Wed mornings to maximize peak intent windows.
💳
CLV Monetization
High CLV Tier Drives 49.4% Revenue — Avg Lifetime Value $149K
High CLV users generate $25.95M. A targeted VIP programme, early access offers, and premium support for this segment would increase share of wallet and reduce churn.
🌍
Geographic Expansion
Canada Leads Revenue; India Shows Emerging Market Opportunity
Canada: $10.74M, CVR 31%. India: $10.2M, CVR 29%. Localized pricing, vernacular content & India-specific payments (UPI, EMI) could unlock +$300K–$500K incremental revenue.
📣
Channel Mix
Organic Carries 75.4% of Revenue — Paid is Under-Scaled
Paid has same CVR as Organic (30%) — the channel works. Increasing paid spend on high-intent audiences could yield 20–30% revenue lift from that channel alone.
🧑🤝🧑 Customer Type Intelligence
🪟
Window Shoppers
2,941 Window Shoppers (4.2%) — Browsing With Intent, Never Reaching Cart
These 2,941 sessions only browsed and left — evenly spread across all 4 segments and all devices. Morning hours are peak window-shopping (765 sessions, 26%). Direct and Referral traffic bring the most browsers. Their avg session value of $2,501 shows intent exists — they just need a trigger. A well-timed "Save for Later" nudge or first-purchase discount can convert even 5% = +$368K revenue.
🏆
Loyal Members
Loyal Members: Highest CLV ($100K), 100% Repeat — But 275 Are Churning
Loyal Members are 100% returning users with the highest avg CLV ($100,271). They use coupons 49.5% of the time and generate 29.2% high-intent sessions. However, 275 show active churn signals — losing even 10% of these means $27.6M in lifetime value gone. A VIP tier with early access + surprise rewards deepens loyalty and halts churn before it accelerates.
✨
New Members
New Members Are Your Best Converters — 30.2% CVR & Lowest Cart Abandonment (62.7%)
New Members outperform every segment: 30.2% CVR, lowest cart abandonment (62.7%), and highest revenue ($13.24M). Zero at-risk flags — they're engaged and buying. This is the golden window: an optimised 30-day onboarding flow with personalised product recommendations can lock in lifetime loyalty before habits form elsewhere.
👤
New Guests
17,518 New Guests — 29.5% High Intent, Zero Churn Risk, One Step from Membership
New Guests (first-time, unregistered) contribute $12.95M with 29.8% CVR and 5,167 high-intent sessions. Zero at-risk. Converting just 15% to members adds ~2,600 new members, each worth $99K CLV = $257M in incremental lifetime value pipeline. A post-purchase membership prompt with a small incentive is the highest-ROI move available.
🔄
Repeat Guests
Repeat Guests Return But Won't Commit — Highest Coupon Dependency (50.1%), 240 at Risk
Repeat Guests return consistently (100% repeat visitors) but resist membership. Their coupon usage is the highest at 50.1% — signalling price sensitivity as the primary barrier to conversion. 240 are flagged at-risk. A "Member Exclusives" campaign showing accumulated savings vs. coupon-hunting can convert this segment and reduce discount dependency platform-wide.
🛒 Cart Recovery Segment Details
- Paid Traffic: 63.5% abandonment — highest priority
- Direct Traffic: 63.4% abandonment — strong recall audience
- 26,532 sessions stuck in Cart stage (avg value $2,496)
- 19,584 sessions abandoned at Checkout (27.98%)
- Estimated recovery at 10%: ~$3.3M via push/email
- Peak abandonment: Night (12AM–6AM) and Evening sessions