Sprinkle Docs
  • What is Sprinkle?
  • Quick Start
  • Analysing your data
    • 🔭Analytics Overview
    • 💠Data Models
      • *️Variables
      • 🌲Hierarchies
      • 🤿Column Mask
    • 🎉Switch to New Reports & Dashboards
    • 🆕Reports
      • Overview
      • Build Using Tables
        • Create a new Report
        • Layout and options
        • Build and Format - Overview
        • Apply Row Limits
        • Identify Date Columns
        • Filter your data
        • Visualizations
          • Table
          • Pivot
          • Line Chart
          • Bar Chart
          • Column Chart
          • Area Chart
          • Combo Chart
          • Scatter & Bubble Plot
          • Pie Chart
          • Funnel Chart
          • Stat Card
          • Point Map
          • Heat Map
          • Radial gauge chart
        • Advanced Features
          • Custom Analysis
          • Variables
          • Table & Quick Calculations
          • Drill - Hierarchical & Date
          • Break Out
          • RLS in Table reports
          • Scheduled Exports
          • Embedding Table Reports
      • Build Using Models
        • Create a new report
        • Layout and options
        • Visualizations
        • Advanced Features
      • Build SQL Reports
        • Create a new Report
        • Layout and options
        • Writing a SQL Code on Editor
        • Visualizations
        • Variables in SQL Reports
    • 🆕Dashboards
      • 🌀Filters
      • 👆Click Behaviour
      • ⏰Data Alerts
      • 🗓️Date Drill
      • 📤Scheduled Exports
      • 🔗Embed link
      • 🖥️Dashboard layout
      • 📱Mobile Dashboards
  • Transforming your data
    • 🔰SQL Transform
    • 📓Python Notebooks
  • Integrating your data
    • ☁️Destination Warehouses
      • AWS Athena
        • Manage storage of Flow tables
      • AWS Redshift
      • Azure Synapse
      • Databricks
      • Google BigQuery
      • MySQL
      • Postgres
      • Snowflake
      • SQL Server
      • K8 Setup
        • AWS EKS
        • Google GKE
        • Azure AKS
    • ⚙️Warehouse & Storage Setup
  • Ingesting your data
    • ☄️Data Imports
      • Databases
        • Azure Cosmos DB
        • Azure Table Storage
        • Google BigQuery
        • Mongo DB
        • MySQL DB
        • Oracle DB
        • Postgres DB
        • SQL Server DB
        • Features
          • Ingestion Modes
          • Add Multiple Datasets
          • CDC Setup
            • CDC setup in Mysql
            • CDC setup in Postgres
            • CDC setup in Mongo
            • CDC setup in SQL Server
          • Destination Create Table Clause
          • SSH Tunnel Setup
      • Files
        • AWS S3
        • AWS S3 External
        • Azure Blob
        • FTP
        • Google Cloud Storage
        • Google Sheet
        • SFTP
      • Applications
        • Apple Search Ads
        • Appsflyer
        • Branch
        • Clevertap
        • Facebook Ads
        • Freshdesk
        • Freshsales
        • Google Ads
        • Google Ads V2
        • Google Analytics
        • Google Analytics 4
        • Google Analytics MCF
        • Google Search Console
        • Hubspot
        • Impact Ads
        • Intercom
        • Klaviyo
        • Leadsquared
        • LinkedIn Ads
        • Magento
        • Mailchimp
        • Marketo
        • Mixpanel
        • MoEngage
        • Rocketlane
        • Salesforce
        • SAP S4
        • Shopify
        • Snapchat Marketing
        • TikTok Ads
        • WooCommerce
        • Zendesk Chat
        • Zendesk Support
        • Zoho Analytics
        • Zoho Books
        • Zoho CRM
        • Zoho Desk
        • Zoho Invoice
        • Zoho Subscription
      • Events
        • Apache Kafka
        • AWS Kinesis
        • Azure EventHub
    • 📤File Uploads
    • 🤖API Pulls
    • 🕸️Webhooks
  • Collaborating on data
    • 📤Sharing
    • 💬Comments
    • ⚡Activity
    • 🏷️Labels
  • Managing Schedules and Data Refreshes
    • ⏱️Schedules
    • 🔔Notifications
  • User Management
    • 🔑Access Management
    • 🧑‍🤝‍🧑Groups
    • 📂Folders
    • 🔄Syncing users, groups and RLS
    • 📧Azure AD Integration
  • Data Security & Privacy
    • 🔐Security at Sprinkle
    • 📄GDPR
    • 📄Privacy Policy
  • Release Notes
    • 📢Release Notes
      • 🗒️Release Notes - v12.1 (New)
      • 🗒️Release Notes - v12.0
      • 🗒️Release Notes - v11.0
      • 🗒️Release Notes - v10.8
      • 🗒️Release Notes - v10.7
      • 🗒️Release Notes - v10.6
      • 🗒️Release Notes - v10.5
      • 🗒️Release Notes - v10.4
      • 🗒️Release Notes - v10.3
      • 🗒️Release Notes - v10.2
      • 🗒️Release Notes - v10.1
      • 🗒️Release Notes - v10.0
      • 🗒️Release Notes - v9.31
      • 🗒️Release Notes - v9.30
      • 🗒️Release Notes - v9.29
      • 🗒️Release Notes - v9.28
      • 🗒️Release Notes - v9.27
      • 🗒️Release Notes - v9.25
      • 🗒️Release Notes - v9.24
      • 🗒️Release Notes - v9.23
      • 🗒️Release Notes - v9.22
      • 🗒️Release Notes - v9.21
      • 🗒️Release Notes - v9.20
      • 🗒️Release Notes - v9.19
      • 🗒️Release Notes - v9.18
      • 🗒️Release Notes - v9.17
      • 🗒️Release Notes - v9.16
      • 🗒️Release Notes - v9.14
      • 🗒️Release Notes - v9.13
      • 🗒️Release Notes - v9.12
      • 🗒️Release Notes -v9.8
      • 🗒️Release Notes - v9.7
      • 🗒️Release Notes - v9.6
      • 🗒️Release Notes - v9.5
      • 🗒️Release Notes - v9.4
      • 🗒️Release Notes - v9.3
      • 🗒️Release Notes - v9.2
      • 🗒️Release Notes - v9.1
      • 🗒️Release Notes - v9.0 (Major)
      • 🗒️Release Notes - v7.23
      • 🗒️Release Notes - v7.21
      • 🗒️Release Notes - v7.20
      • 🗒️Release Notes - v7.15
      • 🗒️Release Notes - v7.14
      • 🗒️Release Notes - v7.13
