Customer Record Hygiene Agent
Removes duplicate buyer records and keeps sales opportunities and nominations current.
- Industry
- Oil & Gas
- Department
- Sales
- Team
- Deal Conversion
- Kind
- Assistant
- Approver
- Sales Operations Manager
- Code
- SAL-16
It removes duplicate buyer and counterparty records, which matter more here because duplicates can split credit exposure and screening, and keeps opportunities current: stale close dates, missing volumes and products, and deals whose cargoes have already lifted. It applies safe fixes and proposes the rest.
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 CRM: accounts, opportunities, activity and their links to credit and KYC records..
- 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 Sales Operations Manager with its reasoning before anything goes out.
- 06Acts
Once approved, it acts in the CRM: it applies the approved merges and field updates. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The customer data rules: duplicate match rules, required opportunity fields, stage definitions, and the link between counterparty records and credit and KYC.
Reads from
the CRM: accounts, opportunities, activity and their links to credit and KYC records.
Acts in
the CRM: it applies the approved merges and field updates.
Hands back
An object with duplicates (a list, each with ids, match_score and action), stale (a list with id, owner and days_inactive), missing_fields (a list with id and fields), to_close (a list) and changes_applied (a count).
Asks a person when
It would merge records (unless exact and off is true), merge records with their own credit or KYC files, change an opportunity's stage, volume, close date or status, or change more than 100 records.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Duplicate match score | 90 | Records matching at or above this are duplicates. |
| Opportunity stale after (days) | 30 | No activity this long is stale. |
| Close date grace (days) | 7 | Past close dates beyond this are flagged. |
| Required opportunity fields | product, volume, delivery_point, period, pricing_basis | Comma-separated. |
| Merge exact duplicates | Off | When on, exact duplicates without separate credit or KYC records are merged. |
| Most changes per run | 100 | More needs the approver. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Records matching at 90 or more are duplicates; merge only exact ones, only when off is true and they do not carry separate credit limits or KYC files.
- Flag opportunities with no activity for 30 days or close dates past 7 days, and missing product, volume, delivery_point, period, pricing_basis.
- An opportunity whose cargo or delivery has lifted is marked for closing, not closed.
- Make at most 100 changes a run.
See the Customer Record 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.