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 for synchronization. Replication with incremental updates requires at least one of the fields.
- Restoring objects with composite primary key, like InterestGroups, from backup is not supported.
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:
- Click +NEW in the top menu.
- Open the Select Connector page by clicking Connection in the menu on the left.
- In the opened pane, click Mailchimp.
In the Connection Editor page, specify a connection name that will be used to identify the connection.
- Click Sign In with Mailchimp.
In the opened window, enter your Mailchimp credentials and click the Log In button.
- Optionally, select values for the Merge Fields Behavior and Metadata Cache parameters. The parameters are described below.
- Optionally, switch API Version from Ver2 to Ver3 if you want to use Mailchimp API 3.0.
- 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 checkbox.
- 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 checkbox. Note that this checkbox is completely ignored if Mailchimp API Ver2 are used.
- 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 checkbox 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 for how long the cached metadata for the connection are considered valid. By default, Skyvia caches metadata of available objects in cloud sources. Whenever necessary, you can reset metadata cache for a connection manually in the Connection Editor by clicking the Clear now link. The following values are available for this parameter:
- Disabled — metadata cache is not created; metadata are queried automatically whenever required.
- One Hour — metadata cache expires one hour after the last refresh.
- One Day — metadata cache expires one day after the last refresh.
- One Week — metadata cache expires one week after the last refresh.
- One Month — metadata cache expires one month after the last refresh.
- Infinite — cache never expires/resets automatically. Default value.
Supported Actions and Actions Specifics
Mailchimp connector supports the following actions:
- Execute Command in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.
Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.
- Lookup in Lookup Data Flow components.
- Insert in Target Data Flow components.
- Update in Target Data Flow components.
- Delete in Target Data Flow components.