ActiveCampaign

Campaigns

report_type: campaigns · 32 metrics · 37 dimensions

Metrics

Field name	Label	Type
`open_rate`	Open rateformula	NUMBER
`click_rate`	Click rateformula	NUMBER
`click_to_open_rate`	Click to open rateformula	NUMBER
`Unsubscribes_rate`	Unsubscribe rateformula	NUMBER
`Forward_rate`	Forward rateformula	NUMBER
`bounced_rate`	Bounced rateformula	NUMBER
`num_of_campaigns`	Sendsformula	NUMBER
`total_bounces`	Total bouncesformula	NUMBER
`automation`	Automation sends	NUMBER
`facebook`	Facebook shares	NUMBER
`forwards`	Forwards	NUMBER
`hardbounces`	Hard bounces (campaigns)	NUMBER
`ip`	Contact IP	NUMBER
`ip4`	Contact IPv4	NUMBER
`linkclicks`	Clicks	NUMBER
`mail_send`	Mail send	NUMBER
`mail_transfer`	Mail transfer	NUMBER
`mailer_log_file`	Mailer log file	NUMBER
`opens`	Opens	NUMBER
`replies`	Replies	NUMBER
`send_amt`	Sends	NUMBER
`socialshares`	Social shares	NUMBER
`softbounces`	Soft bounces (campaigns)	NUMBER
`subscriberclicks`	Subscriber clicks	NUMBER
`tweet`	Twitter mentions	NUMBER
`uniqueforwards`	Unique forwards	NUMBER
`uniquelinkclicks`	Unique link clicks	NUMBER
`uniqueopens`	Unique opens	NUMBER
`uniquereplies`	Unique replies	NUMBER
`unsubreasons`	Unsub reasons	NUMBER
`unsubscribes`	Unsubscribes	NUMBER
`updated_by`	Updated by	NUMBER

Dimensions

Field name	Label	Type
`configName`	Entity name	STRING
`account_id`	Account ID	STRING
`analytics_campaign_name`	Analytics campaign name	STRING
`campaign_id`	Campaign ID	NUMBER
`campaign_name`	Campaign name	STRING
`cdate`	Created date	STRING
`created_timestamp`	Created timestamp	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`laststep`	Last step	STRING
`mdate`	Last modified date	STRING
`sdate`	Last sent date and time	STRING
`status`	Status	STRING
`type`	Type	STRING
`updated_timestamp`	Updated timestamp	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
`day`	Date	STRING
`segmentname`	Segment name	STRING
`listname`	List name	STRING
`listid`	List ID	NUMBER
`fromname`	From name	STRING
`fromemail`	From email	STRING

Contacts

report_type: contacts · 6 metrics · 45 dimensions

Metrics

Field name	Label	Type
`num_of_contacts`	Contacts addedformula	NUMBER
`bounced_hard`	Hard bounces (contacts)	NUMBER
`bounced_soft`	Soft bounces (contacts)	NUMBER
`ip`	Contact IP	NUMBER
`sentcnt`	Sent to contact	NUMBER
`updated_by`	Updated by	NUMBER

Dimensions

Field name	Label	Type
`configName`	Entity name	STRING
`contact_full_name`	Contact full nameformula	STRING
`accountContacts`	Account contacts	STRING
`account_id`	Account ID	STRING
`adate`	Add date	STRING
`bounced_date`	Bounced date	STRING
`contact_id`	Contact ID	STRING
`created_timestamp`	Created timestamp	STRING
`created_utc_timestamp`	Created UTC timestamp	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`email`	Email	STRING
`email_domain`	Email domain	STRING
`firstName`	First name	STRING
`lastName`	Last name	STRING
`last_click_date`	Last click date	STRING
`last_open_date`	Last open date	STRING
`organization_id`	Organisation ID	STRING
`organization_name`	Organisation name	STRING
`phone`	Phone	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
`status`	Status	STRING
`updated_timestamp`	Updated timestamp	STRING
`edate`	Engagement date	STRING
`udate`	Updated date	STRING
`rating`	Contact rating	NUMBER
`score`	Contact score	NUMBER
`gravatar`	Gravatar	STRING
`city`	City	STRING
`state`	State	STRING
`zip`	Zip	STRING
`country`	Country	STRING
`list_id`	List ID	STRING
`list_name`	List name	STRING
`tags`	Tags	STRING
`year`	Yearformula	STRING

