Customer Subscription Data

Customer purchase and call center volume data for a subscription based product

@kaggle.gsagar12_dspp1

Table List

4 tables(22.12 MB)

Customer Product

@kaggle.gsagar12_dspp1.customer_product

9.63 MB
508932 rows
5 columns

unnamed_0 Unnamed: 0	customer_id Customer Id	product Product	signup_date_time Signup Date Time	cancel_date_time Cancel Date Time
1	C2448	prd_1	Sun Jan 01 2017 10:35:09 GMT+0000 (Coordinated Universal Time)
2	C2449	prd_1	Sun Jan 01 2017 11:39:29 GMT+0000 (Coordinated Universal Time)	Sun Sep 05 2021 10:00:02 GMT+0000 (Coordinated Universal Time)
3	C2450	prd_1	Sun Jan 01 2017 11:42:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 13 2019 16:24:55 GMT+0000 (Coordinated Universal Time)
4	C2451	prd_2	Sun Jan 01 2017 13:32:08 GMT+0000 (Coordinated Universal Time)
5	C2452	prd_1	Sun Jan 01 2017 13:57:30 GMT+0000 (Coordinated Universal Time)	Mon Jun 28 2021 18:06:01 GMT+0000 (Coordinated Universal Time)
6	C2453	prd_1	Sun Jan 01 2017 15:26:14 GMT+0000 (Coordinated Universal Time)
7	C2454	prd_1	Sun Jan 01 2017 15:35:03 GMT+0000 (Coordinated Universal Time)	Tue Jun 01 2021 17:09:40 GMT+0000 (Coordinated Universal Time)
8	C2455	prd_1	Mon Jan 02 2017 09:01:31 GMT+0000 (Coordinated Universal Time)
9	C2456	prd_1	Mon Jan 02 2017 09:21:04 GMT+0000 (Coordinated Universal Time)	Thu Jun 08 2017 15:57:45 GMT+0000 (Coordinated Universal Time)
10	C2457	prd_1	Mon Jan 02 2017 09:26:42 GMT+0000 (Coordinated Universal Time)	Sat Nov 25 2017 12:55:05 GMT+0000 (Coordinated Universal Time)


CREATE TABLE customer_product (
  "unnamed_0" BIGINT,
  "customer_id" VARCHAR,
  "product" VARCHAR,
  "signup_date_time" TIMESTAMP,
  "cancel_date_time" TIMESTAMP
);