Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

MailChimp

MailChimp ETL connector for data replication

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      Need help with something?

      Talk to data expert

      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

      1. Sign-in to Daton .
      2. Select Mailchimp from Integrations page.
      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. Provide Mailchimp API Key and Data Centre.
      5. Post successful authentication, you will be prompted to choose from the list of available tables. Select the required tables from the list.
      6. Then select all required fields for each table.
      7. Submit the integration

      Workflow

      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. Users would be able to edit/pause/re-activate/delete integration anytime
      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                 
      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

      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

      Was this article helpful?

      Yes
      No
      Give feedback about this article

      Related Articles

      • Release Notes

      Table of Contents

      Snapshot Integrate Mailchimp with Daton Workflow Mailchimp Data Campaigns ConnectedSites Ecommerce Stores Cart Customers Products Promo Codes Orders Facebook Ads Lists Landing Pages Campaign Reports Campaign Abuse Campaign Open Reports Campaign Clicks Campaign Email Domain Performance Campaign Product Activity

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Experts
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Follow Us

      Linkedin Youtube

      Company

      • Customers
      • Partner With Us
      • Contact Us

      Culture

      • About
      • People
      • Careers

      Offerings

      • Daton
      • For Brands
      • For Agencies

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA

      Follow Us

      Linkedin Youtube

      DISCLAIMER: Various trademarks are held by their respective owners

      © 2023 sarasanalytics.com

      Sitemap

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Sales
      DISCLAIMER: Trademarks are held by their respective owners
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Company

      • Customers
      • Partners
      • About
      • People
      • Careers
      • Contact Us

      Offerings

      • Daton
      • Solution for Brands
      • Solution for Agencies
      • Dashboards
      • Founder's Note
      • Status

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA
      • Sitemap

      © 2023 sarasanalytics.com

      Linkedin Youtube

      Knowledge Base Software powered by Helpjuice

      Expand