Connecting to Mailchimp

Mailchimp is a cloud-based email marketing solution that allows designing and sending marketing emails.

Data integration: Skyvia supports importing data to and from Mailchimp, exporting Mailchimp data to CSV files, replicating Mailchimp data to relational databases, and synchronizing Mailchimp data with other cloud apps and relational databases.

Backup: Skyvia Backup supports Mailchimp backup.

Query: Skyvia Query supports Mailchimp.

Mailchimp-Specific Features and Limitations

Merge Tags Support

Skyvia supports Mailchimp merge tags of the ListMembers table, except for cases when different lists have merge tags with the same name but different type, default value, required setting, etc. Skyvia also does not support Mailchimp merge tags having double quotation marks in their name. Check details of this support below.

Mailchimp API Versions

Skyvia supports connecting via both Mailchimp API 2.0 and 3.0. Please note that some tables and fields, like Automations, ListMemberNotes, ListMemberGoals and others, are available only via Mailchimp API 3.0, and some — only via Mailchimp API 2.0. By default, Skyvia uses Mailchimp API 2.0. You can change this at any time in the connection editor.

Updating ListMembers (Subscribers)

When updating Mailchimp subscribers (ListMembers) in an import package with the UPDATE operation, you can improve performance of this operation if you specify emails of the subscribers to update. You need to specify them in mapping for the Email field. Note that subscriber emails are not actually updated in this case, this field is just used to find the subscribers for update faster.

Mailchimp Support Limitations

Skyvia has the following limitations for Mailchimp:

  • Synchronization and Replication with Incremental Updates enabled are not supported for objects without CreatedDate or LastUpdate fields. Both fields must be present for this functionality.
  • Restoring objects with composite primary key, like InterestGroups, from backup is not supported.

Mailchimp Connections

When creating a Mailchimp connection, you simply log in with Mailchimp. The OAuth authentication token is stored on the Skyvia server. Your Mailchimp account login and password are not stored on the Skyvia server.

To create a Mailchimp connection, perform the following steps:

  1. Click +NEW in the top menu.
  2. Open the Select Connector page by clicking Connection in the menu on the left.
  3. In the opened pane, click Mailchimp.
  4. In the Connection Editor page, specify a connection name that will be used to identify the connection.

    Connection Editor window

  5. Click Log In with Mailchimp.
  6. In the opened window, enter your Mailchimp credentials and click the Log In button.

    Mailchimp Log In window

  7. Optionally, select values for the Merge Fields Behavior and Metadata Cache parameters. The parameters are described below.
  8. Optionally, switch API Version from Ver2 to Ver3 if you want to use Mailchimp API 3.0.
  9. Optionally, if you want to use merge tag values as names for Mailchimp merge tags instead of merge tag labels, click Advanced Settings and select the Merge Tag As Field Name check box.
  10. For Mailchimp API Ver3, batch operations are used by default. This significantly improves performance of loading data to the ListMembers object, which stores subscribers. You may optionally turn off batch operations by clicking Advanced Settings and clearing the Use Batch Operations check box. Note that this check box is completely ignored if Mailchimp API Ver2 are used.
  11. Click Create Connection.

Merge Fields Behavior — this parameter determines how to present Mailchimp merge tags when working with the ListMembers table. Merge tags are custom fields of the ListMembers table in Mailchimp. Its own set of merge tags can be added for list members of each list. However, Skyvia presents all tables, including Mailchimp ListMembers, so that all its rows have the same columns.

The following values are available for this setting:

  • Without Merge Fields — all merge tags are not read from Mailchimp and not added as ListMembers table fields.
  • Join Common Merge Fields — only merge tags defined for all the Lists are added as ListMembers table columns. Other tags are ignored.
  • Join All Merge Fields — all the merge tags are joined to other ListMembers table columns (except for the case described below). If a merge tag is not defined for the list, a list member belongs to, NULL value is returned for the corresponding column of this list member.

If different lists have merge tags with the same name (field label) but different type, default value, required setting, tag, etc., these merge tags are ignored regardless of the Merge Fields Behavior parameter. Merge tags that have the same name for different lists must be the same in order to be available in Skyvia.

However, if only tag values (the values in the Put this tag in your content: column on the List fields and *|MERGE|* tags tab in Mailchimp list settings) are different for different lists, and type, default value, and required settings are the same, you can select the Merge Tag As Field Name check box in your connection settings and have access to merge tags that have the same labels but different tags.

Skyvia displays Mailchimp merge tags with the Required label in mapping and checks whether they are mapped only if both of the following conditions are met:

  • The merge tag is present for all Mailchimp lists.
  • The merge tag has the Required attribute for all Mailchimp lists.

Metadata Cache — this parameter determines how often the cached metadata are updated. By default, Skyvia caches metadata of available objects in cloud sources. When creating a connection, you can configure how often cache is refreshed or, when the connection already exists, you can reset it manually on the Connection Editor page by clicking the Clear Cache button. The following values are available for this setting:

  • Disabled — metadata cache is not created; metadata are queried automatically whenever the connection is opened.
  • One Hour — metadata cache expires one hour after the last refresh; it is refreshed when the connection is opened again.
  • One Day — metadata cache expires one day after the last refresh; it is refreshed when the connection is opened again.
  • One Week — metadata cache expires one week after the last refresh; it is refreshed when the connection is opened again.
  • One Month — metadata cache expires one month after the last refresh; it is refreshed when the connection is opened again.
  • Infinite — cache is never reset automatically. Default value.