Dataset: Telco Product Subscription Data

About this Dataset

Telco Product Subscription Data

This dataset contains programmatically generated data of telco product subscriptions, suitable for data exploration, data visualisation and data storytelling.

1. Product Plan Table
Total Rows: 50 plans
Columns:
Plan Name
Period (1 day, 7 day, 14 day, 30 day)
Plan Price (IDR 5,000 to IDR 200,000)
Network Type (4G, 5G, Fiber)
Has Bundling (Yes/No)
Category (10 categories)
Quota (MB, ranging from 500 MB to 100 GB)

2. Customer Table
Total Rows: 300 customers
Columns:
Customer Name (randomly generated Indonesian names)
City/Province (major Indonesian cities)
Age (17–62 years)
Region (Urban/Rural)
Customer Segment (Individual, SME, Enterprise, Government)
Lifetime Value (IDR 100,000 to 10,000,000)

3. Subscription Table
Total Rows: 15,000 subscriptions
Columns:
Subscribe Date (2021–2024)
Customer ID (linked to the Customer table)
Plan ID (linked to the Product Plan table)
Discount (percentage applied to the subscription)

Tables

Customerdata

@kaggle.gemalarahmani_telco_product_subscription_data.customerdata

15.41 KB
300 rows
8 columns


CREATE TABLE customerdata (
  "customer_id" BIGINT,
  "customer_name" VARCHAR,
  "city" VARCHAR,
  "province" VARCHAR,
  "age" BIGINT,
  "region" VARCHAR,
  "customer_segment" VARCHAR,
  "lifetime_value" DOUBLE
);

Productplan

@kaggle.gemalarahmani_telco_product_subscription_data.productplan

6.85 KB
50 rows
8 columns


CREATE TABLE productplan (
  "id" BIGINT,
  "plan_name" VARCHAR,
  "period" VARCHAR,
  "plan_price" BIGINT,
  "network_type" VARCHAR,
  "has_bundling" VARCHAR,
  "category" VARCHAR,
  "quota" BIGINT
);

Subscriptiondata

@kaggle.gemalarahmani_telco_product_subscription_data.subscriptiondata

193.8 KB
15000 rows
5 columns


CREATE TABLE subscriptiondata (
  "id" BIGINT,
  "subscribe_date" TIMESTAMP,
  "customer_id" BIGINT,
  "plan_id" BIGINT,
  "discount" DOUBLE
);