50,000 Customers. 8 Data-Driven Insights. One Clearer Path to Growth.

By abhishek.verma75000 · September 8, 2026

The real value comes from understanding who your most valuable customers are, what drives their spending, which channels perform best, where churn risk…

The analysis compared customer segments based on their average profitability and lifetime value (CLV). Two visualizations were generated: a grouped bar chart comparing average profitability and CLV across segments, and a scatter plot showing the relationship between profitability and CLV, sized by customer count per segment. These charts let you visually identify which segments are the most valuable and profitable at a glance.

The highest total spending comes from customers aged 45-54 (about $425.7 million), those in the $50K-75K income bracket (about $426.9 million), and Singapore leads all countries with roughly $156.2 million in total spending.

The analysis explored how email open rate, click-through rate, and conversion rate relate to total customer spending. Two visualizations were generated: a bar chart comparing average total spending across quartiles (Low to High) of each engagement metric, and a scatter plot showing the relationship between conversion rate and total spending, colored by email open rate. These charts let you visually compare how spending trends shift as engagement levels increase.

A table breaking down customers by churn risk category was generated, organizing satisfaction scores, return counts, and complaint counts for comparison across risk groups.

The analysis explored how purchase frequency, order value, and customer tenure differ across loyalty tiers, and generated visualizations showing these relationships. One chart compares average order value and tenure by tier, while another breaks down purchase frequency distribution across tiers, giving a clear visual picture of how customer behavior evolves as they move through loyalty levels.

The Mobile App channel and Premium customer segment together deliver the best return relative to acquisition spend. On average, Mobile App customers generate a CLV/CAC ratio of 568.2 (average lifetime value of $57,975 against just $102 acquisition cost), and Premium segment customers show a nearly identical ratio of 568.7. Combined, Mobile App + Premium customers achieve the highest ratio of all, 580.0, across 3,061 customers — meaning every dollar spent acquiring these customers returns roughly $580 in lifetime value. A heatmap and bar chart were generated showing how CLV/CAC ratios vary across all channel and segment combinations, making it easy to spot the strongest pairings at a glance.

The data was broken down by shopping channel and device combination, showing average total spent, average order value, and average purchases for each pair. The top performer is Marketplace + Mobile, with customers spending an average of $51,301.46 total and $502.99 per order across 102.2 purchases. Close behind are Mobile App + Tablet ($50,847.74), In-Store + Multiple ($50,618.77), Mobile App + Desktop ($50,574.84), and In-Store + Mobile ($50,499.14). A heatmap and bar chart were created to visualize spending across all channel-device combinations and the top 5 performers.

Using the IQR method on return count and complaint count, no customers in the dataset were flagged as outliers. The calculated bounds for return count were -12.5 to 31.5 and for complaint count were -9.0 to 23.0 — since these bounds are quite wide (even allowing negative values, which aren't possible for counts), every customer's values fell within the normal range. As a result, 0% of the 50,000 customers were flagged as outliers, meaning there's no distinct outlier group to compare against the rest. For reference, the overall average satisfaction score across all customers was 3.01 and the average churn risk score was 26.84.

The analysis ranked countries by their profitability-to-acquisition-cost ratio (average customer profitability divided by average acquisition cost) and compared the top 10 and bottom 5 performers. Three charts were generated: one showing the ratio for each of these countries, one comparing their average RFM scores, and one breaking down loyalty tier distribution for these groups. Together, these visuals highlight which countries generate the most profit per dollar spent acquiring customers, and how those top and bottom performers differ in customer engagement (RFM) and loyalty tier makeup.

The correlation heatmap shows that email open rate, click-through rate, conversion rate, and satisfaction score all have essentially no linear relationship with customer lifetime value or with each other. The strongest positive correlation found was between email open rate and click-through rate (r = 0.007), and the strongest negative correlation was between email open rate and customer lifetime value (r = -0.002) — both extremely weak. Conversion rate had the highest (though still negligible) relationship with customer LTV at r = 0.006.