CTR In Advertisement

Predict the ad click rate of a customer

@kaggle.arashnic_ctr_in_advertisement

Table List

2 tables(8.04 MB)

Ad Click Prediciton Test

@kaggle.arashnic_ctr_in_advertisement.ad_click_prediciton_test

1.96 MB
128858 rows
14 columns

session_id Session Id	datetime DateTime	user_id User Id	product Product	campaign_id Campaign Id	webpage_id Webpage Id	product_category_1 Product Category 1	product_category_2 Product Category 2	user_group_id User Group Id	gender Gender	age_level Age Level	user_depth User Depth	city_development_index City Development Index	var_1 Var 1
411705	Sat Jul 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	732573	J	404347	53587	1		5	Male	5	3
208263	Sat Jul 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	172910	I	118601	28529	3	82527		nan				1
239450	Sat Jul 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	172910	I	118601	28529	4	82527		nan				1
547761	Sat Jul 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	557318	G	118601	28529	5	82527	1	Male	1	3	1
574275	Sat Jul 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	923896	H	118601	28529	5	82527	9	Female	3	1		1
394913	Sat Jul 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	854182	I	118601	28529	4	82527	1	Male	1	3	4	1
562747	Sat Jul 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	1101628	D	118601	28529	4	82527	2	Male	2	3	2	1
224359	Sat Jul 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	1101628	D	118601	28529	5	82527	2	Male	2	3	2	1
395004	Sat Jul 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	1088284	I	118601	28529	4	82527	2	Male	2	3	1
572855	Sat Jul 08 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	972585	H	118601	28529	5	82527	2	Male	2	3	2


CREATE TABLE ad_click_prediciton_test (
  "session_id" BIGINT,
  "datetime" TIMESTAMP,
  "user_id" BIGINT,
  "product" VARCHAR,
  "campaign_id" BIGINT,
  "webpage_id" BIGINT,
  "product_category_1" BIGINT,
  "product_category_2" DOUBLE,
  "user_group_id" DOUBLE,
  "gender" VARCHAR,
  "age_level" DOUBLE,
  "user_depth" DOUBLE,
  "city_development_index" DOUBLE,
  "var_1" BIGINT
);