Campaign Id The unique identifier for the campaign. |
| ||||||
Campaign Title The title of the campaign. |
| ||||||
Campaign Type The type of campaign. |
| ||||||
Industry Type The industry type. |
| ||||||
Campaign List Id The unique identifier for the list that the campaign was sent to. |
| ||||||
(Deprecated) Campaign List Is Active Indicates whether the list that the campaign was sent to is currently active. |
| ||||||
(Deprecated) Campaign List Name The name of the list that the campaign was sent to. |
| ||||||
Campaign Subject Line The subject line of the campaign. |
| ||||||
Campaign Preview Text The preview text of the campaign. |
| ||||||
Campaign Send Time The date and time the campaign was sent. |
| ||||||
RSS Last Send The date and time the last RSS campaign was sent. |
| ||||||
Share Report - Share URL The URL for sharing the report. |
| ||||||
Campaign Last Open The date and time of the last open. |
| ||||||
Campaign Last Click The date and time of the last click for the campaign. |
| ||||||
A - Last Open The date and time of the last open for the A split of the campaign. |
| ||||||
B - Last Open The date and time of the last open for the B split of the campaign. |
| ||||||
Delivery Status - Enabled Whether delivery status is enabled for the campaign. |
| ||||||
Delivery Status - Can Cancel Whether the campaign can be canceled. |
| ||||||
Delivery Status - Status The delivery status for the campaign. |
| ||||||
Year Year such as 2017. |
| ||||||
Year Quarter Year and quarter. |
| ||||||
Year month Year and month. |
| ||||||
Year week Year and week. |
| ||||||
Date Year, month, and day. |
| ||||||
Year month day hour Year, month, day, and hour. |
| ||||||
Quarter of the year Quarter of the year |
| ||||||
Month of the year Month of the year |
| ||||||
Week of the year Week of the year |
| ||||||
Month and day Month and day |
| ||||||
Day of the week Week of the year |
| ||||||
Day of the month Day of the year |
| ||||||
Hour of the day Hour of the day |
| ||||||
Emails Sent The number of emails that were sent. |
| ||||||
Abuse Reports The number of abuse reports for the campaign. |
| ||||||
Unsubscribed The number of subscribers who unsubscribed from the campaign. |
| ||||||
Opens Total The total number of times the email was opened. |
| ||||||
Unique Opens The number of unique email for the campaign. |
| ||||||
Open Rate The open rate for the campaign. |
| ||||||
Clicks Total The total number of clicks for the campaign. |
| ||||||
Unique Clicks The number of unique clicks for the campaign. |
| ||||||
Unique Subscriber Clicks The number of unique subscriber clicks for the campaign. |
| ||||||
Click Rate The click rate for the campaign. |
| ||||||
Industry Open Rate The open rate for the campaign compared to other campaigns in the industry. |
| ||||||
Industry Click Rate The click rate for the campaign compared to other campaigns in the industry. |
| ||||||
Industry Bounce Rate The bounce rate for the campaign compared to other campaigns in the industry. |
| ||||||
Industry Unopen Rate The unopen rate for the campaign compared to other campaigns in the industry. |
| ||||||
Industry Unsubscribe Rate The unsubscribe rate for the campaign compared to other campaigns in the industry. |
| ||||||
Industry Abuse Rate The abuse rate for the campaign compared to other campaigns in the industry. |
| ||||||
Campaign List Subscription Rate The subscription rate for the list that the campaign was sent to. |
| ||||||
Campaign List Unsubscribe Rate The unsubscribe rate for the list that the campaign was sent to. |
| ||||||
Campaign List Open Rate The open rate for the list that the campaign was sent to. |
| ||||||
Campaign List Click Rate The click rate for the list that the campaign was sent to. |
| ||||||
A - Bounces The number of bounces for the A split of the campaign. |
| ||||||
A - Abuse Reports The number of abuse reports for the A split of the campaign. |
| ||||||
A - Unsubscribed The number of subscribers who unsubscribed from the A split of the campaign. |
| ||||||
A - Recipient Clicks The number of clicks from recipients for the A split of the campaign. |
| ||||||
A - Forwards The number of forwards for the A split of the campaign. |
| ||||||
A - Forwards Opens The number of opens from forwarded emails for the A split of the campaign. |
| ||||||
A - Opens The number of opens for the A split of the campaign. |
| ||||||
A - Unique Opens The number of unique opens for the A split of thecampaign. |
| ||||||
B - Bounces The number of bounces for the B split of the campaign. |
| ||||||
B - Abuse Reports The number of abuse reports for the B split of the campaign. |
| ||||||
B - Unsubscribed The number of subscribers who unsubscribed from the B split of the campaign. |
| ||||||
B - Recipient Clicks The number of clicks from recipients for the B split of the campaign. |
| ||||||
B - Forwards The number of forwards for the B split of the campaign. |
| ||||||
B - Forwards Opens The number of opens from forwarded emails for the B split of the campaign. |
| ||||||
B - Opens The number of opens for the B split of the campaign. |
| ||||||
B - Unique Opens The number of unique opens for the B split of the campaign. |
| ||||||
E-commerce - Total Orders The total number of orders for the campaign. |
| ||||||
E-commerce - Total Spent The total amount spent for the campaign. |
| ||||||
E-commerce - Total Revenue The total revenue for the campaign. |
| ||||||
E-commerce - Currency Code The currency code used for the campaign. |
| ||||||
Emails Delivered The number of emails delivered for the campaign. |
| ||||||
Emails Canceled The number of emails canceled for the campaign. |
| ||||||
Email ID The email id. |
| ||||||
Email Address The email address. |
| ||||||
Status The status of the email sent to the member ('sent', 'hard' for hard bounce, or 'soft' for soft bounce). |
| ||||||
Email Last Open The date and time of the last open for this member. |
| ||||||
ABSplit Group For A/B Split Campaigns, the group the member was apart of ('a', 'b', or 'winner') |
| ||||||
Automation Id The unique identifier for the automation. |
| ||||||
Automation Status The automation status. |
| ||||||
Automation Created Time The automation created time. |
| ||||||
Automation Start Time The automation start time. |
| ||||||
Automation List Id The automation list ID. |
| ||||||
Automation List Is Active The automation List is Active. |
| ||||||
Automation List Name The automation List Name. |
| ||||||
Automation Store ID The automation store id. |
| ||||||
Automation title The automation title. |
| ||||||
Automation From Name The automation title. |
| ||||||
Automation Reply To The automation reply to. |
| ||||||
Automation Use Conversation The automation use conversation. |
| ||||||
Automation To Name The automation to name. |
| ||||||
Automation Authenticate The automation authenticate |
| ||||||
Automation Auto footer The automation auto footer settings |
| ||||||
Automation Inline css The automation inline css settings |
| ||||||
Automation Tracking Opens The automation tracking open settings |
| ||||||
Automation HTML clicks tracking The automation tracking html clicks |
| ||||||
Automation TEXT clicks tracking The automation tracking text clicks |
| ||||||
Automation GOAL clicks tracking The automation tracking goal clicks |
| ||||||
Automation ECOM360 tracking The automation ECOM360 tracking |
| ||||||
Automation Google Analytics tracking The automation Google Analytics tracking |
| ||||||
Automation Clicktale tracking The automation Clicktale tracking |
| ||||||
Automation Workflow type The automation Workflow type |
| ||||||
Automation Workflow Title The automation Workflow Title |
| ||||||
Week of the year (start Sunday) Week of the year |
| ||||||
Link ID The Link ID. |
| ||||||
Link URL The url link. |
| ||||||
Total Link Click The number of the click on the link. |
| ||||||
Link Click Percentage The number of the link click percentage. |
| ||||||
Unique Link Click The number of unique link click. |
| ||||||
Unique Link Click Percentage The number of unique link click percentage. |
| ||||||
The date of the last click Date of the last click on the link |
| ||||||
AB Split - A - Total Link Click The number of the click on the link. |
| ||||||
AB Split - A - Link Click Percentage The number of the link click percentage. |
| ||||||
AB Split - A - Unique Link Click The number of unique link click. |
| ||||||
AB Split - A - Unique Link Click Percentage The number of unique link click percentage. |
| ||||||
AB Split - B - Total Link Click The number of the click on the link. |
| ||||||
AB Split - B - Link Click Percentage The number of the link click percentage. |
| ||||||
AB Split - B - Unique Link Click The number of unique link click. |
| ||||||
AB Split - B - Unique Link Click Percentage The number of unique link click percentage. |
| ||||||
List ID A string that uniquely identifies this list. |
| ||||||
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}. |
| ||||||
List Name The name of the list. |
| ||||||
List Permission Reminder The permission reminder for the list. |
| ||||||
List Use Archive Bar Whether campaigns for this list use the Archive Bar in archives by default. |
| ||||||
List Notify On Subscribe The email address to send subscribe notifications to. |
| ||||||
List Notify On Unsubscribe The email address to send unsubscribe notifications to. |
| ||||||
List Date Created The date and time that this list was created in ISO 8601 format. |
| ||||||
List Rating An auto-generated activity score for the list (0-5). |
| ||||||
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. |
| ||||||
List Subscribe Url Short Our url shortened version of this list's subscribe form. |
| ||||||
List Subscribe Url long The full version of this list's subscribe form (host will vary). |
| ||||||
List Beamer Address The list's Email Beamer address. |
| ||||||
List Visibility Legacy - visibility settings are no longer used Possible values: "pub" or "prv". |
| ||||||
List Double Optin Whether or not to require the subscriber to confirm subscription via email. |
| ||||||
List Has Welcome Whether or not this list has a welcome automation connected. Welcome Automations: welcomeSeries, singleWelcome, emailFollowup. |
| ||||||
List Marketing Permissions Whether or not the list has marketing permissions (eg. GDPR) enabled. |
| ||||||
List Last Sub Date The date and time of the last time someone subscribed to this list in ISO 8601 format. |
| ||||||
List Last Unsub Date The date and time of the last time someone unsubscribed from this list in ISO 8601 format. |
| ||||||
Member ID The MD5 hash of the lowercase version of the list member's email address. |
| ||||||
Member Email Address Email address for a subscriber. |
| ||||||
Member Unique Email ID An identifier for the address across all of Mailchimp. |
| ||||||
Member Full Name The contact's full name. |
| ||||||
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}. |
| ||||||
Member Email Type Type of email this member asked to get ('html' or 'text'). |
| ||||||
Member Status Subscriber's current status. Possible values: "subscribed", "unsubscribed", "cleaned", "pending", "transactional", or "archived". |
| ||||||
Member Unsibscribe Reason Indicates whether a contact consents to 1:1 messaging. |
| ||||||
Member Contents To One To one Messaging IP address the subscriber signed up from. |
| ||||||
Member IP Signup IP address the subscriber signed up from. |
| ||||||
Member Timestamp Signup The date and time the subscriber signed up for the list in ISO 8601 format. |
| ||||||
Member IP Opt The IP address the subscriber used to confirm their opt-in status. |
| ||||||
Member Timestamp Opt The date and time the subscriber confirmed their opt-in status in ISO 8601 format. |
| ||||||
Member Rating Star rating for this member, between 1 and 5. |
| ||||||
Member Last Changed The date and time the member's info was last changed in ISO 8601 format. |
| ||||||
Member Language If set/detected, the subscriber's language. |
| ||||||
Member VIP VIP status for subscriber. |
| ||||||
Member Email Client The list member's email client. |
| ||||||
Member Source The source from which the subscriber was added to this list. |
| ||||||
Member Tags Count The number of tags applied to this member. |
| ||||||
Member Ecommerce Currency Code The three-letter ISO 4217 code for the currency that the store accepts. |
| ||||||
List Member Count The number of active members in the list. |
| ||||||
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. |
| ||||||
List Unsubscribe Count The number of members who have unsubscribed from the list. |
| ||||||
List Clean Count The number of members cleaned from the list. |
| ||||||
List Member Count Since Send The number of active members in the list since the last campaign was sent. |
| ||||||
List Unsubscribe Count Since Send The number of members who have unsubscribed since the last campaign was sent. |
| ||||||
List Clean Count Since Send The number of members cleaned from the list since the last campaign was sent. |
| ||||||
List Campaign Count The number of campaigns in any status that use this list. |
| ||||||
List Merge Field Count The number of merge fields (audience field) for this list (doesn't include EMAIL). |
| ||||||
List Average Sub Rate The average number of subscriptions per month for the list (not returned if we haven't calculated it yet). |
| ||||||
List Average Unsub Rate The average number of unsubscriptions per month for the list (not returned if we haven't calculated it yet). |
| ||||||
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). |
| ||||||
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). |
| ||||||
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). |
| ||||||
Member Average Open Rate A subscriber's average open rate. |
| ||||||
Member Average Click Rate A subscriber's average clickthrough rate. |
| ||||||
Member Total Revenue The total revenue the list member has brought in. |
| ||||||
Member Number Of Orders The total number of orders placed by the list member. |
| ||||||
Extracted Date The date where the extraction take times. |
| ||||||
Platform Name Return the platform name |
|