Claim Settlement Time Analysis

This dataset provides a comprehensive view of insurance claim lifecycles, capturing detailed timestamps, financial amounts, claim types, customer feedback, and agent involvement. It enables in-depth analysis of settlement times, identification of process bottlenecks, and measurement of customer satisfaction, supporting operational improvements and strategic decision making for insurers.

  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Analyzing claim settlement times to identify process bottlenecks

Sample rows

preview · 8 of 200 rows · all 22 columns
claim_idstringclaim_typestringcustomer_satisfaction_scorefloataddress_countrystringpolicy_idstringcustomer_idstringclaim_amountfloatclaim_statusstringsubmission_datedatetimereview_start_datedatetimereview_end_datedatetimeapproval_datedatetimesettlement_datedatetimeclosed_datedatetimesettlement_amountfloatprocessing_agent_idstringaddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestringcustomer_feedbackstringclaim_reasonstring
CLM00001auto4.7USAPOL10001CUST0014250.75settled2024-02-05T09:27:002024-02-05T13:52:002024-02-06T11:20:002024-02-06T14:45:002024-02-08T10:13:002024-02-09T16:37:004250.75AGT00111563 Oakridge AveSan DiegoCA92123Process was quick and clear, very satisfied.Minor fender bender at intersection, no injuries.
CLM00002propertyblankUKPOL10002CUST002120000under_review2024-05-01T08:22:002024-05-01T12:00:00blankblankblankblankblankAGT002324 Jubilee StreetLondonLondonE15 1XLblankFlood damage to basement and appliances.
CLM00003health4.9CanadaPOL10003CUST0036650approved2024-03-19T10:37:002024-03-19T12:54:002024-03-21T15:13:002024-03-22T10:08:00blankblank6650AGT010791 Valley RoadTorontoONM5C 1Z7Great support, reimbursement processed quickly.Hospitalization for appendicitis, surgery required.
CLM00004auto4.6USAPOL10004CUST00415000closed2024-01-16T15:21:002024-01-16T17:45:002024-01-17T12:30:002024-01-17T16:05:002024-01-20T10:18:002024-01-21T16:44:0015000AGT02125802 Pine StreetDallasTX75206Efficient claim process, no hassle.Major collision, front-end damage.
CLM00005travel1.3FrancePOL10005CUST005750rejected2024-04-10T08:15:002024-04-10T11:35:002024-04-10T15:44:00blank2024-04-11T14:00:002024-04-12T10:40:000AGT032112 Rue de la PaixParisÎle-de-France75002Disappointed, claim was not accepted.Lost luggage not covered under policy.
CLM00006property4.2USAPOL10006CUST006320000settled2024-03-01T07:45:002024-03-01T09:17:002024-03-02T11:03:002024-03-03T10:28:002024-03-10T15:38:002024-03-12T14:10:00288000AGT045888 Maple LaneChicagoIL60614Partial payout, but process was transparent.Fire damage to home, partial loss.
CLM00007health4.8AustraliaPOL10007CUST00721000settled2024-01-27T11:05:002024-01-27T13:20:002024-01-29T09:45:002024-01-30T10:22:002024-02-02T13:00:002024-02-03T12:55:0021000AGT004522 Henson AveSydneyNSW2000Very happy with the support and payout.Emergency surgery, covered by plan.
CLM00008auto4.3USAPOL10008CUST0081390.99approved2024-04-14T16:20:002024-04-14T17:50:002024-04-15T10:30:002024-04-15T15:00:00blankblank1390.99AGT0069345 Elm StreetPortlandOR97209Quick approval, thanks!Windshield crack due to debris.

What the 200 rows show

from the 200-row sample

Travel (claim type) stands out: mean customer_satisfaction_score is 2.8, against 4.4 for the rest.

  • 4.5median customer_satisfaction_score
  • 6claim statuses
  • 9,320median claim_amount
  • 9,200median settlement_amount
Mean customer_satisfaction_score by claim_type171 rows
0484.3auto54 rows4.7health33 rows4.5prope…37 rows4.9life17 rows2.8travel20 rows3.0other10 rows
customer_satisfaction_score171 rows, in bands of 0.5
045901631131156890.535customer_satisfaction_score →

Median 4.5, from 0.80 to 5.0.

address_country200 rows · top 10 of 14 values
  1. USA92
  2. UK35
  3. Canada19
  4. Australia16
  5. New Zealand8
  6. France7
  7. Ireland7
  8. Italy3
  9. Hong Kong3
  10. Switzerland3
22 columns by typefrom the column list below
  • string 13
  • float 3
  • datetime 6

Columns

22 columns in three groups
blueprint · 22 columns
columntypedescriptionexample
Text 13 columns
claim_idstringUnique identifier for each insurance claimuniqueCLM00001
policy_idstringUnique identifier for the insurance policy associated with the claimPOL10001
customer_idstringUnique identifier for the customer submitting the claimCUST001
claim_typestringType of insurance claim (e.g., auto, health, property)6 valuesauto
claim_statusstringCurrent status of the claim in the process lifecycle6 valuessettled
processing_agent_idstringIdentifier for the agent or employee handling the claimoptionalAGT0011
customer_feedbackstringFree-text feedback provided by the customer regarding the claim processoptionalQuick approval, thanks!
claim_reasonstringBrief reason or description for the claimFlat tire replacement.
address_streetstringStreet address associated with the claim (e.g., incident location or insured property)optional1563 Oakridge Ave
address_citystringCity of the claim addressoptionalSan Diego
address_statestringState or province of the claim addressoptionalCA
address_postal_codestringPostal code of the claim addressoptional92123
address_countrystringCountry of the claim addressoptionalUSA
Numbers 3 columns
claim_amountfloatTotal monetary amount claimed0 or more4250.75
settlement_amountfloatFinal amount paid out for the claim0 or more · optional4250.75
customer_satisfaction_scorefloatCustomer satisfaction rating for the claim process (0-5 scale)0 to 5 · optional4.7
Dates and times 6 columns
submission_datedatetimeDate and time when the claim was submitted2024-02-05T09:27:00
review_start_datedatetimeDate and time when claim review process beganoptional2024-02-05T13:52:00
review_end_datedatetimeDate and time when claim review process endedoptional2024-02-06T11:20:00
approval_datedatetimeDate and time when the claim was approvedoptional2024-02-06T14:45:00
settlement_datedatetimeDate and time when the claim was settledoptional2024-02-08T10:13:00
closed_datedatetimeDate and time when the claim was officially closedoptional2024-02-09T16:37:00

Use it for

  • median custome…4.5171 rowsmean customer satisfa…4.3auto4.7heal…4.5prop…4.9life

    An insurance dashboard

    Customer_satisfaction_score by claim_type and a breakdown of address_country. Excel, Power BI or Tableau.

  • Why do the 20 travel rows have a mean customer_satisfaction_score of 2.8?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable claims with policy_id, customer_id and claim_type to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 22 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows22 columns
Yours1,000 rows22 columnsaddress_street: UK only

blueprint · claim-settlement-time-analysis

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.

Rules it was built with
  • Include claims by type and value
  • Log submission and settlement dates
  • Flag expedited and delayed cases
  • Record adjuster and policy info
  • Aggregate average processing time
Rows
Open the blueprint in Data Factory

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
claim-settlement-time-analysis

More in Insurance

Browse all
Also in InsuranceInsurance Claim Severity ScoresMedical Insurance Fraud DetectionHealth Insurance Claim PatternsAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.