Fields listing for Mailchimp

The click rate for the campaign.

The open rate for the campaign.

The preview text of the campaign.

Indicates whether the list that the campaign was sent to is currently active.

The name of the list that the campaign was sent to.

The number of abuse reports for the A split of the campaign.

The number of bounces for the A split of the campaign.

The number of forwards for the A split of the campaign.

The number of opens from forwarded emails for the A split of the campaign.

The date and time of the last open for the A split of the campaign.

The number of opens for the A split of the campaign.

The number of clicks from recipients for the A split of the campaign.

The number of unique opens for the A split of thecampaign.

The number of subscribers who unsubscribed from the A split of the campaign.

The number of the link click percentage.

The number of the click on the link.

The number of unique link click.

The number of unique link click percentage.

The number of the link click percentage.

The number of the click on the link.

The number of unique link click.

The number of unique link click percentage.

For A/B Split Campaigns, the group the member was apart of ('a', 'b', or 'winner')

The number of abuse reports for the campaign.

The automation authenticate

The automation auto footer settings

The automation Clicktale tracking

The automation created time.

The automation ECOM360 tracking

The automation title.

The automation tracking goal clicks

The automation Google Analytics tracking

The automation tracking html clicks

The unique identifier for the automation.

The automation inline css settings

The automation list ID.

The automation List is Active.

The automation List Name.

The automation reply to.

The automation start time.

The automation status.

The automation store id.

The automation tracking text clicks

The automation title.

The automation to name.

The automation tracking open settings

The automation use conversation.

The automation Workflow Title

The automation Workflow type

The number of abuse reports for the B split of the campaign.

The number of bounces for the B split of the campaign.

The number of forwards for the B split of the campaign.

The number of opens from forwarded emails for the B split of the campaign.

The date and time of the last open for the B split of the campaign.

The number of opens for the B split of the campaign.

The number of clicks from recipients for the B split of the campaign.

The number of unique opens for the B split of the campaign.

The number of subscribers who unsubscribed from the B split of the campaign.

Bounce rate ((Hard bounces + Soft bounces) / Emails Sent)

Bounces (Hard bounces + Soft bounces)

The unique identifier for the campaign.

The date and time of the last click for the campaign.

The date and time of the last open.

The click rate for the list that the campaign was sent to.

The open rate for the list that the campaign was sent to.

The subscription rate for the list that the campaign was sent to.

The unsubscribe rate for the list that the campaign was sent to.

The date and time the campaign was sent.

The subject line of the campaign.

The title of the campaign.

The type of campaign.

click rate. Formula: Unique Clicks / Emails Sent

The number of clicks activity for the selected granularity.

The total number of clicks for the campaign.

Year, month, and day.

Day of the year

Week of the year

Whether the campaign can be canceled.

The number of emails canceled for the campaign.

The number of emails delivered for the campaign.

Whether delivery status is enabled for the campaign.

The delivery status for the campaign.

The currency code used for the campaign.

The total number of orders for the campaign.

The total revenue for the campaign.

The total amount spent for the campaign.

The email address.

The email id.

The date and time of the last open for this member.

The number of emails delivered (emails sent minus emails bounced)

The number of emails that were sent.

Hard bounce rate (Hard bounces / Emails Sent)

The hard bounce summary for the campaign

Hour of the day

The abuse rate for the campaign compared to other campaigns in the industry.

The bounce rate for the campaign compared to other campaigns in the industry.

The click rate for the campaign compared to other campaigns in the industry.

The open rate for the campaign compared to other campaigns in the industry.

The industry type.

The unopen rate for the campaign compared to other campaigns in the industry.

The unsubscribe rate for the campaign compared to other campaigns in the industry.

The number of the link click percentage.

The Link ID.

The url link.

