Mailchimp
This page describes how to use Census with Mailchimp.

🏃‍♀️⠀Getting Started

In this guide, we will show you how to connect Mailchimp to Census and create your first sync.

Prerequisites

1. Connect Census to Mailchimp

In the Connections page in Census, click the Add Service button under the Service Connections section, and select Mailchimp.
You will be redirected to a page to log in to Mailchimp to authorize your account to Census. Once you enter your credentials and click the Log In button, you'll see a page like the image below, confirming you want to authorize Census.
Once you've authorized Census, you'll be redirected back to the Connections page in Census and you should see your Mailchimp connection there.
If you want to see your connections in Mailchimp in the future, simply navigate to the Profile page, and scroll down to the Connections and notifications section.

💡⠀Mailchimp Field Quirks

There are two mandatory fields for the Mailchimp connection: email and status.
Please note that the mandatory status field only accepts the following values: "subscribed", "unsubscribed", "cleaned", or "pending".
In addition, pre-hashed emails can be used as the record identifier for syncs with the Update behavior. The hash must be the MD5 hash of the lowercase version of the list member's email.
For more details, take a look at Mailchimp's API documentation.

🗄⠀Supported Objects

Object Name
Supported?
Identifiers
List/Audience Members
Email Address, Prehashed Email Address (update-only)

Prehashed Email Identifiers

To prehash your emails, first lowercase the email address and then apply an MD5 hash, both which can be done directly in SQL. For example, here's the SQL you'd use in Snowflake (syntax for other data warehouses vary slightly)
SELECT MD5(LOWER('[email protected]'))

Status and Unsubscribing List Members

The Mailchimp status field supports one of four values: subscribed, unsubscribed, cleaned, or pending. To unsubscribe a member from a particular list, simply set the status field to unsubscribed.

Tags

Mailchimp tags field can be set by providing an array of string values as structured data. Read more about syncing Structured Data using Census.

🔄⠀Supported Sync Behaviors

Learn more about what all of our sync behaviors on our Core Concept page.
Behaviors
Supported?
Objects?
Update or Create
All
Update Only
All

🚑⠀Need help connecting to Mailchimp?

Contact us via [email protected] or start a conversation with us via the in-app chat.