Features | Details |
Release Status | Released |
Source API Version | v3.0 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | Mailchimp account email Mailchimp account password |
Replication Type | Full Replication Key Based Incremental |
Replication Key | Date |
Suggested Replication Frequency | ​ |
Tables/APIs Supported | ​ |
Campaigns | ConnectedSites |
Conversations | Stores |
Lists | AbuseReports |
AdviceReports | CampaignOpenReports |
CampaignClickReports | DomainPerformance |
EcommerceProductActivity | EEPURLReports |
EmailActivityReports | GoogleAnalyticsReports |
LocationReports | RecipientsReports |
SubReports | UnsubscribesReports |
Signin 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 Webservice Endpoint, Username, and Password. Follow the to get your details
Post successful authentication, you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration
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
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: Key-Based Replication
Replication Key: since_create_time
Fields
Name | Target Datatype |
id | STRING |
web_id | NUMERIC |
type | STRING |
create_time | STRING |
archive_url | STRING |
long_archive_url | STRING |
status | STRING |
emails_sent | NUMERIC |
send_time | STRING |
content_type | STRING |
needs_block_refresh | BOOLEAN |
resendable | BOOLEAN |
settings | RECORD |
recipients | RECORD |
tracking | RECORD |
delivery_status | RECORD |
ConnectedSites
Purpose: Get all connected sites in an account
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/connected-sites/# ​
Replication: Key-Based Replication
Replication Key: created_at
Fields
Name | Target Datatype |
foreign_id | STRING |
store_id | STRING |
platform | STRING |
domain | STRING |
created_at | STRING |
updated_at | STRING |
site_script | RECORD |
Conversations
Purpose: Get a list of conversations
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/conversations/​
Replication: Key-Based Replication
Replication Key: created_at
Fields
Name | Target Datatype |
id | STRING |
campaign_id | STRING |
list_id | STRING |
from_label | STRING |
from_email | STRING |
subject | STRING |
message_count | NUMERIC |
unread_messages | NUMERIC |
last_message | RECORD |
Stores
Purpose: Get information about all stores
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/ecommerce/stores/​
Replication: Key-Based Replication Replication Key: created_at
Fields
Name | Target Datatype |
id | STRING |
list_id | STRING |
name | STRING |
platform | STRING |
domain | STRING |
email_address | STRING |
currency_code | STRING |
money_format | STRING |
primary_locale | STRING |
timezone | STRING |
phone | STRING |
is_syncing | BOOLEAN |
address | RECORD |
connected_site | RECORD |
automations | RECORD |
list_is_active | BOOLEAN |
created_at | STRING |
updated_at | STRING |
Lists
Purpose: A Mailchimp list is a powerful and flexible tool that helps you manage your contacts. Get information about all lists
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/campaigns/​
Replication: Key-Based Replication
Replication Key: date
Fields
Name | Target Datatype |
id | STRING |
web_id | INTEGER |
name | STRING |
contact | RECORD |
permission_reminder | STRING |
use_archive_bar | BOOLEAN |
campaign_defaults | RECORD |
notify_on_subscribe | STRING |
notify_on_unsubscribe | STRING |
date_created | STRING |
list_rating | INTEGER |
email_type_option | BOOLEAN |
subscribe_url_short | STRING |
subscribe_url_long | STRING |
beamer_address | STRING |
visibility | STRING |
double_optin | BOOLEAN |
marketing_permissions | BOOLEAN |
stats | RECORD |
connected_site | RECORD |
automations | RECORD |
list_is_active | BOOLEAN |
created_at | STRING |
updated_at | STRING |
AbuseReports
Purpose: Get information about campaign abuse complaints
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/lists/abuse-reports/​
Replication: Key-Based Replication
Replication Key: date
Fields
Name | Target Datatype |
id | NUMERIC |
campaign_id | STRING |
list_id | STRING |
list_is_active | BOOLEAN |
email_id | STRING |
email_address | STRING |
vip | BOOLEAN |
date | STRING |
AdviceReports
Purpose: Get recent feedback based on a campaign’s statistics
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/advice/​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
advice | RECORD |
campaign_id | STRING |
CampaignOpenReports
Purpose: Get a detailed report about any emails in a specific campaign that were opened by the recipient
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/open-details/​
Replication: Key-Based Replication
Replication Key: date
Fields
Name | Target Datatype |
campaign_id | STRING |
list_id | STRING |
list_is_active | BOOLEAN |
email_id | STRING |
email_address | STRING |
vip | BOOLEAN |
opens_count | NUMERIC |
opens | RECORD |
CampaignClickReports
Purpose: Get detailed information about links clicked in campaigns
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/click-details/​
Replication: Key-Based Replication
Replication Key: last_click
Fields
Name | Target Datatype |
campaign_id | STRING |
id | STRING |
url | STRING |
total_clicks | NUMERIC |
click_percentage | FLOAT |
unique_clicks | NUMERIC |
unique_click_percentage | FLOAT |
last_click | STRING |
ab_split | RECORD |
DomainPerformance
Purpose: Get statistics for the top-performing domains from a campaign
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/domain-performance/​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
campaign_id | STRING |
domains | RECORD |
total_sent | NUMERIC |
EcommerceProductActivity
Purpose: Ecommerce product activity report for Campaign
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/ecommerce-product-activity/​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
title | STRING |
sku | STRING |
image_url | STRING |
total_revenue | NUMERIC |
total_purchased | NUMERIC |
currency_code | STRING |
recommendation_total | NUMERIC |
recommendation_purchased | NUMERIC |
EEPURLReports
Purpose: Get a summary of social activity for the campaign, tracked by EepURL
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/eepurl/​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
campaign_id | STRING |
eepurl | STRING |
RECORD | |
clicks | RECORD |
referrers | RECORD |
EmailActivityReports
Purpose: Get list member activity for a specific campaign
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/email-activity/​
Replication: Key-Based Replication
Replication Key: date
Fields
Name | Target Datatype |
campaign_id | STRING |
list_id | STRING |
list_is_active | BOOLEAN |
email_id | STRING |
email_address | STRING |
activity | RECORD |
GoogleAnalyticsReports
Purpose: Get a summary of Google Analytics reports for a specific campaign
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/google-analytics/​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
analytics_profileId | STRING |
analytics_webPropertyId | STRING |
analytics_accountId | STRING |
analytics_profileName | STRING |
analytics_title | STRING |
campaign_id | STRING |
visits | NUMERIC |
page_views | NUMERIC |
new_visits | NUMERIC |
bounces | NUMERIC |
time_on_site | NUMERIC |
goal_conversions | NUMERIC |
goal_value | NUMERIC |
revenue | NUMERIC |
transactions | NUMERIC |
ecomm_conversions | NUMERIC |
goals | RECORD |
LocationReports
Purpose: Get top open locations for a specific campaign
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/locations/​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
campaign_id | STRING |
locations | RECORD |
RecipientsReports
Purpose: Get details about campaign recipients
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/sent-to/​
Replication: Key-Based Replication
Replication Key: last_open
Fields
Name | Target Datatype |
email_id | STRING |
email_address | STRING |
vip | BOOLEAN |
status | STRING |
open_count | NUMERIC |
last_open | STRING |
absplit_group | STRING |
gmt_offset | NUMERIC |
campaign_id | STRING |
list_id | STRING |
list_is_active | BOOLEAN |
SubReports
Purpose: Get a list of reports for child campaigns of a specific parent campaign
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/sub-reports/​
Replication: Key-Based Replication
Replication Key: send_time
Fields
Name | Target Datatype |
id | STRING |
campaign_title | STRING |
type | STRING |
list_id | STRING |
list_is_active | BOOLEAN |
list_name | STRING |
subject_line | STRING |
preview_text | STRING |
emails_sent | NUMERIC |
abuse_reports | NUMERIC |
unsubscribed | NUMERIC |
send_time | STRING |
rss_last_send | STRING |
bounces | RECORD |
forwards | RECORD |
opens | RECORD |
clicks | RECORD |
facebook_likes | RECORD |
industry_stats | RECORD |
list_stats | RECORD |
ab_split | RECORD |
timewarp | RECORD |
timeseries | RECORD |
share_report | RECORD |
ecommerce | RECORD |
delivery_status | RECORD |
UnsubscribesReports
Purpose: Get information about list members who unsubscribed from a specific campaign
Source API Documentation https://developer.mailchimp.com/documentation/mailchimp/reference/reports/unsubscribed/​
Replication: Key-Based Replication
Replication Key: send_time
Fields
Name | Target Datatype |
timestamp | STRING |
campaign_id | STRING |
list_id | STRING |
list_is_active | BOOLEAN |
email_id | STRING |
email_address | STRING |
vip | BOOLEAN |
reason | STRING |