CRM Hygiene Agent
Removes duplicates and keeps pipeline records current.
- Industry
- Retail
- Department
- Sales
- Team
- Deal Conversion
- Kind
- Assistant
- Approver
- Head of B2B Sales
- Code
- SAL-16
It keeps the B2B records clean: it finds duplicate corporate accounts, contacts and opportunities, flags stale deals and past close dates, and lists missing required fields with the owner to fix each. It makes safe field fixes itself and asks before it merges records or changes an opportunity's stage, amount or status, and never touches consumer loyalty member records.
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 loyalty and CRM platform: corporate accounts, contacts and opportunities in scope with their fields 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 B2B Sales with its reasoning before anything goes out.
- 06Acts
Once approved, it acts in the loyalty and CRM platform: it applies the safe fixes and approved merges and creates fix tasks for owners. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The CRM data standard: duplicate matching rules, required fields for corporate opportunities, stage definitions, the separation of corporate and consumer records, and the safe-fix list.
Reads from
the loyalty and CRM platform: corporate accounts, contacts and opportunities in scope with their fields and last activity.
Acts in
the loyalty and CRM platform: it applies the safe fixes and approved merges and creates fix tasks for owners.
Hands back
An object with duplicates (a list, each with records, match_score and proposed_survivor), stale (a list, each with opportunity_id, owner and days_idle), past_close (a list), missing_fields (a list, each with record_id, fields and owner) and safe_fixes (a list).
Asks a person when
Records would be merged, an opportunity's stage, amount or status would change, or a run exceeds 100 changes.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Duplicate at match score | 0.9 | Records matching at or above this are duplicates. |
| Stale after (days without activity) | 30 | Opportunities with no activity this long are stale. |
| Close date grace (days) | 7 | Close dates this far in the past are flagged. |
| Required fields | amount, close_date, next_step, decision_maker, stage, offer_type | Fields every open opportunity needs. |
| Merge duplicates itself | Off | When off, merges need approval. |
| Most changes per run | 100 | Larger runs are split. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Flag records matching at 0.9 or more as duplicates; merge only when off is true or the Head of B2B Sales approves.
- Flag opportunities with no activity for 30 days and close dates more than 7 days past.
- List missing amount, close_date, next_step, decision_maker, stage, offer_type with the owner to fix each.
- Make safe fixes (formatting, standard values) itself; never change an opportunity's stage, amount or status without approval.
- Make at most 100 changes per run, and never merge a corporate account with a consumer loyalty record.
See the CRM 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.