Mailchimp

The table below gives information about all the data fields that you can import from Mailchimp.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs. As a result, the fields shown here may not be the same as the fields available in Adverity. If you notice a difference between this documentation and the fields you see in Adverity, please contact your Adverity account manager for more information.

To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.

Field UI name	Field API name	Description	Use in Adverity
ADD	ADD		dimension
	Abuse Reports (abuse_reports)	Number of recipients that reported your email as spam. Subscribers that report a campaign as spam are automatically unsubscribed from your list.	metric
	Activity Action (activity.action)	Transposed type of activity	dimension
	Activity IP (activity.ip)	A string that uniquely identifies this activity.	dimension
	Activity Timestamp (activity.timestamp)	The time of the activity	dimension
	Activity Type (activity.type)	More detailed information about activity.action	dimension
	Activity URL (activity.url)	If the activity.action resulted in a click to landing page - it will be listed here	dimension
	Average Subscription Rate (stats.avg_sub_rate)	Average Subscribe Rate displays the number of people who have joined your list each month on average.	metric
	Average Unsubscription Rate (stats.avg_unsub_rate)	Average Unsubscribe Rate displays the number of people who have unsubscribed from the list each month on average.	metric
CODE	CODE		dimension
CODE URL	CODE URL		dimension
	Campaign Count (stats.campaign_count)	The number of campaigns	metric
	Campaign ID (campaign_id)	A string that uniquely identifies this campaign.	dimension
	Campaign ID (id)	A string that uniquely identifies this campaign.	dimension
	Campaign Last Sent (stats.campaign_last_sent)	The most recent instance of a sent email.	dimension
Campaign Last Sent ISO	Campaign Last Sent ISO		dimension
	Campaign Title (campaign_title)	The Title of the Campaign.	dimension
	Campaign Type (type)	The campaign type.	dimension
	Cleaned Count (stats.cleaned_count)	The count of valid email-adresses.	metric
	Cleaned Count Since Send (stats.cleaned_count_since_send)	The count of valid email-adresses.	metric
	Click Rate (clicks.click_rate)	Percentage of successfully delivered campaigns that registered a click.	metric
	Click Rate (stats.click_rate)	Average Click Rate shows an average of the click rates from every campaign you have sent to the list.	metric
Company Name	Company Name		dimension
Country	Country		dimension
	Creation Date (date_created)	Date of creation	dimension
Date	Date		dimension
Date Added	Date Added		dimension
	Date of Last List Subscribe (stats.last_sub_date)	Date of last subscription	dimension
	Date of Last List Unsubscribe (stats.last_unsub_date)	Date of last unsubscription	dimension
Direct Phone Number	Direct Phone Number		dimension
	Email Address (email_address)	The list member’s email address.	dimension
	Email ID (email_id)	A string that uniquely identifies an email adress.	dimension
	Emails Sent (emails_sent)	The number of emails sent	metric
Extension	Extension		dimension
FIX	FIX		dimension
	Facebook Likes (facebook_likes.facebook_likes)	The number of Facebook likes resulted out of your campaign.	metric
	Facebook Likes (facebook_likes.facebook_likes)	The number of facebook likes resulted out of your campaign.	metric
	Forward Opens (forwards.forwards_opens)	Number of times the campaign was opened by someone who was forwarded the campaign using a Forward to a Friend form.	metric
Full Address	Full Address		dimension
	Hard Bounces (bounces.hard_bounces)	A hard bounce indicates a permanent reason an email cannot be delivered. In most cases - bounced email addresses are removed automatically and immediately from the active subscribers and placed in the Cleaned portion of your list. Cleaned subscribers will be excluded from future campaign sends to this list. While there are many reasons an email address may hard bounce - these are some common reasons this could happen.	metric
Industry	Industry		dimension
LINK	LINK		dimension
	Last Click (clicks.last_click)	The most recent instance of a recipient clicking a tracked link in the campaign.	dimension
	Last Open (opens.last_open)	The most recent instance of a recipient opening the campaign.	dimension
	List ID (id)	A string that uniquely identifies this list.	dimension
	List ID (list_id)	A string that uniquely identifies this list.	dimension
	List Name (name)	The name of the list.	dimension
	Member Count (stats.member_count)	The number of members in this list.	metric
	Member Count Since Send (stats.member_count_since_send)	The number of members in this list since the last send.	metric
	Merge Var Count (stats.merge_field_count)	The number of members in this list.	metric
Office Phone Number	Office Phone Number		dimension
	Open Rate (opens.open_rate)	Percentage of successfully delivered campaigns that registered as an open.	metric
