What it means
Two sellers open opportunities for the same buyer project, and the pipeline now counts the expected revenue twice. Revenue operations pipeline duplicate opportunity review rate checks whether likely duplicate deals are reviewed before forecasts rely on them.
An opportunity is a specific potential transaction, not just a company name, and one customer may have legitimate separate deals. Duplicate rules can surface candidates, but a match on names alone cannot establish that two opportunities are the same transaction.
Compare buying entity, product scope, project, amount, expected decision, period and customer contacts, and look for the same quote, order form or procurement reference across records as stronger evidence than a shared address. If a customer is buying in several countries, separate legal entities may need separate opportunities despite a shared brand, and an expansion and renewal can coexist, so do not merge them simply because they share an account and date.
If one opportunity is already closed won, another open opportunity may be a later expansion rather than a duplicate, and a rebooked deal should be distinguished from a new sale, with a cross-reference retained if reporting uses both IDs. For a prospect with a common company name, use trusted identifiers before merging unrelated accounts, and an automated merge is risky if separate product purchases can look identical in the CRM.
Use stable account IDs and deal IDs in review logs, since names change, and if a deal split or commission claim is attached to both records, reconcile credit under the relevant policy. Keep links to the original records and a decision of duplicate, legitimate separate deal or unresolved, and a reviewed candidate that is not a duplicate still counts as reviewed but should retain the reason.
If two sellers contact the same buying group, review ownership while preserving a single commercial event where appropriate, and keep customer communications coordinated so the buyer does not receive two conflicting proposals. When merging, check where notes, attachments, tasks and quote links will end up, do not erase sales activity that explains how the duplicate arose, and when a review concludes duplicate, record which opportunity is retained and why, so future reports use the canonical record while keeping a path back to the archived one.
Define a prompt review window before the records enter a commit forecast or lead to duplicate quotes, and define the numerator as flagged potential duplicate opportunity pairs reviewed with a documented decision in the window. The denominator includes all flagged pairs under the chosen screening rule, including later false positives, and if a rule flags the same pair repeatedly, count the pair once for the review period; if a new material fact appears, a fresh review may be appropriate with its own timestamp.
Show confirmed duplicate share and false-positive share alongside review rate, and if a forecast includes both records while the case is unresolved, flag the potential double count. A high review rate can coexist with poor screening if the rule misses most real duplicates, so sample unflagged opportunities to estimate missed duplicates.
If a duplicate was created by integration sync, fix the mapping or workflow rather than repeatedly deleting records, review patterns by import source and team to improve the intake process, and where customer data is restricted, route the review to someone permitted to view both records. If a team rejects a duplicate suggestion, give a reason so it is not endlessly re-flagged, make the decision reversible through an audit trail if new evidence shows two real transactions, and use the rate to protect forecasts and customer experience without collapsing legitimate business into one deal.
In practice
Real-world examples.
Example
Two opportunities carry the same buyer project and quote; a reviewer confirms one commercial transaction.
Example
Two deals share an account but cover separate renewal and expansion purchases. The reviewer rejects the duplicate flag.
Example
A possible duplicate pair sits unresolved while both amounts enter commit forecast. The review misses its window.
Formula
Calculation
Illustrative review rate = distinct flagged candidate pairs classified in the required window / all distinct flagged candidate pairs due for review x 100.
Worked example: a fictional revenue operations team has 50 distinct flagged pairs due for review in the month, and 44 are classified with a documented decision inside the window. The review rate is 44 / 50 x 100 = 88%. The outcomes are 14 confirmed duplicates (28%), 30 false positives (60%) and 6 not yet classified (12%), and 14 + 30 + 6 = 50. If each confirmed duplicate carried about $50,000 of pipeline, removing them took out 14 x $50,000 = $700,000 of double-counted value.Case study
Seen in the real world.
This fictional case follows Mossfield Software. A CRM import created a second opportunity tied to an existing quote. Revenue operations linked the records, removed the double count from forecast and updated the import rule. The delayed review stayed in its missed-window count.
The case is invented. Mossfield then reviewed duplicate patterns by import source and found that one weekly sync created most of the candidate pairs. After the mapping was fixed, the number of flagged pairs fell, and the team sampled unflagged deals to confirm the screening rule was not missing real duplicates.
Watch out
Common mistakes.
- 1. Merging two legitimate purchases because the company name matches.
- 2. Counting repeated alerts for one pair as new reviews.
- 3. Reporting fast review without checking for duplicates the rule never flagged.
Questions
People also ask.
Are same-account deals always duplicates?
No. Compare the actual transaction and buying context.
Do false positives count in the denominator?
Yes, if the screening rule flagged them for review.
Does a high review rate prove the pipeline is clean?
No. Estimate missed duplicates outside the flagged set.
From the founder's library

Take it further with the book.
Build your financial confidence beyond this definition. Shihan's full-length guide, Accounting Fundamentals, takes the same plain-English approach and turns it into a complete, practical playbook for non-finance managers, business owners and students - with chapter-end quiz answers and presentation slides included.
25% off with code MMHQ25, applied at checkout. Priced in USD - checkout may show the equivalent in your local currency.
View the book and save 25%Related
