I have kind of a strange situation that I'm looking to find a solution to. I have a number of duplicate emails, but that is because some of the recipients in our system share an email address among multiple unique individuals within the business. Each of these entities has their own unique ID code within our business that feeds into Marketo with their other information, which exists separately from their automatically assigned Marketo ID. The duplicates in this case are not necessarily a mistake and while they share an email, it is correct that they do not share an ID code.
What I would like to be able to do is to isolate the email duplicates based on another factor. In this case, it is their rewards level. Some individuals share the same email and the same rewards level, but have different proprietary and Marketo ID numbers that correctly identify them as them separate records. Others have all of those factors differing except for the email.
Is it possible to use a campaign or smart list to separate out those who have the same Rewards Level and email, but different proprietary and Marketo ID numbers from those that only share the same email?
... View more