Duplicate email addresses for contacts and consumers

[OlegA]

Hi, I would like to hear your thoughts and experiences on how you deal with duplicate email addresses for contacts and consumers.

A little background, we are implementing CSM and we offer B2B and B2C services.

We experience that often times private individuals use their work email address for private inquiries. And also that one person can represent multiple accounts which also results in two separate contact records for the same individual. And often times they would use the same email address for both account contacts. 

In worst case we can have consumer and multiple account contacts with same email address.

I wish we could forbid using duplicate emails, but some of the contacts/consumers are created automatically based on external registers.

How would you deal with this? 

[RaghavSh]

@OlegA The only option looking feasible here is taking a report at regular intervals and correcting/deleting the redundant data.

Since you cannot forbid duplicate emails, that's the only option left.

Please mark the answer correct/helpful accordingly.

[RaghavSh]

@OlegA was this helpful?

[OlegA]

no, unfortunately not, I don't see how creating a report will help us register and store users with duplicate emails.

[Wasif]

Just thinking out loud,
I think it would depend on the how the data is ingesting into the system.

If its via Transform map, you may have a coalesce in place to honour account + email as key for uniqueness or whatever qualifies as unique combination for the use case.

By default, sys_user, by default has primary key of userid, but an additional layer via integration can try to refine the incoming data.

Alternatively can have data policies in place to govern an and restrict duplicate emails in the underlying table