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. |