E-commerce Customer Dataset

Comprehensive customer behavior dataset with 40 unique features including purchase history, browsing patterns, customer lifetime value, loyalty tiers, payment methods, social engagement, and customer segmentation labels for advanced marketing analytics

Intermediate 40 Features Enhanced Dataset Ready for ML

Dataset Overview

This dataset contains customer purchase history, browsing behavior, product preferences, and customer segmentation labels. Perfect for customer segmentation, recommendation systems, and marketing analytics.

100
Customers
40
Features
3
Segments
6
Categories

Key Features

Purchase History

Complete purchase records including frequency, order values, and total purchases

Browsing Patterns

Detailed browsing behavior data including time spent and device preferences

Product Preferences

Customer preferences for different product categories and device types

Customer Segments

Pre-labeled customer segments (High Value, Medium Value, Low Value)

Ready for Clustering

Optimized for clustering models and machine learning algorithms

Marketing Analytics

Perfect for customer lifetime value, churn prediction, and targeting

Enhanced Unique Features

Customer Lifetime Value

Calculated CLV for each customer based on purchase history

Payment Methods

6 different payment method preferences (Credit, Debit, PayPal, etc.)

Loyalty Tiers

5-tier loyalty program (Bronze, Silver, Gold, Platinum, Diamond)

Email Marketing

Email open rates, click-through rates, and newsletter subscription status

Social Media

Social media engagement scores and social shares count

Customer Satisfaction

Customer satisfaction scores and average review ratings

Geographic Data

5 geographic regions (North, South, East, West, Central)

Mobile App Usage

Mobile app user identification and app engagement metrics

Cart Behavior

Cart abandonment rates and shopping behavior patterns

Discount Usage

Discount usage percentage and coupon redemption counts

Referral Sources

7 different referral sources (Google, Social Media, Email, etc.)

Wishlist Items

Wishlist item counts for each customer

Shopping Hours

Preferred shopping hours and session duration data

Shipping Preferences

Preferred shipping methods (Standard, Express, Overnight, Same Day)

Return Rates

Product return rates and customer support interactions

Cross-Category

Cross-category purchase counts and repeat purchase rates

Reviews & Support

Product review counts and customer support interaction history

Customer Tenure

Customer since (months) and customer retention metrics

Session Analytics

Average session duration and pages per session metrics

Technologies Used

CSV SQL Pandas NumPy Matplotlib Scikit-learn

Dataset Preview

Customer ID Age Gender Annual Income Spending Score Purchase Freq Avg Order Value Category Device Segment

Analysis Scripts

analyze_customers.py

Comprehensive data analysis including exploratory data analysis, customer segmentation, purchasing behavior, and product preferences.

python analyze_customers.py
customer_segmentation.py

Advanced customer segmentation using K-Means, DBSCAN, and Hierarchical Clustering algorithms.

python customer_segmentation.py
queries.sql

25+ SQL queries for data analysis including segmentation, gender analysis, product preferences, device analysis, and advanced analytics.