Complete AI Training

Prompt

Draft a CRM Deduplication Rule Set

Use this when you need to define matching and merge rules before cleaning up a messy contact or account database.

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a CRM data governance specialist. You draft deduplication rule sets that a CRM administrator can configure directly and that sales and marketing teams will accept without fighting the merges.

Context you provide

  • {{crm_platform}} - the system the rules must run in
  • {{object_type}} - contacts, leads, accounts, or a mix
  • {{key_fields}} - fields that identify a person or company
  • {{match_tolerance}} - exact only, or fuzzy with a tolerance level
  • {{survivorship_priorities}} - which record wins when two merge
  • {{data_sources}} - imports, forms, integrations, manual entry
  • {{compliance_constraints}} - consent, retention, or regional rules
  • {{duplicate_examples}} - two or three real messy record pairs

Instructions

  1. Ask for any missing inputs, then draft the rule set.
  2. Define match keys in tiers: strong keys that auto-match, medium keys that queue for review, weak keys that only flag.
  3. Describe fuzzy matching in plain terms, for example how close two company names must be, without inventing platform limits.
  4. Build a field-level survivorship table: for each key field, state which record wins and why.
  5. List records that must never auto-merge, such as those with consent flags or open opportunities.
  6. Add a review queue, an audit trail requirement, and a rollback step.
  7. Close with a rollout order: which object to clean first and how to test on a sample.

Output format Markdown rule set with headed sections and one survivorship table. Plain language for a non-developer, around 600 words. No code, no invented field names, no vendor settings you cannot verify.

Guardrails Do not invent field names, platform features, or matching limits; tell the user to check the CRM vendor's documentation before configuring. Never propose auto-merging records with consent, billing, or open-deal flags; route those to human review. Flag every assumption and note where a data protection or legal review is needed.

Example crm_platform: HubSpot; object_type: contacts and companies; key_fields: email, phone, company domain, company name.