Telecom Customer Plan Migration Records
This dataset provides detailed, event-level records of telecom customers migrating between service plans, including associated churn risk scores, device upgrade activity, and the impact of promotional offers. It enables longitudinal analysis of customer lifecycle events, plan preferences, and retention strategies, making it valuable for churn modeling, marketing optimization, and customer value analysis.
Sample rows
preview · 8 of 200 rows · all 17 columns| migration_idstring | customer_genderstring | churn_risk_scorefloat | device_upgradeboolean | device_model_afterstring | customer_idstring | migration_datedatetime | previous_plan_idstring | new_plan_idstring | device_model_beforestring | promotion_appliedboolean | promotion_idstring | monthly_fee_beforefloat | monthly_fee_afterfloat | tenure_monthsinteger | customer_ageinteger | customer_regionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MIG00001 | female | 0.32 | true | Apple iPhone 13 | CUST1001 | 2022-03-14T15:27:10 | PLAN_BASIC_101 | PLAN_PLUS_202 | Apple iPhone XR | true | PLUS2022MAR | 38.99 | 64.99 | 14 | 27 | Urban Northeast |
| MIG00002 | male | 0.91 | false | blank | CUST1002 | 2023-08-22T10:19:55 | PLAN_FAMILY_305 | PLAN_PREPAID_008 | Samsung Galaxy S9 | false | blank | 112.5 | 0 | 36 | 59 | Rural Midwest |
| MIG00003 | male | 0.46 | false | blank | CUST1003 | 2021-12-10T13:45:03 | PLAN_STUDENT_012 | PLAN_BASIC_101 | Google Pixel 4a | true | BASIC2022 | 19.5 | 36 | 11 | 22 | Central |
| MIG00004 | female | 0.39 | true | Samsung Galaxy S22 Ultra | CUST1004 | 2023-06-08T09:05:33 | PLAN_PLUS_202 | PLAN_PREMIUM_401 | Samsung Galaxy S20 | true | UPGRADE401 | 64 | 96.5 | 16 | 37 | West Coast |
| MIG00005 | other | 0.23 | false | blank | CUST1005 | 2024-01-12T18:23:41 | PLAN_YOUTH_017 | PLAN_STUDENT_012 | Apple iPhone SE 2020 | false | blank | 17 | 22.5 | 7 | 20 | Urban Southwest |
| MIG00006 | female | 0.82 | false | blank | CUST1006 | 2022-05-06T14:01:24 | PLAN_PREMIUM_401 | PLAN_BASIC_101 | LG Velvet | true | BASIC2022MAY | 104 | 29.99 | 28 | 54 | Mountain |
| MIG00007 | male | 0.36 | true | OnePlus 11R | CUST1007 | 2023-03-18T11:10:12 | PLAN_PLUS_202 | PLAN_FAMILY_305 | OnePlus 8T | false | blank | 62 | 88.25 | 20 | 42 | Northeast |
| MIG00008 | female | 0.94 | false | blank | CUST1008 | 2022-10-24T17:43:09 | PLAN_UNLIM_501 | PLAN_PREPAID_008 | Samsung Galaxy A32 | false | blank | 139 | 0 | 6 | 61 | Appalachia |
| MIG00009 | male | 0.28 | true | Apple iPhone 12 | CUST1009 | 2021-11-29T13:02:44 | PLAN_STUDENT_012 | PLAN_PLUS_202 | Moto G Power | true | PLUS2021NOV | 22 | 53 | 10 | 23 | Urban Central |
| MIG00010 | female | 0.48 | true | Google Pixel 8 Pro | CUST1010 | 2023-12-18T16:39:37 | PLAN_BASIC_101 | PLAN_PREMIUM_401 | Google Pixel 5 | false | blank | 37.99 | 87.5 | 16 | 31 | Urban Northeast |
| MIG00011 | prefer_not_to_say | 0.29 | false | blank | CUST1011 | 2022-09-20T09:22:01 | PLAN_YOUTH_017 | PLAN_BASIC_101 | iPhone 7 | true | BASICSEP22 | 15 | 32 | 8 | 21 | Central |
| MIG00012 | female | 0.13 | false | blank | CUST1012 | 2022-07-15T08:47:35 | PLAN_PREPAID_008 | PLAN_BASIC_101 | Samsung Galaxy A10e | false | blank | 0 | 26 | 2 | 33 | West Coast |
| MIG00013 | male | 0.41 | true | Apple iPhone 14 Pro | CUST1013 | 2023-05-12T14:31:10 | PLAN_FAMILY_305 | PLAN_PREMIUM_401 | Apple iPhone 11 | true | PREMIUMMAY | 95 | 129.99 | 18 | 48 | Northeast |
| MIG00014 | male | 0.34 | false | blank | CUST1014 | 2023-02-20T13:59:11 | PLAN_BASIC_101 | PLAN_PLUS_202 | Google Pixel 6a | false | blank | 35 | 63 | 13 | 29 | Urban Northeast |
| MIG00015 | female | 0.27 | true | Samsung Galaxy S24 | CUST1015 | 2024-03-19T15:43:23 | PLAN_PLUS_202 | PLAN_PREMIUM_401 | Samsung Galaxy S21 | true | PREMIUM24MAR | 68 | 112 | 15 | 36 | Urban West Coast |
| MIG00016 | female | 0.3 | false | blank | CUST1001 | 2023-10-03T14:57:09 | PLAN_PLUS_202 | PLAN_UNLIM_501 | Apple iPhone 13 | true | UNLIM2023FALL | 64.99 | 99 | 14 | 28 | Urban Northeast |
| MIG00017 | male | 0.97 | false | blank | CUST1016 | 2023-01-27T11:24:44 | PLAN_UNLIM_501 | PLAN_PREPAID_008 | Samsung Galaxy S10 | false | blank | 149.5 | 0 | 44 | 66 | Rural Midwest |
| MIG00018 | female | 0.44 | false | blank | CUST1017 | 2023-11-12T13:18:13 | PLAN_BASIC_101 | PLAN_PLUS_202 | Apple iPhone XS | true | PLUSNOV23 | 38 | 60.5 | 17 | 32 | Urban Northeast |
| MIG00019 | male | 0.22 | true | Apple iPhone SE 2022 | CUST1018 | 2021-10-02T16:12:29 | PLAN_YOUTH_017 | PLAN_STUDENT_012 | Samsung Galaxy A20 | false | blank | 18 | 24.5 | 5 | 19 | Urban Central |
| MIG00020 | female | 0.42 | true | Apple iPhone 14 Pro | CUST1019 | 2022-06-25T11:32:56 | PLAN_FAMILY_305 | PLAN_PREMIUM_401 | Apple iPhone 12 | true | FAM2PREM22 | 105 | 140 | 20 | 46 | West Coast |
What the 200 rows show
from the 200-row sample- 40%device_
upgrade = true - 0.39median churn_
risk_ score - 20customer regions
- 26new plans
- 29previous plans
- 59.2median monthly_
fee_ before
Median 0.39, from 0.11 to 1.0.
- string 9
- integer 2
- float 3
- datetime 1
- boolean 2
Columns
17 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
migration_id | string | Unique identifier for each plan migration event.unique | MIG00001 |
customer_id | string | Unique identifier for the customer. | CUST1001 |
previous_plan_id | string | Identifier for the customer's previous telecom plan. | PLAN_BASIC_101 |
new_plan_id | string | Identifier for the customer's new telecom plan after migration. | PLAN_PLUS_202 |
device_model_before | string | Model of the customer's device before migration.optional | Apple iPhone XR |
device_model_after | string | Model of the customer's device after migration (if upgraded).optional | Apple iPhone 13 |
promotion_id | string | Identifier for the promotion applied (if any).optional | PLUS2022MAR |
customer_gender | string | Gender of the customer (if available).male · female · other · prefer_not_to_say · optional | female |
customer_region | string | Geographic region or market segment of the customer.optional | Urban Northeast |
| Numbers 5 columns | |||
churn_risk_score | float | Predicted risk of customer churn at the time of migration (0.0 to 1.0).0 to 1 | 0.32 |
monthly_fee_before | float | Monthly fee of the customer's previous plan.0 or more | 38.99 |
monthly_fee_after | float | Monthly fee of the customer's new plan.0 or more | 64.99 |
tenure_months | integer | Number of months the customer was on the previous plan before migration.0 or more | 14 |
customer_age | integer | Age of the customer at the time of migration.0 or more · optional | 27 |
| Dates and times 1 column | |||
migration_date | datetime | Date and time when the customer switched plans. | 2022-03-14T15:27:10 |
| True or false 2 columns | |||
device_upgrade | boolean | Indicates if the customer upgraded their device during migration. | true |
promotion_applied | boolean | Indicates if a promotional offer was applied during migration. | true |
Use it for
A telecommunications dashboard
The device_
upgrade rate, churn_ risk_ score by customer_ gender and a breakdown of device_ model_ after. Excel, Power BI or Tableau. Why do 79 of 200 rows have device_
upgrade = true? A class exercise
Hand out the rows and one question. Everyone works from the same 200 rows.
- Migrations200MIG000010.32femaleMIG000020.91maleMIG000040.39female
A software demo
Believable migrations with customer_
id, migration_ date and previous_ plan_ id to fill a screen in front of a buyer.
blueprint · telecom-customer-plan-migration-records
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 17 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Each record: customer, current and previous plan
- Timestamp and reason for migration
- Promotion/discount flag included
- Device upgrade at migration noted
- Churn risk scored post-migration
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- telecom-customer-plan-migration-records