MailChimp | Email Standard Dataset

Below are the measures and dimensions Alight Analytics considers standard for MailChimp - Email dataset. There is a three day lag on MailChimp and data is pulled for the previous 365 days. 


Field Name Type Description
Report Date Date The date the activity occurred.
List Name Dimension The name of the list.
Campaign Subject Dimension The subject line for the campaign.
Campaign Dimension Title of the Campaign.
Status Dimension The current state of a campaign delivery.
Opens Whole Number The total number of opens for a campaign.
Unique Opens Whole Number The number of unique opens.
Clicks Whole Number The total number of clicks for a campaign.
Unique Clicks Whole Number The number of unique clicks.
Unsubscribes Whole Number The count of unsubscribes.
Abuse Complaints Whole Number Abuse complaints occur when someone reports your campaign as spam.
Recipients Whole Number Count of the recipients on the associated list.
Emails Sent Whole Number The total number of emails confirmed sent for this campaign so far.
Successful Deliveries Whole Number Emails sent less the number of hard/soft bounces.
Insert Date Dimension Internal use: when the row was inserted in the table
ChannelMix Profile Dimension When needed, distinguishes between Mailchimp accounts – Contents defined by Alight.


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request



Please sign in to leave a comment.