Support Tickets
This dataset provides a detailed record of customer support tickets, including issue descriptions, priority levels, agent assignments, status updates, resolution times, and customer feedback. It enables comprehensive analysis of support operations, agent performance, and customer satisfaction, making it valuable for service optimization and reporting.
Sample rows
preview · 8 of 200 rows · all 16 columns| ticket_idstring | statusstring | resolution_time_hoursfloat | assigned_agent_idstring | customer_idstring | customer_namestring | customer_emailstring | prioritystring | assigned_agent_namestring | created_atdatetime | updated_atdatetime | resolved_atdatetime | customer_feedback_ratinginteger | customer_feedback_commentstring | issue_descriptionstring | resolution_summarystring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A1032-YTGH | Resolved | 1.27 | AGT101 | CUST001 | Alice Johnson | alice.johnson@ | High | Samuel Lee | 2024-05-13T09:17:00Z | 2024-05-13T10:23:00Z | 2024-05-13T10:33:00Z | 5 | Quick and efficient help, thank you! | Unable to access account after password reset request. | Reset password manually and verified account access with customer. |
| B2045-KJUI | In Progress | blank | AGT102 | CUST002 | Juan Martinez | juan.martinez@ | Urgent | Priya Singh | 2024-05-14T13:34:00Z | 2024-05-14T13:45:00Z | blank | blank | blank | Payment failure during subscription renewal. | blank |
| C3167-POLK | Closed | 7.12 | AGT103 | CUST003 | Ravi Patel | r.patel@ | Medium | Emily Chen | 2024-05-07T10:52:00Z | 2024-05-07T18:01:00Z | 2024-05-07T17:59:00Z | 4 | Process was smooth, thanks. | Requesting license upgrade for business account. | License upgraded after verification; confirmation sent to customer. |
| D4298-QWER | Pending Customer | blank | AGT104 | CUST004 | Fatima Noor | fatima.noor@ | Low | James Wright | 2024-05-15T14:27:00Z | 2024-05-16T09:17:00Z | blank | blank | blank | Unable to download invoice from portal. | blank |
| E5012-ABCD | Open | blank | blank | CUST005 | Chen Wei | chen.wei@ | Medium | blank | 2024-05-17T07:45:00Z | 2024-05-17T07:45:00Z | blank | blank | blank | Feature request: Add multi-language support for dashboard. | blank |
| F6193-ZXCV | In Progress | blank | AGT105 | CUST006 | Olga Petrova | olga.petrova@ | High | Ahmed El-Sayed | 2024-05-12T16:11:00Z | 2024-05-12T16:40:00Z | blank | blank | blank | Error message when updating user profile information. | blank |
| G7024-HJUI | Resolved | 0.87 | AGT106 | CUST007 | Liam Smith | liam.smith@ | Urgent | Maria Gomez | 2024-05-18T08:05:00Z | 2024-05-18T08:41:00Z | 2024-05-18T08:57:00Z | 5 | Very fast help, much appreciated! | Account locked after multiple failed login attempts. | Unlocked account and reset login credentials for customer. |
| H8135-KLMN | Open | blank | blank | CUST008 | Sofia Rossi | sofia.rossi@ | Low | blank | 2024-05-09T12:11:00Z | 2024-05-09T12:11:00Z | blank | blank | blank | Cannot find transaction history for recent purchases. | blank |
| I9246-TYUI | Resolved | 1.32 | AGT101 | CUST009 | David Miller | d.miller@ | Medium | Samuel Lee | 2024-05-10T09:31:00Z | 2024-05-10T10:04:00Z | 2024-05-10T10:50:00Z | 5 | Thank you for the prompt update! | Request to update company billing address. | Billing address updated per customer request; confirmation sent. |
| J0357-QAZX | In Progress | blank | AGT102 | CUST010 | Laura Kim | laura.kim@ | High | Priya Singh | 2024-05-11T17:22:00Z | 2024-05-11T17:44:00Z | blank | blank | blank | Difficulty exporting data from reporting module. | blank |
| K1468-WSXC | Closed | 12.88 | AGT103 | CUST011 | Mamadou Diouf | mamadou.diouf@ | Medium | Emily Chen | 2024-05-13T19:16:00Z | 2024-05-14T08:10:00Z | 2024-05-14T08:09:00Z | 4 | Good instructions, worked as expected. | Request for assistance with two-factor authentication setup. | Provided step-by-step guide and verified successful setup. |
| L2579-EDCV | Resolved | 18 | AGT104 | CUST012 | Carla Santos | carla.santos@ | High | James Wright | 2024-05-08T15:30:00Z | 2024-05-09T09:26:00Z | 2024-05-09T09:30:00Z | 3 | Took longer than expected, but issue resolved. | Bug report: Dashboard not loading on mobile devices. | Escalated to dev team; patch released to fix mobile bug. |
| M3680-RFVT | Closed | 6.1 | AGT105 | CUST013 | Nina Müller | nina.mueller@ | Medium | Ahmed El-Sayed | 2024-05-06T11:47:00Z | 2024-05-06T17:55:00Z | 2024-05-06T17:53:00Z | 5 | Super helpful, thanks! | Request to merge two user accounts into one. | Accounts merged after verification; user notified. |
| N4791-TGBY | Pending Customer | blank | AGT106 | CUST014 | Jacob Thompson | jacob.thompson@ | Low | Maria Gomez | 2024-05-16T07:59:00Z | 2024-05-16T15:23:00Z | blank | blank | blank | Trouble with recurring payment setup. | blank |
| O5802-BYHN | In Progress | blank | AGT101 | CUST015 | Ava Nguyen | ava.nguyen@ | High | Samuel Lee | 2024-05-14T11:18:00Z | 2024-05-14T11:49:00Z | blank | blank | blank | Unable to update user permissions for team members. | blank |
| P6913-NUJM | Open | blank | blank | CUST016 | Elena Popov | elena.popov@ | Medium | blank | 2024-05-13T14:27:00Z | 2024-05-13T14:27:00Z | blank | blank | blank | Feature request: Add customizable notifications. | blank |
| Q7024-MKLO | Open | blank | blank | CUST017 | Mohammed Al-Farsi | m.al-farsi@ | Low | blank | 2024-05-08T09:05:00Z | 2024-05-08T09:05:00Z | blank | blank | blank | Cannot view previous invoices in account dashboard. | blank |
| R8135-PLKM | Resolved | 0.33 | AGT102 | CUST018 | Isabella Garcia | isabella.garcia@ | Urgent | Priya Singh | 2024-05-15T15:14:00Z | 2024-05-15T15:29:00Z | 2024-05-15T15:34:00Z | 5 | Fantastic service, resolved in minutes. | Payment declined, unable to renew subscription. | Assisted customer with manual payment and renewed subscription. |
| S9246-OKMN | In Progress | blank | AGT103 | CUST019 | Lucas Dubois | lucas.dubois@ | High | Emily Chen | 2024-05-11T10:41:00Z | 2024-05-11T11:57:00Z | blank | blank | blank | Cannot access dashboard since last update. | blank |
| T0357-OLKM | Closed | 5.2 | AGT104 | CUST020 | Amelia Evans | amelia.evans@ | Medium | James Wright | 2024-05-14T07:59:00Z | 2024-05-14T13:12:00Z | 2024-05-14T13:11:00Z | 4 | Resolved quickly, thanks. | Cannot update billing method for account renewal. | Updated billing method and confirmed with customer. |
What the 200 rows show
from the 200-row sampleClosed status stands out: mean resolution_
- 3.8median resolution_
time_ hours - 4priorities
- 50customers
- 5median customer_
feedback_ rating
Median 3.8, from 0.22 to 32.7.
- string 11
- integer 1
- float 1
- datetime 3
Columns
16 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
ticket_id | string | Unique identifier for each support ticketunique | A1032-YTGH |
customer_id | string | Unique identifier for the customer who submitted the ticket | CUST001 |
customer_name | string | Full name of the customer | Alice Johnson |
customer_email | string | Email address of the customer | alice.johnson@ |
issue_description | string | Detailed description of the customer's issue or request10 or more | Unable to access account … |
priority | string | Priority level assigned to the ticketLow · Medium · High · Urgent | High |
status | string | Current status of the support ticketOpen · In Progress · Pending Customer · Resolved · Closed | Resolved |
assigned_agent_id | string | Unique identifier for the support agent assigned to the ticketoptional | AGT101 |
assigned_agent_name | string | Full name of the support agent assigned to the ticketoptional | Samuel Lee |
resolution_summary | string | Summary of how the ticket was resolvedoptional | Reset password manually a… |
customer_feedback_comment | string | Customer's feedback comments on the ticket resolutionoptional | Super helpful, thanks! |
| Numbers 2 columns | |||
resolution_time_hours | float | Time taken to resolve the ticket, in hours0 or more · optional | 1.27 |
customer_feedback_rating | integer | Customer's feedback rating for the ticket resolution (1-5)1 to 5 · optional | 5 |
| Dates and times 3 columns | |||
created_at | datetime | Timestamp when the ticket was created | 2024-05-13T09:17:00Z |
updated_at | datetime | Timestamp when the ticket was last updated | 2024-05-13T10:23:00Z |
resolved_at | datetime | Timestamp when the ticket was marked as resolvedoptional | 2024-05-13T10:33:00Z |
Use it for
A technology dashboard
Resolution_
time_ hours by status and a breakdown of assigned_ agent_ id. Excel, Power BI or Tableau. Why do the 36 Closed rows have a mean resolution_
time_ hours of 11.9? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Tickets200A1032-YTGH1.27ResolvedB2045-KJUIIn Progr…C3167-POLK7.12Closed
A software demo
Believable tickets with customer_
id, customer_ name and customer_ email to fill a screen in front of a buyer.
blueprint · support-tickets
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.
- Ticket ID unique per ticket
- Priority: low, medium, high, critical
- Status: open, in progress, resolved, closed
- Resolution time SLA by priority level
- Assigned agent from support team
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
- support-tickets