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