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:

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:

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

• Performing UPSERT Operation
• Lookup Mapping documentation
• Mailchimp Connection Setup