AnsweredAssumed Answered

Help identifying duplicates across instances

Question asked by Nathaniel Kobza on Mar 9, 2019
Latest reply on Mar 11, 2019 by Nathaniel Kobza

Hey Marketo Community,


A company that I am working with is going through some merging and acquisition changes. One of the objectives in the near to mid term is to consolidate into one Marketo instance.


We are in the process of doing a lot of the prep work and one of those tasks is to identify how many email address duplicates that we have across our two instances.


Has anyone had to do something similar? And, if so, what was your process? Currently the game plan is to export just email addresses from instance A and instance B and then to remove duplicates to just see a raw number of unique emails. There will be a little under 1 million email addresses that we'll be looking for duplicates. And while this particular scenario isn't a really difficult task, I wanted to see if there were more efficient or effective processes to do something of this nature. Especially if, in the future, we want to de-dupe based off of more than just email addresses because that could, and would, bog down the spreadsheet with so many columns and rows filled with data. Or we could possibly run into limitation issues in Excel: Excel specifications and limits - Excel


Thanks in advance for the help.