Business Problem

MailChimp is a great tool for people who are just starting out with email marketing and they currently use Salesforce as their CRM. We have done several implementations of MailChimp and Salesforce and wanted to provide you with our best practice approach of how to set it up right the first time.
This is Part 8 of how to setup the Mailchimp to Salesforce integration where we will show you how to solve the following business challenge we ran into while implementing Mailchimp for Salesforce. Check out our Mailchimp How To section for additional tips on how to extend this integration.
- How to manage email address changes - In this article, we discuss what happens in Mailchimp when an email address changes in Salesforce. The answer is not ideal, but at least you will be ready to manage this issue when it arises.
How to Instructions
How to Manage Email Address Changes
When you change a Contact's email address in Salesforce, a new Contact is created in Mailchimp. Yep, we thought the same thing, not ideal. Because now we have a duplicate contact in Mailchimp with a bad email address. Unfortunately, there is not an automated way to solve for this in Mailchimp because we have no way of querying the records in Mailchimp.
- The best solution we came up with is to create a report in Salesforce that will allow us to see and export the records that need to be archived in Mailchimp. If you have people in Mailchimp that do not exist in Salesforce on purpose, this solution will not work for you because you have no way of knowing which ones should or should not be archived.
- In Salesforce, go to Reports -> New Report -> All -> MC Subscribers -> Start Report
Any comments, questions, concerns – let us know in the comments! We would love to hear from you!