What is the difference between "Add & Update" and "Update Only" during the import process?

  • 0
  • 2
  • Question
  • Updated 3 years ago
  • Answered
  • (Edited)
when I do a new import and click Add & Update, rather than updating the current contact it is creating a new contact and the old one is still there? How can I make sure that the current contact is updated so that I don't have duplicate contacts in the system?
Photo of ICAN

ICAN

  • 9 Posts
  • 0 Reply Likes

Posted 5 years ago

  • 0
  • 2
Photo of Katie Watts

Katie Watts, Support Team Manager

  • 423 Posts
  • 66 Reply Likes
Official Response
Hi there!

Emma uses the email address of a person as the unique identifier for that contact record. So when you do an import and select "add and update," if any of the other information that you've mapped during the import process for that contact record changes, it will be updated on the current record. Selecting the "add and update" option during the import process gets your current member records updated and adds in brand-new audience members.

Since the email address is the unique identifier for a contact record, if the email address changes for a person, then Emma will create a brand new contact record for that new email address. For example, let's say I had an existing contact record in your account with the name "Katie Watts" and the email address of abc@myemma.com. Then you did an add and update import, and in your new spreadsheet, you had the name for abc@myemma.com reflected as "K Watts." That would update the name on the existing contact record for abc@myemma.com to "K Watts." But if on that import you had an entry with the name "Katie Watts" and the email address of abc2@myemma.com, then a new contact record would be created for abc2@myemma.com.

Hope this helps clear things up! If you're looking for some additional information on this, please check out our how-to information on IMPORTING YOUR AUDIENCE CONTACTS. Or if you're finding a situation where the email address matches on both the existing contact record and the spreadsheet you're importing but the existing record isn't being updated as expected, please comment on this thread with the email address of that contact so I can dig in further in your account. Always happy to help!
(Edited)