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 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
Integrate Mailchimp with Daton
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
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: 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
twitter
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

Outbrain

Klaviyo

Last updated 2 years ago

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

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

Name	Target Datatype
foreign_id	STRING
store_id	STRING
platform	STRING
domain	STRING
created_at	STRING
updated_at	STRING
site_script	RECORD

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

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

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

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