Dataset: Customer Subscription Data

About this Dataset

Customer Subscription Data

This data is about a subscription-based digital product offering for financial advisory that includes newsletters, webinars, and investment recommendations. The offering has a couple of varieties, annual subscription, and digital subscription. The product also provides daytime support for customers to reach out to a care team that can help them with any product-related questions and signup/cancellation-related queries.

The data set contains the following information

customer sign-up and cancellation dates at the product level
call center activity
customer demographics
product pricing info

Few of business questions to answer

Forecast 2022 year revenue if the company expects to add the same number of new customers as the previous year
In 2022, one of the company's key initiatives is to improve the customer experience, one of the capabilities is superior customer care service, and they are thinking about enhancing in-product support better but that takes beyond 2022 to happen. It is very important to forecast call center case volume accurately so that they can make appropriate staffing decisions. Need to predict daily call volumes and make recommendations on how to staff on an hourly basis.

Tables

Customer Cases

@kaggle.gsagar12_dspp1.customer_cases

7.5 MB
330512 rows
6 columns


CREATE TABLE customer_cases (
  "unnamed_0" BIGINT,
  "case_id" VARCHAR,
  "date_time" TIMESTAMP,
  "customer_id" VARCHAR,
  "channel" VARCHAR,
  "reason" VARCHAR
);

Customer Info

@kaggle.gsagar12_dspp1.customer_info

4.99 MB
508932 rows
4 columns


CREATE TABLE customer_info (
  "unnamed_0" BIGINT,
  "customer_id" VARCHAR,
  "age" BIGINT,
  "gender" VARCHAR
);

Customer Product

@kaggle.gsagar12_dspp1.customer_product

9.63 MB
508932 rows
5 columns


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

Product Info

@kaggle.gsagar12_dspp1.product_info

3.43 KB
2 rows
4 columns


CREATE TABLE product_info (
  "product_id" VARCHAR,
  "name" VARCHAR,
  "price" BIGINT,
  "billing_cycle" BIGINT
);