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 |
Use in Adverity |
|---|---|---|
Date |
Date |
dimension |
ab_split.a.abuse_reports |
AB Split A: Abuse Reports |
dimension |
ab_split.a.bounces |
AB Split A: Bounces |
dimension |
ab_split.a.forwards_opens |
AB Split A: Forward Opens |
dimension |
ab_split.a.last_open |
AB Split A: Last Open |
dimension |
ab_split.a.opens |
AB Split A: Total 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.unsubs |
AB Split A: Unsubscribe Count |
dimension |
ab_split.b.abuse_reports |
AB Split B: Abuse Reports |
dimension |
ab_split.b.bounces |
AB Split B: Bounces |
dimension |
ab_split.b.forwards_opens |
AB Split B: Forward Opens |
dimension |
ab_split.b.last_open |
AB Split B: Last Open |
dimension |
ab_split.b.opens |
AB Split B: Total 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.unsubs |
AB Split B: Unsubscribe Count |
dimension |
abuse_reports |
Abuse Reports |
metric |
activity.action |
Activity Action |
dimension |
activity.ip |
Activity IP |
dimension |
activity.timestamp |
Activity Timestamp |
dimension |
activity.type |
Activity Type |
dimension |
activity.url |
Activity URL |
dimension |
bounces.hard_bounces |
Hard Bounces |
metric |
bounces.soft_bounces |
Soft Bounces |
metric |
bounces.syntax_errors |
Syntax Errors |
metric |
campaign_title |
Campaign Title |
dimension |
cleaned |
Cleaned |
metric |
clicks.clicks_total |
Total Clicks |
metric |
clicks.last_click |
Last Click |
dimension |
clicks.unique_clicks |
Unique Clicks |
metric |
clicks.unique_subscriber_clicks |
Unique Subscriber Clicks |
metric |
create_time |
Create Time |
dimension |
date |
date |
dimension |
date_created |
Creation Date |
dimension |
date_scheduled |
date_scheduled |
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 |
ecommerce.total_orders |
Total Orders |
metric |
ecommerce.total_revenue |
Total Revenue |
metric |
ecommerce.total_spent |
Total Spent |
metric |
email_address |
Email Address |
dimension |
email_client |
Email Client |
dimension |
email_id |
Email ID |
dimension |
emails_sent |
Emails Sent |
metric |
facebook_likes.facebook_likes |
Facebook Likes |
metric |
facebook_likes.recipient_likes |
Recipient Likes |
metric |
facebook_likes.unique_likes |
Unique Likes |
metric |
forwards.forwards_count |
Total Forwards |
metric |
forwards.forwards_opens |
Forward Opens |
metric |
id |
Campaign ID |
dimension |
industry_stats.abuse_rate |
Industry Status Abuse Rate |
metric |
industry_stats.bounce_rate |
Industry Status Bounce Rate |
metric |
industry_stats.click_rate |
Industry Status Click Rate |
metric |
industry_stats.open_rate |
Industry Status Open Rate |
metric |
industry_stats.type |
Industry Type |
dimension |
industry_stats.unopen_rate |
Unopened Rate |
metric |
industry_stats.unsub_rate |
Unsubscribe Rate |
metric |
ip_opt |
Opt-in IP |
dimension |
ip_signup |
Signup IP |
dimension |
language |
Language |
dimension |
last_changed |
Last Changed Date |
dimension |
list_id |
List ID |
dimension |
list_is_active |
List Status |
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 |
location.country_code |
Country Code |
dimension |
location.dstoff |
DST Offset |
metric |
location.gmtoff |
GMT Offset |
metric |
location.latitude |
Latitude |
metric |
location.longitude |
Longitude |
metric |
location.timezone |
Timezone |
dimension |
member_rating |
Member Rating |
metric |
merge_fields.ADDRESS |
Address |
dimension |
merge_fields.COMPANY |
Company |
dimension |
merge_fields.FNAME |
First Name |
dimension |
merge_fields.LNAME |
Last Name |
dimension |
merge_fields.PHONE |
Phone |
dimension |
month |
Month |
dimension |
opens.last_open |
Last Open |
dimension |
opens.opens_total |
Total Opens |
metric |
opens.unique_opens |
Unique Opens |
metric |
optins |
Opt-in |
metric |
parent_campaign_id |
Parent Campaign ID |
dimension |
pending |
Pending |
metric |
preview_text |
Preview Text |
dimension |
recipients.list_is_active |
Is Active |
dimension |
reconfirm |
Reconfirm |
metric |
report_summary.click_rate |
Click Rate |
metric |
report_summary.clicks |
Clicks |
metric |
report_summary.open_rate |
Open Rate |
metric |
report_summary.opens |
Open |
metric |
report_summary.subscriber_clicks |
Subscriber Clicks |
metric |
rss_last_send |
RSS Last Send |
dimension |
send_time |
Send Time |
dimension |
settings.authenticate |
Authenticate |
dimension |
settings.auto_footer |
Auto Footer |
dimension |
settings.from_name |
From Name |
dimension |
settings.inline_css |
Inline CSS |
dimension |
settings.reply_to |
Reply To |
dimension |
settings.title |
Title |
dimension |
settings.to_name |
To Name |
dimension |
settings.use_conversation |
Use Conversation |
dimension |
share_report.share_password |
Share Report Share Password |
dimension |
share_report.share_url |
Share Report Share URL |
dimension |
source |
Subscriber Source |
dimension |
start_time |
Start Time |
dimension |
stats.avg_click_rate |
Average Click Rate |
metric |
stats.avg_open_rate |
Average Open Rate |
metric |
stats.avg_sub_rate |
Average Subscription Rate |
metric |
stats.avg_unsub_rate |
Average Unsubscription Rate |
metric |
stats.campaign_count |
Campaign Count |
metric |
stats.campaign_last_sent |
Campaign Last Sent |
dimension |
stats.cleaned_count |
Cleaned Count |
metric |
stats.cleaned_count_since_send |
Cleaned Count Since Send |
metric |
stats.last_sub_date |
Date of Last List Subscribe |
dimension |
stats.last_unsub_date |
Date of Last List Unsubscribe |
dimension |
stats.member_count |
Member Count |
metric |
stats.member_count_since_send |
Member Count Since Send |
metric |
stats.merge_field_count |
Merge Var Count |
metric |
stats.unsubscribe_count_since_send |
Unsubscribe Count Since Send |
metric |
status |
Status |
dimension |
status_enabled |
Campaign Delivery Status |
dimension |
subject_line |
Campaign Subject Line |
dimension |
subscribed |
Subscribed |
metric |
tags |
Tags Audience |
dimension |
tags_count |
Tags Audience Count |
metric |
timestamp_opt |
Opt-in Timestamp |
dimension |
timestamp_signup |
Signup Timestamp |
dimension |
tracking.ecomm360 |
EComm 360 |
dimension |
tracking.goal_tracking |
Goal Tracking |
dimension |
tracking.google_analytics |
Google Analytics |
dimension |
tracking.html_clicks |
HTML Clicks |
dimension |
tracking.opens |
Opens |
dimension |
tracking.text_clicks |
Text Clicks |
dimension |
transactional |
Transactional |
metric |
trigger_settings.runtime.days |
Runtime Days |
dimension |
trigger_settings.runtime.hours |
Runtime Hours |
dimension |
trigger_settings.workflow_emails_count |
Workflow Emails Count |
metric |
trigger_settings.workflow_title |
Workflow Title |
dimension |
trigger_settings.workflow_type |
Workflow Type |
dimension |
type |
Campaign Type |
dimension |
unsubscribed |
Unsubscribe Count |
metric |
vip |
VIP |
dimension |