Introduction

Datasources and destinations

Fields listing for Mailchimp

Campaign Id
The unique identifier for the campaign.
Field IDcampaign/id
TypeTEXT
Data Typedimension
Campaign Title
The title of the campaign.
Field IDcampaign/campaign_title
TypeTEXT
Data Typedimension
Campaign Type
The type of campaign.
Field IDcampaign/type
TypeTEXT
Data Typedimension
Industry Type
The industry type.
Field IDcampaign/industry_stats.type
TypeTEXT
Data Typedimension
Campaign List Id
The unique identifier for the list that the campaign was sent to.
Field IDcampaign/list_id
TypeTEXT
Data Typedimension
(Deprecated) Campaign List Is Active
Indicates whether the list that the campaign was sent to is currently active.
Field IDcampaign/list_is_active
TypeBOOLEAN
Data Typedimension
(Deprecated) Campaign List Name
The name of the list that the campaign was sent to.
Field IDcampaign/list_name
TypeTEXT
Data Typedimension
Campaign Subject Line
The subject line of the campaign.
Field IDcampaign/subject_line
TypeTEXT
Data Typedimension
Campaign Preview Text
The preview text of the campaign.
Field IDcampaign/preview_text
TypeTEXT
Data Typedimension
Campaign Send Time
The date and time the campaign was sent.
Field IDcampaign/send_time
TypeYEAR_MONTH_DAY
Data Typedimension
RSS Last Send
The date and time the last RSS campaign was sent.
Field IDcampaign/rss_last_send
TypeYEAR_MONTH_DAY
Data Typedimension
Share Report - Share URL
The URL for sharing the report.
Field IDcampaign/share_report.share_url
TypeTEXT
Data Typedimension
Campaign Last Open
The date and time of the last open.
Field IDcampaign/opens.last_open
TypeYEAR_MONTH_DAY
Data Typedimension
Campaign Last Click
The date and time of the last click for the campaign.
Field IDcampaign/clicks.last_click
TypeYEAR_MONTH_DAY
Data Typedimension
A - Last Open
The date and time of the last open for the A split of the campaign.
Field IDcampaign/ab_split.a.last_open
TypeYEAR_MONTH_DAY
Data Typedimension
B - Last Open
The date and time of the last open for the B split of the campaign.
Field IDcampaign/ab_split.b.last_open
TypeYEAR_MONTH_DAY
Data Typedimension
Delivery Status - Enabled
Whether delivery status is enabled for the campaign.
Field IDcampaign/delivery_status.enabled
TypeBOOLEAN
Data Typedimension
Delivery Status - Can Cancel
Whether the campaign can be canceled.
Field IDcampaign/delivery_status.can_cancel
TypeBOOLEAN
Data Typedimension
Delivery Status - Status
The delivery status for the campaign.
Field IDcampaign/delivery_status.status
TypeTEXT
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Emails Sent
The number of emails that were sent.
Field IDemails_sent
TypeNUMBER
Data Typemetric
Abuse Reports
The number of abuse reports for the campaign.
Field IDabuse_reports
TypeNUMBER
Data Typemetric
Unsubscribed
The number of subscribers who unsubscribed from the campaign.
Field IDunsubscribed
TypeNUMBER
Data Typemetric
Opens Total
The total number of times the email was opened.
Field IDopens.opens_total
TypeNUMBER
Data Typemetric
Unique Opens
The number of unique email for the campaign.
Field IDopens.unique_opens
TypeNUMBER
Data Typemetric
Open Rate
The open rate for the campaign.
Field IDopens.open_rate
TypeNUMBER
Data Typemetric
Clicks Total
The total number of clicks for the campaign.
Field IDclicks.clicks_total
TypeNUMBER
Data Typemetric
Unique Clicks
The number of unique clicks for the campaign.
Field IDclicks.unique_clicks
TypeNUMBER
Data Typemetric
Unique Subscriber Clicks
The number of unique subscriber clicks for the campaign.
Field IDclicks.unique_subscriber_clicks
TypeNUMBER
Data Typemetric
Click Rate
The click rate for the campaign.
Field IDclicks.click_rate
TypeNUMBER
Data Typemetric
Industry Open Rate
The open rate for the campaign compared to other campaigns in the industry.
Field IDindustry_stats.open_rate
TypeNUMBER
Data Typemetric
Industry Click Rate
The click rate for the campaign compared to other campaigns in the industry.
Field IDindustry_stats.click_rate
TypeNUMBER
Data Typemetric
Industry Bounce Rate
The bounce rate for the campaign compared to other campaigns in the industry.
Field IDindustry_stats.bounce_rate
TypeNUMBER
Data Typemetric
Industry Unopen Rate
The unopen rate for the campaign compared to other campaigns in the industry.
Field IDindustry_stats.unopen_rate
TypeNUMBER
Data Typemetric
Industry Unsubscribe Rate
The unsubscribe rate for the campaign compared to other campaigns in the industry.
Field IDindustry_stats.unsub_rate
TypeNUMBER
Data Typemetric
Industry Abuse Rate
The abuse rate for the campaign compared to other campaigns in the industry.
Field IDindustry_stats.abuse_rate
TypeNUMBER
Data Typemetric
Campaign List Subscription Rate
The subscription rate for the list that the campaign was sent to.
Field IDlist_stats.sub_rate
TypeNUMBER
Data Typemetric
Campaign List Unsubscribe Rate
The unsubscribe rate for the list that the campaign was sent to.
Field IDlist_stats.unsub_rate
TypeNUMBER
Data Typemetric
Campaign List Open Rate
The open rate for the list that the campaign was sent to.
Field IDlist_stats.open_rate
TypeNUMBER
Data Typemetric
Campaign List Click Rate
The click rate for the list that the campaign was sent to.
Field IDlist_stats.click_rate
TypeNUMBER
Data Typemetric
A - Bounces
The number of bounces for the A split of the campaign.
Field IDab_split.a.bounces
TypeNUMBER
Data Typemetric
A - Abuse Reports
The number of abuse reports for the A split of the campaign.
Field IDab_split.a.abuse_reports
TypeNUMBER
Data Typemetric
A - Unsubscribed
The number of subscribers who unsubscribed from the A split of the campaign.
Field IDab_split.a.unsubs
TypeNUMBER
Data Typemetric
A - Recipient Clicks
The number of clicks from recipients for the A split of the campaign.
Field IDab_split.a.recipient_clicks
TypeNUMBER
Data Typemetric
A - Forwards
The number of forwards for the A split of the campaign.
Field IDab_split.a.forwards
TypeNUMBER
Data Typemetric
A - Forwards Opens
The number of opens from forwarded emails for the A split of the campaign.
Field IDab_split.a.forwards_opens
TypeNUMBER
Data Typemetric
A - Opens
The number of opens for the A split of the campaign.
Field IDab_split.a.opens
TypeNUMBER
Data Typemetric
A - Unique Opens
The number of unique opens for the A split of thecampaign.
Field IDab_split.a.unique_opens
TypeNUMBER
Data Typemetric
B - Bounces
The number of bounces for the B split of the campaign.
Field IDab_split.b.bounces
TypeNUMBER
Data Typemetric
B - Abuse Reports
The number of abuse reports for the B split of the campaign.
Field IDab_split.b.abuse_reports
TypeNUMBER
Data Typemetric
B - Unsubscribed
The number of subscribers who unsubscribed from the B split of the campaign.
Field IDab_split.b.unsubs
TypeNUMBER
Data Typemetric
B - Recipient Clicks
The number of clicks from recipients for the B split of the campaign.
Field IDab_split.b.recipient_clicks
TypeNUMBER
Data Typemetric
B - Forwards
The number of forwards for the B split of the campaign.
Field IDab_split.b.forwards
TypeNUMBER
Data Typemetric
B - Forwards Opens
The number of opens from forwarded emails for the B split of the campaign.
Field IDab_split.b.forwards_opens
TypeNUMBER
Data Typemetric
B - Opens
The number of opens for the B split of the campaign.
Field IDab_split.b.opens
TypeNUMBER
Data Typemetric
B - Unique Opens
The number of unique opens for the B split of the campaign.
Field IDab_split.b.unique_opens
TypeNUMBER
Data Typemetric
E-commerce - Total Orders
The total number of orders for the campaign.
Field IDecommerce.total_orders
TypeNUMBER
Data Typemetric
E-commerce - Total Spent
The total amount spent for the campaign.
Field IDecommerce.total_spent
TypeNUMBER
Data Typemetric
E-commerce - Total Revenue
The total revenue for the campaign.
Field IDecommerce.total_revenue
TypeNUMBER
Data Typemetric
E-commerce - Currency Code
The currency code used for the campaign.
Field IDecommerce.currency_code
TypeTEXT
Data Typemetric
Emails Delivered
The number of emails delivered for the campaign.
Field IDdelivery_status.emails_sent
TypeNUMBER
Data Typemetric
Emails Canceled
The number of emails canceled for the campaign.
Field IDdelivery_status.emails_canceled
TypeNUMBER
Data Typemetric
Email ID
The email id.
Field IDcampaign_recipient/email_id
TypeTEXT
Data Typedimension
Email Address
The email address.
Field IDcampaign_recipient/email_address
TypeTEXT
Data Typedimension
Status
The status of the email sent to the member ('sent', 'hard' for hard bounce, or 'soft' for soft bounce).
Field IDcampaign_recipient/status
TypeTEXT
Data Typedimension
Email Last Open
The date and time of the last open for this member.
Field IDcampaign_recipient/last_open
TypeYEAR_MONTH_DAY
Data Typedimension
ABSplit Group
For A/B Split Campaigns, the group the member was apart of ('a', 'b', or 'winner')
Field IDcampaign_recipient/absplit_group
TypeTEXT
Data Typedimension
Automation Id
The unique identifier for the automation.
Field IDautomation/id
TypeTEXT
Data Typedimension
Automation Status
The automation status.
Field IDautomation/status
TypeTEXT
Data Typedimension
Automation Created Time
The automation created time.
Field IDautomation/create_time
TypeYEAR_MONTH_DAY
Data Typedimension
Automation Start Time
The automation start time.
Field IDautomation/start_time
TypeYEAR_MONTH_DAY
Data Typedimension
Automation List Id
The automation list ID.
Field IDautomation/recipients.list_id
TypeTEXT
Data Typedimension
Automation List Is Active
The automation List is Active.
Field IDautomation/recipients.list_is_active
TypeBOOLEAN
Data Typedimension
Automation List Name
The automation List Name.
Field IDautomation/recipients.list_name
TypeTEXT
Data Typedimension
Automation Store ID
The automation store id.
Field IDautomation/recipients.store_id
TypeTEXT
Data Typedimension
Automation title
The automation title.
Field IDautomation/settings.title
TypeTEXT
Data Typedimension
Automation From Name
The automation title.
Field IDautomation/settings.from_name
TypeTEXT
Data Typedimension
Automation Reply To
The automation reply to.
Field IDautomation/settings.reply_to
TypeTEXT
Data Typedimension
Automation Use Conversation
The automation use conversation.
Field IDautomation/settings.use_conversation
TypeBOOLEAN
Data Typedimension
Automation To Name
The automation to name.
Field IDautomation/settings.to_name
TypeTEXT
Data Typedimension
Automation Authenticate
The automation authenticate
Field IDautomation/settings.authenticate
TypeBOOLEAN
Data Typedimension
Automation Auto footer
The automation auto footer settings
Field IDautomation/settings.auto_footer
TypeBOOLEAN
Data Typedimension
Automation Inline css
The automation inline css settings
Field IDautomation/settings.inline_css
TypeBOOLEAN
Data Typedimension
Automation Tracking Opens
The automation tracking open settings
Field IDautomation/tracking.tracking_opens
TypeBOOLEAN
Data Typedimension
Automation HTML clicks tracking
The automation tracking html clicks
Field IDautomation/tracking.html_clicks
TypeBOOLEAN
Data Typedimension
Automation TEXT clicks tracking
The automation tracking text clicks
Field IDautomation/tracking.text_clicks
TypeBOOLEAN
Data Typedimension
Automation GOAL clicks tracking
The automation tracking goal clicks
Field IDautomation/tracking.goal_tracking
TypeBOOLEAN
Data Typedimension
Automation ECOM360 tracking
The automation ECOM360 tracking
Field IDautomation/tracking.ecomm360
TypeBOOLEAN
Data Typedimension
Automation Google Analytics tracking
The automation Google Analytics tracking
Field IDautomation/tracking.google_analytics
TypeTEXT
Data Typedimension
Automation Clicktale tracking
The automation Clicktale tracking
Field IDautomation/tracking.clicktale
TypeTEXT
Data Typedimension
Automation Workflow type
The automation Workflow type
Field IDautomation/trigger_settings.workflow_type
TypeTEXT
Data Typedimension
Automation Workflow Title
The automation Workflow Title
Field IDautomation/trigger_settings.workflow_title
TypeTEXT
Data Typedimension
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
TypeWEEK
Data Typedimension
Link ID
The Link ID.
Field IDlink/id
TypeTEXT
Data Typedimension
Link URL
The url link.
Field IDlink/url
TypeTEXT
Data Typedimension
Total Link Click
The number of the click on the link.
Field IDtotal_clicks
TypeNUMBER
Data Typemetric
Link Click Percentage
The number of the link click percentage.
Field IDclick_percentage
TypeNUMBER
Data Typemetric
Unique Link Click
The number of unique link click.
Field IDunique_clicks
TypeNUMBER
Data Typemetric
Unique Link Click Percentage
The number of unique link click percentage.
Field IDunique_click_percentage
TypeNUMBER
Data Typemetric
The date of the last click
Date of the last click on the link
Field IDlast_click
TypeTEXT
Data Typemetric
AB Split - A - Total Link Click
The number of the click on the link.
Field IDab_split.a.total_clicks_a
TypeNUMBER
Data Typemetric
AB Split - A - Link Click Percentage
The number of the link click percentage.
Field IDab_split.a.click_percentage_a
TypeNUMBER
Data Typemetric
AB Split - A - Unique Link Click
The number of unique link click.
Field IDab_split.a.unique_clicks_a
TypeNUMBER
Data Typemetric
AB Split - A - Unique Link Click Percentage
The number of unique link click percentage.
Field IDab_split.a.unique_click_percentage_a
TypeNUMBER
Data Typemetric
AB Split - B - Total Link Click
The number of the click on the link.
Field IDab_split.b.total_clicks_b
TypeNUMBER
Data Typemetric
AB Split - B - Link Click Percentage
The number of the link click percentage.
Field IDab_split.b.click_percentage_b
TypeNUMBER
Data Typemetric
AB Split - B - Unique Link Click
The number of unique link click.
Field IDab_split.b.unique_clicks_b
TypeNUMBER
Data Typemetric
AB Split - B - Unique Link Click Percentage
The number of unique link click percentage.
Field IDab_split.b.unique_click_percentage_b
TypeNUMBER
Data Typemetric
List ID
A string that uniquely identifies this list.
Field IDlist_data/id
TypeTEXT
Data Typedimension
List Web ID
The ID used in the Mailchimp web application. View this list in your Mailchimp account at https://{dc}.admin.mailchimp.com/lists/members/?id={web_id}.
Field IDlist_data/web_id
TypeNUMBER
Data Typedimension
List Name
The name of the list.
Field IDlist_data/name
TypeTEXT
Data Typedimension
List Permission Reminder
The permission reminder for the list.
Field IDlist_data/permission_reminder
TypeTEXT
Data Typedimension
List Use Archive Bar
Whether campaigns for this list use the Archive Bar in archives by default.
Field IDlist_data/use_archive_bar
TypeBOOLEAN
Data Typedimension
List Notify On Subscribe
The email address to send subscribe notifications to.
Field IDlist_data/notify_on_subscribe
TypeTEXT
Data Typedimension
List Notify On Unsubscribe
The email address to send unsubscribe notifications to.
Field IDlist_data/notify_on_unsubscribe
TypeTEXT
Data Typedimension
List Date Created
The date and time that this list was created in ISO 8601 format.
Field IDlist_data/date_created
TypeYEAR_MONTH_DAY
Data Typedimension
List Rating
An auto-generated activity score for the list (0-5).
Field IDlist_data/list_rating
TypeNUMBER
Data Typedimension
List Email Type Option
Whether the list supports multiple formats for emails. When set to true, subscribers can choose whether they want to receive HTML or plain-text emails. When set to false, subscribers will receive HTML emails, with a plain-text alternative backup.
Field IDlist_data/email_type_option
TypeBOOLEAN
Data Typedimension
List Subscribe Url Short
Our url shortened version of this list's subscribe form.
Field IDlist_data/subscribe_url_short
TypeTEXT
Data Typedimension
List Subscribe Url long
The full version of this list's subscribe form (host will vary).
Field IDlist_data/subscribe_url_long
TypeTEXT
Data Typedimension
List Beamer Address
The list's Email Beamer address.
Field IDlist_data/beamer_address
TypeTEXT
Data Typedimension
List Visibility
Legacy - visibility settings are no longer used Possible values: "pub" or "prv".
Field IDlist_data/visibility
TypeTEXT
Data Typedimension
List Double Optin
Whether or not to require the subscriber to confirm subscription via email.
Field IDlist_data/double_optin
TypeBOOLEAN
Data Typedimension
List Has Welcome
Whether or not this list has a welcome automation connected. Welcome Automations: welcomeSeries, singleWelcome, emailFollowup.
Field IDlist_data/has_welcome
TypeBOOLEAN
Data Typedimension
List Marketing Permissions
Whether or not the list has marketing permissions (eg. GDPR) enabled.
Field IDlist_data/marketing_permissions
TypeBOOLEAN
Data Typedimension
List Last Sub Date
The date and time of the last time someone subscribed to this list in ISO 8601 format.
Field IDlist_data/stats.last_sub_date
TypeYEAR_MONTH_DAY
Data Typedimension
List Last Unsub Date
The date and time of the last time someone unsubscribed from this list in ISO 8601 format.
Field IDlist_data/stats.last_unsub_date
TypeYEAR_MONTH_DAY
Data Typedimension
Member ID
The MD5 hash of the lowercase version of the list member's email address.
Field IDmember/id
TypeTEXT
Data Typedimension
Member Email Address
Email address for a subscriber.
Field IDmember/email_address
TypeTEXT
Data Typedimension
Member Unique Email ID
An identifier for the address across all of Mailchimp.
Field IDmember/unique_email_id
TypeTEXT
Data Typedimension
Member Full Name
The contact's full name.
Field IDmember/full_name
TypeTEXT
Data Typedimension
Member Web ID
The ID used in the Mailchimp web application. View this member in your Mailchimp account at https://{dc}.admin.mailchimp.com/lists/members/view?id={web_id}.
Field IDmember/web_id
TypeNUMBER
Data Typedimension
Member Email Type
Type of email this member asked to get ('html' or 'text').
Field IDmember/email_type
TypeTEXT
Data Typedimension
Member Status
Subscriber's current status. Possible values: "subscribed", "unsubscribed", "cleaned", "pending", "transactional", or "archived".
Field IDmember/status
TypeTEXT
Data Typedimension
Member Unsibscribe Reason
Indicates whether a contact consents to 1:1 messaging.
Field IDmember/unsubscribe_reason
TypeTEXT
Data Typedimension
Member Contents To One To one Messaging
IP address the subscriber signed up from.
Field IDmember/consents_to_one_to_one_messaging
TypeBOOLEAN
Data Typedimension
Member IP Signup
IP address the subscriber signed up from.
Field IDmember/ip_signup
TypeTEXT
Data Typedimension
Member Timestamp Signup
The date and time the subscriber signed up for the list in ISO 8601 format.
Field IDmember/timestamp_signup
TypeYEAR_MONTH_DAY
Data Typedimension
Member IP Opt
The IP address the subscriber used to confirm their opt-in status.
Field IDmember/ip_opt
TypeTEXT
Data Typedimension
Member Timestamp Opt
The date and time the subscriber confirmed their opt-in status in ISO 8601 format.
Field IDmember/timestamp_opt
TypeYEAR_MONTH_DAY
Data Typedimension
Member Rating
Star rating for this member, between 1 and 5.
Field IDmember/member_rating
TypeNUMBER
Data Typedimension
Member Last Changed
The date and time the member's info was last changed in ISO 8601 format.
Field IDmember/last_changed
TypeYEAR_MONTH_DAY
Data Typedimension
Member Language
If set/detected, the subscriber's language.
Field IDmember/language
TypeTEXT
Data Typedimension
Member VIP
VIP status for subscriber.
Field IDmember/vip
TypeBOOLEAN
Data Typedimension
Member Email Client
The list member's email client.
Field IDmember/email_client
TypeTEXT
Data Typedimension
Member Source
The source from which the subscriber was added to this list.
Field IDmember/source
TypeTEXT
Data Typedimension
Member Tags Count
The number of tags applied to this member.
Field IDmember/tags_count
TypeNUMBER
Data Typedimension
Member Ecommerce Currency Code
The three-letter ISO 4217 code for the currency that the store accepts.
Field IDmember/stats.ecommerce_data.currency_code
TypeTEXT
Data Typedimension
List Member Count
The number of active members in the list.
Field IDstats.member_count
TypeNUMBER
Data Typemetric
List Total Contacts
The number of contacts in the list, including subscribed, unsubscribed, pending, cleaned, deleted, transactional, and those that need to be reconfirmed. Requires include_total_contacts query parameter to be included.
Field IDstats.total_contacts
TypeNUMBER
Data Typemetric
List Unsubscribe Count
The number of members who have unsubscribed from the list.
Field IDstats.unsubscribe_count
TypeNUMBER
Data Typemetric
List Clean Count
The number of members cleaned from the list.
Field IDstats.cleaned_count
TypeNUMBER
Data Typemetric
List Member Count Since Send
The number of active members in the list since the last campaign was sent.
Field IDstats.member_count_since_send
TypeNUMBER
Data Typemetric
List Unsubscribe Count Since Send
The number of members who have unsubscribed since the last campaign was sent.
Field IDstats.unsubscribe_count_since_send
TypeNUMBER
Data Typemetric
List Clean Count Since Send
The number of members cleaned from the list since the last campaign was sent.
Field IDstats.cleaned_count_since_send
TypeNUMBER
Data Typemetric
List Campaign Count
The number of campaigns in any status that use this list.
Field IDstats.campaign_count
TypeNUMBER
Data Typemetric
List Merge Field Count
The number of merge fields (audience field) for this list (doesn't include EMAIL).
Field IDstats.merge_field_count
TypeNUMBER
Data Typemetric
List Average Sub Rate
The average number of subscriptions per month for the list (not returned if we haven't calculated it yet).
Field IDstats.avg_sub_rate
TypeNUMBER
Data Typemetric
List Average Unsub Rate
The average number of unsubscriptions per month for the list (not returned if we haven't calculated it yet).
Field IDstats.avg_unsub_rate
TypeNUMBER
Data Typemetric
List Target Sub Rate
The target number of subscriptions per month for the list to keep it growing (not returned if we haven't calculated it yet).
Field IDstats.target_sub_rate
TypeNUMBER
Data Typemetric
List Open Rate
The average open rate (a percentage represented as a number between 0 and 100) per campaign for the list (not returned if we haven't calculated it yet).
Field IDstats.open_rate
TypeNUMBER
Data Typemetric
List Click Rate
The average click rate (a percentage represented as a number between 0 and 100) per campaign for the list (not returned if we haven't calculated it yet).
Field IDstats.click_rate
TypeNUMBER
Data Typemetric
Member Average Open Rate
A subscriber's average open rate.
Field IDstats.avg_open_rate
TypeNUMBER
Data Typemetric
Member Average Click Rate
A subscriber's average clickthrough rate.
Field IDstats.avg_click_rate
TypeNUMBER
Data Typemetric
Member Total Revenue
The total revenue the list member has brought in.
Field IDstats.ecommerce_data.total_revenue
TypeNUMBER
Data Typemetric
Member Number Of Orders
The total number of orders placed by the list member.
Field IDstats.ecommerce_data.number_of_orders
TypeNUMBER
Data Typemetric
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension