Merge duplicate deals

Duplicate deals are worse than duplicate contacts, because they inflate the number everyone is making decisions from. A pipeline with duplicates forecasts revenue twice.

There is a pre-flight check to catch them at creation, and merging to fix the ones that got through.

Who this is for

Reps and sales ops keeping the pipeline honest.

Before you start

• Permission to update deals.
• Both deals visible, so you can see which holds the real history.

A duplicate deal double-counts the forecast
Unlike a duplicate contact, which is untidy, a duplicate deal actively misleads. Two records for one opportunity means its value is counted twice in the pipeline and the weighted forecast. That is why this is worth fixing promptly rather than at cleanup time.

Handle duplicates

1. Heed the pre-flight warning
   When creating a deal that looks like one that exists, you are warned. Read it rather than clicking past — that is the cheapest moment to prevent the problem.
2. Confirm it is genuinely the same opportunity
   Two deals with one company can be legitimate — different products, different periods. Same company is not the same as same opportunity.
3. Pick the survivor
   Usually the one with the activity, the notes and the correct stage. Moving history is the expensive part.
4. Merge
   The deals collapse into one, so the pipeline stops counting the opportunity twice.
5. Check value, stage and close date
   After merging, confirm the surviving deal has the right commercial details. This is the moment to correct anything.
6. Look at how it happened
   Duplicates from an integration are a mapping problem; from reps, a habit. Fixing the cause beats merging repeatedly.

What you get

• A pipeline that counts each opportunity once.
• A forecast not inflated by double-counting.
• Full history on one deal instead of split across two.
• Early warning at creation rather than discovery at cleanup.

Frequently asked questions

Can one company legitimately have two open deals?

Absolutely — different products, different renewal periods, different business units. Same company is not the same opportunity.

Why do duplicate deals matter more than duplicate contacts?

Because they inflate the pipeline and the forecast. A duplicate contact is untidy; a duplicate deal makes the number wrong.

Which deal should survive?

The one carrying the activity and notes. Correct the commercial fields on it afterwards if needed.

How do I stop duplicates being created?

The pre-flight check warns at creation. Most duplicates come from clicking past that warning, or from an integration creating deals without matching first.