Skip to main content

Mailchimp

info

API Documentation: Mailchimp API Documentation

Authentication​

Authenticate with Mailchimp using:

  • API key: A Mailchimp API key for the account you want to access.
  • Server prefix: The Mailchimp data center prefix for your account (for example, us19). This must be a valid DNS label (lowercase letters, numbers, and hyphens only).

To find your server prefix, look at the end of your API key (it appears after the hyphen), for example: abcd1234-us19 → server prefix is us19.

Source Setup Guide​

Step 1​

banner in the Edit Source form to the left.

Step 2​

Follow the authentication flow (OAuth) in Mailchimp's website to grant Extract the required permissions.

Step 3​

Confirm you can see your email and profile picture, and that the source is Connected.

Setup Guide​

  1. In Mailchimp, generate an API key:

    • Go to Profile → Extras → API keys.
    • Create a new key and copy it.

  2. Identify your server prefix (also called the data center), which is the part after the hyphen in your API key.
    Example: abcd1234-us19 → server prefix is us19.

  3. In Extract, configure the Mailchimp connector with:

    • API key: your Mailchimp API key
    • Server prefix: your Mailchimp server prefix (for example, us19)

Schema ERD​

Explore the interactive entity relationship diagram for Mailchimp.

Open page

Data Streams​

automation_emails​

Loading ....

automations​

Loading ....

campaign_abuse_report​

Loading ....

campaign_clicks_report​

Loading ....

campaigns​

Loading ....

email_activity_report​

Loading ....

interest_categories​

Loading ....

list_tags​

Loading ....

lists​

Loading ....

member_marketing_permissions​

Loading ....

member_tags​

Loading ....

members​

Loading ....

segment_members​

Loading ....

segments​

Loading ....

shortcut_campaigns​

Loading ....

unsubscribers_report​

Loading ....