PMA vs native MCPs / Mailchimp
Email · data points

Mailchimp

Full PMA field catalogue for Mailchimp — campaigns, automations, customer journeys, lists, landing pages and subscriber data across 8 connected accounts.

PMA: mailchimp Native MCP: None 8 accounts connected 10 report types
In PMA

All email metrics via PMA

  • Campaign performance: sends, opens, clicks, bounces, unsubscribes, revenue
  • Automation and customer journey stats per workflow
  • List growth over time — opt-ins, imports, cleaned, deleted
  • Landing page conversions and subscriber counts
  • Member-level data: engagement rates, order history, tags
  • Industry benchmark stats per campaign
Native MCP

No native MCP

  • 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.)

No native MCP

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.)

PMA field catalogue

Every queryable field in PMA

Grouped by report type. Filter to find a field fast. formula fields are computed — use their component fields in SQL.

Campaigns

report_type: campaigns · 59 metrics · 52 dimensions
Metrics
Field nameLabelType
opens_open_rateOpen rate (campaigns)formulaNUMBER
emails_arrivedArrivedformulaNUMBER
clicks_click_rateClick rate (campaigns)formulaNUMBER
bounces_total_bouncesTotal bouncesformulaNUMBER
ab_split_a_abuse_reportsAB Split A abuse reportsNUMBER
ab_split_a_bouncesAB Split A bouncesNUMBER
ab_split_a_forwardsAB Split A forwardsNUMBER
ab_split_a_forwards_opensAB Split A forwards opensNUMBER
ab_split_a_opensAB Split A opensNUMBER
ab_split_a_recipient_clicksAB Split A recipient clicksNUMBER
ab_split_a_unique_opensAB Split A unique opensNUMBER
ab_split_a_unsubsAB Split A unsubsNUMBER
ab_split_b_abuse_reportsAB Split B abuse reportsNUMBER
ab_split_b_bouncesAB Split B bouncesNUMBER
ab_split_b_forwardsAB Split B forwardsNUMBER
ab_split_b_forwards_opensAB Split B forwards opensNUMBER
ab_split_b_opensAB Split B opensNUMBER
ab_split_b_recipient_clicksAB Split B recipient clicksNUMBER
ab_split_b_unique_opensAB Split B unique opensNUMBER
ab_split_b_unsubsAB Split B unsubsNUMBER
abuse_reportsAbuse reportsNUMBER
bounces_hard_bouncesHard bouncesNUMBER
bounces_soft_bouncesSoft bouncesNUMBER
bounces_syntax_errorsSyntax errors bouncesNUMBER
clicks_clicks_totalTotal clicks (campaigns)NUMBER
clicks_unique_clicksUnique clicks (campaigns)NUMBER
clicks_unique_subscriber_clicksClicked (campaigns)NUMBER
delivery_status_can_cancelDelivery can cancelNUMBER
delivery_status_emails_canceledCanceled (campaigns)NUMBER
delivery_status_emails_sentSent (campaigns)NUMBER
delivery_status_enabledDelivery status enabledNUMBER
ecommerce_total_ordersOrdersNUMBER
ecommerce_total_revenueTotal order revenueNUMBER
ecommerce_total_spentEcommerce total spentNUMBER
emails_sentRecipientsNUMBER
facebook_likes_facebook_likesTotal Facebook likesNUMBER
facebook_likes_recipient_likesRecipients Facebook likesNUMBER
facebook_likes_unique_likesUnique Facebook likes (campaigns)NUMBER
forwards_forwards_countForwardedNUMBER
forwards_forwards_opensForwarded opensNUMBER
industry_stats_abuse_rateIndustry abuse rateNUMBER
industry_stats_bounce_rateIndustry bounce rateNUMBER
industry_stats_click_rateIndustry average click rateNUMBER
industry_stats_open_rateIndustry open rateNUMBER
industry_stats_unopen_rateIndustry unopen rateNUMBER
industry_stats_unsub_rateIndustry unsub rateNUMBER
list_is_activeList is activeNUMBER
list_stats_click_rateList click rateNUMBER
list_stats_open_rateList open rateNUMBER
list_stats_proxy_excluded_open_rateList stats proxy excluded open rateNUMBER
opens_opens_totalTotal opens (campaigns)NUMBER
opens_proxy_excluded_open_rateOpens proxy excluded open rateNUMBER
opens_proxy_excluded_opensOpens proxy excluded opensNUMBER
opens_proxy_excluded_unique_opensOpens proxy excluded unique opensNUMBER
opens_unique_opensOpenedNUMBER
timeseriesTimeseriesNUMBER
unsubscribesUnsubscribes (campaigns)NUMBER
unique_opensUnique opens totalNUMBER
unique_clicksUnique clicks totalNUMBER
Dimensions
Field nameLabelType
configNameEntity nameSTRING
ab_split_a_last_openAB Split A last openSTRING
ab_split_b_last_openAB Split B last openSTRING
account_idAccount IDNUMBER
campaign_idCampaign IDSTRING
campaign_titleCampaign titleSTRING
clicks_last_clickLast clickedSTRING
dataFreshnessData freshnessSTRING
dayDateSTRING
delivery_status_statusDelivery status (campaigns)STRING
ecommerce_currency_codeEcommerce currency codeSTRING
industry_stats_typeIndustry typeSTRING
list_idList IDSTRING
list_nameCampaign list nameSTRING
opens_last_openLast openedSTRING
preview_textPreview textSTRING
send_timeDeliveredSTRING
share_report_share_passwordReport passwordSTRING
share_report_share_urlShare URLSTRING
subject_lineSubject (campaigns)STRING
typeCampaign typeSTRING
statusCampaign statusSTRING
archive_urlArchive URLSTRING
long_archive_urlLong archive URLSTRING
from_nameFrom nameSTRING
reply_toReply toSTRING
create_timeCreate timeSTRING
content_typeContent typeSTRING
tracking_google_analyticsTracking Google AnalyticsSTRING
tracking_clicktaleTracking ClicktaleSTRING
web_idWeb IDNUMBER
parent_campaign_idParent campaign IDSTRING
SubscriptionPMA subscription IDSTRING
TrialPMA trial statusSTRING
PaymentPMA payment URLSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING
isInterpolatedPMA is interpolated?BOOLEAN
dataSourceData sourceSTRING
dataSourceLogoData source logoSTRING
executionIdFunction execution IDSTRING
dataPlatformData platformSTRING
yearYearformulaSTRING
quarterQuarterformulaSTRING
weekWeekformulaSTRING
year_quarterYear quarterformulaSTRING
monthYear monthSTRING

