Mailchimp

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

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

Data Type

Description

Use in Adverity

Docs

Abuse Reports (abuse_reports)

long

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)

string

Transposed type of activity

dimension

Activity IP (activity.ip)

string

A string that uniquely identifies this activity.

dimension

Activity Timestamp (activity.timestamp)

datetime

The time of the activity

dimension

Activity Type (activity.type)

string

More detailed information about activity.action

dimension

Activity URL (activity.url)

string

If the activity.action resulted in a click to landing page - it will be listed here

dimension

Average Subscription Rate (stats.avg_sub_rate)

percentage

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)

percentage

Average Unsubscribe Rate displays the number of people who have unsubscribed from the list each month on average.

metric

Campaign Count (stats.campaign_count)

long

The number of campaigns

metric

Campaign ID (campaign_id)

string

A string that uniquely identifies this campaign.

dimension

Campaign ID (id)

string

A string that uniquely identifies this campaign.

dimension

Campaign Last Sent (stats.campaign_last_sent)

string

The most recent instance of a sent email.

dimension

Campaign Title (campaign_title)

string

The Title of the Campaign.

dimension

Campaign Type (type)

string

The campaign type.

dimension

Cleaned Count (stats.cleaned_count)

long

The count of valid email-adresses.

metric

Cleaned Count Since Send (stats.cleaned_count_since_send)

long

The count of valid email-adresses.

metric

Click Rate (clicks.click_rate)

percentage

Percentage of successfully delivered campaigns that registered a click.

metric

Click Rate (stats.click_rate)

percentage

Average Click Rate shows an average of the click rates from every campaign you have sent to the list.

metric

Creation Date (date_created)

string

Date of creation

dimension

Date of Last List Subscribe (stats.last_sub_date)

string

Date of last subscription

dimension

Date of Last List Unsubscribe (stats.last_unsub_date)

date

Date of last unsubscription

dimension

Email Address (email_address)

string

The list member’s email address.

dimension

Email ID (email_id)

string

A string that uniquely identifies an email adress.

dimension

Emails Sent (emails_sent)

long

The number of emails sent

metric

Facebook Likes (facebook_likes.facebook_likes)

long

The number of facebook likes resulted out of your campaign.

metric

Forward Opens (forwards.forwards_opens)

long

Number of times the campaign was opened by someone who was forwarded the campaign using a Forward to a Friend form.

metric

Hard Bounces (bounces.hard_bounces)

long

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

Last Click (clicks.last_click)

date

The most recent instance of a recipient clicking a tracked link in the campaign.

dimension

Last Open (opens.last_open)

date

The most recent instance of a recipient opening the campaign.

dimension

List ID (id)

string

A string that uniquely identifies this list.

dimension

List ID (list_id)

string

A string that uniquely identifies this list.

dimension

List Name (name)

string

The name of the list.

dimension

Member Count (stats.member_count)

long

The number of members in this list.

metric

Member Count Since Send (stats.member_count_since_send)

long

The number of members in this list since the last send.

metric

Merge Var Count (stats.merge_field_count)

long

The number of members in this list.

metric

Open Rate (opens.open_rate)

percentage

Percentage of successfully delivered campaigns that registered as an open.

metric

Recipient Likes (facebook_likes.recipient_likes)

long

The number of facebook likes resulted out of your campaign.

metric

Send Time (send_time)

datetime

The time of the send.

dimension

Soft Bounces (bounces.soft_bounces)

long

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)

long

Malformed or incomplete email addresses are treated as syntax errors and won't be added to your list.

metric

Target Subscription Rate (stats.target_sub_rate)

long

Mailbox is full (over quota).

metric

Total Clicks (clicks.clicks_total)

long

Recipient email server is down or offline.

metric

Total Forwards (forwards.forwards_count)

long

Email message is too large.

metric

Total Opens (opens.opens_total)

long

Number of recipients that opened this campaign any number of times.

metric

Unique Clicks (clicks.unique_clicks)

long

Percentage of recipients that registered as an open who also clicked a link in your campaign.

metric

Unique Likes (facebook_likes.unique_likes)

long

The number of unique likes

metric

Unique Opens (opens.unique_opens)

long

The number of unique opens

metric

Unique Subscriber Clicks (clicks.unique_subscriber_clicks)

long

The number of unique subscriptions

metric

Unsubscribe Count (stats.unsubscribe_count)

long

The number of unsubscriptions

metric

Unsubscribe Count (unsubscribed)

long

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)

long

Number of subscribers that opted out of your list using the unsubscribe link in this campaign - since the send out of your campaign

metric