CommerceLens
Business

Customer Value Analysis

A dashboard view of revenue, order value, return rate, profit margin, and repeat purchase behavior across the whole dataset and across each major breakdown dimension.

Executive Summary

Revenue
₹7,74,09,571
Orders
16,522
Average Order Value
₹4,685
Median Order Value
₹1,350
Return Rate
11.7%
Avg. Profit Margin
18.5%
Repeat Purchase Rate
85.4%
Conversion Rate
27.5%

Breakdown by Dimension

Choose a grouping dimension to compare value metrics across its categories.

Revenue by Customer Segment
Total revenue contributed by each group
AOV by Customer Segment
Average order value per group
Return Rate by Customer Segment
Share of orders returned per group
Full comparison table — Customer Segment
All value metrics for every group, sorted by revenue
Customer SegmentSessionsUnique CustomersOrdersRevenueAOVMedian Order ValueReturn RateAvg. MarginRepeat RateConversion Rate
Regular25,3616,9337,641₹3,61,45,015₹4,730₹1,37211.9%18.4%100.0%30.1%
Occasional26,96610,2597,116₹3,35,18,987₹4,710₹1,34111.3%18.5%100.0%26.4%
New6,6232,9701,356₹61,32,542₹4,523₹1,24512.2%18.5%0.0%20.5%
Loyal1,050122409₹16,13,027₹3,944₹1,39513.7%18%100.0%39.0%

Distributions, Not Just Averages

AOV is a single number per segment, but it can hide very different underlying spreads. The box plot below shows the full order-value distribution (quartiles, whiskers, and outliers) for each behavioral segment.

Order value distribution by behavioral segment
Quartiles, whiskers, and outliers per segment — not just the mean
₹0₹34,969₹69,938₹1,04,907₹1,39,876₹1,74,844LoyalNewOccasionalRegular

Two segments can share a similar AOV while one has a tight, predictable spread of order values and the other has a wide spread with high-value outliers pulling the mean up. Relying on AOV alone would treat these as identical when the underlying purchasing behavior — and the risk/opportunity profile — is materially different.