We're a nonprofit and we run Sales Cloud with a few (not all) NPSP elements. We use standard contacts and accounts. One of our teams uses the Mailchimp integration to add SF contacts via the Mailchimp newsletter signup on an external website. It gets a lot of traffic and many stakeholders have signed up with multiple email addresses. The MC integration creates "new" signups (often duplicates) as SF leads, which we manually convert.
So far, we've been allowing duplicates for each unique email subscription through MC. We're pretty early in our org-wide SF launch so it hasn't come to a head yet, but our current process is not sustainable. The reasoning for allowing duplicates is that its unclear whether a single contact can be subscribed with multiple emails. I'm concerned that putting one subscribed email into the additional email field on the contact (and eliminating the duplicate record) would signal to MC that the subscriber doesn't exist in SF?
This feels super confusing so here's an example:
I'm subscribed to the MC mailing list (associated with a single campaign in SF) with my professional email proemail@example.com.
I'm also subscribed to the MC mailing list with my personal email personalemail@example.com.
On my contact record, if proemail is in the main email field, it's associated with MC. If I put personalemail into the additional email field, will MC recognize it?
I'm thinking this has to do with field mapping maybe.
Will SF reject the second email since the MC mailing list is linked with a single campaign, and one contact can't be in a single campaign twice? Or can it?
I know enough to know that I'm missing some contextual knowledge to fully understand this. Hopefully its a simple answer! Looking forward to hearing your thoughts, thank you!
2 Antworten
Putting the second address into another email field won’t necessarily make the existing integration treat it as another subscription for that Contact.
I’d figure out how you want to model those subscriptions in Salesforce first. If the current Mailchimp integration keeps creating Leads and duplicates, another option is to handle the sync separately. I’ve used Skyvia (https://skyvia.com/data-integration/integrate-salesforce-mailchimp) for Mailchimp and Salesforce when I needed more control over the mapping and how records were matched before loading them.
