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