Mailchimp: Most-used fields

The Date field is used to filter Mailchimp data based on specific timestamps. Depending on the report type, it can represent the date a campaign was sent, an automation was created, or an audience's growth history for a particular month. For example, it allows users to specify a start or end date to retrieve campaign performance summaries, audience member activity, or automation workflow metrics.

The number of abuse reports for variation A of an A/B split campaign.

The number of bounces for variation A of an A/B split campaign.

The number of times campaign A was forwarded and then opened.

The date and time of the last open for variation A of an A/B split campaign.

The total number of opens for variation A of an A/B split campaign.

The total number of clicks by recipients for variation A of an A/B split campaign.

The number of unique opens for variation A of an A/B split campaign.

The number of unsubscribes for variation A of an A/B split campaign.

The number of abuse reports for variation B of an A/B split campaign.

The number of bounces for variation B of an A/B split campaign.

The number of times campaign B was forwarded and then opened.

The date and time of the last open for variation B of an A/B split campaign.

The total number of opens for variation B of an A/B split campaign.

The total number of clicks by recipients for variation B of an A/B split campaign.

The number of unique opens for variation B of an A/B split campaign.

The number of unsubscribes for variation B of an A/B split campaign.

The total count of abuse reports received for a specific campaign.

The type of action performed by a subscriber, such as 'open', 'click', or 'bounce'.

The IP address associated with the subscriber's activity.

The date and time when a specific subscriber activity occurred.

The general category of activity, such as 'email-activity'.

The URL that was clicked by the subscriber in an email campaign.

The count of hard bounces, indicating permanent delivery failures for email campaigns.

The count of soft bounces, indicating temporary delivery failures for email campaigns.

The count of bounces due to syntax errors in email addresses.

The unique identifier for a campaign.

The descriptive title of an email marketing campaign.

Indicates if a list member's email address has been cleaned due to being invalid or undeliverable.

The rate at which recipients clicked links within a campaign.

The total number of times links within a campaign were clicked.

The date and time of the most recent click recorded for a campaign.

The number of unique individuals who clicked a link in a campaign.

The number of unique subscribers who clicked a link in a campaign.

The date and time a resource was created, in ISO 8601 format.

The date and time a resource was created.

Indicates whether a contact or member has been deleted from an audience. This can refer to a soft delete (archived) or a hard delete (permanently removed). Permanently deleted contacts cannot be re-added via the API and are effectively "banned" from the list unless they resubscribe through a Mailchimp signup form.

Indicates if a campaign's delivery can be canceled.

The number of emails that were prevented from being delivered to recipients because a campaign was canceled while it was still in the process of sending.

The total number of emails sent for a campaign.

A boolean indicator that specifies whether delivery status tracking, such as open and click tracking, is enabled for a campaign or for an account's email settings.

The current delivery status of a campaign (e.g., sending, sent, canceled).

The currency code for the e-commerce store or transaction.

The total number of orders placed in an e-commerce store.

The total revenue generated from an e-commerce store.

The total amount spent by a customer in an e-commerce store.

The email address of a subscriber or recipient.

The email client used by a subscriber to open a campaign.

The unique identifier for a specific email within a campaign, often used for tracking individual email activity.

The total number of emails successfully sent for a campaign.

The total number of Facebook Likes associated with a campaign.

The number of recipients who 'liked' the campaign on Facebook.

The number of unique users who 'liked' the campaign on Facebook.

The total number of times a campaign was forwarded.

The total number of times a forwarded campaign was opened.

The unique identifier for a specific marketing campaign or automation.

The average abuse rate for the industry type associated with the list.

The average bounce rate for the industry type associated with the list.

The average click rate for the industry type associated with the list.

The average open rate for the industry type associated with the list.

The industry type associated with the list.

The average unopen rate for the industry type associated with the list, representing recipients who did not open the email.

The average unsubscribe rate for the industry type associated with the list.

The IP address recorded when a subscriber opted into the list.

The IP address recorded when a subscriber signed up for the list.

The language code for the campaign content or subscriber preference.

The date and time a resource was last changed, in ISO 8601 format.

The unique identifier for an audience list.

Indicates if the list is currently active.

The name of the Mailchimp list.

The average click rate across all campaigns for a specific list.

The average open rate across all campaigns for a specific list.

The average subscription rate for a list.

The average unsubscribe rate for a list.

The rate at which subscribers unsubscribed from a list.

The country code of the subscriber's location based on IP address geocoding.

Daylight Saving Time offset for the subscriber's location.

