Customer Personality Analysis

Analysis of company's ideal customers

@kaggle.imakash3011_customer_personality_analysis

Table List

1 table(88.02 KB)

Marketing Campaign

@kaggle.imakash3011_customer_personality_analysis.marketing_campaign

88.02 KB
2240 rows
29 columns

id ID	year_birth Year Birth	education Education	marital_status Marital Status	income Income	kidhome Kidhome	teenhome Teenhome	dt_customer Dt Customer	recency Recency	mntwines MntWines	mntfruits MntFruits	mntmeatproducts MntMeatProducts	mntfishproducts MntFishProducts	mntsweetproducts MntSweetProducts	mntgoldprods MntGoldProds	numdealspurchases NumDealsPurchases	numwebpurchases NumWebPurchases	numcatalogpurchases NumCatalogPurchases	numstorepurchases NumStorePurchases	numwebvisitsmonth NumWebVisitsMonth	acceptedcmp3 AcceptedCmp3	z_costcontact Z CostContact	z_revenue Z Revenue	response Response
5524	1957	Graduation	Single	58138			04-09-2012	58	635	88	546	172	88	88	3	8	10	4	7		3	11	1
2174	1954	Graduation	Single	46344	1	1	08-03-2014	38	11	1	6	2	1	6	2	1	1	2	5		3	11
4141	1965	Graduation	Together	71613			21-08-2013	26	426	49	127	111	21	42	1	8	2	10	4		3	11
6182	1984	Graduation	Together	26646	1		10-02-2014	26	11	4	20	10	3	5	2	2		4	6		3	11
5324	1981	PhD	Married	58293	1		19-01-2014	94	173	43	118	46	27	15	5	5	3	6	5		3	11
7446	1967	Master	Together	62513		1	09-09-2013	16	520	42	98		42	14	2	6	4	10	6		3	11
965	1971	Graduation	Divorced	55635		1	13-11-2012	34	235	65	164	50	49	27	4	7	3	7	6		3	11
6177	1985	PhD	Married	33454	1		08-05-2013	32	76	10	56	3	1	23	2	4		4	8		3	11
4855	1974	PhD	Together	30351	1		06-06-2013	19	14		24	3	3	2	1	3		2	9		3	11	1
5899	1950	PhD	Together	5648	1	1	13-03-2014	68	28		6	1	1	13	1	1			20	1	3	11


CREATE TABLE marketing_campaign (
  "id" BIGINT,
  "year_birth" BIGINT,
  "education" VARCHAR,
  "marital_status" VARCHAR,
  "income" DOUBLE,
  "kidhome" BIGINT,
  "teenhome" BIGINT,
  "dt_customer" VARCHAR,
  "recency" BIGINT,
  "mntwines" BIGINT,
  "mntfruits" BIGINT,
  "mntmeatproducts" BIGINT,
  "mntfishproducts" BIGINT,
  "mntsweetproducts" BIGINT,
  "mntgoldprods" BIGINT,
  "numdealspurchases" BIGINT,
  "numwebpurchases" BIGINT,
  "numcatalogpurchases" BIGINT,
  "numstorepurchases" BIGINT,
  "numwebvisitsmonth" BIGINT,
  "acceptedcmp3" BIGINT,
  "acceptedcmp4" BIGINT,
  "acceptedcmp5" BIGINT,
  "acceptedcmp1" BIGINT,
  "acceptedcmp2" BIGINT,
  "complain" BIGINT,
  "z_costcontact" BIGINT,
  "z_revenue" BIGINT,
  "response" BIGINT
);