Telecom Customer Onboarding Timeline

This dataset provides detailed, step-by-step records of telecom customer onboarding processes, including timestamps, agent involvement, service types, and churn risk scores. It enables telecom providers to analyze onboarding efficiency, identify process bottlenecks, and proactively manage churn risks, making it valuable for operational optimization and customer experience improvement.

  • last updated 21 Aug 2025
  • by GoMask
The brief that made it

Analyzing onboarding process efficiency and identifying bottlenecks

Sample rows

preview · 8 of 200 rows · all 21 columns
onboarding_step_idstringonboarding_step_statusstringchurn_risk_scorefloataddress_countrystringcustomer_idstringcustomer_namestringcustomer_emailstringcustomer_phonestringaddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestringservice_typestringonboarding_step_namestringonboarding_step_start_datetimedatetimeonboarding_step_end_datetimedatetimeonboarding_step_duration_minutesfloatonboarding_agent_idstringonboarding_channelstringstep_failure_reasonstringnotesstring
step_0001completed0.04GermanyCUST1001Martin Schultzmartin.schultz@outlook.de+49170341234512 LindenwegBerlinBE10115mobileKYC2024-03-01T10:16:00Z2024-03-01T10:22:00Z6blankonlineblankDigital document verification completed successfully.
step_0002in_progress0.28IndiaCUST1002Priya Singhpriya.singh@gmail.com+919812345678203 MG RoadMumbaiMH400001broadbandinstallation2024-04-14T13:45:00ZblankblankAGENT202field_visitblankTechnician is onsite, awaiting equipment delivery.
step_0003failed0.94UKCUST1003Ravi Patelravi.patel@patelcorp.co.uk+44791123456744 High StreetLondonLDNE1 6ANiotactivation2024-02-22T09:05:00Z2024-02-22T09:23:00Z18AGENT078phoneDevice registration failed due to invalid IMEI.Customer will retry with correct device details.
step_0004completed0.18USACUST1004Sarah Williamssarah.williams@icloud.com+1555123456798 Oak LaneMiamiFL33101tvinstallation2024-05-03T15:30:00Z2024-05-03T16:30:00Z60AGENT311field_visitblankSet-top box installed, signal verified.
step_0005completed0.09UAECUST1005Ahmed Al Najjarahmed.najjar@emiratesmail.ae+97150123456755 Sheikh RoadDubaiDU00001broadbandactivation2024-01-30T12:10:00Z2024-01-30T12:13:00Z3blankonlineblankConfirmed broadband activation and speed test.
step_0006pending0.16RussiaCUST1006Olga Ivanovaolga.ivanova@mail.ru+7916123456725 Nevsky ProspektSt PetersburgSPB191186tvKYC2024-06-03T08:00:00Zblankblankblankin_storeblankCustomer scheduled for in-store verification.
step_0007completed0.32GhanaCUST1007Pamela Oseipamela.osei@ghanaweb.com+23350123456717 Independence AveAccraGA00233landlineinstallation2023-12-19T11:00:00Z2023-12-19T12:25:00Z85AGENT489field_visitblankLandline installed after cable replacement.
step_0008completed0.07ChinaCUST1008Wei Zhangwei.zhang@163.com+86138012345678 Fuxing RdShanghaiSH200050iotactivation2024-05-10T09:50:00Z2024-05-10T10:00:00Z10blankonlineblankIoT gateway activated with customer credentials.

What the 200 rows show

from the 200-row sample

Failed (onboarding step status) stands out: mean churn_risk_score is 0.92, against 0.18 for the rest.

  • 0.14median churn_risk_score
  • 3onboarding step names
  • 4onboarding channels
  • 5service types
  • 7onboarding agents
  • 6.0median onboarding_step_duration_minutes
Mean churn_risk_score by onboarding_step_status200 rows
00.510.09pendi…11 rows0.37in_pr…29 rows0.11compl…131 ro…0.92failed22 rows0.90cance…6 rows0.14in_st…1 rows
churn_risk_score200 rows, in bands of 0.1
04080764524188100121600.51churn_risk_score →

Median 0.14, from 0.01 to 0.98.

address_country194 rows with a value · 6 left blank
  1. USA28
  2. Germany14
  3. Russia12
  4. France10
  5. UK9
  6. Brazil9
  7. Spain9
  8. India8
  9. Italy8
  10. South Korea8
21 columns by typefrom the column list below
  • string 17
  • float 2
  • datetime 2

Columns

21 columns in three groups
blueprint · 21 columns
columntypedescriptionexample
Text 17 columns
onboarding_step_idstringUnique identifier for each onboarding step recorduniquestep_0001
customer_idstringUnique identifier for the customerCUST1001
customer_namestringFull name of the customerMartin Schultz
customer_emailstringEmail address of the customerpriya.singh@gmail.com
customer_phonestringPrimary phone number of the customeroptional+491703412345
address_streetstringStreet address of the customeroptional12 Lindenweg
address_citystringCity of the customer's addressoptionalBerlin
address_statestringState or province of the customer's addressoptionalBE
address_postal_codestringPostal or ZIP code of the customer's addressoptional10115
address_countrystringCountry of the customer's addressoptionalGermany
service_typestringType of telecom service being onboarded (e.g., mobile, broadband, TV)mobile · broadband · tv · landline · iotmobile
onboarding_step_namestringName of the onboarding step (e.g., KYC, installation, activation)3 namesKYC
onboarding_step_statusstringCurrent status of the onboarding steppending · in_progress · completed · failed · cancelledcompleted
onboarding_agent_idstringIdentifier for the agent or employee handling the onboarding step7 agents · optionalAGENT202
onboarding_channelstringChannel through which the onboarding step was performed (e.g., online, in-store, phone)online · in_store · phone · field_visit · optionalonline
step_failure_reasonstringReason for failure if the onboarding step was not successfuloptionalDevice registration faile…
notesstringAdditional notes or comments related to the onboarding stepoptionalDigital document verifica…
Numbers 2 columns
onboarding_step_duration_minutesfloatDuration of the onboarding step in minutes0 or more · optional6
churn_risk_scorefloatCalculated risk score for customer churn at this step (0-1 scale)0 to 1 · optional0.04
Dates and times 2 columns
onboarding_step_start_datetimedatetimeTimestamp when the onboarding step started2024-03-01T10:16:00Z
onboarding_step_end_datetimedatetimeTimestamp when the onboarding step endedoptional2024-03-01T10:22:00Z

Use it for

  • median churn r…0.14200 rowsmean churn risk score…0.09pend…0.37in_p…0.11comp…0.92fail…

    A telecommunications dashboard

    Churn_risk_score by onboarding_step_status and a breakdown of address_country. Excel, Power BI or Tableau.

  • Why do the 22 failed rows have a mean churn_risk_score of 0.92?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable onboarding steps with customer_id, customer_name and customer_email to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 21 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 rows21 columns
Yours1,000 rows21 columnsaddress_street: UK only

blueprint · telecom-customer-onboarding-timeline

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 21 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 timeline includes step IDs, timestamps
  • Abandoned onboardings flagged
  • Duration per step calculated
  • Customer segment tagged
  • Missing steps imputed as incomplete
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-onboarding-timeline

More in Telecommunications

Browse all
Also in TelecommunicationsTelecom Customer Plan Migration RecordsTelecom Network Alarm PrioritizationTelecom Subscriber Usage PatternsAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.