Product	Product		dimension
Product id	Product id		dimension
Products (SKU)	Products (SKU)		dimension
Provincia	Provincia		dimension
	Recipient Likes (facebook_likes.recipient_likes)	The number of facebook likes resulted out of your campaign.	metric
	Recipient Likes (facebook_likes.recipient_likes)	The number of facebook likes resulted out of your campaign.	metric
Region	Region		dimension
	Send Time (send_time)	The time of the send.	dimension
Sign up source	Sign up source		dimension
	Soft Bounces (bounces.soft_bounces)	While there are many reasons an email address may soft bounce - these are some common reasons this could happen.	metric
	Syntax Errors (bounces.syntax_errors)	Malformed or incomplete email addresses are treated as syntax errors and won’t be added to your list.	metric
Tags	Tags		dimension
	Target Subscription Rate (stats.target_sub_rate)	Mailbox is full (over quota).	metric
	Total Clicks (clicks.clicks_total)	Recipient email server is down or offline.	metric
	Total Forwards (forwards.forwards_count)	Email message is too large.	metric
	Total Opens (opens.opens_total)	Number of recipients that opened this campaign any number of times.	metric
Type	Type		dimension
	Unique Clicks (clicks.unique_clicks)	Percentage of recipients that registered as an open who also clicked a link in your campaign.	metric
	Unique Likes (facebook_likes.unique_likes)	The number of unique likes	metric
	Unique Likes (facebook_likes.unique_likes)	The number of unique likes	metric
	Unique Opens (opens.unique_opens)	The number of unique opens	metric
	Unique Subscriber Clicks (clicks.unique_subscriber_clicks)	The number of unique subscriptions	metric
	Unsubscribe Count (stats.unsubscribe_count)	The number of unsubscriptions	metric
	Unsubscribe Count (unsubscribed)	Number of subscribers that opted out of your list using the unsubscribe link in this campaign.	metric
	Unsubscribe Count Since Send (stats.unsubscribe_count_since_send)	Number of subscribers that opted out of your list using the unsubscribe link in this campaign - since the send out of your campaign	metric
