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	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.	dimension
ab_split.a.abuse_reports		The number of abuse reports for variation A of an A/B split campaign.	metric
ab_split.a.bounces		The number of bounces for variation A of an A/B split campaign.	metric
ab_split.a.forwards_opens		The number of times campaign A was forwarded and then opened.	metric
ab_split.a.last_open		The date and time of the last open for variation A of an A/B split campaign.	dimension
ab_split.a.opens		The total number of opens for variation A of an A/B split campaign.	metric
ab_split.a.recipient_clicks		The total number of clicks by recipients for variation A of an A/B split campaign.	metric
ab_split.a.unique_opens		The number of unique opens for variation A of an A/B split campaign.	metric
ab_split.a.unsubs		The number of unsubscribes for variation A of an A/B split campaign.	metric
ab_split.b.abuse_reports		The number of abuse reports for variation B of an A/B split campaign.	metric
ab_split.b.bounces		The number of bounces for variation B of an A/B split campaign.	metric
ab_split.b.forwards_opens		The number of times campaign B was forwarded and then opened.	metric
ab_split.b.last_open		The date and time of the last open for variation B of an A/B split campaign.	dimension
ab_split.b.opens		The total number of opens for variation B of an A/B split campaign.	metric
ab_split.b.recipient_clicks		The total number of clicks by recipients for variation B of an A/B split campaign.	metric
ab_split.b.unique_opens		The number of unique opens for variation B of an A/B split campaign.	metric
ab_split.b.unsubs		The number of unsubscribes for variation B of an A/B split campaign.	metric
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_id		The unique identifier for a campaign.	dimension
campaign_title	Campaign Title	The descriptive title of an email marketing campaign.	dimension
cleaned		Indicates if a list member’s email address has been cleaned due to being invalid or undeliverable.	metric
clicks.click_rate		The rate at which recipients clicked links within a campaign.	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		The date and time a resource was created, in ISO 8601 format.	dimension
date_created		The date and time a resource was created.	dimension
deleted		Indicates if a resource has been marked as deleted.	metric
delivery_status.can_cancel		Indicates if a campaign’s delivery can be canceled.	dimension
delivery_status.emails_canceled		The number of emails that were successfully canceled during campaign delivery.	metric
delivery_status.emails_sent		The total number of emails sent for a campaign.	metric
delivery_status.enabled		Indicates if campaign delivery tracking is enabled.	dimension
delivery_status.status		The current delivery status of a campaign (e.g., sending, sent, canceled).	dimension
ecommerce.currency_code	Currency Code	The currency code for the e-commerce store or transaction.	dimension
ecommerce.total_orders	Total Orders	The total number of orders placed in an e-commerce store.	metric
ecommerce.total_revenue	Total Revenue	The total revenue generated from an e-commerce store.	metric
ecommerce.total_spent	Total Spent	The total amount spent by a customer in an e-commerce store.	metric
email_address	Email Address	The email address of a subscriber or recipient.	dimension
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	Abuse Rate	The average abuse rate for the industry type associated with the list.	metric
industry_stats.bounce_rate	Bounce Rate	The average bounce rate for the industry type associated with the list.	metric
industry_stats.click_rate		The average click rate for the industry type associated with the list.	metric
industry_stats.open_rate		The average open rate for the industry type associated with the list.	metric
industry_stats.type	Industry Type	The industry type associated with the list.	dimension
industry_stats.unopen_rate	Unopened Rate	The average unopen rate for the industry type associated with the list, representing recipients who did not open the email.	metric
industry_stats.unsub_rate	Unsubscribe Rate	The average unsubscribe rate for the industry type associated with the list.	metric
ip_opt		The IP address recorded when a subscriber opted into the list.	dimension
ip_signup		The IP address recorded when a subscriber signed up for the list.	dimension
language		The language code for the campaign content or subscriber preference.	dimension
last_changed		The date and time a resource was last changed, in ISO 8601 format.	dimension
list_id	List ID	The unique identifier for an audience list.	dimension
list_is_active	List Status	Indicates if the list is currently active.	dimension
list_name	List Name	The name of the Mailchimp list.	dimension
list_stats.click_rate		The average click rate across all campaigns for a specific list.	metric
list_stats.open_rate		The average open rate across all campaigns for a specific list.	metric
list_stats.sub_rate		The average subscription rate for a list.	metric
list_stats.unsub.rate		The average unsubscribe rate for a list.	metric
list_stats.unsub_rate		The rate at which subscribers unsubscribed from a list.	metric
location.country_code		The country code of the subscriber’s location based on IP address geocoding.	dimension
location.dstoff		Daylight Saving Time offset for the subscriber’s location.	dimension
location.gmtoff		Greenwich Mean Time offset for the subscriber’s location.	dimension
location.latitude		The latitude coordinate of the subscriber’s location.	dimension
location.longitude		The longitude coordinate of the subscriber’s location.	dimension
location.timezone		The timezone of the subscriber’s location.	dimension
member_rating		The subscriber’s engagement rating, from 1 to 5 stars, where 5 is the highest.	metric
merge_fields.ADDRESS		The physical address merge field for a list member.	dimension
merge_fields.COMPANY		The company merge field for a list member.	dimension
merge_fields.FNAME		The first name merge field for a list member.	dimension
merge_fields.LNAME		The last name merge field for a list member.	dimension
merge_fields.PHONE		The phone number merge field for a list member.	dimension
month		The month for which growth history data is reported.	dimension
name		The name of the campaign, list, or other Mailchimp resource.	dimension
opens.last_open	Last Open	The date and time of the most recent open recorded for a campaign.	dimension
opens.open_rate		The rate at which recipients opened a campaign.	metric
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			metric
parent_campaign_id		The unique identifier of the parent campaign for a child campaign (e.g., A/B test variations, RSS campaigns).	dimension
pending		Indicates if a subscriber’s status is pending (e.g., awaiting confirmation).	metric
preview_text	Campaign Preview Text	The text that appears in the inbox after the subject line.	dimension
recipients.list_id		The unique identifier for the list of recipients for a campaign.	dimension
recipients.list_is_active		Indicates if the recipient list for the campaign is active.	dimension
recipients.list_name		The name of the list that received the campaign.	dimension
reconfirm			metric
report_summary.click_rate	Click Rate	The overall click rate for a campaign, representing how many recipients clicked links.	metric
report_summary.clicks		The total number of clicks for a campaign.	metric
report_summary.open_rate	Open Rate	The overall open rate for a campaign, representing how many recipients opened the email.	metric
report_summary.opens		The total number of opens for a campaign.	metric
report_summary.subscriber_clicks		The number of unique subscribers who clicked a link in a campaign.	metric
report_summary.unique_opens		The number of unique opens for a campaign.	metric
rss_last_send		The date and time the last RSS campaign was sent.	dimension
send_time	Send Time	The date and time when a campaign was sent.	dimension
settings.authenticate		Indicates if Mailchimp authentication is enabled for the campaign.	dimension
settings.auto_footer		Indicates if the Mailchimp default footer is automatically included in the campaign.	dimension
settings.from_name		The ‘from’ name for the campaign, as seen by recipients.	dimension
settings.inline_css		Indicates if CSS is inlined in the campaign HTML.	dimension
settings.reply_to		The reply-to email address for the campaign.	dimension
settings.title		The title of the campaign.	dimension
settings.to_name		The ‘to’ name for the campaign, often a merge tag for the recipient’s name.	dimension
settings.use_conversation		Indicates if conversation tracking is enabled for the campaign.	dimension
share_report.share_password		The password required to access the campaign’s shareable report.	dimension
share_report.share_url		The URL for the campaign’s shareable report.	dimension
source		The source of a subscriber’s addition to a list (e.g., API, import).	dimension
start_time		The date and time a campaign started sending or an automation workflow began.	dimension
stats.avg_click_rate		The average click rate across all campaigns for a list.	metric
stats.avg_open_rate		The average open rate across all campaigns for a list.	metric
stats.avg_sub_rate	Average Subscription Rate	The average subscription rate for a list.	metric
stats.avg_unsub_rate	Average Unsubscription Rate	The average unsubscription rate for a list.	metric
stats.campaign_count		The total number of campaigns sent to a list.	metric
stats.campaign_last_sent		The date and time the last campaign was sent to a list.	dimension
stats.cleaned_count		The number of cleaned email addresses on a list.	metric
stats.cleaned_count_since_send		The number of cleaned email addresses on a list since the last campaign send.	metric
stats.click_rate		The overall click rate for a campaign or list, representing how many recipients clicked links.	metric
stats.last_sub_date		The date of the last subscription to a list.	dimension
stats.last_unsub_date		The date of the last unsubscription from a list.	dimension
stats.member_count		The total number of members in a list.	metric
stats.member_count_since_send		The number of members added to a list since the last campaign send.	metric
stats.merge_field_count		The number of merge fields configured for a list.	metric
stats.unsubscribe_count		The total number of unsubscribes for a list.	metric
stats.unsubscribe_count_since_send		The number of unsubscribes from a list since the last campaign send.	metric
status		The current status of a campaign (e.g., draft, sent, scheduled) or list member (e.g., subscribed, unsubscribed).	dimension
status_enabled	Campaign Delivery Status	Indicates if the campaign delivery status is enabled.	dimension
subject_line	Subject Line	The subject line of the campaign email.	dimension
subscribed		Indicates if a member is currently subscribed to a list.	metric
tags		A list of tags applied to a campaign or subscriber.	dimension
tags_count		The number of tags applied to a campaign or subscriber.	metric
timestamp_opt		The date and time a subscriber opted into a list.	dimension
timestamp_signup		The date and time a subscriber signed up for a list.	dimension
tracking.ecomm360		Indicates if e-commerce360 tracking is enabled for the campaign.	dimension
tracking.goal_tracking		Indicates if goal tracking is enabled for the campaign.	dimension
tracking.google_analytics		The Google Analytics tracking code for the campaign.	dimension
tracking.html_clicks		Indicates if HTML click tracking is enabled for the campaign.	dimension
tracking.opens		Indicates if open tracking is enabled for the campaign.	dimension
tracking.text_clicks		Indicates if plain-text click tracking is enabled for the campaign.	dimension
transactional			metric
trigger_settings.runtime.days		The days of the week when an automation workflow is active.	dimension
trigger_settings.runtime.hours		The specific hours when an automation workflow is active.	dimension
trigger_settings.workflow_emails_count		The total number of emails in an automation workflow.	metric
trigger_settings.workflow_title		The title of the automation workflow.	dimension
trigger_settings.workflow_type		The type of automation workflow (e.g., welcome, abandonedCart).	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		Indicates if a subscriber is marked as a VIP.	dimension