Mailchimp: Segments

Description

• Each record represents a segment in Mailchimp, enriched with campaign metrics and (optionally) automation metrics. (Enabled if you are using segments.)

Supported Data Sources

• Mailchimp

Columns

Type	Name	Description
INTEGER	segment_id	The ID for the Segment from Mailchimp
STRING	list_id	The ID of the List the segment is part of.
INTEGER	member_count	The number of members in the segment.
STRING	segment_name	The name of the segment.
STRING	segment_type	The type of segment
DATETIME	updated_timestamp	The date and time the segment was last updated.
DATETIME	created_timestamp	The date and time the segment was created.
INTEGER	campaign_sends	The number of sent emails from campaigns.
INTEGER	campaign_opens	The number of open events from campaign emails. The same email being opened multiple times is included in this metric.
INTEGER	campaign_clicks	The number of click events from campaign emails. The same email being clicked multiple times is included in this metric.
INTEGER	campaign_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	campaign_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	campaign_unsubscribes	The number of users who have unsubscribed from campaign emails.
STRING	list_name	The name of the List the segment is part of.
INTEGER	automation_sends	The number of sent emails from automations.
INTEGER	automation_opens	The number of open events from automation emails. The same email being opened multiple times is included in this metric.
INTEGER	automation_clicks	The number of click events from automation emails. The same email being clicked multiple times is included in this metric.
INTEGER	automation_unique_opens	The unique number of emails opened from automation 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	automation_unique_clicks	The unique number of emails clicked from automation 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	automation_unsubscribes	The number of users who have unsubscribed from automation emails.