How do I export my customers to MailChimp?

#1) Sign up and log in to MailChimp

#2) Set up your API keys

#3) Create an Audience

Log into your MailChimp account and navigate to Audience in the left sidebar > Audience dashboard (direct audience link). Click on "Create Audience" button in the upper right:

Note: If you've already created audiences before, then you can click on Audience Dashboard (left sidebar) > Manage Audience dropdown > View audiences > you'll then be able to use Create Audience like in the above screenshot:


Now you'll see a Create Audience form like so -- fill out with your own business info:

Hit "Save", which will redirect you to your new Audience. Click on Settings > "Audience name and defaults":



Which will show you your audience list ID:

Copy this list ID (without the period) into your CleanerPlanner account > Settings > Integrations > MailChimp > List ID:

Save your settings to close out.


#4 Sync Customers to MailChimp

Note: This is currently not working due to an API upgrade on MailChimp's side. We are working ASAP on a fix for this. Please see the following section 4b which shows you how you can still export to MailChimp.

Whenever you update your customers information in CleanerPlanner, you can go to the Customers tab and click "Update MailChimp". This will sync your customers to MailChimp. The customer's Name, Source, Rounds and Services with Status data are all exported, so you can filter by these as needed in MailChimp.

You can now set up email campaigns, surveys, sign-up forms and more! (see final section in this documentation)


#4b Manual Sync to MailChimp

If the automatic "Update MailChimp" sync isn't working in CleanerPlanner, you can manually sync to MailChimp with a few quick steps in less than 5 minutes.

Go to the Customers tab and hit Export:


Note: In the rare case that your # of customers exceeds the maximum limit (you'll see that when you open up the exported file, it contains fewer than your total # of customers) — drop a message to support@cleanerplanner.com and we'll get your full customer list exported to you ASAP.


Open up the exported file:

  • You only need to keep the columns for Email, First Name, and Last Name
  • You may also find it helpful to keep other columns like Round, Service, Status, and Source
  • All other columns can be deleted


Hit Save.

Now in your MailChimp admin account, navigate to Audience > Audience Dashboard (https://admin.mailchimp.com/audience/). Click on the button to "Add Your Contacts":

Note: If you already synced to MailChimp before, you can add more contacts via "View Contacts" > "Add contacts" dropdown > "Import contacts". Note also that MailChimp is smart enough to dedupe if you were to upload an overlapping contact list, so you can upload your entire customer list each time.

Next, you'll see 3 options for adding your contacts. Select the option to "Upload a file" and upload the CSV that was exported from CleanerPlanner:

Hit "Continue". The fields for Email, First Name, and Last Name should be automatically recognized.

If you added custom extra fields like Round, Status, Source, etc. then you need to mark them for MailChimp to recognize. Hit the "Edit" pencil icon for these custom columns:

In the pop-up, select "Create a new field":

You can then label this field as e.g. Round:


Finish and save. Note that only customers with email addresses will be imported, since MailChimp relies on that to email your customers.

You can now set up email campaigns, surveys, sign-up forms and more! (see final section in this documentation)


#5 Set up Email Campaigns and Surveys

MailChimp has extensive documentation on setting up various types of email campaigns, surveys, sign-up forms etc. As an example, here is the setup for a simple email campaign: https://mailchimp.com/help/create-a-regular-email-campaign/


Go to your admin dashboard in Mailchimp and click on "Create":

You can now select your desired email campaign:


Once you've filled out the email template, hit Send to distribute to your customers!

Note: Please be sure to comply with any GDPR requirements with targeting customers in email campaigns.

Still need help? Contact Support Contact Support