crm-hygiene-audit
Skill13 starsChanged 24 days agoMITView on GitHub
Use this skill when CRM data is messy and reports cannot be trusted: \"audit our CRM\", \"clean up our CRM data\", \"duplicates and missing fields\", \"why is our pipeline report wrong\". Checks duplicates, missing required fields, stale and past-due opportunities, ownership gaps, lifecycle stage errors, bad picklist values and unlinked records, quantifies each issue, ranks them by impact on reporting and selling, and produces a cleanup plan plus the rules that stop the mess coming back. Proposes changes for approval, never bulk-edits on its own.
In this repository77 other files it gives its agents.
- AGENTS.mdAGENTS.md
- abm-account-planSkill
- account-research-briefSkill
- account-tieringSkill
- aeo-answer-optimizerSkill
- breakup-emailSkill
- buyer-persona-builderSkill
- buying-committee-mapperSkill
- buying-signal-scoringSkill
- call-coaching-scorecardSkill
- campaign-performance-analyzerSkill
- case-study-writerSkill
- churn-win-backSkill
- closed-lost-reactivationSkill
- cold-call-scriptSkill
- cold-email-sequenceSkill
- cold-email-writerSkill
- comparison-page-writerSkill
- competitive-battlecardSkill
- competitor-teardownSkill
- customer-interview-guideSkill
- deal-qualificationSkill
- deliverability-auditSkill
- discovery-call-prepSkill
- domain-warmup-planSkill
- email-authentication-setupSkill
- email-copy-reviewSkill
- event-follow-upSkill
- expansion-opportunity-finderSkill
- first-line-personalizationSkill
- follow-up-email-writerSkill
- funding-signal-outreachSkill
- gtm-global-rulesSkill
- hiring-signal-outreachSkill
- icp-builderSkill
- job-change-playsSkill
- lead-list-builderSkill
- lead-magnet-builderSkill
- lead-scoring-modelSkill
- linkedin-comment-strategySkill
- linkedin-connection-noteSkill
- linkedin-message-sequenceSkill
- linkedin-post-writerSkill
- linkedin-profile-optimizerSkill
- list-cleaningSkill
- lookalike-account-finderSkill
- meeting-booking-replySkill
- messaging-matrixSkill
- multichannel-cadenceSkill
- mutual-action-planSkill
- negotiation-playbookSkill
- no-show-recoverySkill
- objection-handlerSkill
- outbound-ab-testSkill
- outbound-mathSkill
- outreach-compliance-checkSkill
- pipeline-reviewSkill
- post-engagement-outreachSkill
- proposal-follow-upSkill
- prospect-research-briefSkill
- The first 60 shown.
The file
We split this skill into the rules it gives an agent
6 rules. About 0 are common, 6 are distinctive, and 0 are very specific to this project.
≈0
Common · estimate
Many files like this have a rule of this kind.
≈6
Distinctive · estimate
This author's own choices. Worth a look.
0
Very specific
Tied to their project's names, files or tools. Probably skip.
- Common
- Distinctive
- Very specific
- Distinctive: line 16
Use this when the pipeline report and reality disagree.
- Distinctive: line 59
Every issue has a count and an impact, not just "data is messy".
- Distinctive: line 66
MUST export a backup before any bulk change.
- Distinctive: line 67
MUST get approval with a sample before merges, deletions or bulk updates.
- Distinctive: line 68
MUST fix opted-out contacts in active sequences immediately.
- Distinctive: line 69
NEVER permanently delete records without explicit approval.
≈ “Common” is an estimate: at least 1 in 5 of the 350,495 skill files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.
Files
Use this when the pipeline report and reality disagree. It produces a ranked list of data problems, a cleanup plan and the rules that keep data clean afterwards.
Inputs
- Exports of accounts, contacts and opportunities (or read access).
- The fields and stages the business relies on.
- The reports leadership uses, so impact can be judged.
The play
1. Inventory issues
| Area | Check |
| Duplicates | Accounts by domain; contacts by email; similar names |
| Completeness | Required fields empty: industry, size, owner, lifecycle stage, source |
| Opportunities | Past close dates, no next step, no activity in 30 days, amount empty or zero, stage without required fields |
| Ownership | Records owned by former employees or unassigned |
| Lifecycle | Customers without closed-won deals; leads with won deals |
| Picklists | Free-text values where picklists should be; outdated values |
| Relationships | Contacts not linked to accounts; deals without contacts |
| Compliance | Opted-out contacts still in active sequences |
2. Quantify and rank
Count each issue and score impact: does it break forecasting, routing, outreach or compliance? Compliance and forecast issues come first.
3. Plan the cleanup
For each issue: the fix, who decides (some merges need a human), whether it can be done in bulk safely, and the order. Merges and deletions are proposed with a sample for approval, then run in batches with a backup export first.
4. Prevent recurrence
Required fields at stage changes, validation rules, duplicate checks on create, ownership reassignment when people leave, a monthly hygiene report.
Output format
Health score: X/100
Issues (ranked): <issue - count - % of records - impact - fix - bulk-safe? - owner>
Cleanup plan: <week by week, with approval points>
Prevention: <rules to add>
Monthly report: <metrics to track>What good looks like
- Every issue has a count and an impact, not just "data is messy".
- Opt-out compliance issues are fixed first.
- The prevention rules are light enough that reps follow them.
- The common mistake is a one-time cleanup sprint with no rules, so the data is dirty again in a quarter.
Rules
- MUST export a backup before any bulk change.
- MUST get approval with a sample before merges, deletions or bulk updates.
- MUST fix opted-out contacts in active sequences immediately.
- NEVER permanently delete records without explicit approval.
Example prompts
- "Audit these CRM exports and tell me what's wrong, ranked by impact."
- "Our forecast is off every month. Check our opportunity data."
- "Write the hygiene rules and monthly report for our CRM."
Does it work?
Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.
No reviews yet
People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.
- It worked
- Partly
- It didn't
Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.
Your trail
Files you open will collect here, so you can find them again.
Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.
Now do this for your own.
Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