Lists (audiences)

report_type: lists · 21 metrics · 49 dimensions
Metrics
Field nameLabelType
double_optinDouble optinNUMBER
email_type_optionEmail typeNUMBER
has_welcomeHas welcome?NUMBER
list_ratingList ratingNUMBER
marketing_permissionsList marketing permissionsNUMBER
modulesList modulesNUMBER
stats_avg_sub_rateList average subscribe rateNUMBER
stats_avg_unsub_rateList average unsubscribe rateNUMBER
stats_campaign_countList campaign countNUMBER
stats_cleaned_countList cleaned countNUMBER
stats_cleaned_count_since_sendList cleaned count since sendNUMBER
stats_click_rateClick rate (lists)NUMBER
stats_member_countList member countNUMBER
stats_member_count_since_sendList member count since sendNUMBER
stats_merge_field_countList merge field countNUMBER
stats_open_rateOpen rate (lists)NUMBER
stats_target_sub_rateList target subscription rateNUMBER
stats_unsubscribe_countList unsubscribe countNUMBER
stats_unsubscribe_count_since_sendList unsubscribe count since sendNUMBER
unread_messagesUnread messagesNUMBER
use_archive_barList use archive barNUMBER
Dimensions (first 20 shown; 49 total)
Field nameLabelType
configNameEntity nameSTRING
account_idAccount IDNUMBER
beamer_addressBeamer addressSTRING
campaign_defaults_from_emailCampaign default from emailSTRING
campaign_defaults_from_nameCampaign default from nameSTRING
campaign_defaults_languageCampaign default languageSTRING
campaign_defaults_subjectCampaign default subjectSTRING
contact_address1Contact addressSTRING
contact_address2Contact address 2STRING
contact_cityContact citySTRING
contact_companyContact companySTRING
contact_countryContact countrySTRING
contact_phoneContact phoneSTRING
contact_stateContact stateSTRING
contact_zipContact zipSTRING
dataFreshnessData freshnessSTRING
date_createdList date createdSTRING
dayDateSTRING
list_idList IDSTRING
nameList nameSTRING
SubscriptionPMA subscription IDSTRING
TrialPMA trial statusSTRING
PaymentPMA payment URLSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING
isInterpolatedPMA is interpolated?BOOLEAN
dataSourceData sourceSTRING
dataSourceLogoData source logoSTRING
executionIdFunction execution IDSTRING
dataPlatformData platformSTRING

Customer journeys

