Distribution Pipeline Hygiene Agent
Removes duplicate leads and quotes and keeps distribution pipeline records current.
- Industry
- Insure AI
- Department
- Sales
- Team
- Deal Conversion
- Kind
- Assistant
- Approver
- Head of Distribution
- Code
- SAL-16
It finds duplicate leads, accounts and submissions in the agent and broker portal, quotes past their expiry still shown as open, and opportunities missing premium, line, renewal date or next step. It proposes merges and fixes with the evidence, and never merges records that sit under different brokers of record without approval.
How it works
6 steps, and a person signs off before step 6.
- 01Looks it up
Finds the record the request is about in the agent and broker portal: the leads, accounts, submissions and quotes in scope with their fields, stages, expiry dates, owners, brokers of record and last activity..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Works it through
Prepares the draft, match, recommendation or reply, with its sources.
- 05Asks a person
Hands the work to Head of Distribution with its reasoning before anything goes out.
- 06Acts
Once approved, it acts in the agent and broker portal: it merges the approved duplicates, closes expired quotes and creates tasks for owners to fill missing fields. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The pipeline data standard: stages from lead to bound, required fields per stage, quote expiry rules, duplicate match rules and broker-of-record ownership.
Reads from
the agent and broker portal: the leads, accounts, submissions and quotes in scope with their fields, stages, expiry dates, owners, brokers of record and last activity.
Acts in
the agent and broker portal: it merges the approved duplicates, closes expired quotes and creates tasks for owners to fill missing fields.
Hands back
An object with merges (a list, each with keep_id, merge_ids, match_score and reason), closes (a list with record_id and reason), missing_fields (a list with record_id, fields and owner) and stale (a list with record_id, days_idle and owner).
Asks a person when
A merge crosses brokers of record, the run has more than 100 changes, or off is false and merges are proposed.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Duplicate match score (0 to 1) | 0.9 | Records matching at or above this are proposed as duplicates. |
| Stale after (days without activity) | 30 | An open opportunity with no activity for this long is flagged. |
| Expired quote grace (days) | 7 | A quote past its expiry by more than this is proposed for closing as not taken up. |
| Required fields | line_of_business, estimated_premium, effective_date, next_step, decision_maker, stage | Comma-separated fields every open opportunity must have. |
| Merge without approval | Off | When on, exact duplicates under the same broker are merged without asking. |
| Most changes per run | 100 | A run with more changes than this needs the approver. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Propose a merge only at 0.9 or above; merge without asking only when off is true and both records share a broker of record.
- Never merge records under different brokers of record, or a lead with a bound policy, without the Head of Distribution.
- Flag open opportunities without activity for 30 days and propose closing quotes more than 7 days past expiry.
- Every open opportunity must have line_of_business, estimated_premium, effective_date, next_step, decision_maker, stage; list what is missing and who owns it rather than guessing a value.
- A run with more than 100 changes needs the Head of Distribution.
See the Distribution Pipeline Hygiene Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.