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 Prediction Train 1

@kaggle.arashnic_ctr_in_advertisement.ad_click_prediction_train_1

6.08 MB
463291 rows
15 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
140690	Sun Jul 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	858557	C	359520	13787	4		10	Female	4	3	3
333291	Sun Jul 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	243253	C	105960	11085	5		8	Female	2	2
129781	Sun Jul 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	243253	C	359520	13787	4		8	Female	2	2
464848	Sun Jul 02 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	1097446	I	359520	13787	3		3	Male	3	3	2	1
90569	Sun Jul 02 2017 00:01:00 GMT+0000 (Coordinated Universal Time)	663656	C	405490	60305	3		2	Male	2	3	2	1
151475	Sun Jul 02 2017 00:01:00 GMT+0000 (Coordinated Universal Time)	509591	I	359520	13787	2		1	Male	1	3
17583	Sun Jul 02 2017 00:01:00 GMT+0000 (Coordinated Universal Time)	1091463	F	405490	60305	3		9	Female	3	3	4
461128	Sun Jul 02 2017 00:01:00 GMT+0000 (Coordinated Universal Time)	469098	C	360936	13787	3		4	Male	4	3	4
390699	Sun Jul 02 2017 00:02:00 GMT+0000 (Coordinated Universal Time)	611906	H	105960	11085	5	270915		nan
353607	Sun Jul 02 2017 00:02:00 GMT+0000 (Coordinated Universal Time)	418107	B	360936	13787	2		4	Male	4	3	4


CREATE TABLE ad_click_prediction_train_1 (
  "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,
  "is_click" BIGINT
);