I seem to have a lot of duplicates (based on the built in duplicate check, i.e. the Email Address field) in my DB, where one of each "pair" is a lead or a contact, and the other one is from a list upload (not flagged as neither a lead nor a contact and not synced to SFDC). Since the 'Email Address' field is the duplicate matching criteria, the duplicates cannot have been created from uploading the list of email addresses to the wrong email field (we have a few), right?
I'm thinking that either
- the lead/contact was created first, and then the list upload person was created as a duplicate
- or of course the other way around
Either way, I would like to understand under what circumstances this can happen (and try to stop this in the future).
Any insights would help!