Customer Purchase Behavior Electronics Sales

Key Features:

1. Customer ID: A unique customer identifier.
2. Age: Numeric value representing the customer’s age.
3. Gender: Specifies the customer’s gender (Male/Female/Non-binary).
4. Loyalty Program Membership: Indicates if the customer is part of the company’s loyalty program (Yes/No). This status can fluctuate, showing when customers join or leave.
5. Product Type: Categorization of the electronic product purchased (e.g., Smartphone, Laptop, Tablet, Smartwatch, Home Appliances).
6. SKU: Stock Keeping Unit, a unique product code that helps in inventory tracking.
7. Product Rating: Customer’s rating of the product, scaled from 1 to 5 stars (All entries must have a rating).
8. Order Status: The outcome of the order (Completed, Cancelled, Returned).
9. Payment Method: Payment channels used by customers (e.g., Cash, Credit Card, Digital Wallets like PayPal, BNPL – Buy Now Pay Later).
10. Total Transaction Value: The total price of the entire purchase.
11. Unit Price: Cost of a single product item.
12. Quantity: The number of units purchased in each transaction.
13. Date of Purchase: The specific date the order was placed (Format: YYYY-MM-DD).
14. Shipping Preference: The shipping method selected (Standard, Overnight, Express, Curbside Pickup).
15. Add-on Products: Optional additional items purchased with the main product (e.g., Protective Case, Extended Warranty, Chargers).
16. Add-on Total: The total amount spent on add-ons.