Powered by GitBook
On this page
  • Datasource Concepts
  • Step by Step Guide
  • STEP-1: Configure Connection
  • STEP-2: Configure Datasource
  • STEP-3: Create Dataset
  • STEP-4: Run and schedule Ingestion
  • Data Feilds
  1. Ingesting your data
  2. Data Imports
  3. Applications

Mailchimp

Guide to integrate your Mailchimp with Sprinkle

PreviousMagentoNextMarketo

Last updated 1 year ago

Datasource Concepts

Before setting up the datasource, learn about datasource concepts

Step by Step Guide

STEP-1: Configure Connection

To learn about Connection, refer

  • Log into Sprinkle application

  • Navigate to Datasources -> Connections Tab -> New Connection ->

  • Select Mailchimp

  • Provide all the mandatory details

    • Name: Name to identify this connection

  • Connect to Mailchimp

  • Test Connection

  • Create

STEP-2: Configure Datasource

  • Navigate to Datasources -> Datasources Tab -> Add ->

  • Select Mailchimp

  • Provide the name -> Create

  • Connection Tab:

    • From the drop-down, select the name of connection created in STEP-2

    • Update

STEP-3: Create Dataset

  • Report Type (Required):

    • Automation:

      • Sub-Reports: Select from drop-down

    • Campaigns

    • Conversations

    • Landing_Pages

    • Reports

      • Sub-Reports: Select from drop-down

    • Lists

    • Members

    • Segments

  • Destination Schema (Required) : Data warehouse schema where the table will be ingested into

  • Destination Table name (Required) : It is the table name to be created on the warehouse. If not given, sprinkle will create like ds_<datasourcename>_<tablename>

  • Create

