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.

  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Churn prediction and customer retention modeling

Sample rows

preview · 8 of 200 rows · all 17 columns
migration_idstringcustomer_genderstringchurn_risk_scorefloatdevice_upgradebooleandevice_model_afterstringcustomer_idstringmigration_datedatetimeprevious_plan_idstringnew_plan_idstringdevice_model_beforestringpromotion_appliedbooleanpromotion_idstringmonthly_fee_beforefloatmonthly_fee_afterfloattenure_monthsintegercustomer_ageintegercustomer_regionstring
MIG00001female0.32trueApple iPhone 13CUST10012022-03-14T15:27:10PLAN_BASIC_101PLAN_PLUS_202Apple iPhone XRtruePLUS2022MAR38.9964.991427Urban Northeast
MIG00002male0.91falseblankCUST10022023-08-22T10:19:55PLAN_FAMILY_305PLAN_PREPAID_008Samsung Galaxy S9falseblank112.503659Rural Midwest
MIG00003male0.46falseblankCUST10032021-12-10T13:45:03PLAN_STUDENT_012PLAN_BASIC_101Google Pixel 4atrueBASIC202219.5361122Central
MIG00004female0.39trueSamsung Galaxy S22 UltraCUST10042023-06-08T09:05:33PLAN_PLUS_202PLAN_PREMIUM_401Samsung Galaxy S20trueUPGRADE4016496.51637West Coast
MIG00005other0.23falseblankCUST10052024-01-12T18:23:41PLAN_YOUTH_017PLAN_STUDENT_012Apple iPhone SE 2020falseblank1722.5720Urban Southwest
MIG00006female0.82falseblankCUST10062022-05-06T14:01:24PLAN_PREMIUM_401PLAN_BASIC_101LG VelvettrueBASIC2022MAY10429.992854Mountain
MIG00007male0.36trueOnePlus 11RCUST10072023-03-18T11:10:12PLAN_PLUS_202PLAN_FAMILY_305OnePlus 8Tfalseblank6288.252042Northeast
MIG00008female0.94falseblankCUST10082022-10-24T17:43:09PLAN_UNLIM_501PLAN_PREPAID_008Samsung Galaxy A32falseblank1390661Appalachia

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
customer_gender200 rows by value
05511082male41%107female54%5other3%6prefer_n…3%
churn_risk_score200 rows, in bands of 0.1
0255015424436164213280.10.61churn_risk_score →

Median 0.39, from 0.11 to 1.0.

device_model_after79 rows with a value · 121 left blank
  1. Samsung Galaxy S239
  2. iPhone 15 Pro7
  3. Samsung Galaxy S23 Ultra6
  4. Google Pixel 85
  5. iPhone 15 Pro Max5
  6. Apple iPhone 14 Pro3
  7. Apple iPhone SE 20223
  8. Google Pixel 7 Pro3
  9. iPhone 143
  10. iPhone 14 Pro3
17 columns by typefrom the column list below
  • string 9
  • integer 2
  • float 3
  • datetime 1
  • boolean 2

Columns

17 columns in four groups
blueprint · 17 columns
columntypedescriptionexample
Text 9 columns
migration_idstringUnique identifier for each plan migration event.uniqueMIG00001
customer_idstringUnique identifier for the customer.CUST1001
previous_plan_idstringIdentifier for the customer's previous telecom plan.PLAN_BASIC_101
new_plan_idstringIdentifier for the customer's new telecom plan after migration.PLAN_PLUS_202
device_model_beforestringModel of the customer's device before migration.optionalApple iPhone XR
device_model_afterstringModel of the customer's device after migration (if upgraded).optionalApple iPhone 13
promotion_idstringIdentifier for the promotion applied (if any).optionalPLUS2022MAR
customer_genderstringGender of the customer (if available).male · female · other · prefer_not_to_say · optionalfemale
customer_regionstringGeographic region or market segment of the customer.optionalUrban Northeast
Numbers 5 columns
churn_risk_scorefloatPredicted risk of customer churn at the time of migration (0.0 to 1.0).0 to 10.32
monthly_fee_beforefloatMonthly fee of the customer's previous plan.0 or more38.99
monthly_fee_afterfloatMonthly fee of the customer's new plan.0 or more64.99
tenure_monthsintegerNumber of months the customer was on the previous plan before migration.0 or more14
customer_ageintegerAge of the customer at the time of migration.0 or more · optional27
Dates and times 1 column
migration_datedatetimeDate and time when the customer switched plans.2022-03-14T15:27:10
True or false 2 columns
device_upgradebooleanIndicates if the customer upgraded their device during migration.true
promotion_appliedbooleanIndicates if a promotional offer was applied during migration.true

Use it for

  • device upgrade40%79 of 200 rowsmean churn risk score…0.50male0.45fema…0.43other0.52pref…

    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.

  • A software demo

    Believable migrations with customer_id, migration_date and previous_plan_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 17 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows17 columns
Yours1,000 rows17 columnscustomer_region: UK only

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.

Rules it was built with
  • 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
Rows
Open the blueprint in Data Factory

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

What should your data show?

Preview 20 rows free
No signup. No card.