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.
Date Dimension
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.
ab_split.a.abuse_reports Metric
The number of abuse reports for variation A of an A/B split campaign.
ab_split.a.bounces Metric
The number of bounces for variation A of an A/B split campaign.
ab_split.a.forwards_opens Metric
The number of times campaign A was forwarded and then opened.
ab_split.a.last_open Dimension
The date and time of the last open for variation A of an A/B split campaign.
ab_split.a.opens AB Split A: Total Opens Metric
The total number of opens for variation A of an A/B split campaign.
ab_split.a.recipient_clicks AB Split A: Recipient Clicks Metric
The total number of clicks by recipients for variation A of an A/B split campaign.
ab_split.a.unique_opens AB Split A: Unique Opens Metric
The number of unique opens for variation A of an A/B split campaign.
ab_split.a.unsubs AB Split A: Unsubscribe Count Metric
The number of unsubscribes for variation A of an A/B split campaign.
ab_split.b.abuse_reports Metric
The number of abuse reports for variation B of an A/B split campaign.
ab_split.b.bounces Metric
The number of bounces for variation B of an A/B split campaign.
ab_split.b.forwards_opens Metric
The number of times campaign B was forwarded and then opened.
ab_split.b.last_open Dimension
The date and time of the last open for variation B of an A/B split campaign.
ab_split.b.opens AB Split B: Total Opens Metric
The total number of opens for variation B of an A/B split campaign.
ab_split.b.recipient_clicks AB Split B: Recipient Clicks Metric
The total number of clicks by recipients for variation B of an A/B split campaign.
ab_split.b.unique_opens AB Split B: Unique Opens Metric
The number of unique opens for variation B of an A/B split campaign.
ab_split.b.unsubs AB Split B: Unsubscribe Count Metric
The number of unsubscribes for variation B of an A/B split campaign.
abuse_reports Abuse Reports Metric
The total count of abuse reports received for a specific campaign.
activity.action Activity Action Dimension
The type of action performed by a subscriber, such as 'open', 'click', or 'bounce'.
activity.ip Activity IP Dimension
The IP address associated with the subscriber's activity.
activity.timestamp Activity Timestamp Dimension
The date and time when a specific subscriber activity occurred.
activity.type Activity Type Dimension
The general category of activity, such as 'email-activity'.
activity.url Activity URL Dimension
The URL that was clicked by the subscriber in an email campaign.
bounces.hard_bounces Hard Bounces Metric
The count of hard bounces, indicating permanent delivery failures for email campaigns.
bounces.soft_bounces Soft Bounces Metric
The count of soft bounces, indicating temporary delivery failures for email campaigns.
bounces.syntax_errors Syntax Errors Metric
The count of bounces due to syntax errors in email addresses.
campaign_id Dimension
The unique identifier for a campaign.
campaign_title Campaign Title Dimension
The descriptive title of an email marketing campaign.
cleaned Metric
Indicates if a list member's email address has been cleaned due to being invalid or undeliverable.
clicks.click_rate Metric
The rate at which recipients clicked links within a campaign.
clicks.clicks_total Total Clicks Metric
The total number of times links within a campaign were clicked.
clicks.last_click Last Click Dimension
The date and time of the most recent click recorded for a campaign.
clicks.unique_clicks Unique Clicks Metric
The number of unique individuals who clicked a link in a campaign.
clicks.unique_subscriber_clicks Unique Subscriber Clicks Metric
The number of unique subscribers who clicked a link in a campaign.
create_time Dimension
The date and time a resource was created, in ISO 8601 format.
date_created Dimension
The date and time a resource was created.
deleted Metric
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.
delivery_status.can_cancel Dimension
Indicates if a campaign's delivery can be canceled.
delivery_status.emails_canceled Metric
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.
delivery_status.emails_sent Delivery Status Emails Sent Metric
The total number of emails sent for a campaign.
delivery_status.enabled Dimension
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.
delivery_status.status Dimension
The current delivery status of a campaign (e.g., sending, sent, canceled).
ecommerce.currency_code Ecommerce Currency Code Dimension
The currency code for the e-commerce store or transaction.
ecommerce.total_orders Ecommerce Total Orders Metric
The total number of orders placed in an e-commerce store.
ecommerce.total_revenue Ecommerce Total Revenue Metric
The total revenue generated from an e-commerce store.
ecommerce.total_spent Ecommerce Total Spent Metric
The total amount spent by a customer in an e-commerce store.
email_address Email Address Dimension
The email address of a subscriber or recipient.
email_client Dimension
The email client used by a subscriber to open a campaign.
email_id Email ID Dimension
The unique identifier for a specific email within a campaign, often used for tracking individual email activity.
emails_sent Emails Sent Metric
The total number of emails successfully sent for a campaign.
facebook_likes.facebook_likes Facebook Likes Metric
The total number of Facebook Likes associated with a campaign.
facebook_likes.recipient_likes Recipient Likes Metric
The number of recipients who 'liked' the campaign on Facebook.
facebook_likes.unique_likes Unique Likes Metric
The number of unique users who 'liked' the campaign on Facebook.
forwards.forwards_count Total Forwards Metric
The total number of times a campaign was forwarded.
forwards.forwards_opens Forward Opens Metric
The total number of times a forwarded campaign was opened.
id Campaign ID Dimension
The unique identifier for a specific marketing campaign or automation.
industry_stats.abuse_rate Metric
The average abuse rate for the industry type associated with the list.
industry_stats.bounce_rate Metric
The average bounce rate for the industry type associated with the list.
industry_stats.click_rate Metric
The average click rate for the industry type associated with the list.
industry_stats.open_rate Metric
The average open rate for the industry type associated with the list.
industry_stats.type Dimension
The industry type associated with the list.
industry_stats.unopen_rate Metric
The average unopen rate for the industry type associated with the list, representing recipients who did not open the email.
industry_stats.unsub_rate Metric
The average unsubscribe rate for the industry type associated with the list.
ip_opt Dimension
The IP address recorded when a subscriber opted into the list.
ip_signup Dimension
The IP address recorded when a subscriber signed up for the list.
language Dimension
The language code for the campaign content or subscriber preference.
last_changed Dimension
The date and time a resource was last changed, in ISO 8601 format.
list_id List ID Dimension
The unique identifier for an audience list.
list_is_active Dimension
Indicates if the list is currently active.
list_name Dimension
The name of the Mailchimp list.
list_stats.click_rate Metric
The average click rate across all campaigns for a specific list.
list_stats.open_rate Metric
The average open rate across all campaigns for a specific list.
list_stats.sub_rate Metric
The average subscription rate for a list.
list_stats.unsub.rate Metric
The average unsubscribe rate for a list.
list_stats.unsub_rate Metric
The rate at which subscribers unsubscribed from a list.
location.country_code Dimension
The country code of the subscriber's location based on IP address geocoding.
location.dstoff Dimension
Daylight Saving Time offset for the subscriber's location.
location.gmtoff Dimension
Greenwich Mean Time offset for the subscriber's location.
location.latitude Dimension
The latitude coordinate of the subscriber's location.
location.longitude Dimension
The longitude coordinate of the subscriber's location.
location.timezone Dimension
The timezone of the subscriber's location.
member_rating Metric
The subscriber's engagement rating, from 1 to 5 stars, where 5 is the highest.
merge_fields.ADDRESS Dimension
The physical address merge field for a list member.
merge_fields.COMPANY Dimension
The company merge field for a list member.
merge_fields.FNAME Dimension
The first name merge field for a list member.
merge_fields.LNAME Dimension
The last name merge field for a list member.
merge_fields.PHONE Dimension
The phone number merge field for a list member.
month Dimension
The month for which growth history data is reported.
name Dimension
The name of the campaign, list, or other Mailchimp resource.
opens.last_open Last Open Dimension
The date and time of the most recent open recorded for a campaign.
opens.open_rate Metric
The rate at which recipients opened a campaign.
opens.opens_total Total Opens Metric
The total number of times a campaign was opened.
opens.unique_opens Unique Opens Metric
The number of unique individuals who opened a campaign.
optins Metric
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.
parent_campaign_id Dimension
The unique identifier of the parent campaign for a child campaign (e.g., A/B test variations, RSS campaigns).
pending Metric
Indicates if a subscriber's status is pending (e.g., awaiting confirmation).
preview_text Dimension
The text that appears in the inbox after the subject line.
recipients.list_id Dimension
The unique identifier for the list of recipients for a campaign.
recipients.list_is_active Dimension
Indicates if the recipient list for the campaign is active.
recipients.list_name Dimension
The name of the list that received the campaign.
reconfirm Metric
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.
report_summary.click_rate Click Rate Metric
The overall click rate for a campaign, representing how many recipients clicked links.
report_summary.clicks Metric
The total number of clicks for a campaign.
report_summary.open_rate Open Rate Metric
The overall open rate for a campaign, representing how many recipients opened the email.
report_summary.opens Metric
The total number of opens for a campaign.
report_summary.subscriber_clicks Metric
The number of unique subscribers who clicked a link in a campaign.
report_summary.unique_opens Metric
The number of unique opens for a campaign.
rss_last_send Dimension
The date and time the last RSS campaign was sent.
send_time Send Time Dimension
The date and time when a campaign was sent.
settings.authenticate Dimension
Indicates if Mailchimp authentication is enabled for the campaign.
settings.auto_footer Dimension
Indicates if the Mailchimp default footer is automatically included in the campaign.
settings.from_name Dimension
The 'from' name for the campaign, as seen by recipients.
settings.inline_css Dimension
Indicates if CSS is inlined in the campaign HTML.
settings.reply_to Dimension
The reply-to email address for the campaign.
settings.title Dimension
The title of the campaign.
settings.to_name Dimension
The 'to' name for the campaign, often a merge tag for the recipient's name.
settings.use_conversation Dimension
Indicates if conversation tracking is enabled for the campaign.
share_report.share_password Dimension
The password required to access the campaign's shareable report.
share_report.share_url Dimension
The URL for the campaign's shareable report.
source Dimension
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.
start_time Dimension
The date and time a campaign started sending or an automation workflow began.
stats.avg_click_rate Metric
The average click rate across all campaigns for a list.
stats.avg_open_rate Metric
The average open rate across all campaigns for a list.
stats.avg_sub_rate Metric
The average subscription rate for a list.
stats.avg_unsub_rate Metric
The average unsubscription rate for a list.
stats.campaign_count Metric
The total number of campaigns sent to a list.
stats.campaign_last_sent Dimension
The date and time the last campaign was sent to a list.
stats.cleaned_count Metric
The number of cleaned email addresses on a list.
stats.cleaned_count_since_send Metric
The number of cleaned email addresses on a list since the last campaign send.
stats.click_rate Metric
The overall click rate for a campaign or list, representing how many recipients clicked links.
stats.last_sub_date Dimension
The date of the last subscription to a list.
stats.last_unsub_date Dimension
The date of the last unsubscription from a list.
stats.member_count Metric
The total number of members in a list.
stats.member_count_since_send Metric
The number of members added to a list since the last campaign send.
stats.merge_field_count Metric
The number of merge fields configured for a list.
stats.unsubscribe_count Metric
The total number of unsubscribes for a list.
stats.unsubscribe_count_since_send Metric
The number of unsubscribes from a list since the last campaign send.
status Dimension
The current status of a campaign (e.g., draft, sent, scheduled) or list member (e.g., subscribed, unsubscribed).
status_enabled Dimension
Indicates if the campaign delivery status is enabled.
subject_line Subject Line Dimension
The subject line of the campaign email.
subscribed Metric
Indicates if a member is currently subscribed to a list.
tags Dimension
A list of tags applied to a campaign or subscriber.
tags_count Metric
The number of tags applied to a campaign or subscriber.
timestamp_opt Dimension
The date and time a subscriber opted into a list.
timestamp_signup Dimension
The date and time a subscriber signed up for a list.
tracking.ecomm360 Dimension
Indicates if e-commerce360 tracking is enabled for the campaign.
tracking.goal_tracking Dimension
Indicates if goal tracking is enabled for the campaign.
tracking.google_analytics Dimension
The Google Analytics tracking code for the campaign.
tracking.html_clicks Dimension
Indicates if HTML click tracking is enabled for the campaign.
tracking.opens Dimension
Indicates if open tracking is enabled for the campaign.
tracking.text_clicks Dimension
Indicates if plain-text click tracking is enabled for the campaign.
transactional Metric
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.
trigger_settings.runtime.days Dimension
The days of the week when an automation workflow is active.
trigger_settings.runtime.hours Dimension
The specific hours when an automation workflow is active.
trigger_settings.workflow_emails_count Metric
The total number of emails in an automation workflow.
trigger_settings.workflow_title Dimension
The title of the automation workflow.
trigger_settings.workflow_type Dimension
The type of automation workflow (e.g., welcome, abandonedCart).
type Campaign Type Dimension
The type of marketing campaign, e.g., 'regular', 'plaintext', 'rss', 'variate', or 'automation'.
unsubscribed Unsubscribe Count Metric
The total number of subscribers who unsubscribed from a campaign or list.
vip Dimension
Indicates if a subscriber is marked as a VIP.