Automated Xactware Claim Cycle Time Report
Every Monday, WebRun opens XactAnalysis on xactware.com, calculates how long each closed claim spent at each stage last week, computes averages by adjuster and claim type, and writes the results to Google Sheets so managers can spot bottlenecks and act on them.
How do I automatically track claim cycle times from Xactware?
WebRun opens XactAnalysis every Monday, reads how long each claim closed last week spent at every stage, groups the results by adjuster and claim type, and writes a cycle-time report to Google Sheets. Stages exceeding your targets are highlighted so managers can address bottlenecks before they compound.
- Bottleneck stages identified weekly before they compound into SLA breaches
- Adjuster-level cycle time visible without manual data pulls
- Multi-week trend chart built automatically from each Monday's run
Built for claims managers · TPA operations teams · carrier claims directors · independent adjusting firm owners
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
xactanalysis.comin a real browser with your saved login - no setup, no API keys. -
1
Xactware - read claim stage durations
xactware.com
WebRun opens Xactware to read claim stage durations. - Open XactAnalysis and filter to claims closed in the past 7 days
- For each claim, read the date and duration at each stage: assignment, inspection, estimate, approval, and close
- Group results by adjuster and claim type
- Compute average cycle time per stage for each group
Done when All last-week closed claims have stage durations computed and grouped.
-
2
Google Sheets - write the weekly cycle-time report
google.com
WebRun opens Google Sheets to write the weekly cycle-time report. - Open the cycle-time report sheet and add a new dated tab for this week
- Write a row per adjuster per claim type with average time at each stage
- Add a summary row with overall averages and highlight stages exceeding your target
- Update the rolling trend chart on the summary tab
Done when This week's cycle-time tab is complete with averages, highlights, and the trend chart updated.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
What claim stages does it measure?
It measures time in each XactAnalysis stage: assignment, inspection, estimate submission, estimate approval, and claim close. The stages match your XactAnalysis workflow configuration.
Can it break down cycle times by claim type or peril?
Yes. It groups by both adjuster and claim type or peril as configured in XactAnalysis, so you can compare fire versus water versus wind cycle times side by side.
How far back does the report look?
Each Monday run covers claims closed in the past 7 days. The Google Sheets rolling chart accumulates data over time so you can spot multi-week trends.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.