Mailchimp: Campaigns

Description

• Each record represents a campaign in Mailchimp, enriched with click, open and unsubscribe metrics.

Supported Data Sources

• Mailchimp

Columns

Type	Name	Description
STRING	campaign_id	The ID of the campaign in Mailchimp.
INTEGER	segment_id	The ID of the Segment a campaign was sent to.
DATETIME	create_timestamp	The date and time the campaign was created.
DATETIME	send_timestamp	The date and time a campaign was sent.
STRING	list_id	The ID of the List a campaign was sent to.
STRING	reply_to_email	The reply-to email address for the campaign.
STRING	campaign_type	The type of campaign sent. Possible values: regular, plaintext, absplit, variate, rss.
STRING	title	The title of the campaign.
STRING	archive_url	The link to the campaign's archive version in ISO 8601 format.
BOOLEAN	authenticate	Whether Mailchimp authenticated the campaign. Defaults to true.
BOOLEAN	auto_footer	Automatically append Mailchimp's default footer to the campaign.
BOOLEAN	auto_tweet	Automatically tweet a link to the campaign archive page when the campaign is sent.
STRING	clicktale	The custom slug for ClickTale tracking (max of 50 bytes).
STRING	content_type	How the campaign's content is put together ('template', 'drag_and_drop', 'html', 'url').
BOOLEAN	drag_and_drop	Whether the campaign uses the drag-and-drop editor.
BOOLEAN	fb_comments	Allows Facebook comments on the campaign (also force-enables the Campaign Archive toolbar). Defaults to true.
INTEGER	folder_id	If the campaign is listed in a folder, the ID for that folder.
STRING	from_name	The 'from' name on the campaign (not an email address).
STRING	google_analytics	The custom slug for Google Analytics tracking (max of 50 bytes).
BOOLEAN	inline_css	Automatically inline the CSS included with the campaign content.
STRING	long_archive_url	The original link to the campaign's archive version.
STRING	status	The current status of the campaign.
STRING	subject_line	The subject line for the campaign.
INTEGER	template_id	The ID for the template used in this campaign.
INTEGER	test_size	The percentage of recipients to send the test combinations to, must be a value between 10 and 100.
BOOLEAN	timewarp	Send this campaign using Timewarpe_this
STRING	to_name	The campaign's custom 'To' name. Typically the first name merge field.
BOOLEAN	track_ecomm_360	Whether to enable eCommerce360 tracking.
BOOLEAN	track_goals	Whether to enable Goal tracking.
BOOLEAN	track_html_clicks	Whether to track clicks in the HTML version of the campaign. Defaults to true. Cannot be set to false for variate campaigns.
BOOLEAN	track_opens	Whether to track opens. Defaults to true. Cannot be set to false for variate campaigns.
BOOLEAN	track_text_clicks	Whether to track clicks in the plain-text version of the campaign. Defaults to true. Cannot be set to false for variate campaigns.
BOOLEAN	use_conversation	Use Mailchimp Conversation feature to manage out-of-office replies.
INTEGER	wait_time	The number of minutes to wait before choosing the winning campaign. The value of wait_time must be greater than 0 and in whole hours, specified in minutes.
INTEGER	winner_criteria	The combination that performs the best. This may be determined automatically by click rate, open rate, or total revenue—or you may choose manually based on the reporting data you find the most valuable. For Multivariate Campaigns testing send_time, winner_criteria is ignored. For Multivariate Campaigns with 'manual' as the winner_criteria, the winner must be chosen in the Mailchimp web application.
INTEGER	winning_campaign_id	ID of the campaign that was sent to the remaining recipients based on the winning combination.
INTEGER	winning_combination_id	ID for the winning combination.
INTEGER	sends	The number of sent emails from campaigns.
INTEGER	opens	The number of open events from campaign emails. The same email being opened multiple times is included in this metric.
INTEGER	clicks	The number of click events from campaign emails. The same email being clicked multiple times is included in this metric.
INTEGER	unique_opens	The unique number of emails opened from campaign emails. If a given email to a user was opened multiple times, it will only count once in this metric.This is the metric for opens that is reported by Mailchimp.
INTEGER	unique_clicks	The unique number of emails clicked from campaign emails. If a given email to a user was clicked multiple times, it will only count once in this metric.This is the metric for clicks that is reported by Mailchimp.
INTEGER	unsubscribes	The number of users who have unsubscribed from campaign emails.