Telecom Customer Billing Disputes
This dataset provides detailed, structured records of telecom customer billing disputes, including dispute reasons, resolution outcomes, time to resolution, and agent involvement. It enables telecom providers to analyze dispute trends, automate billing issue workflows, and improve customer service processes. The dataset is ideal for process optimization, root cause analysis, and training AI-driven support systems.
Sample rows
preview · 8 of 200 rows · all 16 columns| dispute_idstring | dispute_statusstring | disputed_amountfloat | resolution_outcomestring | customer_idstring | account_numberstring | dispute_opened_datetimedatetime | dispute_closed_datetimedatetime | dispute_reason_categorystring | resolved_amountfloat | resolved_by_agent_idstring | resolution_time_hoursfloat | customer_contact_methodstring | customer_regionstring | dispute_reason_detailstring | resolution_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DPT-000001 | Closed | 47.89 | Approved | CUST-1001 | ACC-34012 | 2021-02-14T10:25:48Z | 2021-02-17T11:35:22Z | Overcharge | 47.89 | AGENT-12 | 73.16 | Web Portal | Urban | Customer claims they were billed for an international plan not requested. | Full refund issued for incorrect international plan charge. |
| DPT-000002 | Open | 28.5 | blank | CUST-1002 | ACC-55829 | 2023-07-22T09:08:13Z | blank | Incorrect Plan | blank | blank | blank | Northeast | Plan changed without authorization, higher monthly rate applied. | blank | |
| DPT-000003 | Resolved | 19.99 | Partial Refund | CUST-1003 | ACC-34012 | 2022-11-18T13:44:19Z | 2022-11-28T09:12:46Z | Service Not Provided | 10 | AGENT-07 | 230.48 | Phone | Midwest | Reported paid for premium channel, never activated. | Refunded half the disputed amount; service now active. |
| DPT-000004 | In Progress | 24.75 | blank | CUST-1004 | ACC-90123 | 2020-04-03T16:30:10Z | blank | Payment Not Applied | blank | blank | blank | Phone | South | Recent payment not reflected in latest bill. | blank |
| DPT-000005 | Closed | 12 | Adjusted | CUST-1005 | ACC-88173 | 2022-09-15T18:12:57Z | 2022-09-16T09:55:41Z | Other | 12 | AGENT-02 | 15.71 | Suburban | Customer states loyalty discount not applied as promised. | Account credited for missing loyalty discount. | |
| DPT-000006 | Closed | 22.4 | Denied | CUST-1006 | ACC-20988 | 2021-12-01T20:45:03Z | 2021-12-02T09:00:00Z | Overcharge | 0 | AGENT-17 | 12.25 | Web Portal | Urban | Charged for data overage, but usage below cap. | Usage confirmed above threshold; charge stands. |
| DPT-000007 | Escalated | 35 | blank | CUST-1007 | ACC-63742 | 2022-03-21T07:15:20Z | blank | Service Not Provided | blank | blank | blank | In-Person | Rural | Internet connectivity never restored after outage. | blank |
| DPT-000008 | Closed | 18.6 | Approved | CUST-1008 | ACC-12994 | 2020-10-12T14:11:50Z | 2020-10-12T15:05:12Z | Payment Not Applied | 18.6 | AGENT-04 | 0.89 | Phone | Northeast | blank | Payment located and applied; late fee waived. |
| DPT-000009 | Open | 39.99 | blank | CUST-1009 | ACC-33556 | 2023-03-02T19:44:57Z | blank | Overcharge | blank | blank | blank | Web Portal | West Coast | Billed twice for the same month. | blank |
| DPT-000010 | Resolved | 7.99 | Approved | CUST-1010 | ACC-88321 | 2024-01-08T13:03:13Z | 2024-01-12T16:45:00Z | Overcharge | 7.99 | AGENT-20 | 99.7 | Urban | Extra charges for streaming services not added. | Streaming service fees credited after investigation. | |
| DPT-000011 | Closed | 15.25 | Partial Refund | CUST-1011 | ACC-55829 | 2021-08-30T17:29:00Z | 2021-09-01T11:40:10Z | Incorrect Plan | 7.5 | AGENT-05 | 42.19 | Web Portal | Urban | Plan downgrade did not update, charged premium rate. | Partial refund for two days at incorrect rate. |
| DPT-000012 | Open | 3.45 | blank | CUST-1012 | ACC-40111 | 2023-12-19T20:22:34Z | blank | Other | blank | blank | blank | Other | West Coast | Roaming charges applied while not traveling. | blank |
| DPT-000013 | Closed | 28 | Adjusted | CUST-1013 | ACC-10101 | 2022-04-05T13:12:00Z | 2022-05-01T17:44:30Z | Incorrect Plan | 28 | AGENT-01 | 637.54 | Midwest | Charged for family plan after switching to individual. | Account updated; refund processed for plan difference. | |
| DPT-000014 | In Progress | 13.1 | blank | CUST-1014 | ACC-88321 | 2020-07-19T11:19:00Z | blank | Payment Not Applied | blank | blank | blank | Phone | Midwest | Auto-pay processed, but balance shows overdue. | blank |
| DPT-000015 | Closed | 2.99 | Withdrawn | CUST-1015 | ACC-23742 | 2022-10-20T17:30:00Z | 2022-10-20T19:15:49Z | Overcharge | 0 | AGENT-08 | 1.76 | Web Portal | South | blank | Customer withdrew dispute after clarification. |
| DPT-000016 | Open | 6 | blank | CUST-1016 | ACC-45132 | 2023-01-10T12:07:32Z | blank | Other | blank | blank | blank | Suburban | Requested paperless billing, still being charged for paper statements. | blank | |
| DPT-000017 | Resolved | 54.2 | Partial Refund | CUST-1017 | ACC-56301 | 2021-05-22T09:22:11Z | 2021-05-25T10:11:00Z | Service Not Provided | 27.1 | AGENT-11 | 72.82 | Web Portal | Northeast | Paid for faster internet, speed not increased. | Partial compensation for two weeks of service issues. |
| DPT-000018 | In Progress | 11 | blank | CUST-1018 | ACC-23015 | 2023-09-12T13:14:23Z | blank | Payment Not Applied | blank | blank | blank | Phone | Midwest | blank | blank |
| DPT-000019 | Closed | 0.99 | Denied | CUST-1019 | ACC-97001 | 2021-04-16T08:20:48Z | 2021-04-16T08:50:17Z | Other | 0 | AGENT-16 | 0.49 | Other | Corporate | International call block not applied. | Service confirmed active for international calls. |
| DPT-000020 | Closed | 16.5 | Approved | CUST-1020 | ACC-56301 | 2021-06-06T06:35:15Z | 2021-06-09T09:32:18Z | Overcharge | 16.5 | AGENT-09 | 74.95 | Urban | Roaming charges applied in home region. | Roaming charges removed; system issue confirmed. |
What the 200 rows show
from the 200-row sample- 17.0median disputed_
amount - 5dispute reason categories
- 5customer contact methods
- 8customer regions
- 22resolved by agents
- 10.0median resolved_
amount
Median 17.0, from 0.01 to 3,251.
- string 11
- float 3
- datetime 2
Columns
16 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
dispute_id | string | Unique identifier for each billing dispute recordunique | DPT-000001 |
customer_id | string | Unique identifier for the customer who raised the dispute | CUST-1001 |
account_number | string | Customer's telecom account number associated with the dispute | ACC-34012 |
dispute_status | string | Current status of the dispute (e.g., Open, In Progress, Resolved, Closed, Escalated)Open · In Progress · Resolved · Closed · Escalated | Closed |
dispute_reason_category | string | High-level category of the billing dispute (e.g., Overcharge, Service Not Provided, Incorrect Plan, Payment Not Applied, Other)5 values | Overcharge |
dispute_reason_detail | string | Detailed description of the dispute provided by the customer or agentoptional | Customer claims they were… |
resolution_outcome | string | Outcome of the dispute resolution (e.g., Approved, Denied, Partial Refund, Adjusted, Escalated, Withdrawn)7 values · optional | Approved |
resolution_notes | string | Additional notes or comments regarding the resolution processoptional | Tax overcharge refunded. |
resolved_by_agent_id | string | Identifier of the customer service agent who resolved or closed the disputeoptional | AGENT-12 |
customer_contact_method | string | Primary method used by the customer to initiate the dispute (e.g., Phone, Email, Web Portal, In-Person)Phone · Email · Web Portal · In-Person · Other · optional | Web Portal |
customer_region | string | Geographical region or market segment of the customer (e.g., Northeast, Midwest, Urban, Rural)8 regions · optional | Urban |
| Numbers 3 columns | |||
disputed_amount | float | Amount in dispute, as claimed by the customer0 or more | 47.89 |
resolved_amount | float | Final amount credited, refunded, or adjusted after resolution0 or more · optional | 47.89 |
resolution_time_hours | float | Total time taken to resolve the dispute, in hours0 or more · optional | 73.16 |
| Dates and times 2 columns | |||
dispute_opened_datetime | datetime | Date and time when the dispute was initially logged | 2021-02-14T10:25:48Z |
dispute_closed_datetime | datetime | Date and time when the dispute was resolved or closedoptional | 2021-02-17T11:35:22Z |
Use it for
A telecommunications dashboard
Disputed_
amount by dispute_ status and a breakdown of resolution_ outcome. Excel, Power BI or Tableau. What pattern can you find in 200 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 200 rows.
- Disputes200DPT-00000147.89ClosedDPT-00000228.5OpenDPT-00000319.99Resolved
A software demo
Believable disputes with customer_
id, account_ number and dispute_ opened_ datetime to fill a screen in front of a buyer.
This dataset200 rows16 columns
Yours1,000 rows16 columnscustomer_region: UK only
blueprint · telecom-customer-billing-disputes
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 16 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
- Disputes linked to account and invoice
- Resolution types categorized
- Resolution times in business days
- Repeat dispute rates tracked
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-billing-disputes