Greenwich Mean Time offset for the subscriber's location.

The latitude coordinate of the subscriber's location.

The longitude coordinate of the subscriber's location.

The timezone of the subscriber's location.

The subscriber's engagement rating, from 1 to 5 stars, where 5 is the highest.

The physical address merge field for a list member.

The company merge field for a list member.

The first name merge field for a list member.

The last name merge field for a list member.

The phone number merge field for a list member.

The month for which growth history data is reported.

The name of the campaign, list, or other Mailchimp resource.

The date and time of the most recent open recorded for a campaign.

The rate at which recipients opened a campaign.

The total number of times a campaign was opened.

The number of unique individuals who opened a campaign.

Represents the marketing consent preferences of a contact, indicating the types of marketing communications they have opted in to receive (e.g., email, direct mail, customized online advertising). This can also reflect the opt-in status (single or double opt-in) for a contact.

The unique identifier of the parent campaign for a child campaign (e.g., A/B test variations, RSS campaigns).

Indicates if a subscriber's status is pending (e.g., awaiting confirmation).

The text that appears in the inbox after the subject line.

The unique identifier for the list of recipients for a campaign.

Indicates if the recipient list for the campaign is active.

The name of the list that received the campaign.

Refers to the process where a subscriber is asked to confirm their continued interest in receiving marketing communications, often after a period of inactivity or an unsubscribe. This helps maintain list hygiene and compliance by ensuring explicit consent.

The overall click rate for a campaign, representing how many recipients clicked links.

The total number of clicks for a campaign.

The overall open rate for a campaign, representing how many recipients opened the email.

The total number of opens for a campaign.

The number of unique subscribers who clicked a link in a campaign.

The number of unique opens for a campaign.

The date and time the last RSS campaign was sent.

The date and time when a campaign was sent.

Indicates if Mailchimp authentication is enabled for the campaign.

Indicates if the Mailchimp default footer is automatically included in the campaign.

The 'from' name for the campaign, as seen by recipients.

Indicates if CSS is inlined in the campaign HTML.

The reply-to email address for the campaign.

The title of the campaign.

The 'to' name for the campaign, often a merge tag for the recipient's name.

Indicates if conversation tracking is enabled for the campaign.

The password required to access the campaign's shareable report.

The URL for the campaign's shareable report.

Indicates the origin or method by which a contact was added to an audience, such as through a hosted signup form, an embedded form, a manual administrator add, or an API integration.

The date and time a campaign started sending or an automation workflow began.

The average click rate across all campaigns for a list.

The average open rate across all campaigns for a list.

The average subscription rate for a list.

The average unsubscription rate for a list.

The total number of campaigns sent to a list.

The date and time the last campaign was sent to a list.

The number of cleaned email addresses on a list.

The number of cleaned email addresses on a list since the last campaign send.

The overall click rate for a campaign or list, representing how many recipients clicked links.

The date of the last subscription to a list.

The date of the last unsubscription from a list.

The total number of members in a list.

The number of members added to a list since the last campaign send.

The number of merge fields configured for a list.

The total number of unsubscribes for a list.

The number of unsubscribes from a list since the last campaign send.

The current status of a campaign (e.g., draft, sent, scheduled) or list member (e.g., subscribed, unsubscribed).

Indicates if the campaign delivery status is enabled.

The subject line of the campaign email.

Indicates if a member is currently subscribed to a list.

A list of tags applied to a campaign or subscriber.

The number of tags applied to a campaign or subscriber.

The date and time a subscriber opted into a list.

The date and time a subscriber signed up for a list.

Indicates if e-commerce360 tracking is enabled for the campaign.

Indicates if goal tracking is enabled for the campaign.

The Google Analytics tracking code for the campaign.

Indicates if HTML click tracking is enabled for the campaign.

Indicates if open tracking is enabled for the campaign.

Indicates if plain-text click tracking is enabled for the campaign.

Indicates whether an email or message is a transactional email, meaning it is an automated, event-driven, one-to-one communication (e.g., order confirmations, password resets) sent via the Mailchimp Transactional API, as opposed to a bulk marketing campaign.

The days of the week when an automation workflow is active.

The specific hours when an automation workflow is active.

The total number of emails in an automation workflow.

The title of the automation workflow.

The type of automation workflow (e.g., welcome, abandonedCart).

The type of marketing campaign, e.g., 'regular', 'plaintext', 'rss', 'variate', or 'automation'.

The total number of subscribers who unsubscribed from a campaign or list.

Indicates if a subscriber is marked as a VIP.