Customer Support Ticket Resolution
This dataset provides comprehensive logs of customer support tickets, including detailed issue descriptions, resolution times, outcomes, agent involvement, and customer satisfaction ratings. It enables analysis of support process efficiency, identification of bottlenecks, and development of NLP models for automated ticket classification and resolution prediction.
Sample rows
preview · 8 of 200 rows · all 17 columns| ticket_idstring | resolution_outcomestring | resolution_time_hoursfloat | follow_up_requiredboolean | ticket_statusstring | customer_idstring | customer_namestring | customer_emailstring | ticket_created_atdatetime | ticket_closed_atdatetime | issue_categorystring | resolved_by_agent_idstring | resolved_by_agent_namestring | customer_satisfaction_ratinginteger | priority_levelstring | issue_descriptionstring | resolution_summarystring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ABZ71QJ8 | unresolved | blank | true | open | CUST001 | Javier Martinez | jmartinez@ | 2024-03-01T09:14:00Z | blank | billing | blank | blank | blank | high | Invoice amount appears incorrect for March, please clarify charges. | blank |
| K7Q2LMNP | resolved | 0.75 | false | resolved | CUST002 | Samantha Lee | sam.lee@ | 2024-03-02T15:20:00Z | 2024-03-02T16:05:00Z | account | AGT101 | Priya Patel | 5 | medium | Cannot reset password, link expired before use. | Password reset link regenerated and sent successfully. |
| 3FZ7QW8T | unresolved | blank | true | pending | CUST003 | Ahmed Al-Sayed | ahmed@ | 2024-03-02T11:45:00Z | blank | billing | blank | blank | blank | urgent | Refund not processed for cancelled subscription. | blank |
| XQ8V4JLK | resolved | 26.88 | false | closed | CUST004 | Anna Kowalska | a.kowalska@ | 2024-03-03T10:22:00Z | 2024-03-04T13:15:00Z | account | AGT104 | David Kim | 4 | low | Unable to update mailing address on profile page. | Manual update performed in backend, customer notified. |
| P4H8LQW2 | unresolved | blank | true | open | CUST005 | Chloe Zhang | chloe.zhang@ | 2024-03-04T09:00:00Z | blank | billing | blank | blank | blank | high | Recurring payment charged twice for same month. | blank |
| N9K3XTR6 | resolved | 5.5 | false | resolved | CUST006 | Lucas Ferrari | lucas.ferrari@ | 2024-03-04T13:10:00Z | 2024-03-04T18:40:00Z | technical | AGT105 | Maria Garcia | 5 | high | App crashes during login on Android devices. | Latest app update resolved login crash issue. |
| R8M1QJ2P | resolved | 21.75 | false | closed | CUST007 | Olga Ivanova | ivanova.olga@ | 2024-03-05T11:45:00Z | 2024-03-06T09:30:00Z | account | AGT109 | Chen Li | 4 | medium | Two-factor authentication not working after phone update. | 2FA reset and tested for customer, issue resolved. |
| WB8N7KQ2 | escalated | blank | true | escalated | CUST008 | John Smith | john.smith@ | 2024-03-05T14:00:00Z | blank | technical | blank | blank | blank | urgent | Network connectivity issues at branch locations. | blank |
| B7V1GQ3K | resolved | 0.75 | false | resolved | CUST009 | Fatima Rahman | fatima.rahman@ | 2024-03-05T16:15:00Z | 2024-03-05T17:00:00Z | account | AGT112 | James O'Brien | 5 | medium | Unable to set up email notifications for transactions. | Notification settings enabled and verified with customer. |
| M9Q4LZJ2 | unresolved | blank | true | pending | CUST010 | David Müller | d.muller@ | 2024-03-06T08:35:00Z | blank | billing | blank | blank | blank | urgent | Credit card not accepted for subscription renewal. | blank |
| L3P5H7QK | resolved | 3.33 | false | resolved | CUST011 | Mia Chen | mia.chen@ | 2024-03-06T11:00:00Z | 2024-03-06T14:20:00Z | technical | AGT115 | Emily Nguyen | 4 | high | Website loading slowly on mobile browsers. | Optimized server settings to improve mobile site speed. |
| J1V7QG5M | unresolved | blank | true | open | CUST012 | Carlos Silva | carlos.silva@ | 2024-03-07T07:50:00Z | blank | billing | blank | blank | blank | high | Tax calculation on invoice is incorrect for Brazil. | blank |
| Q7X1R2LK | resolved | 0.33 | false | closed | CUST013 | Ava Wood | ava.wood@ | 2024-03-07T12:30:00Z | 2024-03-07T12:50:00Z | account | AGT120 | Sophie Laurent | 5 | low | Username change request for personal reasons. | Username successfully updated as requested. |
| F8K2L9QW | resolved | 27.25 | false | closed | CUST014 | Hiroshi Tanaka | hiroshi.tanaka@ | 2024-03-07T15:10:00Z | 2024-03-08T18:25:00Z | technical | AGT125 | Alex Johnson | 5 | high | File upload fails intermittently during peak hours. | Server resources scaled up to handle peak traffic. |
| V4W8M1QK | escalated | blank | true | escalated | CUST015 | Isabelle Dupont | isabelle.dupont@ | 2024-03-08T09:20:00Z | blank | technical | blank | blank | blank | urgent | Critical system outage affecting all users. | blank |
| S5J9QK8N | resolved | 0.17 | false | closed | CUST016 | George Brown | george.brown@ | 2024-03-08T13:00:00Z | 2024-03-08T13:10:00Z | account | AGT130 | Linda Becker | 4 | medium | Cannot access archived invoices from last year. | Archived invoices restored to customer portal. |
| H2M5QK7V | resolved | 0.18 | false | resolved | CUST017 | Sofia Rossi | sofia.rossi@ | 2024-03-09T10:35:00Z | 2024-03-09T10:46:00Z | account | AGT133 | Nina Petrova | 5 | medium | Account locked after multiple failed login attempts. | Account unlocked and password reset for customer. |
| T8N3QW2L | unresolved | blank | true | open | CUST018 | Mohammed El-Masry | m.elmasry@ | 2024-03-09T12:10:00Z | blank | billing | blank | blank | blank | high | Annual plan renewal charged at wrong price. | blank |
| Z6Q1P8JL | resolved | 3.67 | false | resolved | CUST019 | Emily Williams | emily.williams@ | 2024-03-10T08:30:00Z | 2024-03-10T12:10:00Z | technical | AGT137 | Victor Lee | 4 | high | Unable to download reports from dashboard. | Report download functionality fixed for all accounts. |
| E1K5QW9L | unresolved | blank | true | pending | CUST020 | Yusuf Demir | yusuf.demir@ | 2024-03-10T14:15:00Z | blank | billing | blank | blank | blank | urgent | Subscription cancelled but still being charged. | blank |
What the 200 rows show
from the 200-row sampleUnresolved (resolution outcome) stands out: 69 of its 69 rows have follow_
- 46%follow_
up_ required = true - 0.93median resolution_
time_ hours - 3issue categories
- 4priority levels
- 5median customer_
satisfaction_ rating
Median 0.93, from 0.0 to 75.4.
- string 12
- integer 1
- float 1
- datetime 2
- boolean 1
Columns
17 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
ticket_id | string | Unique identifier for the support ticketunique | ABZ71QJ8 |
customer_id | string | Unique identifier for the customer who raised the ticket | CUST001 |
customer_name | string | Full name of the customer | Javier Martinez |
customer_email | string | Email address of the customer | jmartinez@ |
ticket_status | string | Current status of the ticketopen · pending · resolved · closed · escalated | open |
issue_category | string | Category of the issue reported (e.g., billing, technical, account)3 categories | billing |
issue_description | string | Detailed description of the issue provided by the customer | Invoice amount appears in… |
resolution_summary | string | Summary of how the issue was resolvedoptional | Password reset link regen… |
resolved_by_agent_id | string | Identifier for the support agent who resolved the ticketoptional | AGT101 |
resolved_by_agent_name | string | Full name of the support agent who resolved the ticketoptional | Priya Patel |
resolution_outcome | string | Outcome of the ticket resolutionresolved · unresolved · escalated · duplicate · invalid | unresolved |
priority_level | string | Priority assigned to the ticketlow · medium · high · urgent | high |
| Numbers 2 columns | |||
resolution_time_hours | float | Total time taken to resolve the ticket, in hours0 or more · optional | 0.75 |
customer_satisfaction_rating | integer | Customer's satisfaction rating after resolution (1-5)1 to 5 · optional | 5 |
| Dates and times 2 columns | |||
ticket_created_at | datetime | Timestamp when the ticket was created | 2024-03-01T09:14:00Z |
ticket_closed_at | datetime | Timestamp when the ticket was resolved or closedoptional | 2024-03-02T16:05:00Z |
| True or false 1 column | |||
follow_up_required | boolean | Indicates if a follow-up is required for this ticketoptional | true |
Use it for
A technology dashboard
The follow_
up_ required rate, resolution_ time_ hours by resolution_ outcome and a breakdown of ticket_ status. Excel, Power BI or Tableau. Why do 91 of 200 rows have follow_
up_ required = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Tickets200ABZ71QJ8unresolv…K7Q2LMNP0.75resolved3FZ7QW8Tunresolv…
A software demo
Believable tickets with customer_
id, customer_ name and customer_ email to fill a screen in front of a buyer.
blueprint · customer-support-ticket-resolution
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.
- Ticket type selected from 10 categories
- Resolution time 5m-5d
- Status: resolved, escalated, pending
- Customer satisfaction score 1-5
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
- customer-support-ticket-resolution