MailChimp

MailChimp enables you to engage your leads with great email marketing campaigns. Connecting Journey Analytics to your MailChimp account will allow you to link these campaigns with any other data source, to capitalize on the leads that matter.

Each day, the integration fetches the previous day's aggregative data and appends a row to the table. For example, on Aug 4th a row would be added showing aggregated data up until Aug 3rd, such as how many emails were sent from the beginning of the campaign. See the full table scheme below.

To integrate MailChimp to your Journey Analytics project please contact your customer success manager or Medallia Support.

Table Name: mailchimp_campaigns


Field	Data Type	Description
campaign_id	STRING	A string that uniquely identifies this campaign.
click_rate	FLOAT	The number of unique clicks divided by the total number of successful deliveries.
clicks	INTEGER	The total number of clicks for an campaign.
creation_date	TIMESTAMP	The date and time the campaign was created.
drag_and_drop	STRING	Whether the campaign uses the drag-and-drop editor.
from_name	STRING	The 'from' name on the campaign (not an email address).
hard_bounces	INTEGER	The total number of hard bounced email addresses.
insert_date	TIMESTAMP	The date this row was inserted to the table
list_id	STRING	The unique list id.
list_name	STRING	The name of the list.
open_rate	FLOAT	The number of unique opens divided by the total number of successful deliveries.
opens	INTEGER	The total number of opens for a campaign.
send_date	TIMESTAMP	The date and time a campaign was sent.
sent	INTEGER	The total number of emails sent for this campaign.
soft_bounces	INTEGER	The total number of soft bounced email addresses.
status	STRING	The current status of the campaign.Possible Values: save paused schedule sending sent
subject_line	STRING	The subject line for the campaign.
subscriber_clicks	INTEGER	The number of unique clicks.
title	STRING	The title of the campaign.
unique_clicks	INTEGER	The total number of unique clicks for links across a campaign.
unique_opens	INTEGER	The number of unique opens.
unsubscribed	INTEGER	The total number of unsubscribed members for this campaign.