Docs
Mailchimp Fields List
204 fields · 131 metrics · 73 dimensions
| Field Name | Label | Type | Description | Group |
|---|---|---|---|---|
| A/B testing23 fields | ||||
ab_test_send_date |
A/B test send date | Dimension | The possible send times to test. The times provided should be in the format YYYY-MM-DD HH:MM:SS. If send_times are provided to test, the test_size will be set to 100% and winner_criteria will be ignored. | A/B testing |
ab_test_size |
A/B test size | Metric | The percentage of recipients to send the test combinations to, must be a value between 10 and 100. | A/B testing |
ab_test_wait_time |
A/B test wait time | Dimension | The number of minutes to wait before choosing the winning campaign. The value of wait_time must be greater than 0 and in whole hours, specified in minutes. | A/B testing |
ab_test_winner_campaign_ID |
A/B test winner campaign ID | Dimension | ID of the campaign that was sent to the remaining recipients based on the winning combination. | A/B testing |
ab_winner_criteria |
A/B winner criteria | Metric | The combination that performs the best. This may be determined automatically by click rate, open rate, or total revenue — or you may choose manually based on the reporting data you find the most valuable. For Multivariate Campaigns testing send_time, winner_criteria is ignored. For Multivariate Campaigns with ‘manual’ as the winner_criteria, the winner must be chosen in the Mailchimp web application. Possible values: "opens", "clicks", "manual", or "total_revenue". | A/B testing |
abuse_reports_a |
Abuse reports A | Metric | Abuse reports for Campaign A. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
abuse_reports_b |
Abuse reports B | Metric | Abuse reports for Campaign B. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
bounces_a |
Bounces A | Metric | Bounces for Campaign A. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
bounces_b |
Bounces B | Metric | Bounces for Campaign B. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
clicks_a |
Clicks A | Metric | Recipient clicks for Campaign A. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
clicks_b |
Clicks B | Metric | Recipient clicks for Campaign B. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
forwards_a |
Forwards A | Metric | Forwards for Campaign A. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
forwards_b |
Forwards B | Metric | Forwards for Campaign B. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
forwards_opens_a |
Forwards opens A | Metric | Opens from forwards for Campaign A. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
forwards_opens_b |
Forwards opens B | Metric | Opens from forwards for Campaign B. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
last_open_date_a |
Last open date A | Metric | Last open for Campaign A. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
last_open_date_b |
Last open date B | Metric | Last open for Campaign B. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
opens_a |
Opens A | Metric | Opens for Campaign A. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
opens_b |
Opens B | Metric | Opens for Campaign B. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
unique_opens_a |
Unique opens A | Metric | Unique opens for Campaign A. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
unique_opens_b |
Unique opens B | Metric | Unique opens for Campaign B. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
unsubs_a |
Unsubscribes A | Metric | Unsubscribes for Campaign A. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
unsubs_b |
Unsubscribes B | Metric | Unsubscribes for Campaign B. Mailchimp does not return information about Multivariate Campaigns. | A/B testing |
| Abuse reports2 fields | ||||
campaign_abuse_rate |
Campaign abuse rate | Dimension | Calculated as Campaign abuse / Emails sent. | Abuse reports |
campaign_abuse_reports |
Campaign abuse reports | Dimension | The number of abuse reports generated for this campaign. | Abuse reports |
| Automation1 fields | ||||
workflow_title |
Workflow title | Dimension | The title of the workflow type. | Automation |
| Automation details6 fields | ||||
automation_creation_date |
Automation creation date | Dimension | The date and time the Automation was created. | Automation details |
automation_id |
Automation ID | Dimension | A string that identifies the Automation. | Automation details |
automation_name |
Automation name | Dimension | The display name of the automation as configured in Mailchimp. | Automation details |
automation_start_date |
Automation start date | Dimension | The date and time the Automation was started. | Automation details |
automation_status |
Automation status | Dimension | The current status of the Automation. Possible values: "save", "paused", or "sending". | Automation details |
automation_type |
Automation type | Dimension | The type of Automation workflow. Possible values: "abandonedBrowse", "abandonedCart", "api", "bestCustomers", "categoryFollowup", "dateAdded", "emailFollowup", "emailSeries", "groupAdd", "groupRemove", "mandrill", "productFollowup", "purchaseFollowup", "recurringEvent", "specialEvent", "visitUrl", or "welcomeSeries". | Automation details |
| Bounces7 fields | ||||
campaign_bounce_rate |
Campaign bounce rate | Dimension | Calculated as Campaign bounces / Emails sent. | Bounces |
campaign_bounces |
Campaign bounces | Dimension | The total number of bounced email addresses. | Bounces |
campaign_hard_bounce_rate |
Campaign hard bounce rate | Dimension | Calculated as Campaign hard bounces / Emails sent. | Bounces |
campaign_hard_bounces |
Campaign hard bounces | Dimension | The total number of hard bounced email addresses. | Bounces |
campaign_soft_bounce_rate |
Campaign soft bounce rate | Dimension | Calculated as Campaign soft bounces / Emails sent. | Bounces |
campaign_soft_bounces |
Campaign soft bounces | Dimension | The total number of soft bounced email addresses. | Bounces |
campaign_syntax_error_bounces |
Campaign syntax error bounces | Dimension | The total number of addresses that were syntax-related bounces. | Bounces |
| Campaign20 fields | ||||
automatic_tweet |
Automatic tweet | Metric | Automatically tweet a link to the campaign archive page when the campaign is sent. | Campaign |
campaign_archive_url |
Campaign archive URL | Dimension | The link to the campaign’s archive version in ISO 8601 format. | Campaign |
campaign_resendable |
Campaign resendable | Dimension | Determines if the campaign qualifies to be resent to non-openers. | Campaign |
can_be_canceled |
Can be canceled | Metric | Whether a campaign send can be canceled. | Campaign |
currency_code |
Currency code | Metric | Currency code metric from Mailchimp. This field provides data for reporting and analysis in your marketing dashboards. | Campaign |
emails_sent |
E-mails sent | Metric | The total number of emails sent for this campaign. | Campaign |
facebook_likes |
Facebook likes | Metric | The number of Facebook likes for the campaign. | Campaign |
preview_text |
Preview text | Dimension | The preview text for the campaign. | Campaign |
recipient_likes |
Recipient likes | Metric | The number of recipients who liked the campaign on Facebook. | Campaign |
rss_last_send |
RSS last send | Metric | For RSS campaigns, the date and time of the last send. | Campaign |
send_time |
Send time | Dimension | The date and time a campaign was sent. | Campaign |
total_spent |
Total spent | Metric | The total spent for a campaign. Calculated as the sum of all order totals with no deductions. | Campaign |
track_clicktale |
Track ClickTale | Metric | The custom slug for ClickTale tracking (max of 50 bytes). | Campaign |
track_ecommerce |
Track E-commerce | Metric | Whether to enable e-commerce tracking. | Campaign |
track_google_analytics |
Track Google Analytics | Metric | The custom slug for Google Analytics tracking (max of 50 bytes). | Campaign |
track_html_clicks |
Track HTML clicks | Metric | Whether to track clicks in the HTML version of the campaign. Defaults to true. Cannot be set to false for variate campaigns. | Campaign |
track_opens |
Track opens | Metric | Whether to track opens. Defaults to true. Cannot be set to false for variate campaigns. | Campaign |
track_text_clicks |
Track text clicks | Dimension | Whether to track clicks in the plain-text version of the campaign. Defaults to true. Cannot be set to false for variate campaigns. | Campaign |
unique_likes |
Unique likes | Metric | The number of like reactions on your content. Likes indicate positive audience sentiment and content appreciation. | Campaign |
unsubscribed |
Unsubscribed | Metric | The total number of unsubscribed members for this campaign. | Campaign |
| Campaign details10 fields | ||||
campaign_creation_date |
Campaign creation date | Dimension | The date and time the campaign was created. | Campaign details |
campaign_folder_id |
Campaign folder ID | Dimension | If the campaign is listed in a folder, the id for that folder. | Campaign details |
campaign_id |
Campaign ID | Dimension | A string that uniquely identifies this campaign. | Campaign details |
campaign_last_click_date |
Campaign last click date | Dimension | The date and time of the last recorded click for the campaign. | Campaign details |
campaign_last_open_date |
Campaign last open date | Dimension | The date and time of the last recorded open. | Campaign details |
campaign_name |
Campaign name | Dimension | The display name of the campaign as configured in Mailchimp. | Campaign details |
campaign_status |
Campaign status | Dimension | The current status of the campaign. Possible values: "save", "paused", "schedule", "sending", "sent", "canceled", "canceling", or "archived". | Campaign details |
campaign_type |
Campaign type | Dimension | The type of campaign (regular, plain-text, ab_split, rss, automation, variate, or auto). | Campaign details |
delivery_status_enabled |
Delivery status enabled | Dimension | Whether Campaign Delivery Status is enabled for this account and campaign. | Campaign details |
delivery_status_name |
Delivery status name | Dimension | The current state of a campaign delivery. Possible values: "delivering", "delivered", "canceling", or "canceled". | Campaign details |
| Campaign forwards2 fields | ||||
campaign_forward_opens |
Campaign forward opens | Dimension | How many times the forwarded campaign has been opened. | Campaign forwards |
campaign_forwards |
Campaign forwards | Dimension | How many times the campaign has been forwarded. | Campaign forwards |
| Campaign insights5 fields | ||||
campaign_delivery_rate |
Campaign delivery rate | Dimension | Calculated as Campaign bounces / Emails sent. | Campaign insights |
campaign_emails_canceled |
Campaign emails canceled | Dimension | The total number of emails canceled for this campaign. | Campaign insights |
campaign_open_rate |
Campaign open rate | Dimension | The number of unique opens divided by the total number of successful deliveries. | Campaign insights |
campaign_opens |
Campaign opens | Dimension | The total number of opens for a campaign. | Campaign insights |
unique_opens |
Unique opens | Metric | The total number of unique opens. | Campaign insights |
| Clicks4 fields | ||||
campaign_click_rate |
Campaign click rate | Dimension | The number of unique clicks divided by the total number of successful deliveries. | Clicks |
campaign_total_clicks |
Campaign total clicks | Dimension | The total number of clicks for the campaign. | Clicks |
campaign_unique_clicks |
Campaign unique clicks | Dimension | The total number of unique clicks for links across a campaign. | Clicks |
campaign_unique_subscriber_clicks |
Campaign unique subscriber clicks | Dimension | The total number of subscribers who clicked on a campaign. | Clicks |
| E-commerce3 fields | ||||
e_commerce_average_orders_revenue_campaign |
E-commerce average orders revenue campaign | Metric | Calculated as member total revenue/member total orders | E-commerce |
e_commerce_total_orders |
E-commerce total orders | Metric | The total orders for a campaign. | E-commerce |
e_commerce_total_revenue |
E-commerce total revenue | Metric | The total revenue for a campaign. Calculated as the sum of all order totals minus shipping and tax totals. | E-commerce |
| Email content9 fields | ||||
authenticate |
Authenticate | Metric | Whether Mailchimp authenticated the campaign. Defaults to true. | Email content |
campaign_hour_of_the_day |
Campaign hour of the day | Dimension | The hour of the day a campaign was sent. | Email content |
content_type |
Content type | Dimension | How the campaign’s content is put together. Possible values: "template", "html", "url", or "multichannel". | Email content |
from_name |
From name | Dimension | The ‘from’ name on the campaign (not an email address). | Email content |
reply_to |
Reply to | Metric | The reply-to email address for the campaign. | Email content |
subject_line |
Subject line | Metric | The subject line for the campaign. | Email content |
to_name |
To name | Dimension | The campaign’s custom ‘To’ name. Typically the first name audience field. | Email content |
use_of_auto_footer |
Use of auto footer | Metric | Automatically append Mailchimp’s default footer to the campaign. | Email content |
use_of_conversation |
Use of conversation | Metric | Use Mailchimp Conversation feature to manage out-of-office replies. | Email content |
| Industry benchmarks7 fields | ||||
industry_abuse_rate |
Industry abuse rate | Metric | The percentage rate of industry abuse relative to total interactions. Calculated as a ratio of successful events to total opportunities. | Industry benchmarks |
industry_bounce_rate |
Industry bounce rate | Metric | The percentage rate of industry bounce relative to total interactions. Calculated as a ratio of successful events to total opportunities. | Industry benchmarks |
industry_click_rate |
Industry click rate | Metric | The percentage rate of industry click relative to total interactions. Calculated as a ratio of successful events to total opportunities. | Industry benchmarks |
industry_open_rate |
Industry open rate | Metric | The percentage rate of industry open relative to total interactions. Calculated as a ratio of successful events to total opportunities. | Industry benchmarks |
industry_type |
Industry type | Dimension | The type of business industry associated with your account. For example: retail, education, etc. | Industry benchmarks |
industry_unopen_rate |
Industry unopen rate | Metric | The percentage rate of industry unopen relative to total interactions. Calculated as a ratio of successful events to total opportunities. | Industry benchmarks |
industry_unsubscribe_rate |
Industry unsubscribe rate | Metric | The percentage rate of industry unsubscribe relative to total interactions. Calculated as a ratio of successful events to total opportunities. | Industry benchmarks |
| List47 fields | ||||
address1 |
Address 1 | Metric | The street address for the list contact. | List |
address2 |
Address 2 | Metric | The street address for the list contact. | List |
city |
City | Dimension | The city for the list contact. | List |
company |
Company | Metric | The company name for the list. | List |
country |
Country | Dimension | A two-character ISO3166 country code. Defaults to US if invalid. | List |
default_from_email |
Default from email | Metric | The default from email for campaigns sent to this list. | List |
default_from_name |
Default from name | Dimension | The default from name for campaigns sent to this list. | List |
default_language |
Default language | Metric | The default language for this lists’s forms. | List |
default_subject |
Default subject | Metric | The default subject line for campaigns sent to this list. | List |
double_optin |
Double optin | Metric | Whether or not to require the subscriber to confirm subscription via email. | List |
has_marketing_permissions |
Has marketing permissions | Metric | Whether or not the list has marketing permissions (eg. GDPR) enabled. | List |
has_welcome |
Has welcome | Metric | Whether or not this list has a welcome automation connected. Welcome Automations: welcomeSeries, singleWelcome, emailFollowup. | List |
list_all_time_open_rate |
List all-time open rate | Metric | The average open rate (a percentage represented as a number between 0 and 100) per campaign for the list. This won’t be present if Mailchimp haven’t calculated it yet for this list. | List |
list_average_unsubscriptions_per_month |
List average unsubscriptions per month | Metric | The average number of unsubscriptions per month for the list. This won’t be present if Mailchimp haven’t calculated it yet for this list. | List |
list_campaign_last_sent_date |
List campaign last sent date | Dimension | The date and time the last campaign was sent to this list. This is updated when a campaign is sent to 10 or more recipients. | List |
list_cleaned_count_since_send |
List cleaned count since send | Metric | The number of members cleaned from the list since the last campaign was sent. | List |
list_click_rate |
List click rate | Metric | The average click rate (a percentage represented as a number between 0 and 100) per campaign for the list. This won’t be present if Mailchimp haven’t calculated it yet for this list. | List |
list_creation_date |
List creation date | Dimension | The date and time that this list was created. | List |
list_hard_bounces |
List hard bounces | Metric | The total number of hard bounced email addresses for this list. | List |
list_id |
List ID | Dimension | Unique identifier for the list in Mailchimp. | List |
list_last_subscribe_date |
List last subscribe date | Dimension | The date and time of the last time someone subscribed to this list. | List |
list_last_unsubscribe_date |
List last unsubscribe date | Dimension | The date and time of the last time someone unsubscribed to this list. | List |
list_member_count_since_send |
List member count since send | Metric | The number of active members in the list since the last campaign was sent. | List |
list_merge_field_count |
List merge field count | Metric | The number of merge fields (audience field) for this list (doesn’t include EMAIL). | List |
list_modules |
List modules | Metric | Any list-specific modules installed for this list. | List |
list_name |
List name | Dimension | The display name of the list as configured in Mailchimp. | List |
list_rating_number |
List rating (Number) | Metric | An auto-generated activity score for the list (0-5). | List |
list_rating_star |
List rating (Star) | Metric | An auto-generated activity score for the list (0-5). | List |
list_signup_form_link |
List signup form link | Dimension | The full version of this list’s subscribe form (host will vary). | List |
list_soft_bounces |
List soft bounces | Metric | The total number of soft bounced email addresses for this list. | List |
list_unique_opens |
List unique opens | Metric | The total number of unique opens for this list. | List |
list_unsubscribes_since_send |
List unsubscribes since send | Metric | The number of members who have unsubscribed since the last campaign was sent. | List |
list_visibility |
List visibility | Metric | Legacy – visibility settings are no longer used Possible values: "pub" or "prv". | List |
multiple_email_formats |
Multiple email formats | Metric | 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 |
notify_on_subscribe |
Notification email for subscribes | Metric | The email address to send subscribe notifications to. | List |
notify_on_unsubscribe |
Notification email for unsubscribes | Metric | The email address to send unsubscribe notifications to. | List |
other_adds |
Other adds | Metric | The number of subscribers who may have been added outside of the double opt-in process, such as imports or API activity. | List |
other_removes |
Other removes | Metric | The number of subscribers who may have been removed outside of unsubscribing or reporting an email as spam (for example, deleted subscribers). | List |
permission_reminder |
Permission reminder | Metric | The permission reminder for the list. | List |
phone_number |
Phone number | Metric | The phone number for the list contact. | List |
recipient_clicks |
Recipient clicks | Metric | The number of clicks on your ads or content. Clicks indicate user interest and engagement with your marketing materials. | List |
recipient_count |
Recipient count | Metric | Count of the recipients on the associated list. | List |
state |
State | Metric | The state for the list contact. | List |
subscribe_url_short |
Subscribe URL (short) | Metric | URL shortened version of this list’s subscribe form. | List |
subscribes |
subscribes | Metric | subscribes metric from Mailchimp. This field provides data for reporting and analysis in your marketing dashboards. | List |
use_archive_bar |
Use archive bar | Metric | Whether campaigns for this list use the Archive Bar in archives by default. | List |
zip_code |
ZIP code | Metric | The postal or zip code for the list contact. | List |
| List all-time totals5 fields | ||||
list_average_subscriptions_per_month |
List average subscriptions per month | Metric | The average number of subscriptions per month for the list. This won’t be present if Mailchimp haven’t calculated it yet for this list. | List all-time totals |
list_target_growth_rate |
List target growth rate | Metric | The target number of subscriptions per month for the list to keep it growing (not returned if Mailchimp hasn’t calculated it yet). | List all-time totals |
list_total_campaigns |
List total campaigns | Metric | The number of campaigns in any status that use this list. | List all-time totals |
list_total_contacts |
List total contacts | Metric | The number of contacts in the list, including subscribed, unsubscribed, pending, cleaned, deleted, transactional, and those that need to be reconfirmed. | List all-time totals |
list_total_members |
List total members | Metric | The number of active members in the list. | List all-time totals |
| List insights3 fields | ||||
list_cleaned_members |
List cleaned members | Metric | The number of members cleaned from the list. | List insights |
list_emails_sent |
List emails sent | Metric | The total number of emails sent for this list. | List insights |
list_unsubscribed_members |
List unsubscribed members | Metric | The number of members who have unsubscribed from the list. | List insights |
| List members39 fields | ||||
e_commerce_average_orders_revenue_members |
E-commerce average orders revenue members | Metric | Calculated as member total revenue/member total orders | List members |
member_average_click_through_rate |
Member average click-through rate | Metric | A subscriber’s average clickthrough rate. | List members |
member_consents_to_one_to_one_messaging |
Member consents 1:1 messaging | Metric | Indicates whether a contact consents to 1:1 messaging. | List members |
member_contact_id |
Member contact ID | Dimension | As Mailchimp evolves beyond email, you may eventually have contacts without email addresses. While the id is the MD5 hash of their email address, this contact_id is agnostic of contact’s inclusion of an email address. | List members |
member_coordinates |
Member coordinates | Metric | Member latitude and longitude coordinates. | List members |
member_country |
Member country | Metric | Geographic dimension showing member country. Enables location-based performance analysis. | List members |
member_country_code |
Member country code | Metric | The unique code for the location country. | List members |
member_currency_code |
Member currency code | Metric | The three-letter ISO 4217 code for the currency that the store accepts. | List members |
member_dst_offset |
Member DST offset | Metric | The offset for timezones where daylight saving time is observed. | List members |
member_email |
Member email | Metric | The list member’s email client. | List members |
member_email_address |
Member email address | Metric | Email address for a subscriber. | List members |
member_email_type |
Member email type | Dimension | Type of email this member asked to get (‘html’ or ‘text’). | List members |
member_gtm_offset |
Member GTM offset | Metric | The time difference in hours from GMT. | List members |
member_id |
Member ID | Dimension | The MD5 hash of the lowercase version of the list member’s email address. | List members |
member_ip_opt |
Member IP opt | Metric | The IP address the subscriber used to confirm their opt-in status. | List members |
member_ip_signup |
Member IP sign up | Metric | IP address the subscriber signed up from. | List members |
member_language |
Member language | Metric | If set/detected, the subscriber’s language. | List members |
member_last_change_date |
Member last change date | Dimension | The date and time the member’s info was last changed. | List members |
member_last_note |
Member last note | Metric | Member last note metric from Mailchimp. This field provides data for reporting and analysis in your marketing dashboards. | List members |
member_last_note_created_by |
Member last note created by | Dimension | Timestamp indicating when the member last note by occurred. Used for time-series analysis and reporting. | List members |
member_last_note_creation_date |
Member last note creation date | Dimension | The date and time the note was created. | List members |
member_last_note_id |
Member last note ID | Dimension | Unique identifier for the member last note in Mailchimp. | List members |
member_name |
Member name | Dimension | The display name of the member as configured in Mailchimp. | List members |
member_number_of_orders |
Member number of orders | Metric | The total number of orders placed by the list member. | List members |
member_open_rate |
Member open rate | Metric | A subscriber’s average open rate. | List members |
member_optin_date |
Member opt-in date | Dimension | The date and time the subscribe confirmed their opt-in status. | List members |
member_rating_number |
Member rating (Number) | Metric | Star rating for this member, between 1 and 5. | List members |
member_rating_star |
Member rating (Star) | Metric | Star rating for this member, between 1 and 5. | List members |
member_region |
Member region | Metric | Geographic dimension showing member region. Enables location-based performance analysis. | List members |
member_signup_date |
Member signup date | Dimension | The date and time the subscriber signed up for the list. | List members |
member_source |
Member source | Metric | The source from which the subscriber was added to this list. | List members |
member_status |
Member status | Dimension | Subscriber’s current status. Possible values: "subscribed", "unsubscribed", "cleaned", "pending", "transactional", or "archived". | List members |
member_tags |
Member tags | Metric | Returns up to 50 tags applied to this member. | List members |
member_tags_count |
Member tags count | Metric | The number of tags applied to this member. | List members |
member_timezone |
Member timezone | Dimension | The timezone for the location. | List members |
member_total_revenue |
Member total revenue | Metric | The total revenue the list member has brought in. | List members |
member_unique_email_id |
Member unique email ID | Dimension | An identifier for the address across all of Mailchimp. | List members |
member_unsubscribe_reason |
Member unsubscribe reason | Metric | A subscriber’s reason for unsubscribing. | List members |
member_vip |
Member VIP | Metric | Member VIP metric from Mailchimp. This field provides data for reporting and analysis in your marketing dashboards. | List members |
| Time11 fields | ||||
date |
Date | Dimension | Timestamp or date value for date. Used for time-series analysis and filtering. | Time |
day_of_week |
Day of week (Mon – Sun) | Metric | Day of week (Mon – Sun) metric from Mailchimp. This field provides data for reporting and analysis in your marketing dashboards. | Time |
hour_of_day |
Hour of day | Metric | Hour of day metric from Mailchimp. This field provides data for reporting and analysis in your marketing dashboards. | Time |
month |
Month | Metric | Month metric from Mailchimp. This field provides data for reporting and analysis in your marketing dashboards. | Time |
month_day |
Month day | Metric | Month day metric from Mailchimp. This field provides data for reporting and analysis in your marketing dashboards. | Time |
quarter |
Quarter | Metric | Quarter metric from Mailchimp. This field provides data for reporting and analysis in your marketing dashboards. | Time |
week |
Week | Metric | Week metric from Mailchimp. This field provides data for reporting and analysis in your marketing dashboards. | Time |
year |
Year | Metric | Year metric from Mailchimp. This field provides data for reporting and analysis in your marketing dashboards. | Time |
year_month |
Month and year | Metric | Month and year metric from Mailchimp. This field provides data for reporting and analysis in your marketing dashboards. | Time |
year_quarter |
Quarter and year | Metric | Quarter and year metric from Mailchimp. This field provides data for reporting and analysis in your marketing dashboards. | Time |
year_week |
Week and year | Metric | Week and year metric from Mailchimp. This field provides data for reporting and analysis in your marketing dashboards. | Time |
Power BI