A Quick Guide to Importing and Updating Audience Members in Mailchimp
Overview
This article explains how to configure an UPSERT operation for the Mailchimp ListMembers object in Skyvia. This is the recommended approach for importing and updating Audience members without creating duplicates.
How UPSERT Works for Mailchimp ListMembers
The UPSERT behavior depends on whether the Id field is mapped:
| Id value | Operation |
|---|---|
| Id is specified | Update - Skyvia attempts to update the existing member, even if the Id turns out to be incorrect |
| Id is NULL | Insert - Skyvia creates a new member; the Id is generated by Mailchimp |
Required Fields
When setting up UPSERT for the ListMembers object, the following fields must be mapped:
- Id - resolved via Lookup Mapping (see Step 1)
- ListId - the ID of the Mailchimp Audience
- Email - the member's email address
Configuration Steps
Step 1: Set the Lookup Mapping for the Id field
Configure a Lookup Mapping to resolve the member's Id based on their email and audience:
| Setting | Value |
|---|---|
| Lookup Object | ListMembers |
| Resulted Column | Id |
| Lookup Key Column 1 | ListId |
| Column 1 | ListId (or set as a Constant value) |
| Lookup Key Column 2 | |
| Column 2 |
Step 2: Enable "Set Null When No Match Found"
Open Options in the Lookup Mapping and enable Set Null When No Match Found.
Note: This option is required only for UPSERT. When no existing member is found, the Id becomes NULL and triggers an Insert operation.
Step 3: Map ListId and Email fields
Map ListId to a Constant (enter the target Audience ID as a constant value) and map Email from the source column.
Step 4: Map remaining fields
Map any additional fields required for your use case (e.g., first name, last name, subscription status).
How to Find Your Mailchimp ListId
Use one of the following methods:
- Follow the Find Your Audience ID guide on the Mailchimp website.
- Run the following SQL query in Skyvia Query against your Mailchimp connection:
SELECT "Id", "Name" FROM "Lists"
Useful Links
Related Articles
Working with Mailchimp Custom Merge Fields
Overview In some scenarios, you may encounter difficulties accessing custom Mailchimp fields in Skyvia. This article explains how to configure the Merge Fields Behavior setting to make custom (merge) fields available in your integration. Steps to ...Skyvia Query: Verify Data in Your Connection
Overview Skyvia Query allows you to browse and verify data in any connected data source directly from the Skyvia interface, without writing complex scripts or using third-party tools. You can use the visual Builder view or write custom SQL ...UPSERT Runs Successfully but Doesn't Insert or Update Data
Overview Sometimes an integration run in Skyvia finishes with Success, but no new data is inserted or updated in the target table. This situation most often occurs when using the UPSERT operation. Why This Happens UPSERT decides whether to Insert or ...Mapping the RowNo Column for UPDATE/UPSERT Operations in Google Sheets
Overview When performing UPDATE or UPSERT operations on Google Sheets data in Skyvia, the RowNo field is mandatory. RowNo is a unique auto-generated row number assigned to each row in the sheet. Skyvia uses it to identify which row to update. Without ...Collection of Skyvia Help Resources
Overview This article provides a quick reference to all official Skyvia resources. Use the guide below to find the right resource for your task. Official Resources Documentation — Technical reference covering all Skyvia products: Data Integration, ...