The average number of subscriptions per month for the list (not returned if we haven't calculated it yet).

The average number of unsubscriptions per month for the list (not returned if we haven't calculated it yet).

The list's Email Beamer address.

The number of campaigns in any status that use this list.

The number of members cleaned from the list.

The number of members cleaned from the list since the last campaign was sent.

The average click rate (a percentage represented as a number between 0 and 100) per campaign for the list (not returned if we haven't calculated it yet).

The date and time that this list was created in ISO 8601 format.

Whether or not to require the subscriber to confirm subscription via email.

Whether the list supports multiple formats for emails. When set to true, subscribers can choose whether they want to receive HTML or plain-text emails. When set to false, subscribers will receive HTML emails, with a plain-text alternative backup.

Whether or not this list has a welcome automation connected. Welcome Automations: welcomeSeries, singleWelcome, emailFollowup.

A string that uniquely identifies this list.

The date and time of the last time someone subscribed to this list in ISO 8601 format.

The date and time of the last time someone unsubscribed from this list in ISO 8601 format.

Whether or not the list has marketing permissions (eg. GDPR) enabled.

The number of active members in the list.

The number of active members in the list since the last campaign was sent.

The number of merge fields (audience field) for this list (doesn't include EMAIL).

The name of the list.

The email address to send subscribe notifications to.

The email address to send unsubscribe notifications to.

The average open rate (a percentage represented as a number between 0 and 100) per campaign for the list (not returned if we haven't calculated it yet).

The permission reminder for the list.

An auto-generated activity score for the list (0-5).

The full version of this list's subscribe form (host will vary).

Our url shortened version of this list's subscribe form.

The target number of subscriptions per month for the list to keep it growing (not returned if we haven't calculated it yet).

The number of contacts in the list, including subscribed, unsubscribed, pending, cleaned, deleted, transactional, and those that need to be reconfirmed. Requires include_total_contacts query parameter to be included.

The number of members who have unsubscribed from the list.

The number of members who have unsubscribed since the last campaign was sent.

Whether campaigns for this list use the Archive Bar in archives by default.

Legacy - visibility settings are no longer used Possible values: "pub" or "prv".

The ID used in the Mailchimp web application. View this list in your Mailchimp account at https://{dc}.admin.mailchimp.com/lists/members/?id={web_id}.

A subscriber's average clickthrough rate.

A subscriber's average open rate.

IP address the subscriber signed up from.

The three-letter ISO 4217 code for the currency that the store accepts.

Email address for a subscriber.

The list member's email client.

Type of email this member asked to get ('html' or 'text').

The contact's full name.

The MD5 hash of the lowercase version of the list member's email address.

The IP address the subscriber used to confirm their opt-in status.

IP address the subscriber signed up from.

If set/detected, the subscriber's language.

The date and time the member's info was last changed in ISO 8601 format.

The total number of orders placed by the list member.

Star rating for this member, between 1 and 5.

The source from which the subscriber was added to this list.

Subscriber's current status. Possible values: "subscribed", "unsubscribed", "cleaned", "pending", "transactional", or "archived".

The number of tags applied to this member.

The date and time the subscriber confirmed their opt-in status in ISO 8601 format.

The date and time the subscriber signed up for the list in ISO 8601 format.

The total revenue the list member has brought in.

An identifier for the address across all of Mailchimp.

Indicates whether a contact consents to 1:1 messaging.

VIP status for subscriber.

The ID used in the Mailchimp web application. View this member in your Mailchimp account at https://{dc}.admin.mailchimp.com/lists/members/view?id={web_id}.

Month and day

Month of the year

The number of open mails activity for the selected granularity.

open rate. Formula: Unique Opens / Emails Sent

The total number of times the email was opened.

Quarter of the year

The date and time the last RSS campaign was sent.

The URL for sharing the report.

Soft bounce rate (Soft bounces / Emails Sent)

The soft bounce summary for the campaign

The status of the email sent to the member ('sent', 'hard' for hard bounce, or 'soft' for soft bounce).

The total number of addresses that were syntax-related bounces

Date of the last click on the link

The number of the click on the link.

The number of unique clicks for the campaign.

The number of unique link click.

The number of unique link click percentage.

The number of unique email for the campaign.

The number of unique subscriber clicks for the campaign.

The number of subscribers who unsubscribed from the campaign.

Week of the year

Week of the year

Year such as 2017.

Year and month.

Year, month, day, and hour.

Year, month, day, hour and minute.

Year and quarter.

Year and week.