report_type: customer_journeys · 26 metrics · 57 dimensions
Metrics
Field nameLabelType
automation_emails_sentSentNUMBER
delivery_status_enabledDelivery status enabledNUMBER
needs_block_refreshNeeds block refreshNUMBER
recipients_list_is_activeRecipients list is activeNUMBER
recipients_recipient_countSuccessful deliveriesNUMBER
report_summary_clicksTotal clicks (automations)NUMBER
report_summary_ecommerce_total_ordersTotal orders (journeys)NUMBER
report_summary_ecommerce_total_revenueTotal revenue (journeys)NUMBER
report_summary_ecommerce_total_spentTotal spent (journeys)NUMBER
report_summary_opensTotal opens (automations)NUMBER
report_summary_subscriber_clicksSubscriber clicksNUMBER
report_summary_unique_opensUnique opensNUMBER
resendableResendableNUMBER
settings_authenticateSettings authenticateNUMBER
settings_auto_footerSettings auto footerNUMBER
settings_auto_tweetSettings auto tweetNUMBER
settings_drag_and_dropSettings drag and dropNUMBER
settings_fb_commentsSettings FB commentsNUMBER
settings_inline_cssSettings inline CSSNUMBER
settings_timewarpSettings timewarpNUMBER
settings_use_conversationSettings use conversationNUMBER
tracking_ecomm360Tracking Ecomm360NUMBER
tracking_goal_trackingTracking goal trackingNUMBER
tracking_html_clicksTracking HTML clicksNUMBER
tracking_opensTracking opensNUMBER
tracking_text_clicksTracking text clicksNUMBER
Dimensions
Field nameLabelType
configNameEntity nameSTRING
account_idAccount IDNUMBER
archive_urlArchive URLSTRING
content_typeContent typeSTRING
create_timeCreate timeSTRING
customer_journey_idJourney IDNUMBER
dataFreshnessData freshnessSTRING
dayDateSTRING
email_idEmail IDSTRING
long_archive_urlLong archive URLSTRING
recipients_list_idRecipients list IDSTRING
recipients_list_nameAudienceSTRING
send_timeDeliveredSTRING
settings_from_nameSettings from nameSTRING
settings_preview_textCampaign preview textSTRING
settings_reply_toSettings reply toSTRING
settings_subject_lineSubject (automation)STRING
settings_template_idSettings template IDNUMBER
settings_titleWorkflowSTRING
settings_to_nameSettings to nameSTRING
SubscriptionPMA subscription IDSTRING
TrialPMA trial statusSTRING
PaymentPMA payment URLSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING
isInterpolatedPMA is interpolated?BOOLEAN
dataSourceData sourceSTRING
dataSourceLogoData source logoSTRING
executionIdFunction execution IDSTRING
dataPlatformData platformSTRING

Automations

report_type: automations · 21 metrics · 42 dimensions
Metrics
Field nameLabelType
report_summary_open_rateOpen rateformulaNUMBER
report_summary_click_rateClick rateformulaNUMBER
automation_emails_sentSentNUMBER
recipients_list_is_activeRecipients list is activeNUMBER
report_summary_clicksTotal clicks (automations)NUMBER
report_summary_opensTotal opens (automations)NUMBER
report_summary_subscriber_clicksSubscriber clicksNUMBER
report_summary_unique_opensUnique opensNUMBER
settings_authenticateSettings authenticateNUMBER
settings_auto_footerSettings auto footerNUMBER
settings_inline_cssSettings inline CSSNUMBER
settings_use_conversationSettings use conversationNUMBER
tracking_capsule_notesTracking Capsule notesNUMBER
tracking_ecomm360Tracking Ecomm360NUMBER
tracking_goal_trackingTracking goal trackingNUMBER
tracking_html_clicksTracking HTML clicksNUMBER
tracking_opensTracking opensNUMBER
tracking_salesforce_campaignTracking Salesforce campaignNUMBER
tracking_salesforce_notesTracking Salesforce notesNUMBER
tracking_text_clicksTracking text clicksNUMBER
trigger_settings_workflow_emails_countTrigger settings workflow emails countNUMBER
Dimensions
Field nameLabelType
configNameEntity nameSTRING
account_idAccount IDNUMBER
automation_idAutomation IDSTRING
create_timeCreate timeSTRING
dataFreshnessData freshnessSTRING
dayDateSTRING
recipients_list_idRecipients list IDSTRING
recipients_list_nameAudienceSTRING
recipients_segment_opts_matchRecipients segment options matchSTRING
recipients_segment_opts_saved_segment_idRecipients segment options saved segment IDNUMBER
recipients_store_idRecipients store IDSTRING
settings_from_nameSettings from nameSTRING
settings_reply_toSettings reply toSTRING
settings_titleWorkflowSTRING
settings_to_nameSettings to nameSTRING
start_timeAutomations start timeSTRING
statusAutomation statusSTRING
tracking_clicktaleTracking ClicktaleSTRING
tracking_google_analyticsTracking Google AnalyticsSTRING
trigger_settings_runtime_daysTrigger settings runtime daysSTRING
SubscriptionPMA subscription IDSTRING
TrialPMA trial statusSTRING

