MailChimp
MailChimp ETL connector for data replication
Snapshot
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 API Key Mailchimp data centre |
Replication Type | Key Based Replication |
Replication Key | Date-Time |
Suggested Replication Frequency | 24 hrs |
Tables/APIs Supported | |
Campaigns | Connected Sites |
Ecommerce Stores | Cart |
Customers | Products |
Product variants | Promo Rules |
Promo Codes | Orders |
Facebook Ads | Lists |
Abuse Reports | Activity |
Clients | Growth History |
Interest Categories | Locations |
Merge Fields | Segments |
Landing Pages | Campaign Reports |
Campaign Abuse | Campaign Open Reports |
Campaign Clicks | Campaign Email Domain Performance |
Campaign Product Activity | Campaign Email Activity |
Campaign Locations | Campaign Sent To |
Campaign Sub Reports | Campaign Unsubscribes |
Campaign Advice reports |
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
Name | Target Datatype |
id | STRING |
web_id | NUMERIC |
type | STRING |
create_time | TIMESTAMP |
archive_url | STRING |
long_archive_url | STRING |
status | STRING |
emails_sent | NUMERIC |
send_time | TIMESTAMP |
content_type | STRING |
needs_block_refresh | BOOLEAN |
resendable | BOOLEAN |
recipients | RECORD |
settings | RECORD |
tracking | RECORD |
report_summary | RECORD |
delivery_status | RECORD |
_links | RECORD |
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
Name | Target Datatype |
foreign_id | STRING |
store_id | STRING |
platform | STRING |
domain | STRING |
site_script | RECORD |
created_at | TIMESTAMP |
updated_at | TIMESTAMP |
_links | RECORD |
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
Name | Target Datatype |
id | STRING |
list_id | STRING |
name | STRING |
platform | STRING |
domain | STRING |
is_syncing | BOOLEAN |
email_address | STRING |
currency_code | STRING |
money_format | STRING |
primary_locale | STRING |
timezone | STRING |
phone | STRING |
address | RECORD |
connected_site | RECORD |
automations | RECORD |
list_is_active | BOOLEAN |
created_at | TIMESTAMP |
updated_at | TIMESTAMP |
_links | RECORD |
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
Name | Target Datatype |
store_id | STRING |
id | STRING |
customer | RECORD |
campaign_id | STRING |
checkout_url | STRING |
currency_code | STRING |
order_total | NUMERIC |
tax_total | NUMERIC |
lines | RECORD |
created_at | TIMESTAMP |
updated_at | TIMESTAMP |
_links | RECORD |
Customers
Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-customers/
Replication: Full Load
Fields
Name | Target Datatype |
store_id | STRING |
id | STRING |
email_address | STRING |
opt_in_status | BOOLEAN |
company | STRING |
first_name | STRING |
last_name | STRING |
orders_count | NUMERIC |
total_spent | NUMERIC |
address | RECORD |
created_at | TIMESTAMP |
updated_at | TIMESTAMP |
_links | RECORD |
Products
Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-products/
Replication: Full Load
Fields
Name | Target Datatype |
store_id | STRING |
id | STRING |
currency_code | STRING |
title | STRING |
handle | STRING |
url | STRING |
description | STRING |
type | STRING |
vendor | STRING |
image_url | STRING |
published_at_foreign | TIMESTAMP |
_links | RECORD |
variants | RECORD |
published_at_foreign_st | STRING |
Product variants
Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-product-variants/
Replication: Full Load
Fields
Name | Target Datatype |
store_id | STRING |
product_id | STRING |
id | STRING |
title | STRING |
url | STRING |
sku | STRING |
price | NUMERIC |
inventory_quantity | NUMERIC |
image_url | STRING |
backorders | STRING |
visibility | STRING |
created_at | TIMESTAMP |
updated_at | TIMESTAMP |
_links | RECORD |
Promo Rules
Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-promo-rules/
Replication: Full Load
Fields
store_id | STRING |
id | STRING |
title | STRING |
description | STRING |
starts_at | TIMESTAMP |
ends_at | STRING |
amount | NUMERIC |
type | STRING |
target | STRING |
enabled | BOOLEAN |
created_at_foreign | TIMESTAMP |
updated_at_foreign | TIMESTAMP |
_links | RECORD |
Promo Codes
Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-promo-codes/
Replication: Full Load
Fields
promo_rules_id | STRING |
store_id | STRING |
id | STRING |
code | STRING |
redemption_url | STRING |
usage_count | NUMERIC |
enabled | BOOLEAN |
created_at_foreign | STRING |
updated_at_foreign | STRING |
_links | RECORD |
Orders
Source API Documentation https://mailchimp.com/developer/marketing/api/ecommerce-orders/
Replication: Full Load
Fields
id | STRING |
customer | RECORD |
store_id | STRING |
campaign_id | STRING |
landing_site | STRING |
financial_status | STRING |
fulfillment_status | STRING |
currency_code | STRING |
order_total | NUMERIC |
order_url | STRING |
discount_total | NUMERIC |
tax_total | NUMERIC |
shipping_total | NUMERIC |
tracking_code | STRING |
processed_at_foreign | TIMESTAMP |
cancelled_at_foreign | STRING |
updated_at_foreign | TIMESTAMP |
shipping_address | RECORD |
billing_address | RECORD |
lines | RECORD |
tracking_number | STRING |
tracking_carrier | STRING |
tracking_url | STRING |
_daton_user_id | NUMERIC |
_daton_batch_runtime | NUMERIC |
_daton_batch_id | NUMERIC |
promos | RECORD |
outreach | RECORD |
Facebook Ads
Source API Documentation https://mailchimp.com/developer/marketing/api/facebook-ads/
Replication: Full Load
Fields
id | STRING |
web_id | NUMERIC |
name | STRING |
type | STRING |
status | STRING |
show_report | BOOLEAN |
create_time | TIMESTAMP |
start_time | TIMESTAMP |
updated_at | TIMESTAMP |
canceled_at | TIMESTAMP |
published_time | TIMESTAMP |
has_segment | BOOLEAN |
report_summary | RECORD |
recipients | RECORD |
thumbnail | STRING |
email_source_name | STRING |
paused_at | TIMESTAMP |
end_time | TIMESTAMP |
needs_attention | BOOLEAN |
was_canceled_by_facebook | BOOLEAN |
is_connected | BOOLEAN |
has_audience | BOOLEAN |
has_content | BOOLEAN |
channel | RECORD |
feedback | RECORD |
site | RECORD |
audience | RECORD |
budget | RECORD |
content | RECORD |
_links | RECORD |
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
id | STRING |
web_id | NUMERIC |
name | STRING |
contact | RECORD |
permission_reminder | STRING |
use_archive_bar | BOOLEAN |
campaign_defaults | RECORD |
notify_on_subscribe | STRING |
notify_on_unsubscribe | STRING |
date_created | TIMESTAMP |
list_rating | NUMERIC |
email_type_option | BOOLEAN |
subscribe_url_short | STRING |
subscribe_url_long | STRING |
beamer_address | STRING |
visibility | STRING |
double_optin | BOOLEAN |
has_welcome | BOOLEAN |
marketing_permissions | BOOLEAN |
stats | RECORD |
_links | RECORD |
Landing Pages
Source API Documentation https://mailchimp.com/developer/marketing/api/landing-pages/
Replication: Full Load
Fields
id | STRING |
name | STRING |
title | STRING |
description | STRING |
template_id | NUMERIC |
status | STRING |
list_id | STRING |
store_id | STRING |
web_id | NUMERIC |
created_by_source | STRING |
url | STRING |
created_at | TIMESTAMP |
published_at | TIMESTAMP |
unpublished_at | TIMESTAMP |
updated_at | TIMESTAMP |
tracking | RECORD |
_links | RECORD |
Campaign Reports
Source API Documentation https://mailchimp.com/developer/marketing/api/reports/
Replication: Incremental
Replication Key: send_time
Fields
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 | TIMESTAMP |
bounces | RECORD |
forwards | RECORD |
opens | RECORD |
clicks | RECORD |
facebook_likes | RECORD |
industry_stats | RECORD |
list_stats | RECORD |
timeseries | RECORD |
ecommerce | RECORD |
delivery_status | RECORD |
_links | RECORD |
Campaign Abuse
Source API Documentation https://mailchimp.com/developer/marketing/api/campaign-abuse/
Replication: Full Load
Fields
id | NUMERIC |
campaign_id | STRING |
list_id | STRING |
list_is_active | BOOLEAN |
email_id | STRING |
email_address | STRING |
merge_fields | RECORD |
vip | BOOLEAN |
date | TIMESTAMP |
_links | RECORD |
Campaign Open Reports
Source API Documentation https://mailchimp.com/developer/marketing/api/open-reports/
Replication: Full Load
Fields
campaign_id | STRING |
list_id | STRING |
list_is_active | BOOLEAN |
contact_status | STRING |
email_id | STRING |
email_address | STRING |
merge_fields | RECORD |
vip | BOOLEAN |
opens_count | NUMERIC |
opens | RECORD |
_links | RECORD |
Campaign Clicks
Source API Documentation https://mailchimp.com/developer/marketing/api/click-reports/
Replication: Full Load
Fields
id | STRING |
url | STRING |
total_clicks | NUMERIC |
click_percentage | NUMERIC |
unique_clicks | NUMERIC |
unique_click_percentage | NUMERIC |
last_click | TIMESTAMP |
campaign_id | STRING |
_links | RECORD |
Campaign Email Domain Performance
Source API Documentation https://mailchimp.com/developer/marketing/api/domain-performance-reports/
Replication: Full Load
Fields
campaign_id | STRING |
domain | STRING |
emails_sent | NUMERIC |
bounces | NUMERIC |
opens | NUMERIC |
clicks | NUMERIC |
unsubs | NUMERIC |
delivered | NUMERIC |
emails_pct | NUMERIC |
bounces_pct | NUMERIC |
opens_pct | NUMERIC |
clicks_pct | NUMERIC |
unsubs_pct | NUMERIC |
Campaign Product Activity
Source API Documentation https://mailchimp.com/developer/marketing/api/domain-performance-reports/
Replication: Full Load
Fields
campaign_id | STRING |
title | STRING |
sku | STRING |
image_url | STRING |
total_revenue | NUMERIC |
total_purchased | NUMERIC |
currency_code | STRING |
recommendation_total | NUMERIC |
recommendation_purchased | NUMERIC |
Last updated