Customer Churn Call Reason Analysis
This dataset provides detailed call log records linked to customer churn events, including call metadata, customer demographics, churn reasons, and resolution outcomes. It enables comprehensive analysis of why customers leave, how call center interactions influence churn, and supports the development of targeted retention strategies. The dataset is ideal for churn prediction modeling, root cause analysis, and customer experience optimization.
Sample rows
preview · 8 of 65 rows · all 19 columns| customer_idstring | customer_segmentstring | customer_tenure_monthsinteger | churn_flagboolean | agent_idstring | call_idstring | call_datetimedatetime | call_duration_secondsinteger | call_typestring | churn_datedate | churn_reason_codestring | churn_reason_descriptionstring | resolution_statusstring | customer_regionstring | call_topicstring | follow_up_requiredboolean | follow_up_completedboolean | customer_ageinteger | customer_genderstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CUST10001 | premium | 34 | false | AGT001 | CALL20001 | 2024-03-04T10:12:18 | 542 | inbound | blank | blank | blank | resolved | Northeast | billing | false | false | 41 | female |
| CUST10002 | standard | 21 | false | AGT003 | CALL20002 | 2024-03-12T15:24:08 | 174 | outbound | blank | blank | blank | resolved | Midwest | technical support | true | true | 28 | male |
| CUST10003 | basic | 15 | true | AGT002 | CALL20003 | 2024-01-16T13:56:46 | 392 | inbound | 2024-01-20 | BILL01 | Disputed bill amount not resolved | escalated | West | billing | true | false | 36 | female |
| CUST10004 | standard | 8 | false | AGT004 | CALL20004 | 2024-02-06T09:33:25 | 80 | inbound | blank | blank | blank | resolved | South | account update | false | false | 25 | female |
| CUST10005 | premium | 60 | false | AGT005 | CALL20005 | 2024-01-22T17:14:44 | 623 | inbound | blank | blank | blank | resolved | Midwest | technical support | true | true | 48 | male |
| CUST10006 | basic | 4 | false | AGT002 | CALL20006 | 2024-03-10T11:20:58 | 259 | outbound | blank | blank | blank | unresolved | Northeast | service inquiry | true | false | 38 | unknown |
| CUST10007 | standard | 13 | false | blank | CALL20007 | 2024-02-14T13:01:42 | 120 | inbound | blank | blank | blank | resolved | West | technical support | false | false | 31 | female |
| CUST10008 | basic | 9 | false | AGT003 | CALL20008 | 2024-02-17T16:25:03 | 333 | inbound | blank | blank | blank | unresolved | South | service inquiry | true | false | 22 | male |
| CUST10009 | standard | 32 | false | AGT001 | CALL20009 | 2024-03-01T14:19:13 | 250 | outbound | blank | blank | blank | resolved | Northeast | billing | false | false | 45 | male |
| CUST10010 | basic | 7 | true | AGT004 | CALL20010 | 2024-01-27T10:07:20 | 75 | inbound | 2024-02-02 | TECH02 | Repeated technical issues, unresolved | escalated | West | technical support | true | false | 24 | female |
| CUST10011 | premium | 49 | false | AGT002 | CALL20011 | 2024-03-11T12:45:32 | 492 | outbound | blank | blank | blank | resolved | Northeast | account update | false | false | 52 | male |
| CUST10012 | premium | 29 | false | AGT005 | CALL20012 | 2024-02-05T14:57:15 | 657 | inbound | blank | blank | blank | resolved | South | service inquiry | false | false | 40 | other |
| CUST10013 | standard | 17 | false | AGT003 | CALL20013 | 2024-03-13T11:38:09 | 305 | inbound | blank | blank | blank | resolved | Midwest | billing | false | false | 33 | male |
| CUST10014 | basic | 23 | false | blank | CALL20014 | 2024-03-05T09:22:16 | 218 | inbound | blank | blank | blank | resolved | West | account update | false | false | 30 | unknown |
| CUST10015 | standard | 11 | false | AGT005 | CALL20015 | 2024-02-19T16:43:53 | 130 | outbound | blank | blank | blank | unresolved | Midwest | technical support | true | true | 29 | female |
| CUST10016 | standard | 19 | true | AGT002 | CALL20016 | 2024-01-29T14:28:37 | 462 | inbound | 2024-02-05 | CNCL03 | Requested cancellation, dissatisfied with service | unresolved | South | cancellation | false | false | 47 | male |
| CUST10017 | basic | 10 | false | AGT001 | CALL20017 | 2024-03-07T12:05:44 | 88 | inbound | blank | blank | blank | resolved | Northeast | billing | false | false | 27 | male |
| CUST10018 | premium | 38 | false | AGT004 | CALL20018 | 2024-03-12T15:55:28 | 251 | outbound | blank | blank | blank | resolved | West | account update | true | true | 55 | female |
| CUST10019 | standard | 14 | false | AGT003 | CALL20019 | 2024-01-18T13:50:12 | 195 | inbound | blank | blank | blank | resolved | South | billing | false | false | 39 | female |
| CUST10020 | premium | 47 | false | AGT005 | CALL20020 | 2024-03-03T10:20:10 | 551 | outbound | blank | blank | blank | resolved | Midwest | technical support | true | true | 49 | male |
What the 65 rows show
from the 65-row samplePremium (customer segment) stands out: mean customer_
- 18%churn_
flag = true - 21median customer_
tenure_ months - 2call types
- 3resolution statuses
- 4customer genders
- 7call topics
Median 21, from 2 to 73.
- string 11
- integer 3
- date 1
- datetime 1
- boolean 3
Columns
19 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
customer_id | string | Unique identifier for each customerunique | CUST10001 |
call_id | string | Unique identifier for each call log entryunique | CALL20001 |
call_type | string | Type of call (inbound or outbound)inbound · outbound | inbound |
agent_id | string | Unique identifier for the customer service agent handling the calloptional | AGT001 |
churn_reason_code | string | Standardized code representing the primary reason for churnoptional | BILL01 |
churn_reason_description | string | Text description of the churn reason as provided by the customeroptional | Service too expensive |
resolution_status | string | Status of the call resolution (resolved, unresolved, escalated)resolved · unresolved · escalated | resolved |
customer_segment | string | Customer segment or tier (e.g., 'premium', 'standard', 'basic')3 segments · optional | premium |
customer_region | string | Geographical region or market of the customer9 regions · optional | Northeast |
call_topic | string | Main topic or category of the call (e.g., billing, technical support, cancellation)7 topics · optional | billing |
customer_gender | string | Gender of the customermale · female · other · unknown · optional | female |
| Numbers 3 columns | |||
call_duration_seconds | integer | Duration of the call in seconds0 or more | 542 |
customer_tenure_months | integer | Number of months the customer has been with the company at the time of the call0 or more · optional | 34 |
customer_age | integer | Age of the customer at the time of the call0 or more · optional | 41 |
| Dates and times 2 columns | |||
call_datetime | datetime | Date and time when the call occurred | 2024-03-04T10:12:18 |
churn_date | date | Date when the customer churned (null if not churned)optional | 2024-01-20 |
| True or false 3 columns | |||
churn_flag | boolean | Indicates whether the customer churned after the call (true = churned, false = retained) | false |
follow_up_required | boolean | Indicates if a follow-up action was required after the calloptional | false |
follow_up_completed | boolean | Indicates if the follow-up action was completedoptional | false |
Use it for
A telecommunications dashboard
The churn_
flag rate, customer_ tenure_ months by customer_ segment and a breakdown of agent_ id. Excel, Power BI or Tableau. Why do the 19 premium rows have a mean customer_
tenure_ months of 52.3? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Customers65CUST1000134premiumCUST1000315basicCUST100107basic
A software demo
Believable customers with call_
id, call_ datetime and call_ duration_ seconds to fill a screen in front of a buyer.
blueprint · customer-churn-call-reason-analysis
Behind this dataset
Same schema. As many rows as you need.
These 65 rows came out of a blueprint — 19 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.
- Log churn call date and reason
- Record customer ID and contract type
- Flag preventable reasons (e.g. service issues)
- Aggregate by churn reason category
- Summarize churn rates monthly
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
- customer-churn-call-reason-analysis