Refund Requests
This dataset provides comprehensive records of product and service refund requests, including customer details, reasons, amounts, processing status, and resolution times. It enables analysis of refund patterns, operational efficiency, and customer satisfaction, supporting business decision-making and process optimization.
Sample rows
preview · 8 of 200 rows · all 14 columns| refund_idstring | product_typestring | refund_amountfloat | currencystring | customer_idstring | transaction_idstring | product_idstring | request_datedatetime | processing_statusstring | resolution_datedatetime | resolution_time_hoursfloat | processed_bystring | customer_emailstring | refund_reasonstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RFND-00001-A | product | 48.75 | USD | CUST-00001 | TXN-100001 | PRD-1001 | 2023-01-11T10:23:15Z | pending | blank | blank | blank | cust-00001@ | Product arrived damaged and packaging was torn. |
| RFND-00002-A | service | 290.3 | EUR | CUST-00002 | TXN-100002 | SRV-2001 | 2023-03-07T12:45:32Z | approved | 2023-03-09T15:03:12Z | 50.31 | EMP-1001 | cust-00002@ | Service was not provided as scheduled and was missed. |
| RFND-00003-A | product | 32.99 | USD | CUST-00003 | TXN-100003 | PRD-1002 | 2023-07-16T08:17:41Z | completed | 2023-07-17T10:54:10Z | 26.61 | EMP-1002 | cust-00003@ | Incorrect item received in my order. |
| RFND-00004-A | service | 14.99 | USD | CUST-00004 | TXN-100004 | SRV-2002 | 2023-09-24T16:40:59Z | completed | 2023-09-25T18:12:44Z | 25.53 | EMP-1003 | cust-00004@ | Double charged for monthly subscription fee. |
| RFND-00005-A | service | 1800 | GBP | CUST-00005 | TXN-100005 | SRV-2003 | 2023-11-22T11:08:37Z | approved | 2023-11-27T14:28:21Z | 125.33 | EMP-1004 | cust-00005@ | Service contract was terminated early, refund requested. |
| RFND-00006-A | product | 18 | USD | CUST-00006 | TXN-100006 | PRD-1003 | 2023-12-01T09:17:23Z | rejected | 2023-12-02T13:45:07Z | 28.46 | SYS-AUTO | cust-00006@ | Product was defective and did not function. |
| RFND-00007-A | service | 99.99 | CHF | CUST-00007 | TXN-100007 | SRV-2004 | 2023-12-17T14:36:55Z | in_review | blank | blank | blank | cust-00007@ | Overpayment detected on the last invoice. |
| RFND-00008-A | service | 620 | EUR | CUST-00008 | TXN-100008 | SRV-2005 | 2024-01-18T16:47:42Z | pending | blank | blank | blank | cust-00008@ | Service was not delivered as described. |
| RFND-00009-A | product | 27.5 | USD | CUST-00009 | TXN-100009 | PRD-1004 | 2024-02-03T13:55:21Z | approved | 2024-02-05T16:11:32Z | 50.27 | EMP-1005 | cust-00009@ | Did not receive product by promised delivery date. |
| RFND-00010-A | product | 63.2 | USD | CUST-00010 | TXN-100010 | PRD-1005 | 2024-02-17T19:29:06Z | completed | 2024-02-18T09:18:18Z | 13.82 | EMP-1006 | cust-00010@ | Product was missing essential components. |
| RFND-00011-A | service | 12.99 | CAD | CUST-00011 | TXN-100011 | SRV-2006 | 2024-03-05T08:04:41Z | completed | 2024-03-05T16:09:45Z | 8.08 | EMP-1007 | cust-00011@ | Subscription cancelled but was still billed. |
| RFND-00012-A | service | 5 | AUD | CUST-00012 | TXN-100012 | SRV-2007 | 2024-03-15T22:27:12Z | approved | 2024-03-16T03:20:33Z | 4.89 | EMP-1008 | cust-00012@ | Customer requested refund for promotional code not applied. |
| RFND-00013-A | product | 37 | USD | CUST-00013 | TXN-100013 | PRD-1006 | 2024-03-21T11:56:37Z | in_review | blank | blank | blank | cust-00013@ | Product was not as described online. |
| RFND-00014-A | service | 2750 | JPY | CUST-00014 | TXN-100014 | SRV-2008 | 2024-04-01T09:14:22Z | approved | 2024-04-03T20:26:19Z | 59.2 | EMP-1009 | cust-00014@ | Service was delayed by over a week. |
| RFND-00015-A | product | 28.99 | USD | CUST-00015 | TXN-100015 | PRD-1007 | 2024-04-15T15:37:58Z | pending | blank | blank | blank | cust-00015@ | Received wrong product color and size. |
| RFND-00016-A | service | 117.5 | EUR | CUST-00016 | TXN-100016 | SRV-2009 | 2024-04-20T11:22:30Z | completed | 2024-04-21T15:18:00Z | 27.93 | EMP-1010 | cust-00016@ | Service was not up to agreed standards. |
| RFND-00017-A | product | 56 | USD | CUST-00017 | TXN-100017 | PRD-1008 | 2024-05-05T07:56:18Z | rejected | 2024-05-06T09:14:26Z | 25.3 | SYS-AUTO | cust-00017@ | Package was lost during transit. |
| RFND-00018-A | service | 22.49 | CAD | CUST-00018 | TXN-100018 | SRV-2010 | 2024-05-18T18:39:50Z | approved | 2024-05-18T22:42:11Z | 4.03 | EMP-1011 | cust-00018@ | Accidental subscription renewal, refund requested. |
| RFND-00019-A | product | 44 | USD | CUST-00019 | TXN-100019 | PRD-1009 | 2024-05-29T13:43:35Z | pending | blank | blank | blank | cust-00019@ | Order was cancelled before shipment but charged. |
| RFND-00020-A | service | 215 | GBP | CUST-00020 | TXN-100020 | SRV-2011 | 2024-06-03T21:31:47Z | completed | 2024-06-05T00:41:02Z | 27.16 | EMP-1012 | cust-00020@ | Service quality was below expectations. |
What the 200 rows show
from the 200-row sample- 40.0median refund_
amount - 5processing statuses
- 25.3median resolution_
time_ hours
Median 40.0, from 5.0 to 4,200.
- string 10
- float 2
- datetime 2
Columns
14 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 10 columns | |||
refund_id | string | Unique identifier for each refund requestunique | RFND-00001-A |
customer_id | string | Unique identifier for the customer requesting the refund | CUST-00001 |
transaction_id | string | Reference to the original transaction for which the refund is requested | TXN-100001 |
product_id | string | Identifier for the product or service related to the refund | PRD-1001 |
refund_reason | string | Reason provided by the customer for requesting the refundup to 255 | Missing item in package. |
currency | string | Currency code for the refund amount (ISO 4217)9 currencies | USD |
processing_status | string | Current status of the refund requestpending · approved · rejected · in_review · completed | pending |
processed_by | string | Identifier for the staff member or system that processed the refund requestoptional | EMP-1001 |
customer_email | string | Email address of the customer requesting the refund | cust-00001@ |
product_type | string | Type of item for which refund is requested (product or service)product · service | product |
| Numbers 2 columns | |||
refund_amount | float | Amount requested for refund0.01 or more | 48.75 |
resolution_time_hours | float | Time taken to resolve the refund request, in hours0 or more · optional | 50.31 |
| Dates and times 2 columns | |||
request_date | datetime | Date and time when the refund request was submitted | 2023-01-11T10:23:15Z |
resolution_date | datetime | Date and time when the refund request was resolved (approved/rejected/completed)optional | 2023-03-09T15:03:12Z |
Use it for
An e-commerce dashboard
Refund_
amount by product_ type and a breakdown of currency. 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.
- Refunds200RFND-00001-A48.75productRFND-00002-A290.3serviceRFND-00003-A32.99product
A software demo
Believable refunds with customer_
id, transaction_ id and product_ id to fill a screen in front of a buyer.
blueprint · refund-requests
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 14 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.
- Refund amount not exceeding original purchase
- Request date after original transaction date
- Reason codes for refund classification
- Status: requested, approved, processed, denied
- Processing time tracked in business days
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
- refund-requests