Library/RevOps, Data & Analytics Support/Data Governance & Enrichment/Build a safe CRM dedupe-and-merge decision framework
TestedRevOps, Data & Analytics SupportSame-Day Use (under 30 min)
About this prompt
This prompt helps RevOps teams design a careful dedupe-and-merge framework for duplicate accounts and contacts. It produces matching rules, false-positive guards, survivorship logic, and review tiers that bias toward not destroying data. Use it before running any merge effort where a wrong merge could combine two different companies or overwrite clean records.Duplicate accounts and contacts pollute reporting, routing, and forecasting, but merging carelessly can combine two genuinely separate companies or overwrite good data with stale values. This prompt builds a decision framework that separates high-confidence auto-mergeable matches from probable matches needing human review, spells out the false-positive traps (subsidiaries vs. parents, franchises, two people with the same name), and defines field-by-field survivorship logic so the best data wins. Describe WHAT'S DUPLICATED and why, what makes it hard (SIMILAR-BUT-DIFFERENT ENTITIES, SUBSIDIARIES, COMMON NAMES, BAD IMPORTS), what the dupes break (REPORTING, ROUTING, REP CONFUSION, DOUBLE-COUNTING), and the data you can match on (NAME, DOMAIN, EMAIL, ADDRESS). This is the planning step before a cleanup, distinct from a one-time enrichment pass. The framework deliberately errs toward caution, so a practical tip is to keep the review-queue threshold conservative early and loosen it only after the auto-merge rules prove safe on a sample.The prompt
We have duplicate accounts and contacts polluting the CRM, but dedupe is dangerous — merge wrong and I destroy good data or combine two different companies. Help me design a safe dedupe-and-merge deci
The rest of this prompt is Pro.Copying the full text is Pro. Browsing stays free, and 100 prompts are free in full.
Copying the full text is Pro.
Variables to replace
WHAT'S DUPLICATED — ACCOUNTS, CONTACTS, BOTH — AND WHY IT HAPPENS | SIMILAR-BUT-DIFFERENT ENTITIES, SUBSIDIARIES, COMMON NAMES, BAD IMPORTS | REPORTING, ROUTING, REP CONFUSION, DOUBLE-COUNTING | NAME, DOMAIN, EMAIL, ADDRESS, ETC.
How to run it
- Copy the prompt and paste it into Claude, ChatGPT, Gemini, or Copilot — it's tuned to run in any of them.
- Replace the variables — swap each bracketed token for your deal's specifics. The variables list above explains every field.
- Make it yours — run it, keep what's strong, and tighten your inputs on the next pass. The prompt improves with your context.
What good output looks like
Make it yours
Promptifi ProFull text of all 2,900+ prompts, every workflow, unlimited saves.Start Pro — $4.99/moor $99 once, lifetime
You're ProFull library open. Copy, save, and chain anything.