MailChimp

MailChimp ETL connector for data replication

Snapshot

Integrate Mailchimp with Daton

  1. Sign-in to Daton .

  2. Select Mailchimp from Integrations page.

  3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later.

  4. Provide Mailchimp API Key and Data Centre.

  5. Post successful authentication, you will be prompted to choose from the list of available tables. Select the required tables from the list.

  6. Then select all required fields for each table.

  7. Submit the integration

Workflow

  1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

  2. Users would be able to edit/pause/re-activate/delete integration anytime

  3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Mailchimp Data

Campaigns

Purpose: Get all campaigns in an account. Campaigns are how you send emails to your Mailchimp list. Use the Campaigns API calls to manage campaigns in your Mailchimp account

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/campaigns/

Replication: Incremental

Replication Key: send_time

Fields

ConnectedSites

Purpose: Get all connected sites in an account

Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/connected-sites/#

Replication: Full Load

Fields

Ecommerce Stores

Purpose: Get a list of all Ecommerce Stores

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-stores/

Replication: Full Load

Fields

Cart

Purpose: Get information about all carts in a store

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-carts/

Replication: Full Load

Fields

Customers

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-customers/

Replication: Full Load

Fields

Products

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-products/

Replication: Full Load

Fields

Product variants

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-product-variants/

Replication: Full Load

Fields

Promo Rules

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-promo-rules/

Replication: Full Load

Fields

Promo Codes

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-promo-codes/

Replication: Full Load

Fields

Orders

Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-orders/

Replication: Full Load

Fields

Facebook Ads

Source API Documentation https://mailchimp.com/developer/marketing/api/facebook-ads/

Replication: Full Load

Fields

Lists

Purpose: Your Mailchimp list, also known as your audience, is where you store and manage all of your contacts.

Source API Documentation https://mailchimp.com/developer/marketing/api/lists/

Replication: Incremental

Replication Key: campaign_last_sent

Fields

Landing Pages

Source API Documentation https://mailchimp.com/developer/marketing/api/landing-pages/

Replication: Full Load

Fields

Campaign Reports

Source API Documentation https://mailchimp.com/developer/marketing/api/reports/

Replication: Incremental

Replication Key: send_time

Fields

Campaign Abuse

Source API Documentation https://mailchimp.com/developer/marketing/api/campaign-abuse/

Replication: Full Load

Fields

Campaign Open Reports

Source API Documentation https://mailchimp.com/developer/marketing/api/open-reports/

Replication: Full Load

Fields

Campaign Clicks

Source API Documentation https://mailchimp.com/developer/marketing/api/click-reports/

Replication: Full Load

Fields

Campaign Email Domain Performance

Source API Documentation https://mailchimp.com/developer/marketing/api/domain-performance-reports/

Replication: Full Load

Fields

Campaign Product Activity

Source API Documentation https://mailchimp.com/developer/marketing/api/domain-performance-reports/

Replication: Full Load

Fields

Last updated