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.

• Related Articles

• Mapping the RowNo Column for UPDATE/UPSERT Operations in Google Sheets

  When implementing UPDATE/UPSERT operations in Google Sheets, you may need to set up mapping for the RowNo mandatory field. RowNo is a unique auto-generated row number in the Sheet. It is essential for performing UPSERT/UPDATE operations, as it ...

• Salesforce Audit Fields: Quick Insertion Guide

  To use audit fields for the INSERT operation in Skyvia, please enable the 'Create Audit Fields' permission in your Salesforce instance. More details can be found here. Below are the steps to enable the permission: Go to Setup → User Interface. Enable ...

• Account and Workspace Roles in Skyvia

  In Skyvia, we distinguish between account and workspace roles for seamless teamwork: 1. Account Roles The account admin, also known as the account owner, has full control over the account. They can manage subscriptions to Skyvia products, modify ...

• BigCommerce: "The value of the column Categories has incorrect JSON format" error

  When working with the Categories field in the Product object within the BigCommerce API, it's important to understand how to format and import data correctly to ensure a successful import. In the BigCommerce API, the Categories field in the Product ...

• The specified lookup is ambiguous. Lookup must return at most one row for the specified lookup condition

  This error occurs when a Lookup operation returns multiple matching records for the specified condition. Lookups are designed to find and act on only one record — when that’s not possible, this error is triggered. Possible Solutions: 1. Use "First ...