Dataset: CTR In Advertisement

About this Dataset

CTR In Advertisement

Context

A company wants to know the CTR ( Click Through Rate ) in order to identify whether spending their money on digital advertising is worth or not.
A higher CTR represents more interest in that specific campaign, whereas a lower CTR can show that the ad may not be as relevant.
High CTRs are important because they show that more people are clicking through the website. Along with this high CTRs also help to get better ad position for less money on online platforms like Google, Bing etc.

Content

The dataset divided to train (463291, 15) and test (128858, 14). Features are clear and target is "is_click" , 0 (No) , 1(Yes).

Kerner(s)

Quick EDA and Base Model

Inspiration

EDA and customer analytics
Prediction of the ad click rate of a customer

Tables

Ad Click Prediciton Test

@kaggle.arashnic_ctr_in_advertisement.ad_click_prediciton_test

1.96 MB
128858 rows
14 columns


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
);

Ad Click Prediction Train 1

@kaggle.arashnic_ctr_in_advertisement.ad_click_prediction_train_1

6.08 MB
463291 rows
15 columns


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
);