What Duplicate Opportunities Are
Duplicate opportunities are two or more CRM records representing the same buying process. The pipeline counts both. Coverage counts both. The forecast counts both. Only one can ever close, so every duplicate is pipeline value that was never real.Duplicates are harder to spot than stale deals because both records usually look healthy. Recent activity, a plausible close date, an engaged contact. Nothing about a duplicate looks wrong at the record level. The problem only shows up in aggregate.
Where duplicates come from
- Re-entry after close lost. A rep closes a deal lost, the buyer returns six months later, and the rep creates a fresh record rather than reopening the old one. Both now sit in reporting, and one buying process is counted twice. - Multi-product splits. A single negotiation gets logged as three opportunities, one per product line, with each carrying the full contract value instead of its share. - Renewal and expansion overlap. The renewal record and the expansion record both include the base ARR, so the account appears to be worth roughly double what the customer will actually pay. - Partner and direct collision. A channel partner registers a deal the direct team already has open, and neither side closes the other record.
What duplicates do to the math
Duplicates inflate pipeline coverage in the most convincing way possible, because the extra value sits inside real records owned by real reps against real accounts. A team reporting 4x coverage with 10% duplication is actually at 3.6x, and the correction arrives as a miss instead of a warning. Coverage benchmarks make this worse. The standard range runs 3x to 5x, and ORM sees most customer books sitting near 3.5x, which means a duplication rate in the low teens is enough to push a book below the bottom of that range without anything visible changing.
Win rate takes the harder hit. Duplicates enter the denominator as separate opportunities and exit as losses, so a company that duplicates aggressively reports conversion well below its true rate. That understated rate then sets the coverage target, and the team builds extra pipeline to compensate for a CRM problem. The knock-on effect lands on forecast accuracy, since the model is calibrated on a conversion rate that never existed.How to find and prevent them
- Search by account and close date proximity. Open opportunities on the same account with close dates within 45 days of each other are the highest-yield candidates for review. - Check for matching amounts. Identical values on the same account almost always mean a copied record or a multi-product deal that was never split properly. - Reopen instead of recreate. Make reopening a closed-lost opportunity the default path for a returning buyer, and preserve the original creation date so deal age stays honest. - Name one primary record per buying process. When a deal genuinely spans products, one record carries the value and the others carry zero.
Duplication is a process defect, so cleanup alone will not hold. Fix the creation path or the duplicates come back next quarter.
Frequently Asked Questions
How do duplicate opportunities get created?
Four paths cover most cases. A rep creates a new record instead of reopening a closed-lost deal when the buyer returns. A single negotiation gets split into one record per product line, each carrying full value. Renewal and expansion records both include the base ARR. A channel partner registers a deal the direct team is already working.
How do you find duplicate opportunities?
Start with open opportunities on the same account whose close dates fall within about 45 days of each other, then check for matching amounts. Identical amounts on the same account almost always indicate a copy or an unsplit multi-product deal.
Why do duplicates hurt win rate more than coverage?
Duplicates enter the win rate denominator as separate opportunities and exit as losses, so reported conversion lands well below true conversion. That understated rate then drives a higher coverage target, and the team builds extra pipeline to solve a problem that only exists in the CRM.
Should duplicates be deleted or merged?
Merge where the CRM supports it, so the history survives. Where it does not, keep one primary record carrying the full value and zero out the others rather than deleting them. Deleting records removes the evidence that forecast models learn from.
Put these metrics to work
ORM builds custom revenue forecast models that turn concepts like duplicate opportunities into prescriptive action for your team.
Schedule a Demo