Duplicates in Salesforce - Integration Issues

  • 0
  • 2
  • Question
  • Updated 1 year ago
  • Answered
My client has some contacts that are actually different people that share the same email address. When the integration was first turned on, contact names were overwritten on several records since the email address matched a different contact as well.

Is it correct to assume that Emma is keying off of the Email address to make updates and no other fields in Salesforce? I think need to clean some data and put some duplicate checks in place, but I want to make sure the integration is just matching on the email field only and the Emma Member ID field isn't used in the integration. These contact records also share the same Emma Member ID as well. Would that data need to be cleaned out on the "bad" duplicate records?
Photo of Lisa Alworth

Lisa Alworth

  • 1 Post
  • 0 Reply Likes

Posted 2 years ago

  • 0
  • 2
Photo of DigiVid360

DigiVid360

  • 4 Posts
  • 4 Reply Likes
Lisa,
It's probably best to let a representative from Emma answer your question, but my understanding that the record "key" between Salesforce and Emma is the email address.  If there are duplicates in one place or the other, it can produce unwanted results.

There is an Emma Member ID stored in Salesforce but I'm not sure how that is used. It seems logical that it would be a record ID but I don't think it is used for the sync between the two systems.

I also don't have a clear answer for your current situation of "bad" duplicate records as in the cleanup you will want to keep the records that synced and remove the ones that are true duplicates. But I will say, this will be a manual process for you to resolve. 

You will want to contact their support team for help.
Photo of Laura Dickerson

Laura Dickerson, Official Rep

  • 778 Posts
  • 64 Reply Likes
Hi there!

In Emma the unique identifier is the email address and that email address can only be used once. If you have two people using the same email address, Emma will only accept one of them. You would need to decide which record should be the main one. I hope this helps?
Photo of Mazamas

Mazamas

  • 6 Posts
  • 1 Reply Like
This is a bit of a challenge. I'm trying to send out camp notifications to parents who have multiple kids in a camp, but I can only send them one email, which is just going to cause major confusion. Rather frustrating as it doesn't seem like we can use your service to send these emails.
Photo of Grey Stepp

Grey Stepp, Support Team Manager

  • 1700 Posts
  • 135 Reply Likes
Hey there!   Some other customers (schools, etc) have had luck with using Dynamic Content to solve your particular use-case.  Check out Jason's answer on this post:
https://community.myemma.com/emma/topics/multiple-emails-with-multiple-personalization-tags

I think that may help!  

Cheers!

-G