Emails can only be used once per list
Your email marketing platform will not allow you to bring in the same email address into the same list for more than one record.
Therefore, MailChimp and Constant Contact will only accept one of the records in a Novi group.
Only one record will appear in the contacts listing during the sync, so that the record names do not merge.
If an individual shares an email with a company, the individual will always win in this situation. If you think about it, you're never emailing a company (Imagine a building trying to check its email, ha!) - you're emailing a contact at a company.
If two or more people share the same email address, it will sync the first person, until their subscription status changes (they unsubscribe, are removed from the Novi group, etc.)
Notice in the MailChimp screenshot above that the company last name is blank. First/Last name are both sent in all cases, but last name is simply blank if it is a company.
Notice in the Constant Contact screenshot above that the people records have a First Name, Last Name, AND Company (separate from their name). The company record down at the bottom only has its name, and will have a First Name of the company name, Last Name of an underscore.
NOTE: If your groups were synced prior to the Sprint 82 release notes, you may see people and company names mixed (EX: Novi AMS Smith). This is because prior to that release, duplicate email addresses shared between records merged the record names in MailChimp and Constant Contact to prevent duplicate issues.
Why are duplicate emails an issue?
In the association world, it is not uncommon for a company record and a person record to share the same email address. We've also seen in some trade associations where multiple people share the same email address.
In that case, Novi will send or attempt to send all of those records over and whichever record is received first will be the name associated with that email address.
This is so that the same email isn't sent the same campaign two or more times, which protects your reputation across your members' email servers as a valid, non-spam email sender.
What could happen if these platforms allowed duplicates: Sally, John, and Steve are all using their company's email - email@example.com. You send a campaign to a group that includes all 3 co-workers. Office@abc.com in Outlook now gets 3 of the same emails, signaling the email provider's spam alert. The first time you send your campaign, Outlook might send you to spam. The next time and any time after, your emails probably won't go through at all.
Note: Duplicate contact emails will not affect your ability to operate in Novi. Just keep in mind that user login account emails must be different. Learn more here.
How can I prevent duplicate emails from being used?
As an admin, you will want to clean up the underlying data and actively encourage members to use their own individual email address upon signup.
How can I tell if my Novi groups have duplicates?
A simple way to check if your group has duplicates is to sort your Novi group members by email address. This will alphabetize the list by email, revealing any records with the same email addresses. You could also download the list and use the Excel function to highlight duplicates in the email column.