Customer Segmentation Data

Unlock Insights, Optimize Marketing: Explore Data for Customer Segmentation

@kaggle.ravalsmit_customer_segmentation_data

Table List

1 table(1.42 MB)

Customer Segmentation Data

@kaggle.ravalsmit_customer_segmentation_data.customer_segmentation_data

1.42 MB
53503 rows
20 columns

customer_id Customer ID	age Age	gender Gender	marital_status Marital Status	education_level Education Level	geographic_information Geographic Information	occupation Occupation	income_level Income Level	behavioral_data Behavioral Data	purchase_history Purchase History	interactions_with_customer_service Interactions With Customer Service	insurance_products_owned Insurance Products Owned	coverage_amount Coverage Amount	premium_amount Premium Amount	policy_type Policy Type	customer_preferences Customer Preferences	preferred_communication_channel Preferred Communication Channel	preferred_contact_time Preferred Contact Time	preferred_language Preferred Language	segmentation_group Segmentation Group
84966	23	Female	Married	Associate Degree	Mizoram	Entrepreneur	70541	policy5	04-10-2018	Phone	policy2	366603	2749	Group	Email	In-Person Meeting	Afternoon	English	Segment5
95568	26	Male	Widowed	Doctorate	Goa	Manager	54168	policy5	11-06-2018	Chat	policy1	780236	1966	Group	Mail	In-Person Meeting	Morning	French	Segment5
10544	29	Female	Single	Associate Degree	Rajasthan	Entrepreneur	73899	policy5	06-05-2021	Email	policy3	773926	4413	Group	Email	Mail	Evening	German	Segment3
77033	20	Male	Divorced	Bachelor's Degree	Sikkim	Entrepreneur	63381	policy5	09-02-2018	Chat	policy2	787815	4342	Family	Text	In-Person Meeting	Anytime	French	Segment3
88160	25	Female	Separated	Bachelor's Degree	West Bengal	Manager	38794	policy1	09-10-2018	Chat	policy4	366506	1276	Family	Email	Text	Weekends	English	Segment2
60937	41	Female	Separated	Master's Degree	Uttar Pradesh	Nurse	87188	policy5	9/19/2020	Chat	policy1	570757	1106	Individual	Text	Text	Afternoon	English	Segment4
37676	55	Male	Single	Bachelor's Degree	Rajasthan	Manager	94891	policy3	07-04-2021	Chat	policy2	604069	3661	Group	In-Person Meeting	Text	Weekends	Mandarin	Segment5
54100	35	Male	Married	Master's Degree	Himachal Pradesh	Artist	61003	policy1	11-01-2021	Phone	policy3	418997	1148	Business	Email	Phone	Morning	English	Segment5
30476	43	Female	Single	Doctorate	Manipur	Salesperson	116249	policy1	9/20/2020	Mobile App	policy4	319423	2612	Business	In-Person Meeting	Text	Weekends	Mandarin	Segment2
39071	32	Female	Single	Master's Degree	Gujarat	Artist	49083	policy3	4/24/2020	Phone	policy1	701577	4595	Group	Phone	Email	Weekends	English	Segment2


CREATE TABLE customer_segmentation_data (
  "customer_id" BIGINT,
  "age" BIGINT,
  "gender" VARCHAR,
  "marital_status" VARCHAR,
  "education_level" VARCHAR,
  "geographic_information" VARCHAR,
  "occupation" VARCHAR,
  "income_level" BIGINT,
  "behavioral_data" VARCHAR,
  "purchase_history" VARCHAR,
  "interactions_with_customer_service" VARCHAR,
  "insurance_products_owned" VARCHAR,
  "coverage_amount" BIGINT,
  "premium_amount" BIGINT,
  "policy_type" VARCHAR,
  "customer_preferences" VARCHAR,
  "preferred_communication_channel" VARCHAR,
  "preferred_contact_time" VARCHAR,
  "preferred_language" VARCHAR,
  "segmentation_group" VARCHAR
);