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

  1. 1.
    Signin to Daton
  2. 2.
    Select Mailchimp from Integrations page
  3. 3.
    Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
  4. 4.
    Provide Mailchimp Webservice Endpoint, Username, and Password. Follow the to get your details
  5. 5.
    Post successful authentication, you will be prompted to choose from the list of available tables
  6. 6.
    Then select all required fields for each table
  7. 7.
    Submit the integration

Workflow

  1. 1.
    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
  2. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 3.
    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
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
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
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
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
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
AbuseReports
Purpose: Get information about campaign abuse complaints
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
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
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
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
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
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
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
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
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
Replication: Full Replication
Replication Key: NA
Fields
Name
Target Datatype
campaign_id
STRING
locations
RECORD
RecipientsReports
Purpose: Get details about campaign recipients
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
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
UnsubscribesReports
Purpose: Get information about list members who unsubscribed from a specific campaign
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
Last modified 3yr ago