ActiveCampaign Field Reference
Sample
This connector fetches data from ActiveCampaign on a address, automation, campaign, contact, deal and message level
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
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| address_address1 | TEXT | Address address1 | Address address1 | adresses |
| address_address2 | TEXT | Address address2 | Address address2 | adresses |
| address_allgroup | TEXT | Address allgroup | Address allgroup | adresses |
| address_city | CITY | Address city | Address city | adresses |
| address_company_name | TEXT | Address company name | Address company name | adresses |
| address_country | TEXT | Address country | Address country | adresses |
| address_district | TEXT | Address district | Address district | adresses |
| address_id | TEXT | Address id | Address id | adresses |
| address_is_default | TEXT | Address is default flag | Address is default flag | adresses |
| address_state | TEXT | Address state | Address state | adresses |
| address_zip | TEXT | Address zip | Address zip | adresses |
| automation_cdate | DATE | Automation cdate | Automation creation date | automations |
| automation_defaultscreenshot | TEXT | Automation default screenshot | Automation default screenshot | automations |
| automation_entered | TEXT | Automation entered | Automation entered | automations |
| automation_exited | TEXT | Automation exited | Automation exited | automations |
| TEXT | Automation hidden | Automation hidden | automations | |
| automation_id | TEXT | Automation id | Automation id | automations |
| automation_mdate | DATE | Automation mdate | Automation modification date | automations |
| automation_name | TEXT | Automation name | Automation name | automations |
| automation_screenshot | TEXT | Automation screenshot | Automation screenshot | automations |
| automation_status | TEXT | Automation status | Automation status | automations |
| automation_userid | TEXT | Automation user id | Automation user id | automations |
| campaign | TEXT | Campaign name | Campaign name | campaigns |
| campaign_activerss_interval | TEXT | Campaign activerss interval | Campaign activerss interval | campaigns |
| campaign_activerss_items | TEXT | Campaign activerss items | Campaign activerss items | campaigns |
| campaign_activerss_url | TEXT | Campaign activerss url | Campaign activerss url | campaigns |
| campaign_addressid | TEXT | Campaign address id | Campaign address id | campaigns |
| campaign_analytics_campaign_name | TEXT | Campaign analytics_campaign_name | Campaign analytics_campaign_name | campaigns |
| campaign_automation | TEXT | Campaign automation | Campaign automation | campaigns |
| campaign_basemessageid | TEXT | Campaign base message id | Campaign base message id | campaigns |
| campaign_basetemplateid | TEXT | Campaign basetemplate id | Campaign basetemplate id | campaigns |
| campaign_bounceid | TEXT | Campaign bounce id | Campaign bounce id | campaigns |
| campaign_cdate | DATE | Campaign cdate | Campaign creation date | campaigns |
| campaign_deletestamp | TEXT | Campaign deletestamp | Campaign deletestamp | campaigns |
| campaign_embed_images | TEXT | Campaign embed_images | Campaign embed_images | campaigns |
| campaign_facebook | TEXT | Campaign facebook | Campaign facebook | campaigns |
| campaign_formid | TEXT | Campaign form id | Campaign form id | campaigns |
| campaign_forwards | NUMERIC | Campaign forwards | Campaign forwards | campaigns |
| campaign_hardbounces | NUMERIC | Campaign hard bounces | Campaign hard bounces | campaigns |
| campaign_htmlunsub | NUMERIC | Campaign html unsub | Campaign html unsub | campaigns |
| campaign_htmlunsubdata | TEXT | Campaign html unsub data | Campaign html unsub data | campaigns |
| campaign_id | TEXT | Campaign id | Campaign id | campaigns |
| campaign_ip4 | TEXT | Campaign ip4 | Campaign ip4 | campaigns |
| campaign_laststep | TEXT | Campaign last step | Campaign last step | campaigns |
| campaign_ldate | DATE | Campaign ldate | Campaign ldate | campaigns |
| campaign_linkclicks | NUMERIC | Campaign link clicks | Campaign link clicks | campaigns |
| campaign_mail_cleanup | TEXT | Campaign mail_cleanup | Campaign mail_cleanup | campaigns |
| campaign_mail_send | TEXT | Campaign mail_send | Campaign mail_send | campaigns |
| campaign_mail_transfer | TEXT | Campaign mail transfer | Campaign mail transfer | campaigns |
| campaign_mailer_log_file | TEXT | Campaign mailer_log_file | Campaign mailer_log_file | campaigns |
| campaign_managetext | TEXT | Campaign manage text | Campaign manage text | campaigns |
| campaign_mdate | DATE | Campaign mdate | Campaign modification date | campaigns |
| campaign_opens | NUMERIC | Campaign opens | Campaign opens | campaigns |
| campaign_public | TEXT | Campaign public | Campaign public | campaigns |
| campaign_realcid | TEXT | Campaign realcid | Campaign realcid | campaigns |
| campaign_recurring | TEXT | Campaign recurring | Campaign recurring | campaigns |
| campaign_reminder_field | TEXT | Campaign reminder field | Campaign reminder field | campaigns |
| campaign_reminder_format | TEXT | Campaign reminder format | Campaign reminder format | campaigns |
| campaign_reminder_last_cron_run | TEXT | Campaign reminder last cron run | Campaign reminder last cron run | campaigns |
| campaign_reminder_offset | TEXT | Campaign reminder offset | Campaign reminder offset | campaigns |
| campaign_reminder_offset_sign | TEXT | Campaign reminder offset sign | Campaign reminder offset sign | campaigns |
| campaign_reminder_offset_type | TEXT | Campaign reminder offset type | Campaign reminder offset type | campaigns |
| campaign_reminder_type | TEXT | Campaign reminder type | Campaign reminder type | campaigns |
| campaign_replies | NUMERIC | Campaign replies | Campaign replies | campaigns |
| campaign_replysys | TEXT | Campaign replysys | Campaign replysys | campaigns |
| campaign_responder_existing | TEXT | Campaign responder existing | Campaign responder existing | campaigns |
| campaign_responder_offset | TEXT | Campaign responder offset | Campaign responder offset | campaigns |
| campaign_responder_type | TEXT | Campaign responder type | Campaign responder type | campaigns |
| campaign_schedule | TEXT | Campaign schedule | Campaign schedule | campaigns |
| campaign_scheduleddate | DATE | Campaign scheduled date | Campaign scheduled date | campaigns |
| campaign_sdate | DATE | Campaign sdate | Campaign sdate | campaigns |
| campaign_segmentid | TEXT | Campaign segment id | Campaign segment id | campaigns |
| campaign_send_amt | NUMERIC | Campaign send_amt | Campaign send_amt | campaigns |
| campaign_sendid | TEXT | Campaign send id | Campaign send id | campaigns |
| campaign_seriesid | TEXT | Campaign series id | Campaign series id | campaigns |
| campaign_socialshares | NUMERIC | Campaign social shares | Campaign social shares | campaigns |
| campaign_softbounces | NUMERIC | Campaign soft bounces | Campaign soft bounces | campaigns |
| campaign_source | TEXT | Campaign source | Campaign source | campaigns |
| campaign_split_content | TEXT | Campaign split content | Campaign split content | campaigns |
| campaign_split_offset | TEXT | Campaign split offset | Campaign split offset | campaigns |
| campaign_split_offset_type | TEXT | Campaign split offset type | Campaign split offset type | campaigns |
| campaign_split_type | TEXT | Campaign split type | Campaign split type | campaigns |
| campaign_split_winner_awaiting | TEXT | Campaign split winner awaiting | Campaign split winner awaiting | campaigns |
| campaign_split_winner_messageid | TEXT | Campaign split winner message id | Campaign split winner message id | campaigns |
| campaign_status | TEXT | Campaign status | Campaign status | campaigns |
| campaign_subscriberclicks | NUMERIC | Campaign subscriber clicks | Campaign subscriber clicks | campaigns |
| campaign_survey | TEXT | Campaign survey | Campaign survey | campaigns |
| campaign_textunsub | NUMERIC | Campaign text unsub | Campaign text unsub | campaigns |
| campaign_textunsubdata | TEXT | Campaign text unsub data | Campaign text unsub data | campaigns |
| campaign_threadid | TEXT | Campaign thread id | Campaign thread id | campaigns |
| campaign_total_amt | NUMERIC | Campaign total_amt | Campaign total_amt | campaigns |
| campaign_tracklinks | TEXT | Campaign track links | Campaign track links | campaigns |
| campaign_tracklinksanalytics | TEXT | Campaign track links analytics | Campaign track links analytics | campaigns |
| campaign_trackreads | TEXT | Campaign track reads | Campaign track reads | campaigns |
| campaign_trackreadsanalytics | TEXT | Campaign track reads analytics | Campaign track reads analytics | campaigns |
| campaign_tweet | TEXT | Campaign tweet | Campaign tweet | campaigns |
| campaign_type | TEXT | ActiveCampaign campaign type | ActiveCampaign campaign type | campaigns |
| campaign_uniqueforwards | NUMERIC | Campaign unique forwards | Campaign unique forwards | campaigns |
| campaign_uniquelinkclicks | NUMERIC | Campaign unique link clicks | Campaign unique link clicks | campaigns |
| campaign_uniqueopens | NUMERIC | Campaign unique opens | Campaign unique opens | campaigns |
| campaign_uniquereplies | NUMERIC | Campaign unique replies | Campaign unique replies | campaigns |
| campaign_unsubreasons | NUMERIC | Campaign unsub reasons | Campaign unsub reasons | campaigns |
| campaign_unsubscribes | NUMERIC | Campaign unsubscribes | Campaign unsubscribes | campaigns |
| campaign_updates | DATE | Campaign updates | Campaign updates | campaigns |
| campaign_user | TEXT | Campaign user | Campaign user | campaigns |
| campaign_userid | TEXT | Campaign user id | Campaign user id | campaigns |
| campaign_waitpreview | TEXT | Campaign waitpreview | Campaign waitpreview | campaigns |
| campaign_willrecur | TEXT | Campaign willrecur | Campaign willrecur | campaigns |
| contact_adate | DATE | Contact adate | Contact adate | contacts |
| contact_bounced_date | DATE | Contact bounced date | Contact bounced date | contacts |
| contact_bounced_hard | TEXT | Contact bounced hard | Contact bounced hard | contacts |
| contact_bounced_soft | TEXT | Contact bounced soft | Contact bounced soft | contacts |
| contact_cdate | DATE | Contact cdate | Contact creation date | contacts |
| contact_deleted | TEXT | Contact deleted | Contact deleted | contacts |
| contact_edate | DATE | Contact edate | Contact edate | contacts |
| contact_email | TEXT | Contact email | Contact email | contacts |
| contact_email_domain | TEXT | Contact email domain | Contact email domain | contacts |
| contact_email_local | TEXT | Contact email local | Contact email local | contacts |
| contact_first_name | TEXT | Contact first name | Contact first name | contacts |
| contact_gravatar | TEXT | Contact gravatar | Contact gravatar | contacts |
| contact_hash | TEXT | Contact hash | Contact hash | contacts |
| contact_id | TEXT | Contact id | Contact id | contacts |
| contact_ip | TEXT | Contact ip | Contact ip | contacts |
| contact_last_name | TEXT | Contact last name | Contact last name | contacts |
| contact_organization | TEXT | Contact organization | Contact organization | contacts |
| contact_orgid | TEXT | Contact orgid | Contact orgid | contacts |
| contact_phone | TEXT | Contact phone | Contact phone | contacts |
| contact_rating_tstamp | TEXT | Contact rating_tstamp | Contact rating_tstamp | contacts |
| contact_segmentio_id | TEXT | Contact segmentio_id | Contact segmentio_id | contacts |
| contact_sentcnt | NUMERIC | Contact sentcnt | Contact sentcnt | contacts |
| contact_socialdata_lastcheck | TEXT | Contact socialdata_lastcheck | Contact socialdata_lastcheck | contacts |
| contact_ua | TEXT | Contact ua | Contact ua | contacts |
| contact_udate | DATE | Contact udate | Contact update date | contacts |
| deal_account | TEXT | Deal account | Deal account | deals |
| deal_activitycount | NUMERIC | Deal activity count | Deal activity count | deals |
| deal_cdate | DATE | Deal cdate | Deal creation date | deals |
| deal_contact | TEXT | Deal contact | Deal contact | deals |
| deal_currency | TEXT | Deal currency | Deal currency | deals |
| deal_customer_account | TEXT | Deal customer account | Deal customer account | deals |
| deal_description | TEXT | Deal description | Deal description | deals |
| deal_edate | DATE | Deal edate | Deal edate | deals |
| deal_group | TEXT | Deal group | Deal group | deals |
| deal_id | TEXT | Deal id | Deal id | deals |
| deal_mdate | DATE | Deal mdate | Deal modification date | deals |
| deal_nextdate | DATE | Deal next date | Deal next date | deals |
| deal_nextdealid | TEXT | Deal next deal id | Deal next deal id | deals |
| deal_nexttaskid | TEXT | Deal next task id | Deal next task id | deals |
| deal_organization | TEXT | Deal organization | Deal organization | deals |
| deal_owner | TEXT | Deal owner | Deal owner | deals |
| deal_percent | PERCENT | Deal percent | Deal percent | deals |
| deal_stage | TEXT | Deal stage | Deal stage | deals |
| deal_status | TEXT | Deal status | Deal status | deals |
| deal_task_assignee | TEXT | Deal task assignee | Deal task assignee | deal_tasks |
| deal_task_automation | TEXT | Deal task automation | Deal task automation | deal_tasks |
| deal_task_cdate | DATE | Deal task cdate | Deal task creation date | deal_tasks |
| deal_task_deal_tasktype | TEXT | Deal task type | Deal task type | deal_tasks |
| deal_task_done_automation | TEXT | Deal task done automation | Deal task done automation | deal_tasks |
| deal_task_duedate | DATE | Deal task due date | Deal task due date | deal_tasks |
| deal_task_edate | DATE | Deal task edate | Deal task edate | deal_tasks |
| deal_task_id | TEXT | Deal task id | Deal task id | deal_tasks |
| deal_task_note | TEXT | Deal task note | Deal task note | deal_tasks |
| deal_task_outcome_info | TEXT | Deal task outcome info | Deal task outcome info | deal_tasks |
| deal_task_outcomeid | TEXT | Deal task outcome id | Deal task outcome id | deal_tasks |
| deal_task_relid | TEXT | Deal task relid | Deal task relid | deal_tasks |
| deal_task_reltype | TEXT | Deal task reltype | Deal task reltype | deal_tasks |
| deal_task_status | TEXT | Deal task status | Deal task status | deal_tasks |
| deal_task_title | TEXT | Deal task title | Deal task title | deal_tasks |
| deal_task_udate | DATE | Deal task udate | Deal task update date | deal_tasks |
| deal_task_user | TEXT | Deal task user | Deal task user | deal_tasks |
| deal_title | TEXT | Deal title | Deal title | deals |
| deal_value | NUMERIC | Deal value | Deal value | deals |
| deal_win_probability | NUMERIC | Deal win probability | Deal win probability | deals |
| deal_win_probability_mdate | DATE | Deal win probability mdate | Deal win probability mdate | deals |
| list_analytics_domains | TEXT | List analytics_domains | List analytics_domains | lists |
| list_analytics_source | TEXT | List analytics_source | List analytics_source | lists |
| list_analytics_ua | TEXT | List analytics_ua | List analytics_ua | lists |
| list_carboncopy | TEXT | List carboncopy | List carboncopy | lists |
| list_cdate | DATE | List cdate | List creation date | lists |
| list_deletestamp | TEXT | List deletestamp | List deletestamp | lists |
| list_facebook_session | TEXT | List facebook session | List facebook session | lists |
| list_fulladdress | TEXT | List full address | List full address | lists |
| list_get_unsubscribe_reason | TEXT | List get_unsubscribe_reason | List get_unsubscribe_reason | lists |
| list_id | TEXT | List id | List id | lists |
| list_name | TEXT | List name | List name | lists |
| list_optinmessageid | TEXT | List optinmessageid | List optinmessageid | lists |
| list_optinoptout | TEXT | List optin optout | List optin optout | lists |
| list_optoutconf | TEXT | List optout conf | List optout conf | lists |
| list_p_embed_image | TEXT | List p_embed_image | List p_embed_image | lists |
| list_p_use_analytics_link | TEXT | List p_use_analytics_link | List p_use_analytics_link | lists |
| list_p_use_analytics_read | TEXT | List p_use_analytics_read | List p_use_analytics_read | lists |
| list_p_use_captcha | TEXT | List p_use_captcha | List p_use_captcha | lists |
| list_p_use_facebook | TEXT | List p_use_facebook | List p_use_facebook | lists |
| list_p_use_tracking | TEXT | List p_use_tracking | List p_use_tracking | lists |
| list_p_use_twitter | TEXT | List p_use_twitter | List p_use_twitter | lists |
| list_private | TEXT | List private | List private | lists |
| list_require_name | TEXT | List require name | List require name | lists |
| list_send_last_broadcast | TEXT | List send_last_broadcast | List send_last_broadcast | lists |
| list_sender_addr1 | TEXT | List sender addr1 | List sender addr1 | lists |
| list_sender_addr2 | TEXT | List sender addr2 | List sender addr2 | lists |
| list_sender_city | CITY | List sender city | List sender city | lists |
| list_sender_country | TEXT | List sender country | List sender country | lists |
| list_sender_name | TEXT | List sender name | List sender name | lists |
| list_sender_phone | TEXT | List sender phone | List sender phone | lists |
| list_sender_reminder | TEXT | List sender reminder | List sender reminder | lists |
| list_sender_state | TEXT | List sender state | List sender state | lists |
| list_sender_url | TEXT | List sender url | List sender url | lists |
| list_sender_zip | TEXT | List sender zip | List sender zip | lists |
| list_stringid | TEXT | List string id | List string id | lists |
| list_subscription_notify | TEXT | List subscription_notify | List subscription_notify | lists |
| list_to_name | TEXT | List to_name | List to_name | lists |
| list_twitter_token | TEXT | List twitter_token | List twitter_token | lists |
| list_twitter_token_secret | TEXT | List twitter token secret | List twitter token secret | lists |
| list_udate | DATE | List update date | List update date | lists |
| list_unsubscription_notify | TEXT | List unsubscription notify | List unsubscription notify | lists |
| list_user | TEXT | List user | List user | lists |
| list_userid | TEXT | List user id | List user id | lists |
| message_cdate | DATE | Message cdate | Message creation date | messages |
| message_charset | TEXT | Message charset | Message charset | messages |
| message_ed_instanceid | TEXT | Message ed_instanceid | Message ed_instanceid | messages |
| message_ed_version | TEXT | Message ed_version | Message ed_version | messages |
| message_encoding | TEXT | Message encoding | Message encoding | messages |
| message_format | TEXT | Message format | Message format | messages |
| message_fromemail | TEXT | Message from email | Message from email | messages |
| message_fromname | TEXT | Message from name | Message from name | messages |
| TEXT | Message hidden | Message hidden | messages | |
| message_html | TEXT | Message html | Message html | messages |
| message_htmlfetch | TEXT | Message html fetch | Message htmlfetch | messages |
| message_id | TEXT | Message id | Message id | messages |
| message_mdate | DATE | Message mdate | Message modification date | messages |
| message_name | TEXT | Message name | Message name | messages |
| message_preheader_text | TEXT | Message preheader text | Message preheader text | messages |
| message_preview_data | TEXT | Message preview data | Message preview data | messages |
| message_preview_mime | TEXT | Message preview mime | Message preview mime | messages |
| message_priority | TEXT | Message priority | Message priority | messages |
| message_reply2 | TEXT | Message reply2 | Message reply2 | messages |
| message_subject | TEXT | Message subject | Message subject | messages |
| message_text | TEXT | Message text | Message text | messages |
| message_textfetch | TEXT | Message text fetch | Message text fetch | messages |
| message_user | TEXT | Message user | Message user | messages |
| message_userid | TEXT | Message user id | Message user id | messages |
| today | DATE | Today | Today's date |