MailChimp
MailChimp ETL connector for data replication
Snapshot
Integrate Mailchimp with Daton
Sign-in to Daton .
Select Mailchimp from Integrations page.
Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later.
Provide Mailchimp API Key and Data Centre.
Post successful authentication, you will be prompted to choose from the list of available tables. Select the required tables from the list.
Then select all required fields for each table.
Submit the integration
Workflow
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
Users would be able to edit/pause/re-activate/delete integration anytime
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