Complete AI Training
Sign inGet my AI kit

Your job's AI kit

Get your AI kit

Tell us who you are and what you do. We show you your kit right away and email you the link: skills, prompts, AI agents, MCP servers and courses for your job.

500+ jobs ready, and we make a kit for any other job. No payment needed to look.

Share

AI agent for mediators

Mediation Outcome Statistics Agent

Produce an accurate quarterly outcome report without rebuilding the numbers by hand.

Mediation Outcome Statistics Agent: what goes in, what the agent does and what you get

What it does

Courts and funders ask for settlement rates and time to resolution, and the numbers are rebuilt by hand each quarter. The agent pulls closed case records, classifies outcomes, and checks for missing dates or categories. It asks the mediator to fill the gaps, then re-checks. It calculates settlement rate, days to resolution and session counts by case type and compares them with the prior quarter, flagging large moves. It drafts the report. The mediator approves it before it goes to the court or funder. Edge case: 6 cases have no closing date, so the agent asks for them before calculating time to resolution.

How it works

Follow the arrows from top to bottom. The orange dashed arrow is the loop: when a check fails, the agent goes back and tries again.

Start and resultWhat it doesA check on its own workWaits for your OKGoes back and retries
Yes, continueYes, continueApprovedNoNo 1 STARTS WHEN Quarter ends 2 USES A TOOL Pull closed case records for the quarter 3 DOES Classify each outcome using the program categories 4 CHECKS THE RESULT Does every case have a type, outcome and dates? If not: List the gaps and ask the mediator to fill them.Back to step 2. 5 USES A TOOL Calculate settlement rate, days to resolution andsessions by type 6 DOES Compare with the prior quarter 7 CHECKS THE RESULT Do the totals reconcile with the case count and aremoves explained? If not: Check the data behind the move and fix theclassification. Back to step 4. 8 DOES Draft the report in the funder's format 9 YOU APPROVE Mediator approves the report before submission 10 RESULT Approved quarterly report
Read the steps as a list
  1. Quarter ends
  2. Pull closed case records for the quarter
  3. Classify each outcome using the program categories
  4. Does every case have a type, outcome and dates?If not: List the gaps and ask the mediator to fill them. Back to step 2.
  5. Calculate settlement rate, days to resolution and sessions by type
  6. Compare with the prior quarter
  7. Do the totals reconcile with the case count and are moves explained?If not: Check the data behind the move and fix the classification. Back to step 4.
  8. Draft the report in the funder's format
  9. Mediator approves the report before submissionThe agent waits here for your OK.
  10. Approved quarterly report

How it decides

A case is counted only when it has a type, outcome and dates. Gaps are returned to the mediator before calculation. Moves over the threshold are flagged with the cases behind them.

  • Cases with missing data are held out until fixed
  • A change over 10 percentage points is flagged
  • Totals by type must equal the total number of cases
  • Outcome categories follow the program definition

Make it yours

Every agent is a starting point. You choose these settings for your own situation.

  • Outcome categories
  • Threshold for flagging a change (default 10 points)
  • Report template
  • Case types for breakdown

What keeps you in control

It always asks you first

  • Mediator approves the report before submission

Hard limits

  • Never submits the report itself
  • Never guesses missing dates or outcomes

It stops when

  • Done: report approved and sent
  • Stop: data gaps remain, so the mediator decides to report with a note

Set it up

We guide you through the set-up, step by step

Members get the full set-up guide for this agent. No technical skills needed: you copy, paste and upload.

10 minto set it up in your AI
5 AIsChatGPT, Claude, Copilot, Gemini, Grok
  • One set of instructions to paste into your AI, with the clicks for ChatGPT, Claude, Microsoft 365 Copilot, Gemini and Grok
  • The agent then walks you through connecting your own data, one source at a time
  • A downloadable copy with the flow chart, the rules and the full guide
Get access to this agent

An example run

What happensFor the second quarter, the agent pulled 118 closed cases. Six had no closing date, so the data check failed. The mediator supplied 5 and marked 1 as withdrawn. The agent calculated a settlement rate of 61 percent against 68 percent last quarter and flagged the 7 point drop, tracing it to 9 family cases. The mediator approved the report with a short note.

More agents for mediators