Untitled	Untitled		dimension
Variant	Variant		dimension
Variant id	Variant id		dimension
Website	Website		dimension
AB Split A: Abuse Reports	ab_split.a.abuse_reports		dimension
AB Split A: Bounces	ab_split.a.bounces		dimension
AB Split A: Forward Opens	ab_split.a.forwards_opens		dimension
AB Split A: Last Open	ab_split.a.last_open		dimension
AB Split A: Total Opens	ab_split.a.opens		dimension
AB Split A: Recipient Clicks	ab_split.a.recipient_clicks		dimension
AB Split A: Unique Opens	ab_split.a.unique_opens		dimension
AB Split A: Unsubscribe Count	ab_split.a.unsubs		dimension
AB Split B: Abuse Reports	ab_split.b.abuse_reports		dimension
AB Split B: Bounces	ab_split.b.bounces		dimension
AB Split B: Forward Opens	ab_split.b.forwards_opens		dimension
AB Split B: Last Open	ab_split.b.last_open		dimension
AB Split B: Total Opens	ab_split.b.opens		dimension
AB Split B: Recipient Clicks	ab_split.b.recipient_clicks		dimension
AB Split B: Unique Opens	ab_split.b.unique_opens		dimension
AB Split B: Unsubscribe Count	ab_split.b.unsubs		dimension
Abuse Reports	abuse_reports		metric
Hard Bounces	bounces.hard_bounces		metric
Soft Bounces	bounces.soft_bounces		metric
Syntax Errors	bounces.syntax_errors		metric
Campaign Title	campaign_title		dimension
Cleaned	cleaned		metric
Total Clicks	clicks.clicks_total		metric
Last Click	clicks.last_click		dimension
Unique Clicks	clicks.unique_clicks		metric
Unique Subscriber Clicks	clicks.unique_subscriber_clicks		metric
Create Time	create_time		dimension
Creation Date	date_created		dimension
Deleted	deleted		metric
Delivery Status Can Cancel	delivery_status.can_cancel		dimension
Delivery Status Emails Canceled	delivery_status.emails_canceled		metric
Delivery Status Emails Sent	delivery_status.emails_sent		metric
Delivery Status Enabled	delivery_status.enabled		dimension
Delivery Status - Status	delivery_status.status		dimension
Ecommerce Currency Code	ecommerce.currency_code		dimension
Total Orders	ecommerce.total_orders		metric
Total Revenue	ecommerce.total_revenue		metric
Total Spent	ecommerce.total_spent		metric
Email Address	email_address		dimension
Email Client	email_client		dimension
Emails Sent	emails_sent		metric
Existing	existing		metric
Total Forwards	forwards.forwards_count		metric
Forward Opens	forwards.forwards_opens		metric
ID	id		dimension
Industry Status Abuse Rate	industry_stats.abuse_rate		metric
Industry Status Bounce Rate	industry_stats.bounce_rate		metric
Industry Status Click Rate	industry_stats.click_rate		metric
Industry Status Open Rate	industry_stats.open_rate		metric
Industry Type	industry_stats.type		dimension
Unopened Rate	industry_stats.unopen_rate		metric
Unsubscribe Rate	industry_stats.unsub_rate		metric
Opt-in IP	ip_opt		dimension
Signup IP	ip_signup		dimension
Language	language		dimension
Last Changed Date	last_changed		dimension
List ID	list_id		dimension
List Status	list_is_active		dimension
List Name	list_name		dimension
List Stats Click Rate	list_stats.click_rate		metric
List Stats Open Rate	list_stats.open_rate		metric
List Stats Sub Rate	list_stats.sub_rate		metric
List Stats Unsub Rate	list_stats.unsub.rate		dimension
Country Code	location.country_code		dimension
DST Offset	location.dstoff		metric
GMT Offset	location.gmtoff		metric
Latitude	location.latitude		metric
Longitude	location.longitude		metric
Timezone	location.timezone		dimension
Member Rating	member_rating		metric
Address	merge_fields.ADDRESS		dimension
Company	merge_fields.COMPANY		dimension
First Name	merge_fields.FNAME		dimension
Last Name	merge_fields.LNAME		dimension
Phone	merge_fields.PHONE		dimension
Month	month		dimension
Last Open	opens.last_open		dimension
Total Opens	opens.opens_total		metric
Unique Opens	opens.unique_opens		metric
Opt-in	optins		metric
Parent Campaign ID	parent_campaign_id		dimension
Pending	pending		metric
Preview Text	preview_text		dimension
Is Active	recipients.list_is_active		dimension
Reconfirm	reconfirm		metric
Click Rate	report_summary.click_rate		metric
Clicks	report_summary.clicks		metric
Open Rate	report_summary.open_rate		metric
Open	report_summary.opens		metric
Subscriber Clicks	report_summary.subscriber_clicks		metric
RSS Last Send	rss_last_send		dimension
Send Time	send_time		dimension
Authenticate	settings.authenticate		dimension
Auto Footer	settings.auto_footer		dimension
From Name	settings.from_name		dimension
Inline CSS	settings.inline_css		dimension
Reply To	settings.reply_to		dimension
Title	settings.title		dimension
To Name	settings.to_name		dimension
Use Conversation	settings.use_conversation		dimension
Share Report Share Password	share_report.share_password		dimension
Share Report Share URL	share_report.share_url		dimension
Subscriber Source	source		dimension
Start Time	start_time		dimension
Average Click Rate	stats.avg_click_rate		metric
Average Open Rate	stats.avg_open_rate		metric
Average Subscription Rate	stats.avg_sub_rate		metric
Average Unsubscription Rate	stats.avg_unsub_rate		metric
Campaign Count	stats.campaign_count		metric
Campaign Last Sent	stats.campaign_last_sent		dimension
Cleaned Count	stats.cleaned_count		metric
Cleaned Count Since Send	stats.cleaned_count_since_send		metric
Date of Last List Subscribe	stats.last_sub_date		dimension
Date of Last List Unsubscribe	stats.last_unsub_date		dimension
Member Count	stats.member_count		metric
Member Count Since Send	stats.member_count_since_send		metric
Merge Var Count	stats.merge_field_count		metric
Target Subscription Rate	stats.target_sub_rate		metric
Unsubscribe Count Since Send	stats.unsubscribe_count_since_send		metric
Status	status		dimension
Campaign Delivery Status	status_enabled		dimension
Subject Line	subject_line		dimension
Subscribed	subscribed		metric
Tags Audience	tags		dimension
Tags Audience Count	tags_count		metric
Opt-in Timestamp	timestamp_opt		dimension
Signup Timestamp	timestamp_signup		dimension
Clicktale	tracking.clicktale		dimension
EComm 360	tracking.ecomm360		dimension
Goal Tracking	tracking.goal_tracking		dimension
Google Analytics	tracking.google_analytics		dimension
HTML Clicks	tracking.html_clicks		dimension
Opens	tracking.opens		dimension
Text Clicks	tracking.text_clicks		dimension
Transactional	transactional		metric
Runtime Days	trigger_settings.runtime.days		dimension
Runtime Hours	trigger_settings.runtime.hours		dimension
Workflow Emails Count	trigger_settings.workflow_emails_count		metric
Workflow Title	trigger_settings.workflow_title		dimension
Workflow Type	trigger_settings.workflow_type		dimension
Campaign Type	type		dimension
Unsubscribed	unsubscribed		metric
VIP	vip		dimension