Telecom Support Ticket Resolution Data
This dataset provides detailed records of telecom customer support tickets, including issue types, resolution timelines, agent actions, and customer satisfaction ratings. It enables process optimization, root cause analysis, and AI/ML chatbot training by offering granular insights into ticket lifecycles and outcomes.
Sample rows
preview · 8 of 200 rows · all 22 columns| ticket_idstring | prioritystring | resolution_time_hoursfloat | ticket_escalatedboolean | resolved_by_agent_idstring | customer_idstring | customer_namestring | customer_emailstring | customer_phonestring | service_typestring | issue_categorystring | ticket_statusstring | created_datetimedatetime | first_response_datetimedatetime | resolved_datetimedatetime | agent_namestring | customer_satisfaction_ratinginteger | follow_up_requiredboolean | follow_up_datetimedatetime | issue_descriptionstring | resolution_summarystring | escalation_reasonstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TCKT_001A7B | high | 2.83 | false | AGT_101 | CUST_8901A | Emily Anderson | emily.anderson@ | +1-202-555-0127 | mobile | network | resolved | 2024-05-14T10:15:00Z | 2024-05-14T10:25:00Z | 2024-05-14T13:05:00Z | Sophie Turner | 5 | false | blank | Customer is experiencing frequent call drops in the downtown area. | Network tower reset performed and signal strength improved. | blank |
| TCKT_002B8F | medium | 6.42 | false | AGT_104 | CUST_2349B | Michael Young | michael.young@ | +1-312-555-0183 | broadband | billing | closed | 2024-05-15T09:45:00Z | 2024-05-15T10:05:00Z | 2024-05-15T16:10:00Z | Rajiv Kumar | 5 | false | blank | Customer was charged for an inactive broadband service. | Refund processed for incorrect billing charge. | blank |
| TCKT_003C4H | urgent | blank | true | blank | CUST_5637C | Ana Rodriguez | ana.rodriguez@ | +44 20 7946 0892 | fiber | technical | pending | 2024-05-16T08:10:00Z | 2024-05-16T08:30:00Z | blank | blank | blank | false | blank | Fiber internet connection drops every evening around 8pm. | blank | Recurring outages detected; escalated to field engineering team for onsite investigation. |
| TCKT_004D9K | medium | 1.58 | false | AGT_102 | CUST_2349B | Michael Young | michael.young@ | +1-312-555-0183 | mobile | device | resolved | 2024-05-17T11:20:00Z | 2024-05-17T11:32:00Z | 2024-05-17T12:55:00Z | Laura Chen | 4 | false | blank | SIM card not detected after device update. | SIM card replaced and device updated to latest firmware. | blank |
| TCKT_005E2J | low | blank | false | blank | CUST_8890D | Robert Lee | robert.lee@ | +61 3 9123 4567 | tv | network | open | 2024-05-17T16:10:00Z | blank | blank | blank | blank | false | blank | TV service pixelates during peak hours, signal is unstable. | blank | blank |
| TCKT_006F5M | medium | 3.78 | false | AGT_104 | CUST_1907E | Jessica White | jessica.white@ | +1-718-555-0172 | broadband | account | resolved | 2024-05-18T10:20:00Z | 2024-05-18T10:32:00Z | 2024-05-18T14:17:00Z | Rajiv Kumar | 5 | false | blank | Unable to access online account portal for broadband services. | Password reset and portal access re-enabled for the customer. | blank |
| TCKT_007G1Q | high | blank | false | blank | CUST_5637C | Ana Rodriguez | ana.rodriguez@ | +44 20 7946 0892 | fiber | technical | pending | 2024-05-18T17:22:00Z | 2024-05-18T17:36:00Z | blank | blank | blank | true | 2024-05-19T17:00:00Z | Customer reports slow fiber speeds during weekends. | blank | blank |
| TCKT_008H8R | low | blank | false | blank | CUST_3401F | Sarah Kim | sarah.kim@ | +1-415-555-0134 | landline | account | open | 2024-05-19T08:05:00Z | blank | blank | blank | blank | false | blank | Customer requests update on address for landline billing. | blank | blank |
| TCKT_009K8S | medium | 1.75 | false | AGT_105 | CUST_8901A | Emily Anderson | emily.anderson@ | +1-202-555-0127 | mobile | device | resolved | 2024-05-19T12:00:00Z | 2024-05-19T12:20:00Z | 2024-05-19T13:45:00Z | Daniel Evans | 4 | false | blank | Mobile device unable to connect to 5G network. | Device settings updated and 5G connectivity restored. | blank |
| TCKT_010M3T | urgent | blank | true | blank | CUST_1907E | Jessica White | jessica.white@ | +1-718-555-0172 | broadband | billing | escalated | 2024-05-20T09:40:00Z | 2024-05-20T09:54:00Z | blank | blank | blank | true | 2024-05-22T09:00:00Z | Customer disputes recent broadband invoice charges. | blank | Billing dispute could not be resolved at Tier 1; escalated to billing specialist. |
| TCKT_011N7U | low | 2.88 | false | AGT_103 | CUST_8890D | Robert Lee | robert.lee@ | +61 3 9123 4567 | tv | technical | resolved | 2024-05-20T15:00:00Z | 2024-05-20T15:12:00Z | 2024-05-20T17:55:00Z | Fatima Zahra | 5 | false | blank | TV remote control not pairing with set-top box. | Remote reprogrammed and set-top box rebooted successfully. | blank |
| TCKT_012P4V | high | blank | false | blank | CUST_2365G | David Martinez | david.martinez@ | +1-305-555-0149 | fiber | network | pending | 2024-05-21T08:25:00Z | 2024-05-21T08:39:00Z | blank | blank | blank | true | 2024-05-22T10:00:00Z | Fiber connection is intermittent during rainstorms. | blank | blank |
| TCKT_013Q9W | medium | 2.22 | false | AGT_102 | CUST_3401F | Sarah Kim | sarah.kim@ | +1-415-555-0134 | landline | technical | resolved | 2024-05-21T12:12:00Z | 2024-05-21T12:32:00Z | 2024-05-21T14:25:00Z | Laura Chen | 5 | false | blank | Landline static noise present during calls. | Technician replaced faulty wiring causing interference. | blank |
| TCKT_014R6X | medium | blank | false | blank | CUST_4821H | Kelvin Wright | kelvin.wright@ | +1-212-555-0100 | mobile | billing | open | 2024-05-22T09:55:00Z | 2024-05-22T10:14:00Z | blank | blank | blank | false | blank | Customer requests waiver for roaming charges. | blank | blank |
| TCKT_015S2Y | urgent | 1.1 | false | AGT_101 | CUST_5637C | Ana Rodriguez | ana.rodriguez@ | +44 20 7946 0892 | fiber | network | resolved | 2024-05-22T15:11:00Z | 2024-05-22T15:20:00Z | 2024-05-22T16:17:00Z | Sophie Turner | 5 | false | blank | No internet connectivity since last night’s outage. | ISP outage resolved, service restored. | blank |
| TCKT_016T1Z | low | blank | false | blank | CUST_2365G | David Martinez | david.martinez@ | +1-305-555-0149 | tv | account | open | 2024-05-22T19:00:00Z | blank | blank | blank | blank | false | blank | Customer needs to update payment method for TV subscription. | blank | blank |
| TCKT_017U7A | high | 2.43 | false | AGT_105 | CUST_1907E | Jessica White | jessica.white@ | +1-718-555-0172 | broadband | technical | resolved | 2024-05-23T08:35:00Z | 2024-05-23T08:45:00Z | 2024-05-23T11:01:00Z | Daniel Evans | 4 | true | 2024-05-24T11:00:00Z | Broadband modem keeps disconnecting every hour. | Modem firmware updated and connection stabilized. | blank |
| TCKT_018V1B | low | blank | false | blank | CUST_7722J | Linda Patel | linda.patel@ | +1-415-555-0191 | mobile | other | open | 2024-05-23T13:50:00Z | blank | blank | blank | blank | false | blank | Customer requests upgrade eligibility information. | blank | blank |
| TCKT_019W3C | medium | blank | false | blank | CUST_4821H | Kelvin Wright | kelvin.wright@ | +1-212-555-0100 | mobile | network | pending | 2024-05-24T10:45:00Z | 2024-05-24T10:59:00Z | blank | blank | blank | false | blank | Mobile data speeds are low in rural area. | blank | blank |
| TCKT_020X9D | low | 1 | false | AGT_103 | CUST_3401F | Sarah Kim | sarah.kim@ | +1-415-555-0134 | landline | billing | resolved | 2024-05-24T17:35:00Z | 2024-05-24T17:53:00Z | 2024-05-24T18:35:00Z | Fatima Zahra | 5 | false | blank | Customer requests explanation for landline invoice. | Provided itemized bill and explained charges. | blank |
What the 200 rows show
from the 200-row sampleUrgent priority stands out: 13 of its 22 rows have ticket_
- 13%ticket_
escalated = true - 1.7median resolution_
time_ hours - 5service types
- 5ticket statuses
- 6issue categories
- 23agent names
Median 1.7, from 0.39 to 19.5.
- string 14
- integer 1
- float 1
- datetime 4
- boolean 2
Columns
22 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
ticket_id | string | Unique identifier for each support ticketunique | TCKT_001A7B |
customer_id | string | Unique identifier for the customer who raised the ticket | CUST_8901A |
customer_name | string | Full name of the customer | Emily Anderson |
customer_email | string | Email address of the customer | noah.lee@ |
customer_phone | string | Contact phone number of the customeroptional | +1-202-555-0127 |
service_type | string | Type of telecom service (e.g., mobile, broadband, landline)mobile · broadband · landline · fiber · tv | mobile |
issue_category | string | General category of the reported issue6 values | network |
issue_description | string | Detailed description of the customer's issue | Customer is experiencing … |
ticket_status | string | Current status of the support ticketopen · pending · resolved · closed · escalated | resolved |
priority | string | Priority level assigned to the ticketlow · medium · high · urgent | high |
resolution_summary | string | Summary of the resolution provided to the customeroptional | Network tower reset perfo… |
resolved_by_agent_id | string | Unique identifier for the support agent who resolved the ticketoptional | AGT_101 |
agent_name | string | Name of the support agent who resolved the ticketoptional | Sophie Turner |
escalation_reason | string | Reason for ticket escalation, if applicableoptional | Recurring outages detecte… |
| Numbers 2 columns | |||
resolution_time_hours | float | Total time taken to resolve the ticket, in hours0 or more · optional | 2.83 |
customer_satisfaction_rating | integer | Customer satisfaction rating after ticket resolution (1-5 scale)1 to 5 · optional | 5 |
| Dates and times 4 columns | |||
created_datetime | datetime | Date and time when the ticket was created | 2024-05-14T10:15:00Z |
first_response_datetime | datetime | Date and time when the first support response was madeoptional | 2024-05-14T10:25:00Z |
resolved_datetime | datetime | Date and time when the ticket was marked as resolvedoptional | 2024-05-14T13:05:00Z |
follow_up_datetime | datetime | Scheduled date and time for follow-up, if requiredoptional | 2024-05-19T17:00:00Z |
| True or false 2 columns | |||
follow_up_required | boolean | Indicates if a follow-up action is required after resolutionoptional | false |
ticket_escalated | boolean | Indicates if the ticket was escalated during its lifecycleoptional | false |
Use it for
A telecommunications dashboard
The ticket_
escalated rate, resolution_ time_ hours by priority and a breakdown of resolved_ by_ agent_ id. Excel, Power BI or Tableau. Why do 25 of 200 rows have ticket_
escalated = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Tickets200TCKT_001A7B2.83highTCKT_003C4HurgentTCKT_010M3Turgent
A software demo
Believable tickets with customer_
id, customer_ name and customer_ email to fill a screen in front of a buyer.
blueprint · telecom-support-ticket-resolution-data
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 22 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.
- Ticket includes issue type and timestamp
- Resolution times in minutes
- Unresolved tickets flagged
- Customer feedback score included
- Duplicate tickets removed
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- telecom-support-ticket-resolution-data