A Quick Guide to Importing and Updating Audience Members in Mailchimp

A Quick Guide to Importing and Updating Audience Members in Mailchimp

If your integration involves importing data into Mailchimp Audiences, this information might be helpful.

To start, let’s take a quick look at how the UPSERT operation works:
  1. If the Id is specified, the integration attempts an Update operation even if the Id is incorrect.
  2. If the Id is set to NULL, an Insert operation is triggered, and the Id is generated on the Mailchimp side. Therefore, mapping the Id field is necessary, but it can contain a NULL value. This applies if the source column is missing or if it’s a lookup that returns NULL, in which case the Insert operation will proceed.
For more details on UPSERT operations, please refer to this article in our documentation.

When setting up the UPSERT operation for the ListMembers object, you have to map at least a few required fields: Id, ListId, and Email.
Please follow these steps to configure UPSERT for the ListMembers table:

1. Set the Lookup Mapping for the Id Field:

Lookup Object: ListMembers
Resulted Column: Id
Lookup Key Column: ListId
Column: ListId (or set it as a constant value)
Lookup Key Column: Email
Column: Email


2. Open Options and enable "Set Null When No Match Found".
Note: This option is necessary only for the UPSERT operation.

​

3.   Map ListId to the Constant (set the necessary ListId value) and set mapping for the Email field:


4. Set mapping for other fields, if necessary, etc.

To get your ListId, you can use:
  1. Find Your Audience article on the Mailchimp website.
  2. Skyvia Query Tool with this SQL command on your Mailchimp connection:
SELECT "Id", "Name" FROM "Lists"

If you run into any issues or have more questions, we’re here to help with any technical questions you might have!
You can reach out to us through our Support Portal, by Email, or via Live Chat.