Mailchimp to Amazon Redshift

Each of these CDPs lists a connector that reads from Mailchimp and one that sends data to Amazon Redshift. A route is a possible path, not a tested one: what travels depends on each connector, so check the documentation links.

• BLBlueConic

  Reads from Mailchimp

  BlueConic ⇄ Mailchimp

  Imports Mailchimp audience members and mail activity into BlueConic and exports segment profiles to selected Mailchimp audiences in scheduled or manual batch runs.

  Docs ↗

  Sends to Amazon Redshift

  BlueConic ⇄ Amazon Redshift

  Imports Amazon Redshift tables or SQL query results into BlueConic profiles, orders, events and groups, and exports profiles in sync, replace or append mode staged through Amazon S3.

  Docs ↗
• KLKlaviyo

  Reads from Mailchimp

  Mailchimp → Klaviyo

  Migrates Mailchimp contacts to Klaviyo in a one-time sync, along with when each contact received, opened and clicked emails, so campaign metrics carry over.

  Docs ↗

  Sends to Amazon Redshift

  Klaviyo → Amazon Redshift

  Exports Klaviyo profiles and events to an Amazon Redshift instance, with the option to leave out events from integrations that already feed Redshift.

  Docs ↗
• LYLytics

  Reads from Mailchimp

  Lytics ⇄ Mailchimp

  Imports Mailchimp subscribers and campaign activity into Lytics every 12 hours and exports Lytics audiences to Mailchimp, with campaigns importable as Lytics Experiences.

  Docs ↗

  Sends to Amazon Redshift

  Lytics ⇄ Amazon Redshift

  Imports user tables from Amazon Redshift into Lytics over a PostgreSQL connection and keeps a Redshift table of a Lytics audience updated by loading files staged in S3.

  Docs ↗
• MPmParticle

  Reads from Mailchimp

  Mailchimp → mParticle

  Feed. Brings Mailchimp email events into mParticle as a feed through a Mailchimp webhook.

  Docs ↗

  Sends to Amazon Redshift

  mParticle → Amazon Redshift

  Loads all incoming mParticle data into an Amazon Redshift cluster, so you can query events and user data with SQL.

  Docs ↗
• SDSalesforce Data 360

  Reads from Mailchimp

  Mailchimp → Salesforce

  Brings Mailchimp campaigns, audiences, automations and e-commerce orders into Data 360 in batches or through Zero Copy query federation (beta).

  Docs ↗

  Sends to Amazon Redshift

  Salesforce ⇄ Amazon Redshift

  Connects Data 360 and Amazon Redshift through Zero Copy, querying Redshift tables in place and sharing Data 360 data back to Redshift.

  Docs ↗
• SESegment

  Reads from Mailchimp

  Mailchimp → Segment

  Source. Pulls Mailchimp objects into Segment on a schedule for syncing to a warehouse.

  Docs ↗

  Sends to Amazon Redshift

  Segment → Amazon Redshift

  Loads Segment event data into Amazon Redshift on a schedule as a storage destination, ready for SQL analysis.

  Docs ↗
• TETealium

  Reads from Mailchimp

  Mailchimp → Tealium

  Webhook data source. Sends Mailchimp list activity, including subscribes, unsubscribes, profile and email changes, cleaned addresses and campaign events, to Tealium AudienceStream through a list webhook.

  Docs ↗

  Sends to Amazon Redshift

  Tealium → Amazon Redshift

  Loads full or custom event and visitor data into Amazon Redshift tables in micro-batches or batches, from AudienceStream or EventStream.

  Docs ↗
• TATreasure AI

  Reads from Mailchimp

  Mailchimp → Treasure AI

  Import. Imports Mailchimp lists with their members and member activity, plus campaigns, into Treasure Data with an API key or OAuth, using batch operations to ease rate limits.

  Docs ↗

  Sends to Amazon Redshift

  Treasure AI → Amazon Redshift

  Export. Writes Treasure Data job results to tables in an existing Amazon Redshift cluster over JDBC, with no support for timestamp or date columns, which you must first convert to strings or Unix time.

  Docs ↗

Each of these CDPs lists a connector that reads from Amazon Redshift and one that sends data to Mailchimp.

• ACActionIQ

  Reads from Amazon Redshift

  Amazon Redshift → ActionIQ

  Connects ActionIQ to Amazon Redshift with HybridCompute, pushing generated SQL down to the warehouse and returning only the needed results, usually customer IDs, without copying the data.

  Docs ↗

  Sends to Mailchimp

  ActionIQ → Mailchimp

  Mailchimp
• AEAdobe Experience Platform

  Reads from Amazon Redshift

  Amazon Redshift → Adobe

  Brings Amazon Redshift data into Experience Platform for Real-Time CDP Ultimate customers.

  Docs ↗

  Sends to Mailchimp

  Adobe → Mailchimp

  Event forwarding. Sends events server-side to the Mailchimp Marketing API through event forwarding, where they can trigger emails from campaigns, customer journeys or transactional sends.

  Docs ↗

  Adobe → Mailchimp

  Interest Categories. Sends Real-Time CDP audiences to Mailchimp as interest categories named after each audience, adding or updating contacts and moving them in or out of groups.

  Docs ↗

  Adobe → Mailchimp

  Tags. Sends Real-Time CDP audiences to Mailchimp as tags named after each audience, adding new contacts or tagging existing ones within a chosen Mailchimp audience.

  Docs ↗