Deals

report_type: deals · 5 metrics · 38 dimensions

Metrics

Field name	Label	Type
`Average_deal_value`	Average deal valueformula	NUMBER
`num_of_deals`	Number of dealsformula	NUMBER
`deals_won`	Deals wonformula	NUMBER
`deals_lost`	Deals lostformula	NUMBER
`dealValue`	Deal value	NUMBER

Dimensions

Field name	Label	Type
`configName`	Entity name	STRING
`account_id`	Account ID	STRING
`cdate`	Created date	STRING
`contact_id`	Contact ID	STRING
`currency`	Currency	STRING
`dataFreshness`	Data freshness	STRING
`date`	Date and time	STRING
`deal_id`	Deal ID	STRING
`deal_status`	Deal status	STRING
`description`	Description	STRING
`mdate`	Last modified date	STRING
`owner`	Deal owner	STRING
`owner_id`	Owner ID	NUMBER
`stage_id`	Stage ID	NUMBER
`status`	Status	STRING
`title`	Deal 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
`year`	Yearformula	STRING
`quarter`	Quarterformula	STRING
`week`	Weekformula	STRING
`year_quarter`	Year quarterformula	STRING
`month`	Year month	STRING
`day`	Date	STRING
`group_id`	Group ID (pipeline)	NUMBER
`pipeline_title`	Pipeline title	STRING
`deal_stage`	Deal stage	STRING
`edate`	Expected close date	STRING
`contact_name`	Contact name	STRING
`organization_name`	Organisation name	STRING

Groups and stages

report_type: groupsAndStages · 0 metrics · 11 dimensions

Dimensions

Field name	Label	Type
`configName`	Entity 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

Groups dimensions

report_type: groups_dimensions · 0 metrics · 14 dimensions

Dimensions

Field name	Label	Type
`configName`	Entity name	STRING
`account_id`	Account ID	STRING
`dataFreshness`	Data freshness	STRING
`deals_pipeline_title`	Deals pipeline title	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

Stages dimensions

report_type: stages_dimensions · 0 metrics · 15 dimensions

Dimensions

Field name	Label	Type
`configName`	Entity name	STRING
`account_id`	Account ID	STRING
`dataFreshness`	Data freshness	STRING
`deal_stage`	Deal stage	STRING
`stage_id`	Stage 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
`isInterpolated`	PMA is interpolated?	BOOLEAN
`dataSource`	Data source	STRING
`dataSourceLogo`	Data source logo	STRING
`executionId`	Function execution ID	STRING
`dataPlatform`	Data platform	STRING

Messages

report_type: messages · 0 metrics · 15 dimensions

Dimensions

Field name	Label	Type
`configName`	Entity name	STRING
`account_id`	Account ID	STRING
`dataFreshness`	Data freshness	STRING
`from_email`	From email	STRING
`subject`	Subject	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

Account contacts

report_type: account_contacts · 0 metrics · 15 dimensions

Dimensions

Field name	Label	Type
`configName`	Entity name	STRING
`account_id`	Account ID	STRING
`contact_id`	Contact ID	STRING
`dataFreshness`	Data freshness	STRING
`job_title`	Job title	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

All ActiveCampaign data via PMA

No native MCP

No native MCP

Every queryable field in PMA

Campaigns

Contacts

Deals

Groups and stages

Groups dimensions

Stages dimensions

Messages

Account contacts