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)

Build a safe CRM dedupe-and-merge decision framework

Get matching rules, false-positive guards, and survivorship logic to merge CRM duplicates without destroying good data.

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.
Copy prompt
☆ Save to library
Send to a teammate
Email it
Link copied — paste it in Slack
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

  1. Copy the prompt and paste it into Claude, ChatGPT, Gemini, or Copilot — it's tuned to run in any of them.
  2. Replace the variables — swap each bracketed token for your deal's specifics. The variables list above explains every field.
  3. 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

StageOngoing/Cross-Stage
SeatRevOps / Sales Ops
DifficultyAdvanced
Time to valueSame-Day Use (under 30 min)
Works withAI-Agnostic
CategoryRevOps, Data & Analytics Support
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.

Stop rewriting. Start closing.

Copy prompt
Start Pro — $4.99/mo