ActiveCampaign Connector Reference

This connector fetches data from ActiveCampaign on a address, automation, campaign, contact, deal and message level. The ActiveCampaign connector also supports custom fields.

Custom fields and objects supported in ActiveCampaign

The Windsor.ai ActiveCampaign connector pulls both the standard ActiveCampaign objects and any custom fields you
have defined on Contacts and Deals. There’s no manual setup required for the custom fields. They appear
automatically in the field list once your account is connected.

Standard objects

The following ActiveCampaign objects (API resources) are queryable as tables:

– Accounts — CRM accounts/companies
– Addresses — sender addresses used by campaigns
– Automations — automation workflows and their status
– Campaigns — email campaigns, including send/open/click stats
– Contacts — contacts and their standard fields
– Deals — deals (opportunities) in the CRM pipeline
– Deal Stages — stages in your deal pipelines
– Deal Tasks — tasks attached to deals
– Lists — contact lists
– Messages — message templates used in campaigns
– Users — ActiveCampaign user accounts (deal owners, list owners, etc.)

Related objects are joined automatically. For example, deals are enriched with their associated account, primary
contact, stage, and owner so that you can break down deal metrics by any of those dimensions in a single query.

Custom fields on Contacts

Every custom field you have created in ActiveCampaign for contacts is exposed as a queryable field. Windsor.ai:

– Discovers them from the /fields endpoint per account
– Names each field after its title in ActiveCampaign
– Detects the type. Numeric custom fields become NUMERIC, date fields become DATE, and everything else (text,
dropdown, multi-select, etc.) is returned as TEXT

When you select a contact custom field alongside contact fields in a query, Windsor.ai fetches the corresponding
fieldValues from ActiveCampaign and joins them onto the right contact row.

Custom fields on Deals

Custom deal fields are supported the same way as contact custom fields, sourced from the /dealCustomFieldMeta
endpoint and joined onto the matching deal via dealCustomFieldData. They are also typed automatically (NUMERIC /
DATE / TEXT).

Date filtering

You can filter by created or last updated date independently on:

– Contacts — Contact creation date / Contact update date
– Deals — Deal creation date / Deal modification date

Date filters are pushed down to the ActiveCampaign API where possible, so only the matching rows are fetched.

What is not supported

The connector currently focuses on the resources listed above. ActiveCampaign objects outside that set (e.g.
notes, tags-by-contact assignments, event tracking) are not exposed as tables today. If you need one, let us know.
Most ActiveCampaign endpoints follow the same pattern and can be added.

Sample URL to retrieve address related data

https://connectors.windsor.ai/activecampaign?api_key=[API Key]&date_preset=last_7d&fields=address_address1,address_address2,address_allgroup,address_city,address_company_name,address_country,address_district,address_id,address_is_default,address_state,address_zip

Sample URL to retrieve automation related data

https://connectors.windsor.ai/activecampaign?api_key=[API Key]&date_preset=last_7d&fields=automation_cdate,automation_defaultscreenshot,automation_entered,automation_exited,automation_hidden,automation_id,automation_mdate,automation_name,automation_screenshot,automation_status,automation_userid

Sample URL to retrieve campaign related data

https://connectors.windsor.ai/activecampaign?api_key=[API Key]&date_preset=last_7d&fields=campaign,campaign_activerss_interval,campaign_activerss_items,campaign_activerss_url,campaign_addressid,campaign_analytics_campaign_name,campaign_automation,campaign_basemessageid,campaign_basetemplateid,campaign_bounceid,campaign_cdate,campaign_deletestamp,campaign_embed_images,campaign_facebook,campaign_formid,campaign_forwards,campaign_hardbounces,campaign_htmlunsub,campaign_htmlunsubdata,campaign_id,campaign_ip4,campaign_laststep,campaign_ldate,campaign_linkclicks,campaign_mail_cleanup,campaign_mail_send,campaign_mail_transfer,campaign_mailer_log_file,campaign_managetext,campaign_mdate,campaign_opens,campaign_public,campaign_realcid,campaign_recurring,campaign_reminder_field,campaign_reminder_format,campaign_reminder_last_cron_run,campaign_reminder_offset,campaign_reminder_offset_sign,campaign_reminder_offset_type,campaign_reminder_type,campaign_replies,campaign_replysys,campaign_responder_existing,campaign_responder_offset,campaign_responder_type,campaign_schedule,campaign_scheduleddate,campaign_sdate,campaign_segmentid,campaign_send_amt,campaign_sendid,campaign_seriesid,campaign_socialshares,campaign_softbounces,campaign_source,campaign_split_content,campaign_split_offset,campaign_split_offset_type,campaign_split_type,campaign_split_winner_awaiting,campaign_split_winner_messageid,campaign_status,campaign_subscriberclicks,campaign_survey,campaign_textunsub,campaign_textunsubdata,campaign_threadid,campaign_total_amt,campaign_tracklinks,campaign_tracklinksanalytics,campaign_trackreads,campaign_trackreadsanalytics,campaign_tweet,campaign_type,campaign_uniqueforwards,campaign_uniquelinkclicks,campaign_uniqueopens,campaign_uniquereplies,campaign_unsubreasons,campaign_unsubscribes,campaign_updates,campaign_user,campaign_userid,campaign_waitpreview,campaign_willrecur

Sample URL to retrieve contact related data

https://connectors.windsor.ai/activecampaign?api_key=[API Key]&date_preset=last_7d&fields=contact_adate,contact_bounced_date,contact_bounced_hard,contact_bounced_soft,contact_cdate,contact_deleted,contact_edate,contact_email,contact_email_domain,contact_email_local,contact_first_name,contact_gravatar,contact_hash,contact_id,contact_ip,contact_last_name,contact_organization,contact_orgid,contact_phone,contact_rating_tstamp,contact_segmentio_id,contact_sentcnt,contact_socialdata_lastcheck,contact_ua,contact_udate

Sample URL to retrieve deal related data

https://connectors.windsor.ai/activecampaign?api_key=[API Key]&date_preset=last_7d&fields=deal_account,deal_activitycount,deal_cdate,deal_contact,deal_currency,deal_customer_account,deal_description,deal_edate,deal_group,deal_id,deal_mdate,deal_nextdate,deal_nextdealid,deal_nexttaskid,deal_organization,deal_owner,deal_percent,deal_stage,deal_status,deal_task_assignee,deal_task_automation,deal_task_cdate,deal_task_deal_tasktype,deal_task_done_automation,deal_task_duedate,deal_task_edate,deal_task_id,deal_task_note,deal_task_outcome_info,deal_task_outcomeid,deal_task_relid,deal_task_reltype,deal_task_status,deal_task_title,deal_task_udate,deal_task_user,deal_title,deal_value,deal_win_probability,deal_win_probability_mdate

Sample URL to retrieve message related data

https://connectors.windsor.ai/activecampaign?api_key=[API Key]&date_preset=last_7d&fields=message_cdate,message_charset,message_ed_instanceid,message_ed_version,message_encoding,message_format,message_fromemail,message_fromname,message_hidden,message_html,message_htmlfetch,message_id,message_mdate,message_name,message_preheader_text,message_preview_data,message_preview_mime,message_priority,message_reply2,message_subject,message_text,message_textfetch,message_user,message_userid