Full PMA field catalogue for Mailchimp — campaigns, automations, customer journeys, lists, landing pages and subscriber data across 8 connected accounts.
No native Mailchimp MCP. PMA is our only source for these client Mailchimp accounts. (Our Kit MCP is a separate Hedgehog-owned platform, not these accounts.)
Grouped by report type. Filter to find a field fast. formula fields are computed — use their component fields in SQL.
| Field name | Label | Type |
|---|---|---|
opens_open_rate | Open rate (campaigns)formula | NUMBER |
emails_arrived | Arrivedformula | NUMBER |
clicks_click_rate | Click rate (campaigns)formula | NUMBER |
bounces_total_bounces | Total bouncesformula | NUMBER |
ab_split_a_abuse_reports | AB Split A abuse reports | NUMBER |
ab_split_a_bounces | AB Split A bounces | NUMBER |
ab_split_a_forwards | AB Split A forwards | NUMBER |
ab_split_a_forwards_opens | AB Split A forwards opens | NUMBER |
ab_split_a_opens | AB Split A opens | NUMBER |
ab_split_a_recipient_clicks | AB Split A recipient clicks | NUMBER |
ab_split_a_unique_opens | AB Split A unique opens | NUMBER |
ab_split_a_unsubs | AB Split A unsubs | NUMBER |
ab_split_b_abuse_reports | AB Split B abuse reports | NUMBER |
ab_split_b_bounces | AB Split B bounces | NUMBER |
ab_split_b_forwards | AB Split B forwards | NUMBER |
ab_split_b_forwards_opens | AB Split B forwards opens | NUMBER |
ab_split_b_opens | AB Split B opens | NUMBER |
ab_split_b_recipient_clicks | AB Split B recipient clicks | NUMBER |
ab_split_b_unique_opens | AB Split B unique opens | NUMBER |
ab_split_b_unsubs | AB Split B unsubs | NUMBER |
abuse_reports | Abuse reports | NUMBER |
bounces_hard_bounces | Hard bounces | NUMBER |
bounces_soft_bounces | Soft bounces | NUMBER |
bounces_syntax_errors | Syntax errors bounces | NUMBER |
clicks_clicks_total | Total clicks (campaigns) | NUMBER |
clicks_unique_clicks | Unique clicks (campaigns) | NUMBER |
clicks_unique_subscriber_clicks | Clicked (campaigns) | NUMBER |
delivery_status_can_cancel | Delivery can cancel | NUMBER |
delivery_status_emails_canceled | Canceled (campaigns) | NUMBER |
delivery_status_emails_sent | Sent (campaigns) | NUMBER |
delivery_status_enabled | Delivery status enabled | NUMBER |
ecommerce_total_orders | Orders | NUMBER |
ecommerce_total_revenue | Total order revenue | NUMBER |
ecommerce_total_spent | Ecommerce total spent | NUMBER |
emails_sent | Recipients | NUMBER |
facebook_likes_facebook_likes | Total Facebook likes | NUMBER |
facebook_likes_recipient_likes | Recipients Facebook likes | NUMBER |
facebook_likes_unique_likes | Unique Facebook likes (campaigns) | NUMBER |
forwards_forwards_count | Forwarded | NUMBER |
forwards_forwards_opens | Forwarded opens | NUMBER |
industry_stats_abuse_rate | Industry abuse rate | NUMBER |
industry_stats_bounce_rate | Industry bounce rate | NUMBER |
industry_stats_click_rate | Industry average click rate | NUMBER |
industry_stats_open_rate | Industry open rate | NUMBER |
industry_stats_unopen_rate | Industry unopen rate | NUMBER |
industry_stats_unsub_rate | Industry unsub rate | NUMBER |
list_is_active | List is active | NUMBER |
list_stats_click_rate | List click rate | NUMBER |
list_stats_open_rate | List open rate | NUMBER |
list_stats_proxy_excluded_open_rate | List stats proxy excluded open rate | NUMBER |
opens_opens_total | Total opens (campaigns) | NUMBER |
opens_proxy_excluded_open_rate | Opens proxy excluded open rate | NUMBER |
opens_proxy_excluded_opens | Opens proxy excluded opens | NUMBER |
opens_proxy_excluded_unique_opens | Opens proxy excluded unique opens | NUMBER |
opens_unique_opens | Opened | NUMBER |
timeseries | Timeseries | NUMBER |
unsubscribes | Unsubscribes (campaigns) | NUMBER |
unique_opens | Unique opens total | NUMBER |
unique_clicks | Unique clicks total | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Entity name | STRING |
ab_split_a_last_open | AB Split A last open | STRING |
ab_split_b_last_open | AB Split B last open | STRING |
account_id | Account ID | NUMBER |
campaign_id | Campaign ID | STRING |
campaign_title | Campaign title | STRING |
clicks_last_click | Last clicked | STRING |
dataFreshness | Data freshness | STRING |
day | Date | STRING |
delivery_status_status | Delivery status (campaigns) | STRING |
ecommerce_currency_code | Ecommerce currency code | STRING |
industry_stats_type | Industry type | STRING |
list_id | List ID | STRING |
list_name | Campaign list name | STRING |
opens_last_open | Last opened | STRING |
preview_text | Preview text | STRING |
send_time | Delivered | STRING |
share_report_share_password | Report password | STRING |
share_report_share_url | Share URL | STRING |
subject_line | Subject (campaigns) | STRING |
type | Campaign type | STRING |
status | Campaign status | STRING |
archive_url | Archive URL | STRING |
long_archive_url | Long archive URL | STRING |
from_name | From name | STRING |
reply_to | Reply to | STRING |
create_time | Create time | STRING |
content_type | Content type | STRING |
tracking_google_analytics | Tracking Google Analytics | STRING |
tracking_clicktale | Tracking Clicktale | STRING |
web_id | Web ID | NUMBER |
parent_campaign_id | Parent campaign ID | STRING |
Subscription | PMA subscription ID | STRING |
Trial | PMA trial status | STRING |
Payment | PMA payment URL | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |
isInterpolated | PMA is interpolated? | BOOLEAN |
dataSource | Data source | STRING |
dataSourceLogo | Data source logo | STRING |
executionId | Function execution ID | STRING |
dataPlatform | Data platform | STRING |
year | Yearformula | STRING |
quarter | Quarterformula | STRING |
week | Weekformula | STRING |
year_quarter | Year quarterformula | STRING |
month | Year month | STRING |
| Field name | Label | Type |
|---|---|---|
double_optin | Double optin | NUMBER |
email_type_option | Email type | NUMBER |
has_welcome | Has welcome? | NUMBER |
list_rating | List rating | NUMBER |
marketing_permissions | List marketing permissions | NUMBER |
modules | List modules | NUMBER |
stats_avg_sub_rate | List average subscribe rate | NUMBER |
stats_avg_unsub_rate | List average unsubscribe rate | NUMBER |
stats_campaign_count | List campaign count | NUMBER |
stats_cleaned_count | List cleaned count | NUMBER |
stats_cleaned_count_since_send | List cleaned count since send | NUMBER |
stats_click_rate | Click rate (lists) | NUMBER |
stats_member_count | List member count | NUMBER |
stats_member_count_since_send | List member count since send | NUMBER |
stats_merge_field_count | List merge field count | NUMBER |
stats_open_rate | Open rate (lists) | NUMBER |
stats_target_sub_rate | List target subscription rate | NUMBER |
stats_unsubscribe_count | List unsubscribe count | NUMBER |
stats_unsubscribe_count_since_send | List unsubscribe count since send | NUMBER |
unread_messages | Unread messages | NUMBER |
use_archive_bar | List use archive bar | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Entity name | STRING |
account_id | Account ID | NUMBER |
beamer_address | Beamer address | STRING |
campaign_defaults_from_email | Campaign default from email | STRING |
campaign_defaults_from_name | Campaign default from name | STRING |
campaign_defaults_language | Campaign default language | STRING |
campaign_defaults_subject | Campaign default subject | STRING |
contact_address1 | Contact address | STRING |
contact_address2 | Contact address 2 | STRING |
contact_city | Contact city | STRING |
contact_company | Contact company | STRING |
contact_country | Contact country | STRING |
contact_phone | Contact phone | STRING |
contact_state | Contact state | STRING |
contact_zip | Contact zip | STRING |
dataFreshness | Data freshness | STRING |
date_created | List date created | STRING |
day | Date | STRING |
list_id | List ID | STRING |
name | List name | STRING |
Subscription | PMA subscription ID | STRING |
Trial | PMA trial status | STRING |
Payment | PMA payment URL | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |
isInterpolated | PMA is interpolated? | BOOLEAN |
dataSource | Data source | STRING |
dataSourceLogo | Data source logo | STRING |
executionId | Function execution ID | STRING |
dataPlatform | Data platform | STRING |
| Field name | Label | Type |
|---|---|---|
automation_emails_sent | Sent | NUMBER |
delivery_status_enabled | Delivery status enabled | NUMBER |
needs_block_refresh | Needs block refresh | NUMBER |
recipients_list_is_active | Recipients list is active | NUMBER |
recipients_recipient_count | Successful deliveries | NUMBER |
report_summary_clicks | Total clicks (automations) | NUMBER |
report_summary_ecommerce_total_orders | Total orders (journeys) | NUMBER |
report_summary_ecommerce_total_revenue | Total revenue (journeys) | NUMBER |
report_summary_ecommerce_total_spent | Total spent (journeys) | NUMBER |
report_summary_opens | Total opens (automations) | NUMBER |
report_summary_subscriber_clicks | Subscriber clicks | NUMBER |
report_summary_unique_opens | Unique opens | NUMBER |
resendable | Resendable | NUMBER |
settings_authenticate | Settings authenticate | NUMBER |
settings_auto_footer | Settings auto footer | NUMBER |
settings_auto_tweet | Settings auto tweet | NUMBER |
settings_drag_and_drop | Settings drag and drop | NUMBER |
settings_fb_comments | Settings FB comments | NUMBER |
settings_inline_css | Settings inline CSS | NUMBER |
settings_timewarp | Settings timewarp | NUMBER |
settings_use_conversation | Settings use conversation | NUMBER |
tracking_ecomm360 | Tracking Ecomm360 | NUMBER |
tracking_goal_tracking | Tracking goal tracking | NUMBER |
tracking_html_clicks | Tracking HTML clicks | NUMBER |
tracking_opens | Tracking opens | NUMBER |
tracking_text_clicks | Tracking text clicks | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Entity name | STRING |
account_id | Account ID | NUMBER |
archive_url | Archive URL | STRING |
content_type | Content type | STRING |
create_time | Create time | STRING |
customer_journey_id | Journey ID | NUMBER |
dataFreshness | Data freshness | STRING |
day | Date | STRING |
email_id | Email ID | STRING |
long_archive_url | Long archive URL | STRING |
recipients_list_id | Recipients list ID | STRING |
recipients_list_name | Audience | STRING |
send_time | Delivered | STRING |
settings_from_name | Settings from name | STRING |
settings_preview_text | Campaign preview text | STRING |
settings_reply_to | Settings reply to | STRING |
settings_subject_line | Subject (automation) | STRING |
settings_template_id | Settings template ID | NUMBER |
settings_title | Workflow | STRING |
settings_to_name | Settings to name | STRING |
Subscription | PMA subscription ID | STRING |
Trial | PMA trial status | STRING |
Payment | PMA payment URL | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |
isInterpolated | PMA is interpolated? | BOOLEAN |
dataSource | Data source | STRING |
dataSourceLogo | Data source logo | STRING |
executionId | Function execution ID | STRING |
dataPlatform | Data platform | STRING |
| Field name | Label | Type |
|---|---|---|
report_summary_open_rate | Open rateformula | NUMBER |
report_summary_click_rate | Click rateformula | NUMBER |
automation_emails_sent | Sent | NUMBER |
recipients_list_is_active | Recipients list is active | NUMBER |
report_summary_clicks | Total clicks (automations) | NUMBER |
report_summary_opens | Total opens (automations) | NUMBER |
report_summary_subscriber_clicks | Subscriber clicks | NUMBER |
report_summary_unique_opens | Unique opens | NUMBER |
settings_authenticate | Settings authenticate | NUMBER |
settings_auto_footer | Settings auto footer | NUMBER |
settings_inline_css | Settings inline CSS | NUMBER |
settings_use_conversation | Settings use conversation | NUMBER |
tracking_capsule_notes | Tracking Capsule notes | NUMBER |
tracking_ecomm360 | Tracking Ecomm360 | NUMBER |
tracking_goal_tracking | Tracking goal tracking | NUMBER |
tracking_html_clicks | Tracking HTML clicks | NUMBER |
tracking_opens | Tracking opens | NUMBER |
tracking_salesforce_campaign | Tracking Salesforce campaign | NUMBER |
tracking_salesforce_notes | Tracking Salesforce notes | NUMBER |
tracking_text_clicks | Tracking text clicks | NUMBER |
trigger_settings_workflow_emails_count | Trigger settings workflow emails count | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Entity name | STRING |
account_id | Account ID | NUMBER |
automation_id | Automation ID | STRING |
create_time | Create time | STRING |
dataFreshness | Data freshness | STRING |
day | Date | STRING |
recipients_list_id | Recipients list ID | STRING |
recipients_list_name | Audience | STRING |
recipients_segment_opts_match | Recipients segment options match | STRING |
recipients_segment_opts_saved_segment_id | Recipients segment options saved segment ID | NUMBER |
recipients_store_id | Recipients store ID | STRING |
settings_from_name | Settings from name | STRING |
settings_reply_to | Settings reply to | STRING |
settings_title | Workflow | STRING |
settings_to_name | Settings to name | STRING |
start_time | Automations start time | STRING |
status | Automation status | STRING |
tracking_clicktale | Tracking Clicktale | STRING |
tracking_google_analytics | Tracking Google Analytics | STRING |
trigger_settings_runtime_days | Trigger settings runtime days | STRING |
Subscription | PMA subscription ID | STRING |
Trial | PMA trial status | STRING |
| Field name | Label | Type |
|---|---|---|
unsubscribes_count | Countformula | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Entity name | STRING |
account_id | Account ID | NUMBER |
campaign_id | Campaign ID | STRING |
dataFreshness | Data freshness | STRING |
day | Date | STRING |
email | Unsubscribe email | STRING |
list_id | List ID | STRING |
reason | Reason | STRING |
Subscription | PMA subscription ID | STRING |
Trial | PMA trial status | STRING |
Payment | PMA payment URL | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |
isInterpolated | PMA is interpolated? | BOOLEAN |
dataSource | Data source | STRING |
dataSourceLogo | Data source logo | STRING |
executionId | Function execution ID | STRING |
dataPlatform | Data platform | STRING |
year | Yearformula | STRING |
quarter | Quarterformula | STRING |
| Field name | Label | Type |
|---|---|---|
report_summary_open_rate | Open rateformula | NUMBER |
report_summary_click_rate | Click rateformula | NUMBER |
automation_emails_sent | Sent | NUMBER |
delay_amount | Delay amount | NUMBER |
has_logo_merge_tag | Has logo merge tag | NUMBER |
needs_block_refresh | Needs block refresh | NUMBER |
position | Automation position | NUMBER |
recipients_list_is_active | Recipients list is active | NUMBER |
recipients_recipient_count | Successful deliveries | NUMBER |
report_summary_clicks | Total clicks (automations) | NUMBER |
report_summary_opens | Total opens (automations) | NUMBER |
report_summary_subscriber_clicks | Subscriber clicks | NUMBER |
report_summary_unique_opens | Unique opens | NUMBER |
settings_authenticate | Settings authenticate | NUMBER |
settings_auto_footer | Settings auto footer | NUMBER |
settings_auto_tweet | Settings auto tweet | NUMBER |
settings_drag_and_drop | Settings drag and drop | NUMBER |
settings_fb_comments | Settings FB comments | NUMBER |
settings_inline_css | Settings inline CSS | NUMBER |
tracking_ecomm360 | Tracking Ecomm360 | NUMBER |
tracking_goal_tracking | Tracking goal tracking | NUMBER |
tracking_html_clicks | Tracking HTML clicks | NUMBER |
tracking_opens | Tracking opens | NUMBER |
tracking_text_clicks | Tracking text clicks | NUMBER |
trigger_settings_workflow_emails_count | Trigger settings workflow emails count | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Entity name | STRING |
_links | Automation links | STRING |
account_id | Account ID | NUMBER |
archive_url | Archive URL | STRING |
automation_id | Automation ID | STRING |
content_type | Content type | STRING |
create_time | Create time | STRING |
dataFreshness | Data freshness | STRING |
day | Date | STRING |
delay_action | Delay action | STRING |
delay_action_description | Delay action description | STRING |
delay_direction | Delay direction | STRING |
delay_full_description | Delay full description | STRING |
delay_type | Delay type | STRING |
email_id | Email ID | STRING |
recipients_list_id | Recipients list ID | STRING |
recipients_list_name | Audience | STRING |
recipients_segment_opts_match | Recipients segment options match | STRING |
recipients_segment_opts_saved_segment_id | Recipients segment options saved segment ID | NUMBER |
recipients_segment_text | Recipients segment text | STRING |
Subscription | PMA subscription ID | STRING |
Trial | PMA trial status | STRING |
Payment | PMA payment URL | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |
| Field name | Label | Type |
|---|---|---|
cleaned | Cleaned | NUMBER |
deleted | Deleted | NUMBER |
existing | Existing | NUMBER |
imports | Imports | NUMBER |
optins | Opt-ins | NUMBER |
pending | Pending | NUMBER |
reconfirm | Reconfirm | NUMBER |
stats_member_count | List member count | NUMBER |
transactional | Transactional | NUMBER |
unsubscribed | Unsubscribed | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Entity name | STRING |
account_id | Account ID | NUMBER |
dataFreshness | Data freshness | STRING |
list_id | List ID | STRING |
month | Year month | STRING |
name | List name | STRING |
Subscription | PMA subscription ID | STRING |
Trial | PMA trial status | STRING |
Payment | PMA payment URL | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |
isInterpolated | PMA is interpolated? | BOOLEAN |
dataSource | Data source | STRING |
dataSourceLogo | Data source logo | STRING |
executionId | Function execution ID | STRING |
dataPlatform | Data platform | STRING |
| Field name | Label | Type |
|---|---|---|
can_resend_to_new_subscribers | Can resend to new subscribers | NUMBER |
needs_block_refresh | Needs block refresh | NUMBER |
resendable | Resendable | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Entity name | STRING |
account_id | Account ID | NUMBER |
archive_url | Archive URL | STRING |
campaign_id | Campaign ID | STRING |
campaign_title | Campaign title | STRING |
content_type | Content type | STRING |
create_time | Create time | STRING |
dataFreshness | Data freshness | STRING |
from_name | From name | STRING |
long_archive_url | Long archive URL | STRING |
parent_campaign_id | Parent campaign ID | STRING |
preview_text | Preview text | STRING |
reply_to | Reply to | STRING |
send_time | Delivered | STRING |
status | Automation status | STRING |
subject_line | Subject (campaigns) | STRING |
tracking_clicktale | Tracking Clicktale | STRING |
tracking_google_analytics | Tracking Google Analytics | STRING |
type | Campaign type | STRING |
web_id | Web ID | NUMBER |
Subscription | PMA subscription ID | STRING |
Trial | PMA trial status | STRING |
| Field name | Label | Type |
|---|---|---|
conversion_rate | Conversion rateformula | NUMBER |
clicks | Clicks (landing pages) | NUMBER |
ecommerce_average_order_revenue | Average order revenue | NUMBER |
ecommerce_total_orders | Orders | NUMBER |
ecommerce_total_revenue | Total order revenue | NUMBER |
subscribes | Subscribes | NUMBER |
unique_visits | Unique visits | NUMBER |
visits | Visits | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Entity name | STRING |
account_id | Account ID | NUMBER |
dataFreshness | Data freshness | STRING |
day | Date | STRING |
ecommerce_currency_code | Ecommerce currency code | STRING |
landing_page_id | Landing page ID | STRING |
landing_page_name | Landing page name | STRING |
list_id | List ID | STRING |
list_name | Campaign list name | STRING |
published_at | Publish date | STRING |
status | Automation status | STRING |
title | Page title | STRING |
unpublished_at | Unpublished at | STRING |
url | URL | STRING |
web_id | Web ID | NUMBER |
Subscription | PMA subscription ID | STRING |
Trial | PMA trial status | STRING |
Payment | PMA payment URL | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |
| Field name | Label | Type |
|---|---|---|
consents_to_one_to_one_messaging | Consents to one-to-one messaging | NUMBER |
last_note_created_by | Last note created by | NUMBER |
member_rating | Member rating | NUMBER |
stats_avg_click_rate | Stats avg click rate | NUMBER |
stats_avg_open_rate | Stats avg open rate | NUMBER |
stats_ecommerce_data_number_of_orders | Stats ecommerce data number of orders | NUMBER |
stats_ecommerce_data_total_revenue | Stats ecommerce data total revenue | NUMBER |
tags_count | Tags count | NUMBER |
vip | VIP | NUMBER |
| Field name | Label | Type |
|---|---|---|
configName | Entity name | STRING |
account_id | Account ID | NUMBER |
contact_id | Contact ID | STRING |
dataFreshness | Data freshness | STRING |
day | Date | STRING |
email_address | Member email address | STRING |
email_client | Email client | STRING |
email_type | Email type | STRING |
full_name | Full name | STRING |
ip_opt | IP opt | STRING |
ip_signup | IP signup | STRING |
language | Language | STRING |
last_note_created_at | Last note created at | STRING |
last_note_note | Last note note | STRING |
last_note_note_id | Last note note ID | NUMBER |
list_id | List ID | STRING |
member_id | Member ID | STRING |
sms_phone_number | SMS phone number | STRING |
sms_subscription_last_updated | SMS subscription last updated | STRING |
sms_subscription_status | SMS subscription status | STRING |
Subscription | PMA subscription ID | STRING |
Trial | PMA trial status | STRING |
Payment | PMA payment URL | STRING |
MinDate | PMA minimum cached data date | STRING |
MaxDate | PMA maximum cached data date | STRING |