Mailchimp: Most-used fields

The table below gives information about most-used fields that you can import from Mailchimp. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Description	Use in Adverity
Date	Date	This field represents a primary date associated with a Mailchimp campaign, such as the date the campaign was sent or created. It provides a key timestamp for understanding campaign performance or lifecycle. Mailchimp APIs typically use ISO 8601 format for date and time information.	dimension
ab_split.a.abuse_reports	AB Split A: Abuse Reports	The count of abuse reports for segment A of an A/B split campaign.	dimension
ab_split.a.bounces	AB Split A: Bounces	The total count of bounces for segment A of an A/B split campaign.	dimension
ab_split.a.forwards_opens	AB Split A: Forward Opens	The total count of opens from forwarded emails for segment A of an A/B split campaign.	dimension
ab_split.a.last_open	AB Split A: Last Open	The date and time of the most recent open for segment A of an A/B split campaign.	dimension
ab_split.a.opens	AB Split A: Total Opens	The total number of opens for segment A of an A/B split campaign.	dimension
ab_split.a.recipient_clicks	AB Split A: Recipient Clicks	The total number of clicks by recipients for segment A of an A/B split campaign.	dimension
ab_split.a.unique_opens	AB Split A: Unique Opens	The number of unique opens for segment A of an A/B split campaign.	dimension
ab_split.a.unsubs	AB Split A: Unsubscribe Count	The total number of unsubscribes for segment A of an A/B split campaign.	dimension
ab_split.b.abuse_reports	AB Split B: Abuse Reports	The count of abuse reports for segment B of an A/B split campaign.	dimension
ab_split.b.bounces	AB Split B: Bounces	The total count of bounces for segment B of an A/B split campaign.	dimension
ab_split.b.forwards_opens	AB Split B: Forward Opens	The total count of opens from forwarded emails for segment B of an A/B split campaign.	dimension
ab_split.b.last_open	AB Split B: Last Open	The date and time of the most recent open for segment B of an A/B split campaign.	dimension
ab_split.b.opens	AB Split B: Total Opens	The total number of opens for segment B of an A/B split campaign.	dimension
ab_split.b.recipient_clicks	AB Split B: Recipient Clicks	The total number of clicks by recipients for segment B of an A/B split campaign.	dimension
ab_split.b.unique_opens	AB Split B: Unique Opens	The number of unique opens for segment B of an A/B split campaign.	dimension
ab_split.b.unsubs	AB Split B: Unsubscribe Count	The total number of unsubscribes for segment B of an A/B split campaign.	dimension
abuse_reports	Abuse Reports	The total count of abuse reports received for a specific campaign.	metric
activity.action	Activity Action	The type of action performed by a subscriber, such as ‘open’, ‘click’, or ‘bounce’.	dimension
activity.ip	Activity IP	The IP address associated with the subscriber’s activity.	dimension
activity.timestamp	Activity Timestamp	The date and time when a specific subscriber activity occurred.	dimension
activity.type	Activity Type	The general category of activity, such as ‘email-activity’.	dimension
activity.url	Activity URL	The URL that was clicked by the subscriber in an email campaign.	dimension
bounces.hard_bounces	Hard Bounces	The count of hard bounces, indicating permanent delivery failures for email campaigns.	metric
bounces.soft_bounces	Soft Bounces	The count of soft bounces, indicating temporary delivery failures for email campaigns.	metric
bounces.syntax_errors	Syntax Errors	The count of bounces due to syntax errors in email addresses.	metric
campaign_title	Campaign Title	The descriptive title of an email marketing campaign.	dimension
cleaned	Cleaned	A boolean indicating if an audience member’s email address has been cleaned due to permanent delivery issues.	metric
clicks.clicks_total	Total Clicks	The total number of times links within a campaign were clicked.	metric
clicks.last_click	Last Click	The date and time of the most recent click recorded for a campaign.	dimension
clicks.unique_clicks	Unique Clicks	The number of unique individuals who clicked a link in a campaign.	metric
clicks.unique_subscriber_clicks	Unique Subscriber Clicks	The number of unique subscribers who clicked a link in a campaign.	metric
create_time	Create Time	The date and time when a resource, such as an automation or campaign, was created.	dimension
date	date	This field captures user-defined date information for an audience member (subscriber). It corresponds to a ‘date’ type merge field in Mailchimp, allowing for custom dates like anniversaries or other relevant personal dates to be stored for contacts. Dates are typically collected and stored in formats such as YYYY-MM-DD.	dimension
date_created	Creation Date	The date and time when a campaign or list was created.	dimension
date_scheduled	date_scheduled	The date and time when a campaign is scheduled to be sent.	dimension
deleted	Deleted	A boolean indicating if an audience member has been deleted from the list.	metric
delivery_status.can_cancel	Delivery Status Can Cancel	Indicates whether the delivery of an automation email can be canceled.	dimension
delivery_status.emails_canceled	Delivery Status Emails Canceled	The number of emails that were canceled for an automation workflow.	metric
delivery_status.emails_sent	Delivery Status Emails Sent	The number of emails sent for an automation workflow.	metric
delivery_status.enabled	Delivery Status Enabled	Indicates whether the delivery status for an automation workflow is enabled.	dimension
delivery_status.status	Delivery Status - Status	The current delivery status of an automation workflow (e.g., ‘sending’, ‘paused’).	dimension
ecommerce.currency_code	Ecommerce Currency Code	The currency code used for e-commerce transactions related to a campaign.	dimension
ecommerce.total_orders	Total Orders	The total number of e-commerce orders generated from a campaign.	metric
ecommerce.total_revenue	Total Revenue	The total revenue generated from e-commerce activity linked to a campaign.	metric
ecommerce.total_spent	Total Spent	The total amount spent by customers via e-commerce activity linked to a campaign.	metric
email_address	Email Address	The email address of a subscriber or recipient.	dimension
email_client	Email Client	The email client used by a subscriber to open a campaign.	dimension
email_id	Email ID	The unique identifier for a specific email within a campaign, often used for tracking individual email activity.	dimension
emails_sent	Emails Sent	The total number of emails successfully sent for a campaign.	metric
facebook_likes.facebook_likes	Facebook Likes	The total number of Facebook Likes associated with a campaign.	metric
facebook_likes.recipient_likes	Recipient Likes	The number of recipients who ‘liked’ the campaign on Facebook.	metric
facebook_likes.unique_likes	Unique Likes	The number of unique users who ‘liked’ the campaign on Facebook.	metric
forwards.forwards_count	Total Forwards	The total number of times a campaign was forwarded.	metric
forwards.forwards_opens	Forward Opens	The total number of times a forwarded campaign was opened.	metric
id	Campaign ID	The unique identifier for a specific marketing campaign or automation.	dimension
industry_stats.abuse_rate	Industry Status Abuse Rate	The average abuse rate for the industry, providing a benchmark for campaign performance.	metric
industry_stats.bounce_rate	Industry Status Bounce Rate	The average bounce rate for the industry, providing a benchmark for email deliverability.	metric
industry_stats.click_rate	Industry Status Click Rate	The average click rate for the industry, providing a benchmark for campaign engagement.	metric
industry_stats.open_rate	Industry Status Open Rate	The average open rate for the industry, providing a benchmark for campaign reach.	metric
industry_stats.type	Industry Type	The industry category for which the statistics are provided.	dimension
industry_stats.unopen_rate	Unopened Rate	The average unopen rate for the industry, indicating emails not opened.	metric
industry_stats.unsub_rate	Unsubscribe Rate	The average unsubscribe rate for the industry, providing a benchmark for subscriber retention.	metric
ip_opt	Opt-in IP	The IP address recorded when a subscriber opted into the list.	dimension
ip_signup	Signup IP	The IP address recorded when a subscriber signed up for the list.	dimension
language	Language	The primary language of the audience member.	dimension
last_changed	Last Changed Date	The date and time when a member’s information was last updated.	dimension
list_id	List ID	The unique identifier for an audience list.	dimension
list_is_active	List Status	Indicates whether the audience list is currently active.	dimension
list_name	List Name	The name of the audience list.	dimension
list_stats.click_rate	List Stats Click Rate	The average click rate across all campaigns sent to this specific audience list.	metric
list_stats.open_rate	List Stats Open Rate	The average open rate across all campaigns sent to this specific audience list.	metric
list_stats.sub_rate	List Stats Sub Rate	The average subscription rate for this specific audience list.	metric
list_stats.unsub.rate	List Stats Unsub Rate	The average unsubscription rate for this specific audience list.	dimension
location.country_code	Country Code	The two-letter country code (ISO 3166-1 alpha-2) of the subscriber’s location.	dimension
location.dstoff	DST Offset	The Daylight Saving Time (DST) offset for the subscriber’s location.	metric
location.gmtoff	GMT Offset	The GMT offset for the subscriber’s location.	metric
location.latitude	Latitude	The geographical latitude of the subscriber’s location.	metric
location.longitude	Longitude	The geographical longitude of the subscriber’s location.	metric
location.timezone	Timezone	The timezone of the subscriber’s location.	dimension
member_rating	Member Rating	The subscriber’s member rating, indicating their engagement level.	metric
merge_fields.ADDRESS	Address	The address merge field for an audience member.	dimension
merge_fields.COMPANY	Company	The company name merge field for an audience member.	dimension
merge_fields.FNAME	First Name	The first name merge field for an audience member.	dimension
merge_fields.LNAME	Last Name	The last name merge field for an audience member.	dimension
merge_fields.PHONE	Phone	The phone number merge field for an audience member.	dimension
month	Month	The month for which growth history data is reported, often used for filtering monthly list growth metrics.	dimension
opens.last_open	Last Open	The date and time of the most recent open recorded for a campaign.	dimension
opens.opens_total	Total Opens	The total number of times a campaign was opened.	metric
opens.unique_opens	Unique Opens	The number of unique individuals who opened a campaign.	metric
optins	Opt-in	The number of successful opt-ins for a list.	metric
parent_campaign_id	Parent Campaign ID	The ID of the parent campaign, used for multivariate or A/B split campaigns.	dimension
pending	Pending	A boolean indicating if an audience member’s subscription is pending confirmation.	metric
preview_text	Preview Text	The preview text that displays after the subject line in an email inbox.	dimension
recipients.list_is_active	Is Active	Indicates whether the list of recipients for a campaign is active.	dimension
reconfirm	Reconfirm	A boolean indicating if an audience member needs to reconfirm their subscription.	metric
report_summary.click_rate	Click Rate	The percentage of recipients who clicked a link in a campaign.	metric
report_summary.clicks	Clicks	The total number of clicks for the campaign in the report summary.	metric
report_summary.open_rate	Open Rate	The percentage of recipients who opened a campaign.	metric
report_summary.opens	Open	The total number of opens for the campaign in the report summary.	metric
report_summary.subscriber_clicks	Subscriber Clicks	The number of unique subscriber clicks for the campaign in the report summary.	metric
rss_last_send	RSS Last Send	The date and time of the last send for an RSS campaign.	dimension
send_time	Send Time	The date and time when a campaign was sent.	dimension
settings.authenticate	Authenticate	Boolean indicating whether the campaign’s domain is authenticated for DMARC compliance.	dimension
settings.auto_footer	Auto Footer	Boolean indicating whether the Mailchimp footer is automatically included in the campaign.	dimension
settings.from_name	From Name	The name displayed as the sender of the campaign email.	dimension
settings.inline_css	Inline CSS	Boolean indicating whether CSS styles are inlined in the campaign HTML.	dimension
settings.reply_to	Reply To	The email address where replies to the campaign will be sent.	dimension
settings.title	Title	The internal title of the campaign.	dimension
settings.to_name	To Name	The name used in the ‘To’ field of the campaign email.	dimension
settings.use_conversation	Use Conversation	Boolean indicating whether conversations are enabled for the campaign.	dimension
share_report.share_password	Share Report Share Password	The password required to access the sharable campaign report.	dimension
share_report.share_url	Share Report Share URL	The URL to view the sharable campaign report.	dimension
source	Subscriber Source	The method or origin through which a subscriber joined the list.	dimension
start_time	Start Time	The date and time when an automation workflow or campaign started.	dimension
stats.avg_click_rate	Average Click Rate	The average click-through rate across all campaigns for an account or list.	metric
stats.avg_open_rate	Average Open Rate	The average open rate across all campaigns for an account or list.	metric
stats.avg_sub_rate	Average Subscription Rate	The average rate at which new members subscribe to a list.	metric
stats.avg_unsub_rate	Average Unsubscription Rate	The average rate at which members unsubscribe from a list.	metric
stats.campaign_count	Campaign Count	The total number of campaigns associated with a list.	metric
stats.campaign_last_sent	Campaign Last Sent	The date and time when the last campaign was sent for a list.	dimension
stats.cleaned_count	Cleaned Count	The total number of email addresses on a list that have been marked as ‘cleaned’ due to permanent delivery issues.	metric
stats.cleaned_count_since_send	Cleaned Count Since Send	The number of email addresses marked as ‘cleaned’ since the last campaign was sent to the list.	metric
stats.last_sub_date	Date of Last List Subscribe	The date and time of the most recent subscription to the list.	dimension
stats.last_unsub_date	Date of Last List Unsubscribe	The date and time of the most recent unsubscription from the list.	dimension
stats.member_count	Member Count	The total number of members in an audience list.	metric
stats.member_count_since_send	Member Count Since Send	The net change in member count for a list since the last campaign was sent.	metric
stats.merge_field_count	Merge Var Count	The total number of merge fields (custom subscriber data fields) defined for an audience list.	metric
stats.unsubscribe_count_since_send	Unsubscribe Count Since Send	The number of members who unsubscribed from a list since the last campaign was sent.	metric
status	Status	The current status of a campaign, automation, or audience member (e.g., ‘sent’, ‘draft’, ‘subscribed’).	dimension
status_enabled	Campaign Delivery Status	Indicates whether the campaign’s delivery is currently enabled or paused.	dimension
subject_line	Campaign Subject Line	The subject line of the email campaign.	dimension
subscribed	Subscribed	A boolean indicating if an audience member is currently subscribed.	metric
tags	Tags Audience	A list of tags associated with an audience member.	dimension
tags_count	Tags Audience Count	The total number of tags associated with an audience member.	metric
timestamp_opt	Opt-in Timestamp	The date and time when a subscriber opted into the list.	dimension
timestamp_signup	Signup Timestamp	The date and time when a subscriber signed up for the list.	dimension
tracking.ecomm360	EComm 360	Boolean indicating if EComm 360 tracking is enabled for the campaign.	dimension
tracking.goal_tracking	Goal Tracking	Boolean indicating if Goal Tracking is enabled for the campaign.	dimension
tracking.google_analytics	Google Analytics	Boolean indicating if Google Analytics tracking is enabled for the campaign.	dimension
tracking.html_clicks	HTML Clicks	Boolean indicating if HTML clicks are tracked for the campaign.	dimension
tracking.opens	Opens	Boolean indicating if opens are tracked for the campaign.	dimension
tracking.text_clicks	Text Clicks	Boolean indicating if text clicks are tracked for the campaign.	dimension
transactional	Transactional	A boolean indicating if the campaign is a transactional email (sent via Mailchimp Transactional).	metric
trigger_settings.runtime.days	Runtime Days	The number of days an automation workflow is set to run.	dimension
trigger_settings.runtime.hours	Runtime Hours	The number of hours per day an automation workflow is set to run.	dimension
trigger_settings.workflow_emails_count	Workflow Emails Count	The total number of emails in an automation workflow.	metric
trigger_settings.workflow_title	Workflow Title	The title of the automation workflow.	dimension
trigger_settings.workflow_type	Workflow Type	The type of automation workflow.	dimension
type	Campaign Type	The type of marketing campaign, e.g., ‘regular’, ‘plaintext’, ‘rss’, ‘variate’, or ‘automation’.	dimension
unsubscribed	Unsubscribe Count	The total number of subscribers who unsubscribed from a campaign or list.	metric
vip	VIP	A boolean indicating if an audience member is marked as VIP.	dimension