STEP-4: Run and schedule Ingestion

In the Ingestion Jobs tab:

  • Trigger the Job, using Run button

  • To schedule, enable Auto-Run. Change the frequency if needed

Data Feilds

All the datasets can have following fields.

Campaigns
  • id

  • web_id

  • type

  • create_time

  • archive_url

  • long_archive_url

  • status

  • emails_sent

  • send_time

  • content_type

  • needs_block_refresh

  • resendable

  • recipients_list_id

  • recipients_list_is_active

  • recipients_list_name

  • recipients_segment_text

  • recipients_recipient_count

  • settings_subject_line

  • settings_title

  • settings_from_name

  • settings_reply_to

  • settings_use_conversation

  • settings_to_name

  • settings_folder_id

  • settings_authenticate

  • settings_auto_footer

  • settings_inline_css

  • settings_auto_tweet

  • settings_fb_comments

  • settings_timewarp

  • settings_template_id

  • settings_drag_and_drop

  • tracking_opens

  • tracking_html_clicks

  • tracking_text_clicks

  • tracking_goal_tracking

  • tracking_ecomm360

  • tracking_google_analytics

  • tracking_clicktale

  • delivery_status_enabled

  • report_summary_opens

  • report_summary_unique_opens

  • report_summary_open_rate

  • report_summary_clicks

  • report_summary_subscriber_clicks

  • report_summary_click_rate

  • report_summary_ecommerce_total_orders

  • report_summary_ecommerce_total_spent

  • report_summary_ecommerce_total_revenue

  • settings_preview_text

Connected_Sites
  • foreign_id

  • store_id

  • platform

  • domain

  • site_script_url

  • site_script_fragment

  • created_at

  • updated_at

Conversations
  • id

  • message_count

  • campaign_id

  • list_id

  • unread_message

  • from_label

  • from_email

  • subject

  • last_message

  • _links

Automation

Automations

  • id

  • create_time

  • start_time

  • status

  • emails_sent

  • recipients_list_id

  • recipients_list_is_active

  • recipients_list_name

  • settings_title

  • settings_from_name

  • settings_reply_to

  • settings_use_conversation

  • settings_to_name

  • settings_authenticate

  • settings_auto_footer

  • settings_inline_css

  • tracking_opens

  • tracking_html_clicks

  • tracking_text_clicks

  • tracking_goal_tracking

  • tracking_ecomm360

  • tracking_google_analytics

  • tracking_clicktale

  • trigger_settings_workflow_type

  • trigger_settings_workflow_title

  • trigger_settings_runtime_days_0_

  • trigger_settings_runtime_days_1_

  • trigger_settings_runtime_days_2_

  • trigger_settings_runtime_days_3_

  • trigger_settings_runtime_days_4_

  • trigger_settings_runtime_days_5_

  • trigger_settings_runtime_days_6_

  • trigger_settings_runtime_hours_type

  • trigger_settings_workflow_emails_count

  • report_summary_opens

  • report_summary_unique_opens

  • report_summary_open_rate

  • report_summary_clicks

  • report_summary_subscriber_clicks

  • report_summary_click_rate

