Interactive Dataset Filters
Personal Analytical Perspective & Goals
I explored this Kaggle dataset of 50,000 e-commerce customers to understand how platform engagement touchpoints (logins, session length, email opens, mobile app usage) correlate with customer purchasing volume and retention status. Rather than jumping to predictive modeling, I wanted to rigorously examine the evidence: What distinguishes active customers from churned ones? Where does friction occur? And what patterns challenge common assumptions about customer tenure and monetary value?
Total Customers Analyzed
50,000
100% Audited50,000 records across 25 features
Overall Churn Rate
28.9%
Target Variable14,450 churned customers
Active Customer Base
35,550
Retained71.10% retained customers
Average Lifetime Value
$1,440.63
LTVCumulative revenue per customer
Average Order Value
$123.12
AOVMean spending per completed transaction
Mean Membership Tenure
2.98 Yrs
TenureCustomer platform age (0–10 years)
Dataset Schema & Data Quality Audit
Verification of missing values, anomalies, and column definitions
Missing Value Summary
Social Media Score: 6,000 (12.0%)
Credit Balance: 5,500 (11.0%)
Mobile App Usage: 5,000 (10.0%)
Returns Rate: 4,491 (9.0%)
Wishlist Items: 4,000 (8.0%)
Session Duration: 3,399 (6.8%)
Inspected Data Anomalies & Outliers
- • Age Outliers: 20 records with Age > 100 (max 200 yrs). Filtered in age analyses.
- • Cart Abandonment > 100%: 30 records up to 143.7%. Treated as extreme friction artifacts.
- • AOV Upper Tail: Max AOV reaches $9,666.38 (vs median $108.94).
- • Duplicates: 0 duplicate rows detected.
| Field Name | Type | Meaning | Missing | Analytical Purpose |
|---|---|---|---|---|
| Age | float | Customer age in years | 2,495 | Demographic profiling, generational cohorts |
| Gender | string | Customer self-reported gender | 0 | Gender representation and churn comparison |
| Country | string | Country of residence | 0 | Geographic analysis and market regional performance |
| City | string | City of residence | 0 | Urban customer concentration |
| Membership_Years | float | Duration as registered member in years | 0 | Tenure analysis vs churn risk |
| Login_Frequency | float | Monthly platform login frequency | 0 | Core engagement metric |
| Session_Duration_Avg | float | Average session length in minutes | 3,399 | Platform engagement depth |
| Pages_Per_Session | float | Average pages viewed per session | 3,000 | Browsing activity intensity |
| Cart_Abandonment_Rate | float | Percentage of shopping carts abandoned without checkout | 0 | Checkout friction signal |
| Wishlist_Items | float | Number of items saved to wishlist | 4,000 | Product interest and purchase intent |
Showing top 10 fields of 25 available columns in dataset