Unsubscribes

report_type: unsubscribes · 1 metric · 27 dimensions
Metrics
Field nameLabelType
unsubscribes_countCountformulaNUMBER
Dimensions
Field nameLabelType
configNameEntity nameSTRING
account_idAccount IDNUMBER
campaign_idCampaign IDSTRING
dataFreshnessData freshnessSTRING
dayDateSTRING
emailUnsubscribe emailSTRING
list_idList IDSTRING
reasonReasonSTRING
SubscriptionPMA subscription IDSTRING
TrialPMA trial statusSTRING
PaymentPMA payment URLSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING
isInterpolatedPMA is interpolated?BOOLEAN
dataSourceData sourceSTRING
dataSourceLogoData source logoSTRING
executionIdFunction execution IDSTRING
dataPlatformData platformSTRING
yearYearformulaSTRING
quarterQuarterformulaSTRING

Automation emails

report_type: automation_emails · 25 metrics · 67 dimensions
Metrics
Field nameLabelType
report_summary_open_rateOpen rateformulaNUMBER
report_summary_click_rateClick rateformulaNUMBER
automation_emails_sentSentNUMBER
delay_amountDelay amountNUMBER
has_logo_merge_tagHas logo merge tagNUMBER
needs_block_refreshNeeds block refreshNUMBER
positionAutomation positionNUMBER
recipients_list_is_activeRecipients list is activeNUMBER
recipients_recipient_countSuccessful deliveriesNUMBER
report_summary_clicksTotal clicks (automations)NUMBER
report_summary_opensTotal opens (automations)NUMBER
report_summary_subscriber_clicksSubscriber clicksNUMBER
report_summary_unique_opensUnique opensNUMBER
settings_authenticateSettings authenticateNUMBER
settings_auto_footerSettings auto footerNUMBER
settings_auto_tweetSettings auto tweetNUMBER
settings_drag_and_dropSettings drag and dropNUMBER
settings_fb_commentsSettings FB commentsNUMBER
settings_inline_cssSettings inline CSSNUMBER
tracking_ecomm360Tracking Ecomm360NUMBER
tracking_goal_trackingTracking goal trackingNUMBER
tracking_html_clicksTracking HTML clicksNUMBER
tracking_opensTracking opensNUMBER
tracking_text_clicksTracking text clicksNUMBER
trigger_settings_workflow_emails_countTrigger settings workflow emails countNUMBER
Dimensions
Field nameLabelType
configNameEntity nameSTRING
_linksAutomation linksSTRING
account_idAccount IDNUMBER
archive_urlArchive URLSTRING
automation_idAutomation IDSTRING
content_typeContent typeSTRING
create_timeCreate timeSTRING
dataFreshnessData freshnessSTRING
dayDateSTRING
delay_actionDelay actionSTRING
delay_action_descriptionDelay action descriptionSTRING
delay_directionDelay directionSTRING
delay_full_descriptionDelay full descriptionSTRING
delay_typeDelay typeSTRING
email_idEmail IDSTRING
recipients_list_idRecipients list IDSTRING
recipients_list_nameAudienceSTRING
recipients_segment_opts_matchRecipients segment options matchSTRING
recipients_segment_opts_saved_segment_idRecipients segment options saved segment IDNUMBER
recipients_segment_textRecipients segment textSTRING
SubscriptionPMA subscription IDSTRING
TrialPMA trial statusSTRING
PaymentPMA payment URLSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING

List growth

report_type: list_growth · 10 metrics · 16 dimensions
Metrics
Field nameLabelType
cleanedCleanedNUMBER
deletedDeletedNUMBER
existingExistingNUMBER
importsImportsNUMBER
optinsOpt-insNUMBER
pendingPendingNUMBER
reconfirmReconfirmNUMBER
stats_member_countList member countNUMBER
transactionalTransactionalNUMBER
unsubscribedUnsubscribedNUMBER
Dimensions
Field nameLabelType
configNameEntity nameSTRING
account_idAccount IDNUMBER
dataFreshnessData freshnessSTRING
list_idList IDSTRING
monthYear monthSTRING
nameList nameSTRING
SubscriptionPMA subscription IDSTRING
TrialPMA trial statusSTRING
PaymentPMA payment URLSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING
isInterpolatedPMA is interpolated?BOOLEAN
dataSourceData sourceSTRING
dataSourceLogoData source logoSTRING
executionIdFunction execution IDSTRING
dataPlatformData platformSTRING