Automation_Email

  • id

  • web_id

  • workflow_id

  • position

  • delay_type

  • delay_action

  • delay_action_description

  • delay_full_description

  • create_time

  • start_time

  • archive_url

  • status

  • emails_sent

  • send_time

  • content_type

  • needs_block_refresh

  • has_logo_merge_tag

  • recipients_list_id

  • recipients_list_is_active

  • recipients_list_name

  • recipients_segment_text

  • recipients_recipient_count

  • settings_subject_line

  • settings_preview_text

  • settings_title

  • settings_from_name

  • settings_reply_to

  • settings_authenticate

  • settings_auto_footer

  • settings_inline_css

  • settings_auto_tweet

  • settings_fb_comments

  • settings_template_id

  • settings_drag_and_drop

  • tracking_opens

  • tracking_html_clicks

  • tracking_text_clicks

  • tracking_goal_tracking

  • tracking_ecomm360

  • tracking_google_analytics

  • tracking_clicktale

  • trigger_settings_workflow_type

  • trigger_settings_workflow_title

  • trigger_settings_runtime_days_0_

  • trigger_settings_runtime_days_1_

  • trigger_settings_runtime_days_2_

  • trigger_settings_runtime_days_3_

  • trigger_settings_runtime_days_4_

  • trigger_settings_runtime_days_5_

  • trigger_settings_runtime_days_6_

  • trigger_settings_runtime_hours_type

  • trigger_settings_workflow_emails_count

  • report_summary_opens

  • report_summary_unique_opens

  • report_summary_open_rate

  • report_summary_clicks

  • report_summary_subscriber_clicks

  • report_summary_click_rate

Reports

Campaign_Reports

  • id

  • campaign_title

  • type

  • list_id

  • list_is_active

  • list_name

  • subject_line

  • preview_text

  • emails_sent

  • abuse_reports

  • unsubscribed

  • send_time

  • bounces_hard_bounces

  • bounces_soft_bounces

  • bounces_syntax_errors

  • forwards_forwards_count

  • forwards_forwards_opens

  • opens_opens_total

  • opens_unique_opens

  • opens_open_rate

  • opens_last_open

  • clicks_clicks_total

  • clicks_unique_clicks

  • clicks_unique_subscriber_clicks

  • clicks_click_rate

  • clicks_last_click

  • facebook_likes_recipient_likes

  • facebook_likes_unique_likes

  • facebook_likes_facebook_likes

  • list_stats_sub_rate

  • list_stats_unsub_rate

  • list_stats_open_rate

  • list_stats_click_rate

  • timeseries_0__timestamp

  • timeseries_0__emails_sent

  • timeseries_0__unique_opens

  • timeseries_0__recipients_clicks

  • timeseries_1__timestamp

  • timeseries_1__emails_sent

  • timeseries_1__unique_opens

  • timeseries_1__recipients_clicks

  • timeseries_2__timestamp

  • timeseries_2__emails_sent

  • timeseries_2__unique_opens

  • timeseries_2__recipients_clicks

  • timeseries_3__timestamp

  • timeseries_3__emails_sent

  • timeseries_3__unique_opens

  • timeseries_3__recipients_clicks

  • timeseries_4__timestamp

  • timeseries_4__emails_sent

  • timeseries_4__unique_opens

  • timeseries_4__recipients_clicks

  • timeseries_5__timestamp

  • timeseries_5__emails_sent

  • timeseries_5__unique_opens

  • timeseries_5__recipients_clicks

  • timeseries_6__timestamp

  • timeseries_6__emails_sent

  • timeseries_6__unique_opens

  • timeseries_6__recipients_clicks

  • timeseries_7__timestamp

  • timeseries_7__emails_sent

  • timeseries_7__unique_opens

  • timeseries_7__recipients_clicks

  • timeseries_8__timestamp

  • timeseries_8__emails_sent

  • timeseries_8__unique_opens

  • timeseries_8__recipients_clicks

  • timeseries_9__timestamp

  • timeseries_9__emails_sent

  • timeseries_9__unique_opens

  • timeseries_9__recipients_clicks

  • timeseries_10__timestamp

  • timeseries_10__emails_sent

  • timeseries_10__unique_opens

  • timeseries_10__recipients_clicks

  • timeseries_11__timestamp

  • timeseries_11__emails_sent

  • timeseries_11__unique_opens

  • timeseries_11__recipients_clicks

  • timeseries_12__timestamp

  • timeseries_12__emails_sent

  • timeseries_12__unique_opens

  • timeseries_12__recipients_clicks

  • timeseries_13__timestamp

  • timeseries_13__emails_sent

  • timeseries_13__unique_opens

  • timeseries_13__recipients_clicks

  • timeseries_14__timestamp

  • timeseries_14__emails_sent

  • timeseries_14__unique_opens

  • timeseries_14__recipients_clicks

  • timeseries_15__timestamp

  • timeseries_15__emails_sent

  • timeseries_15__unique_opens

  • timeseries_15__recipients_clicks

  • timeseries_16__timestamp

  • timeseries_16__emails_sent

  • timeseries_16__unique_opens

