topic Re: Limiting the dup pairs to the ones with only two duplicate record in DemandTools

Limiting the dup pairs to the ones with only two duplicate record

NA — Fri, 18 Jul 2025 17:39:08 GMT

Hi, we have a situation that when there is only two records in a dup pair - the winner is clear.

If there are three or more duplicate records in a dup-pair, it usually means something requires human intervention.

Is there any way to make the Merge Managemnt aka review duplicate process, limit the results to only those dup-pairs with only two?

Thanks

Re: Limiting the dup pairs to the ones with only two duplicate record

Pugs_Validity — Mon, 21 Jul 2025 19:40:05 GMT

@NA - Not particularly but what is it that makes your winner clear? When you get instances of more than one duplicate record, is it typically an situation where you have two winners or two losers?

Re: Limiting the dup pairs to the ones with only two duplicate record

NA — Tue, 22 Jul 2025 23:26:53 GMT

Fair question:

Unfortunately, a member of our IT team unintentionally ran a process that created 16,000 anonymous households. The goal here is to reunite these anonymous households with the correct account that they were created from.

To create the rule that the anonymous household will always be the loser - that part was straightforward .
And when there is only one record dupe - then the winner is easy to identify.
When there is three or more than it is not clear cut.
So the goal is to create a subset of only two record pairs - so Demand Tools can do it's stuff.
Am I making sense?

Re: Limiting the dup pairs to the ones with only two duplicate record

Pugs_Validity — Wed, 23 Jul 2025 21:26:23 GMT

@NA - Ah, gotcha. When you setup your Winner Rule, turn the Score Delta on, it shouldn't matter what number you have it at, as long as it's greater than zero. Once that's on, if the two non-anynonmous households are in a set with a anonymous household, Demandtools won't select a winner in that set due to them scoring the same value and not meeting the score delta threshold. You should then only be left processing those that have one non-anonymous. Additionally, you can then manually review or apply a 2nd or 3rd Winner Rule for the sets of 3+. Make sense?

Re: Limiting the dup pairs to the ones with only two duplicate record

NA — Thu, 24 Jul 2025 21:07:03 GMT

Works like a charm - Thanks - Neil