Campaign dimensions

report_type: campaigns_dimensions · 3 metrics · 42 dimensions
Metrics
Field nameLabelType
can_resend_to_new_subscribersCan resend to new subscribersNUMBER
needs_block_refreshNeeds block refreshNUMBER
resendableResendableNUMBER
Dimensions
Field nameLabelType
configNameEntity nameSTRING
account_idAccount IDNUMBER
archive_urlArchive URLSTRING
campaign_idCampaign IDSTRING
campaign_titleCampaign titleSTRING
content_typeContent typeSTRING
create_timeCreate timeSTRING
dataFreshnessData freshnessSTRING
from_nameFrom nameSTRING
long_archive_urlLong archive URLSTRING
parent_campaign_idParent campaign IDSTRING
preview_textPreview textSTRING
reply_toReply toSTRING
send_timeDeliveredSTRING
statusAutomation statusSTRING
subject_lineSubject (campaigns)STRING
tracking_clicktaleTracking ClicktaleSTRING
tracking_google_analyticsTracking Google AnalyticsSTRING
typeCampaign typeSTRING
web_idWeb IDNUMBER
SubscriptionPMA subscription IDSTRING
TrialPMA trial statusSTRING

Landing pages

report_type: landing_pages · 8 metrics · 34 dimensions
Metrics
Field nameLabelType
conversion_rateConversion rateformulaNUMBER
clicksClicks (landing pages)NUMBER
ecommerce_average_order_revenueAverage order revenueNUMBER
ecommerce_total_ordersOrdersNUMBER
ecommerce_total_revenueTotal order revenueNUMBER
subscribesSubscribesNUMBER
unique_visitsUnique visitsNUMBER
visitsVisitsNUMBER
Dimensions
Field nameLabelType
configNameEntity nameSTRING
account_idAccount IDNUMBER
dataFreshnessData freshnessSTRING
dayDateSTRING
ecommerce_currency_codeEcommerce currency codeSTRING
landing_page_idLanding page IDSTRING
landing_page_nameLanding page nameSTRING
list_idList IDSTRING
list_nameCampaign list nameSTRING
published_atPublish dateSTRING
statusAutomation statusSTRING
titlePage titleSTRING
unpublished_atUnpublished atSTRING
urlURLSTRING
web_idWeb IDNUMBER
SubscriptionPMA subscription IDSTRING
TrialPMA trial statusSTRING
PaymentPMA payment URLSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING

Members

report_type: members · 9 metrics · 48 dimensions
Metrics
Field nameLabelType
consents_to_one_to_one_messagingConsents to one-to-one messagingNUMBER
last_note_created_byLast note created byNUMBER
member_ratingMember ratingNUMBER
stats_avg_click_rateStats avg click rateNUMBER
stats_avg_open_rateStats avg open rateNUMBER
stats_ecommerce_data_number_of_ordersStats ecommerce data number of ordersNUMBER
stats_ecommerce_data_total_revenueStats ecommerce data total revenueNUMBER
tags_countTags countNUMBER
vipVIPNUMBER
Dimensions
Field nameLabelType
configNameEntity nameSTRING
account_idAccount IDNUMBER
contact_idContact IDSTRING
dataFreshnessData freshnessSTRING
dayDateSTRING
email_addressMember email addressSTRING
email_clientEmail clientSTRING
email_typeEmail typeSTRING
full_nameFull nameSTRING
ip_optIP optSTRING
ip_signupIP signupSTRING
languageLanguageSTRING
last_note_created_atLast note created atSTRING
last_note_noteLast note noteSTRING
last_note_note_idLast note note IDNUMBER
list_idList IDSTRING
member_idMember IDSTRING
sms_phone_numberSMS phone numberSTRING
sms_subscription_last_updatedSMS subscription last updatedSTRING
sms_subscription_statusSMS subscription statusSTRING
SubscriptionPMA subscription IDSTRING
TrialPMA trial statusSTRING
PaymentPMA payment URLSTRING
MinDatePMA minimum cached data dateSTRING
MaxDatePMA maximum cached data dateSTRING