Click_Details

  • id

  • url

  • total_clicks

  • click_percentage

  • unique_clicks

  • unique_click_percentage

  • last_click

  • campaign_id

Email_Activity

  • campaign_id

  • list_id

  • list_is_active

  • email_id

  • email_address

  • activity_0__action

  • activity_0__timestamp

  • activity_0__ip

  • activity_1__action

  • activity_1__timestamp

  • activity_1__ip

  • activity_2__action

  • activity_2__timestamp

  • activity_2__ip

  • activity_3__action

  • activity_3__timestamp

  • activity_3__ip

  • activity_4__action

  • activity_4__timestamp

  • activity_4__ip

  • activity

  • activity_0__type

Sent_To

  • email_id

  • email_address

  • merge_fields_fname

  • merge_fields_lname

  • merge_fields_address_addr1

  • merge_fields_address_addr2

  • merge_fields_address_city

  • merge_fields_address_state

  • merge_fields_address_zip

  • merge_fields_address_country

  • merge_fields_phone

  • merge_fields_birthday

  • vip

  • status

  • open_count

  • last_open

  • absplit_group

  • gmt_offset

  • campaign_id

  • list_id

  • list_is_active

  • merge_fields_address

Unsubscribed

  • email_id

  • email_address

  • merge_fields

  • vip

  • timestamp

  • reason

  • campaign_id

  • list_id

  • list_is_active

  • _links

Landing_Pages
  • id

  • name

  • title

  • description

  • template_id

  • content_type

  • status

  • list_id

  • web_id

  • created_by_source

  • created_at

  • published_at

  • unpublished_at

  • updated_at

  • tracking_track_with_mailchimp

  • tracking_enable_restricted_data_processing

  • url

Lists
  • id

  • web_id

  • name

  • contact

  • permission_reminder

  • use_archive_bar

  • campaign_defaults

  • notify_on_subscribe

  • notify_on_unsubscribe

  • date_created

  • list_rating

  • email_type_option

  • subscribe_url_short

  • subscribe_url_long

  • beamer_address

  • visibility

  • double_optin

  • double_optin

  • marketing_permissions

  • modules

  • stats

  • _links

Members
  • id

  • email_address

  • unique_email_id

  • contact_id

  • full_name

  • web_id

  • email_type

  • status

  • consents_to_one_to_one_messaging

  • merge_fields_fname

  • merge_fields_lname

  • merge_fields_address_addr1

  • merge_fields_address_addr2

  • merge_fields_address_city

  • merge_fields_address_state

  • merge_fields_address_zip

  • merge_fields_address_country

  • merge_fields_phone

  • merge_fields_birthday

  • stats_avg_open_rate

  • stats_avg_click_rate

  • ip_signup

  • timestamp_signup

  • ip_opt

  • timestamp_opt

  • member_rating

  • last_changed

  • language

  • vip

  • email_client

  • location_latitude

  • location_longitude

  • location_gmtoff

  • location_dstoff

  • location_country_code

  • location_timezone

  • location_region

  • source

  • tags_count

  • tags

  • list_id

  • tags_0__id

  • tags_0__name

  • merge_fields_address

Segments
  • id

  • name

  • member_count

  • type

  • created_at

  • updated_at

  • list_id

To learn about datasource, refer

Datasets Tab: To learn about Dataset, refer . Add Dataset for each report/dataset that you want to integrate, providing following details

Destination Create Table Clause: Provide additional clauses to warehouse-create table queries such as clustering, partitioning, and more, useful for optimizing DML statements. on how to use this field.

☄️
here
here
here
here
Learn more