Customer Segmentation Analysis
Premium Customers
(Spent more than $2000)
| ID | Customer Name | City | Total Spent | Orders |
| 16 | Luxury Living | Beverly Hills | 11400.00 | 10 |
| 23 | Elite Furnishings | Miami | 9000.00 | 10 |
| 11 | American Euro Lifestyles | Prospect Park | 7525.00 | 8 |
| 3 | Home Furnishings | Albany | 4950.00 | 6 |
| 20 | Classic Designs | Boston | 4350.00 | 2 |
| 7 | Period Furniture | Seattle | 4075.00 | 3 |
| 21 | Urban Furniture | Chicago | 3700.00 | 5 |
| 1 | Contemporary Casuals | Gainesville | 3400.00 | 5 |
| 15 | Mountain Scenes | Ogden | 2675.00 | 5 |
Frequent Customers
(More than 3 orders)
| ID | Customer Name | City | Orders | Total Spent |
| 16 | Luxury Living | Beverly Hills | 10 | 11400.00 |
| 23 | Elite Furnishings | Miami | 10 | 9000.00 |
| 11 | American Euro Lifestyles | Prospect Park | 8 | 7525.00 |
| 3 | Home Furnishings | Albany | 6 | 4950.00 |
| 1 | Contemporary Casuals | Gainesville | 5 | 3400.00 |
| 2 | Value Furniture | Plano | 5 | 1825.00 |
| 18 | Eco Home | Portland | 5 | 1525.00 |
| 21 | Urban Furniture | Chicago | 5 | 3700.00 |
| 15 | Mountain Scenes | Ogden | 5 | 2675.00 |
Bulk Buyers
(Average quantity more than 3)
| ID | Customer Name | City | Avg Quantity | Total Items |
| 20 | Classic Designs | Boston | 7.00 | 14 |
| 7 | Period Furniture | Seattle | 4.00 | 12 |
Occasional Customers
(1 or fewer orders)
| ID | Customer Name | City | Orders | Total Spent |
| 4 | Eastern Furniture | Carteret | 1 | 175.00 |
| 8 | Calfornia Classics | Santa Clara | 1 | 400.00 |
| 9 | M and H Casual Furniture | Clearwater | 1 | 175.00 |
| 17 | Budget Furniture | Detroit | 1 | 175.00 |
| 22 | Cozy Homes | Denver | 1 | 400.00 |
| 1934 | Takreem Atif | Islamabad | 0 | 0.00 |
| 10 | Seminole Interiors | Seminole | 0 | 0.00 |
| 12 | Battle Creek Furniture | Battle Creek | 0 | 0.00 |
Low Value Customers
(Spent less than $500)
| ID | Customer Name | City | Total Spent | Orders |
| 10 | Seminole Interiors | Seminole | 0.00 | 0 |
| 12 | Battle Creek Furniture | Battle Creek | 0.00 | 0 |
| 1934 | Takreem Atif | Islamabad | 0.00 | 0 |
| 9 | M and H Casual Furniture | Clearwater | 175.00 | 1 |
| 4 | Eastern Furniture | Carteret | 175.00 | 1 |
| 17 | Budget Furniture | Detroit | 175.00 | 1 |
| 22 | Cozy Homes | Denver | 400.00 | 1 |
| 8 | Calfornia Classics | Santa Clara | 400.00 | 1 |
Inactive Customers
(No orders in last 6 months)
| ID | Customer Name | City | Last Order |
| 1 | Contemporary Casuals | Gainesville | 12 May 2025 |
| 2 | Value Furniture | Plano | 28 May 2025 |
| 3 | Home Furnishings | Albany | 25 May 2025 |
| 4 | Eastern Furniture | Carteret | 01 Mar 2025 |
| 5 | Impressions | Sacramento | 20 May 2025 |
| 6 | Furniture Gallery | Boulder | 20 Sep 2024 |
| 7 | Period Furniture | Seattle | 01 May 2025 |
| 8 | Calfornia Classics | Santa Clara | 10 Apr 2025 |
| 9 | M and H Casual Furniture | Clearwater | 05 May 2025 |
| 10 | Seminole Interiors | Seminole | Never Ordered |
| 11 | American Euro Lifestyles | Prospect Park | 15 Apr 2025 |
| 12 | Battle Creek Furniture | Battle Creek | Never Ordered |
| 13 | Heritage Furnishings | Carlisle | 14 May 2025 |
| 14 | Kaneohe Homes | Kaneohe | 10 May 2025 |
| 15 | Mountain Scenes | Ogden | 10 May 2025 |
| 16 | Luxury Living | Beverly Hills | 25 May 2025 |
| 17 | Budget Furniture | Detroit | 15 Mar 2025 |
| 18 | Eco Home | Portland | 05 May 2025 |
| 19 | Modern Interiors | Austin | 20 Apr 2025 |
| 20 | Classic Designs | Boston | 30 Apr 2025 |
| 21 | Urban Furniture | Chicago | 12 May 2025 |
| 22 | Cozy Homes | Denver | 18 Mar 2025 |
| 23 | Elite Furnishings | Miami | 22 May 2025 |
| 24 | Discount Mart | Houston | 20 Aug 2024 |
| 25 | Royal Interiors | New York | 25 May 2025 |
| 1934 | Takreem Atif | Islamabad | Never Ordered |
Loyal Customers
(Frequent + Premium)
| ID | Customer Name | City | Orders | Total Spent |
| 1 | Contemporary Casuals | Gainesville | 5 | 3400.00 |
| 3 | Home Furnishings | Albany | 6 | 4950.00 |
| 11 | American Euro Lifestyles | Prospect Park | 8 | 7525.00 |
| 15 | Mountain Scenes | Ogden | 5 | 2675.00 |
| 16 | Luxury Living | Beverly Hills | 10 | 11400.00 |
| 21 | Urban Furniture | Chicago | 5 | 3700.00 |
| 23 | Elite Furnishings | Miami | 10 | 9000.00 |