Skip to content
sandadocs

Mailchimp

Connect Mailchimp to sanda: what to prepare, the fields the connection form asks for, and how its data lands in your warehouse.

Connect Mailchimp

  1. Open the catalogue. In the console, go to Data · Connections and press New connection.
  2. Choose Mailchimp. It is listed under marketing and analytics; you can also search for it by name.
  3. Fill in the form. Enter the fields below. Credentials go straight to sanda’s sync engine and are never stored in sanda’s database.
  4. Choose what to sync. Pick the streams you want, and a sync mode for each. See choose what to sync.
  5. Run the first sync. sanda tests the connection, then lands each stream as a table in your warehouse.

Configuration fields

What the connection form asks for. Required fields are marked; the rest are optional.

Field Type Required Description
Number of Concurrent Threads integer No The number of worker threads to use for the sync. Higher values can speed up syncs but may hit rate limits. Mailchimp allows up to 10 simultaneous connections. Default 2.
Authentication one of 2 options No
Incremental Sync Start Date string No The date from which you want to start syncing data for Incremental streams. Only records that have been created or modified since this date will be synced. If left blank, all data will by synced.

Authentication

Choose one of the following. Each asks for its own fields.

OAuth2.0

Field Type Required Description
Access Token string, secret Yes An access token generated using the above client ID and secret.
Client ID string, secret No The Client ID of your OAuth application.
Client Secret string, secret No The Client Secret of your OAuth application.

API Key

Field Type Required Description
API Key string, secret Yes Mailchimp API Key.

Something unclear or out of date? Tell us, and we will fix the page.