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
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
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
TypeTEXT
Data Typedimension
RSS Last Send
The date and time the last RSS campaign was sent.
Field IDcampaign/rss_last_send
TypeTEXT
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
TypeTEXT
Data Typedimension
Campaign Last Click
The date and time of the last click for the campaign.
Field IDcampaign/clicks.last_click
TypeTEXT
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
TypeTEXT
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
TypeTEXT
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
List Subscription Rate
The subscription rate for the list that the campaign was sent to.
Field IDlist_stats.sub_rate
TypeNUMBER
Data Typemetric
List Unsubscribe Rate
The unsubscribe rate for the list that the campaign was sent to.
Field IDlist_stats.unsub_rate
TypeNUMBER
Data Typemetric
List Open Rate
The open rate for the list that the campaign was sent to.
Field IDlist_stats.open_rate
TypeNUMBER
Data Typemetric
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
Delivery Status - Emails Sent
The number of emails sent for the campaign.
Field IDdelivery_status.emails_sent
TypeNUMBER
Data Typemetric
Delivery Status - 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
TypeTEXT
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
TypeTEXT
Data Typedimension
Automation Start Time
The automation start time.
Field IDautomation/start_time
TypeTEXT
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
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