Tech Support Ticket Analytics
This dataset provides comprehensive logs of tech support tickets, including customer and agent details, ticket lifecycle events, escalation history, and resolution outcomes. It enables technology firms to analyze support processes, optimize resource allocation, and improve customer satisfaction through actionable insights.
Sample rows
preview · 8 of 200 rows · all 19 columns| ticket_idstring | resolution_outcomestring | customer_satisfaction_scorefloat | follow_up_requiredboolean | assigned_agent_idstring | customer_idstring | customer_namestring | customer_emailstring | ticket_created_datetimedatetime | ticket_closed_datetimedatetime | issue_categorystring | prioritystring | statusstring | assigned_agent_namestring | escalatedboolean | escalation_levelstring | escalation_datetimedatetime | issue_descriptionstring | resolution_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TCKT-10001 | resolved | 4.7 | false | AGT-201 | CUST-303 | Samantha Lee | samantha.lee@ | 2024-03-01T09:15:23 | 2024-03-02T10:45:00 | software | high | resolved | Brian Carter | false | none | blank | Application crashes upon startup after latest update. | Patched software and guided customer through update process. |
| TCKT-10002 | blank | blank | blank | blank | CUST-308 | Rajesh Kumar | rkumar@ | 2024-03-01T12:30:11 | blank | network | medium | open | blank | false | none | blank | Unable to connect to corporate VPN from home. | blank |
| TCKT-10003 | blank | blank | true | AGT-209 | CUST-317 | Emily Foster | emily.foster@ | 2024-03-02T14:06:34 | blank | hardware | high | pending | Linda Nguyen | false | none | blank | Laptop keyboard is not responding intermittently. | blank |
| TCKT-10004 | resolved | 5 | false | AGT-202 | CUST-304 | Peter Wilson | peterwilson@ | 2024-03-03T08:26:19 | 2024-03-03T09:10:35 | software | urgent | resolved | Carla Gomez | false | none | blank | Cannot access dashboard after password reset. | Reset password and verified dashboard access. |
| TCKT-10005 | blank | blank | blank | blank | CUST-310 | Mohammed Al-Sayed | mohammed.sayed@ | 2024-03-04T16:45:02 | blank | billing | medium | open | blank | false | none | blank | Charged twice for subscription renewal. | blank |
| TCKT-10006 | workaround | 3.8 | true | AGT-203 | CUST-315 | Jessica Chang | jessica.chang@ | 2024-03-05T11:19:55 | 2024-03-06T10:25:17 | hardware | high | closed | Tom Harris | false | none | blank | Monitor flickers during use. | Suggested external adapter; awaiting replacement. |
| TCKT-10007 | resolved | 4.1 | false | AGT-204 | CUST-306 | Felipe Souza | fsouza@ | 2024-03-05T13:33:22 | 2024-03-05T15:01:09 | network | medium | resolved | Natalie Brooks | false | none | blank | Frequent Wi-Fi drops in office. | Restarted router and updated firmware. |
| TCKT-10008 | blank | blank | blank | blank | CUST-311 | Olga Petrova | olga.petrova@ | 2024-03-06T08:12:42 | blank | billing | low | open | blank | false | none | blank | Invoice not received for last month. | blank |
| TCKT-10009 | resolved | 4.9 | false | AGT-205 | CUST-318 | Lucas Miller | lucas.miller@ | 2024-03-06T12:55:30 | 2024-03-07T09:10:25 | software | high | resolved | Helen Stewart | true | tier 2 | 2024-03-06T20:02:12 | Error message when exporting reports. | Fixed export function and tested with customer. |
| TCKT-10010 | resolved | 4.2 | false | AGT-206 | CUST-303 | Samantha Lee | samantha.lee@ | 2024-03-07T10:17:44 | 2024-03-07T16:32:18 | hardware | medium | closed | Paul Kim | false | none | blank | Printer not connecting to network. | Reconfigured printer network settings. |
| TCKT-10011 | blank | blank | blank | blank | CUST-309 | David Martinez | david.martinez@ | 2024-03-07T11:47:01 | blank | network | low | open | blank | false | none | blank | Slow internet speed in remote office. | blank |
| TCKT-10012 | resolved | 4.6 | false | AGT-205 | CUST-314 | Eva Green | eva.green@ | 2024-03-07T15:30:45 | 2024-03-08T08:14:02 | software | high | resolved | Helen Stewart | false | none | blank | Unable to save files in document editor. | Identified permissions issue and updated settings. |
| TCKT-10013 | blank | blank | true | blank | CUST-307 | Mariana Costa | mariana.costa@ | 2024-03-08T09:22:18 | blank | billing | medium | open | blank | false | none | blank | Credit card declined for payment. | blank |
| TCKT-10014 | resolved | 4.5 | false | AGT-207 | CUST-312 | John Smith | john.smith@ | 2024-03-08T11:34:50 | 2024-03-09T10:12:35 | hardware | medium | closed | Emily Watson | true | tier 2 | 2024-03-08T16:20:10 | Laptop fan is making loud noise. | Cleaned fan and updated BIOS. |
| TCKT-10015 | resolved | 4.8 | false | AGT-208 | CUST-316 | Sara Johansson | sara.johansson@ | 2024-03-09T13:03:31 | 2024-03-09T15:25:00 | software | high | resolved | Michael Chen | false | none | blank | License expired before renewal date. | Renewed license and verified activation. |
| TCKT-10016 | blank | blank | blank | blank | CUST-303 | Samantha Lee | samantha.lee@ | 2024-03-10T10:23:19 | blank | other | low | open | blank | false | none | blank | Inquiry about warranty coverage. | blank |
| TCKT-10017 | resolved | 4.3 | false | AGT-209 | CUST-308 | Rajesh Kumar | rkumar@ | 2024-03-10T12:17:04 | 2024-03-10T16:08:22 | billing | medium | closed | Linda Nguyen | false | none | blank | Refund not received for cancelled service. | Processed refund through finance department. |
| TCKT-10018 | blank | blank | false | AGT-210 | CUST-314 | Eva Green | eva.green@ | 2024-03-11T08:49:51 | blank | software | low | pending | Anthony King | false | none | blank | Popup warnings during normal usage. | blank |
| TCKT-10019 | resolved | 4.1 | false | AGT-202 | CUST-315 | Jessica Chang | jessica.chang@ | 2024-03-11T10:12:30 | 2024-03-11T12:59:22 | hardware | high | resolved | Carla Gomez | true | tier 3 | 2024-03-11T11:15:56 | USB ports not working after update. | Rolled back update and verified hardware functionality. |
| TCKT-10020 | blank | blank | true | blank | CUST-309 | David Martinez | david.martinez@ | 2024-03-12T09:07:48 | blank | network | medium | open | blank | false | none | blank | Unable to access shared drive from remote location. | blank |
What the 200 rows show
from the 200-row sampleWorkaround (resolution outcome) stands out: 12 of its 20 rows have follow_
- 20%follow_
up_ required = true - 4.3median customer_
satisfaction_ score - 4priorities
- 5issue categories
- 5statuses
- 5escalation levels
Workaround (resolution outcome)'s mean customer_
Median 4.3, from 2.5 to 5.0.
- string 13
- float 1
- datetime 3
- boolean 2
Columns
19 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
ticket_id | string | Unique identifier for each support ticketunique | TCKT-10001 |
customer_id | string | Unique identifier for the customer who raised the ticket | CUST-303 |
customer_name | string | Full name of the customeroptional | Samantha Lee |
customer_email | string | Email address of the customeroptional | samantha.lee@ |
issue_category | string | General category of the issue (e.g., software, hardware, billing)software · hardware · billing · network · other | software |
issue_description | string | Detailed description of the customer's issue | Cannot reset password. |
priority | string | Priority level assigned to the ticketlow · medium · high · urgent | high |
status | string | Current status of the ticketopen · pending · resolved · closed · escalated | resolved |
assigned_agent_id | string | Unique identifier for the support agent assigned to the ticketoptional | AGT-201 |
assigned_agent_name | string | Full name of the support agent assigned to the ticketoptional | Brian Carter |
resolution_outcome | string | Outcome of the ticket resolution (e.g., resolved, unresolved, workaround, duplicate)resolved · unresolved · workaround · duplicate · cancelled · optional | resolved |
resolution_notes | string | Detailed notes on how the issue was resolved or why it was closedoptional | Manual update performed. |
escalation_level | string | Level to which the ticket was escalated (if applicable)none · tier 2 · tier 3 · manager · external · optional | none |
| Numbers 1 column | |||
customer_satisfaction_score | float | Customer satisfaction rating after ticket closure (e.g., 1-5 scale)1 to 5 · optional | 4.7 |
| Dates and times 3 columns | |||
ticket_created_datetime | datetime | Timestamp when the support ticket was created | 2024-03-01T09:15:23 |
ticket_closed_datetime | datetime | Timestamp when the support ticket was closed/resolvedoptional | 2024-03-02T10:45:00 |
escalation_datetime | datetime | Timestamp when the ticket was escalated (if applicable)optional | 2024-03-06T20:02:12 |
| True or false 2 columns | |||
escalated | boolean | Indicates if the ticket was escalated to higher support level | false |
follow_up_required | boolean | Indicates if a follow-up with the customer is neededoptional | false |
Use it for
A technology dashboard
The follow_
up_ required rate, customer_ satisfaction_ score by resolution_ outcome and a breakdown of assigned_ agent_ id. Excel, Power BI or Tableau. Why do 35 of 176 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.
- Tickets200TCKT-100014.7resolvedTCKT-10003—TCKT-100063.8workarou…
A software demo
Believable tickets with customer_
id, customer_ name and customer_ email to fill a screen in front of a buyer.
blueprint · tech-support-ticket-analytics
Behind this dataset
Same schema. As many rows as you need.
These 200 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.
- Ticket ID and timestamps tracked
- Issue category and user demographics included
- Resolution status and time recorded
- Escalation and feedback metrics annotated
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
- tech-support-ticket-analytics