• BLBlueConic

  Reads from Amazon Redshift

  BlueConic ⇄ Amazon Redshift

  Imports Amazon Redshift tables or SQL query results into BlueConic profiles, orders, events and groups, and exports profiles in sync, replace or append mode staged through Amazon S3.

  Docs ↗

  Sends to Mailchimp

  BlueConic ⇄ Mailchimp

  Imports Mailchimp audience members and mail activity into BlueConic and exports segment profiles to selected Mailchimp audiences in scheduled or manual batch runs.

  Docs ↗
• DIDinMo

  Reads from Amazon Redshift

  Amazon Redshift → DinMo

  Connects Amazon Redshift, provisioned or Serverless, to DinMo as the source for models, segments and activations, reached directly or through AWS PrivateLink, an SSH tunnel or SSM.

  Docs ↗

  Sends to Mailchimp

  DinMo → Mailchimp

  Creates Mailchimp segments inside a chosen contact list from DinMo segments and keeps them current by email for existing contacts, rebuilding a segment from scratch on historical refresh.

  Docs ↗
• FAFivetran Activations

  Reads from Amazon Redshift

  Amazon Redshift → Fivetran Activations

  Source. Extracts Amazon Redshift tables and views for Fivetran Activations syncs with the UNLOAD command, which in a VPC deployment needs an S3 VPC endpoint.

  Docs ↗

  Sends to Mailchimp

  Fivetran Activations → Mailchimp

  Adds and updates Mailchimp audience members by email from Fivetran Activations after you sign in to Mailchimp, with a required status such as subscribed or unsubscribed.

  Docs ↗
• HIHightouch

  Reads from Amazon Redshift

  Amazon Redshift → Hightouch

  Source. Connects Amazon Redshift to Hightouch as a source, so SQL, dbt or table-based models built there can sync to any destination.

  Docs ↗

  Sends to Mailchimp

  Hightouch → Mailchimp

  Keeps Mailchimp audiences in sync with warehouse segments for personalized and automated email.

  Docs ↗
• LYLytics

  Reads from Amazon Redshift

  Lytics ⇄ Amazon Redshift

  Imports user tables from Amazon Redshift into Lytics over a PostgreSQL connection and keeps a Redshift table of a Lytics audience updated by loading files staged in S3.

  Docs ↗

  Sends to Mailchimp

  Lytics ⇄ Mailchimp

  Imports Mailchimp subscribers and campaign activity into Lytics every 12 hours and exports Lytics audiences to Mailchimp, with campaigns importable as Lytics Experiences.

  Docs ↗
• MPmParticle

  Reads from Amazon Redshift

  Amazon Redshift → mParticle

  Warehouse Sync. Brings user and event data from Amazon Redshift or Redshift Serverless into mParticle, with access through an IAM role that mParticle assumes.

  Docs ↗

  Sends to Mailchimp

  mParticle → Mailchimp

  Audiences. Keeps Mailchimp lists in step with mParticle audiences through Mailchimp's v3 API.

  Docs ↗

  mParticle → Mailchimp

  Events. Forwards mParticle events and user data to Mailchimp for email campaign targeting and tracking.

  Docs ↗
• RURudderStack

  Reads from Amazon Redshift

  Amazon Redshift → RudderStack

  Source. Reads tables or SQL models from Amazon Redshift with RudderStack Reverse ETL and syncs the rows to downstream tools on a schedule.

  Docs ↗

  Sends to Mailchimp

  RudderStack → Mailchimp

  Adds and updates Mailchimp audience members from RudderStack users and records their events.

  Docs ↗
• SESegment

  Reads from Amazon Redshift

  Amazon Redshift → Segment

  Data Graph. Connects a Redshift cluster to Segment's Data Graph through its own role and user, so Linked Audiences and Linked Events can use warehouse entity tables next to Profiles Sync data.

  Docs ↗

  Amazon Redshift → Segment

  Reverse ETL source. Lets Segment Reverse ETL query an Amazon Redshift cluster as a dedicated database user and send the results to destinations, keeping sync state in its own schema.

  Docs ↗

  Sends to Mailchimp

  Segment → Mailchimp

  Destination. Sends identify calls from Segment to Mailchimp for email marketing in cloud mode.

  Docs ↗
• TETealium

  Reads from Amazon Redshift

  Amazon Redshift → Tealium

  Cloud data source. Reads a table or view from an Amazon Redshift cluster into Tealium attributes over JDBC, using the cluster's hostname, port, database, schema and credentials.

  Docs ↗

  Sends to Mailchimp

  Tealium → Mailchimp

  Subscribes or unsubscribes Mailchimp list members and upserts e-commerce orders and abandoned carts from AudienceStream.

  Docs ↗
• TATreasure AI

  Reads from Amazon Redshift

  Amazon Redshift → Treasure AI

  Import. Imports a table from Amazon Redshift into Treasure Data with an optional WHERE condition, and can load only rows added since the last scheduled run.

  Docs ↗

  Amazon Redshift → Treasure AI

  Live Connect zero-copy. Runs federated Trino queries from Treasure Data against Amazon Redshift tables through a Live Connect zero-copy source, once enabled, keeping results seven days unless saved.

  Docs ↗

  Sends to Mailchimp

  Treasure AI → Mailchimp

  Export. Adds Treasure Data segments to a Mailchimp list or updates existing members by email, filling merge fields and interest groups, signing in with an API key or OAuth.

  Docs ↗
• ZGZeta Global

  Reads from Amazon Redshift

  Amazon Redshift → Zeta Global

  Queries Amazon Redshift provisioned clusters from Zeta Data Flows to ingest selected data, connecting with host, port and database plus optional IAM authentication.

  Docs ↗

  Sends to Mailchimp

  Zeta Global → Mailchimp

  Pushes Zeta customers to Mailchimp through a Channel Manager channel following the Mailchimp Lists API, authenticated as Mailchimp's developer docs describe, from Experiences.

  Docs ↗