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 |