Dataset: 🛒 E-commerce Customer Data For Behavior Analysis

About this Dataset

🛒 E-commerce Customer Data For Behavior Analysis

Customer ID: A unique identifier for each customer.
Customer Name: The name of the customer (generated by Faker).
Customer Age: The age of the customer (generated by Faker).
Gender: The gender of the customer (generated by Faker).
Purchase Date: The date of each purchase made by the customer.
Product Category: The category or type of the purchased product.
Product Price: The price of the purchased product.
Quantity: The quantity of the product purchased.
Total Purchase Amount: The total amount spent by the customer in each transaction.
Payment Method: The method of payment used by the customer (e.g., credit card, PayPal).
Returns: Whether the customer returned any products from the order (binary: 0 for no return, 1 for return).
Churn: A binary column indicating whether the customer has churned (0 for retained, 1 for churned).

Note:

Tables

Ecommerce Customer Data Custom Ratios

@kaggle.shriyashjagtap_e_commerce_customer_for_behavior_analysis.ecommerce_customer_data_custom_ratios

4.44 MB
250000 rows
13 columns


CREATE TABLE ecommerce_customer_data_custom_ratios (
  "customer_id" BIGINT,
  "purchase_date" TIMESTAMP,
  "product_category" VARCHAR,
  "product_price" BIGINT,
  "quantity" BIGINT,
  "total_purchase_amount" BIGINT,
  "payment_method" VARCHAR,
  "customer_age" BIGINT,
  "returns" DOUBLE,
  "customer_name" VARCHAR,
  "age" BIGINT,
  "gender" VARCHAR,
  "churn" BIGINT
);

Ecommerce Customer Data Large

@kaggle.shriyashjagtap_e_commerce_customer_for_behavior_analysis.ecommerce_customer_data_large

4.44 MB
250000 rows
13 columns


CREATE TABLE ecommerce_customer_data_large (
  "customer_id" BIGINT,
  "purchase_date" TIMESTAMP,
  "product_category" VARCHAR,
  "product_price" BIGINT,
  "quantity" BIGINT,
  "total_purchase_amount" BIGINT,
  "payment_method" VARCHAR,
  "customer_age" BIGINT,
  "returns" DOUBLE,
  "customer_name" VARCHAR,
  "age" BIGINT,
  "gender" VARCHAR,
  "churn" BIGINT
);