ActiveCampaign Field Reference

Sample

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

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

IDTypeNameDescriptionReport
address_address1TEXTAddress address1Address address1adresses
address_address2TEXTAddress address2Address address2adresses
address_allgroupTEXTAddress allgroupAddress allgroupadresses
address_cityCITYAddress cityAddress cityadresses
address_company_nameTEXTAddress company nameAddress company nameadresses
address_countryCOUNTRYAddress countryAddress countryadresses
address_districtTEXTAddress districtAddress districtadresses
address_idTEXTAddress IDAddress IDadresses
address_is_defaultTEXTAddress is default flagAddress is default flagadresses
address_stateTEXTAddress stateAddress stateadresses
address_zipTEXTAddress zipAddress zipadresses
automation_cdateDATEAutomation creation dateAutomation creation dateautomations
automation_defaultscreenshotTEXTAutomation default screenshotAutomation default screenshotautomations
automation_enteredTEXTAutomation enteredAutomation enteredautomations
automation_exitedTEXTAutomation exitedAutomation exitedautomations
automation_hiddenTEXTAutomation hiddenAutomation hiddenautomations
automation_idTEXTAutomation IDAutomation IDautomations
automation_mdateDATEAutomation modification dateAutomation modification dateautomations
automation_nameTEXTAutomation nameAutomation nameautomations
automation_screenshotTEXTAutomation screenshotAutomation screenshotautomations
automation_statusTEXTAutomation statusAutomation statusautomations
automation_useridTEXTAutomation user IDAutomation user IDautomations
campaignTEXTCampaign nameCampaign namecampaigns
campaign_activerss_intervalTEXTCampaign activerss intervalCampaign activerss intervalcampaigns
campaign_activerss_itemsTEXTCampaign activerss itemsCampaign activerss itemscampaigns
campaign_activerss_urlTEXTCampaign activerss URLCampaign activerss URLcampaigns
campaign_addressidTEXTCampaign address IDCampaign address IDcampaigns
campaign_analytics_campaign_nameTEXTCampaign analytics_campaign_nameCampaign analytics_campaign_namecampaigns
campaign_automationTEXTCampaign automationCampaign automationcampaigns
campaign_basemessageidTEXTCampaign base message IDCampaign base message IDcampaigns
campaign_basetemplateidTEXTCampaign basetemplate IDCampaign basetemplate IDcampaigns
campaign_bounceidTEXTCampaign bounce IDCampaign bounce IDcampaigns
campaign_cdateDATECampaign creation dateCampaign creation datecampaigns
campaign_deletestampTEXTCampaign deletestampCampaign deletestampcampaigns
campaign_embed_imagesTEXTCampaign embed_imagesCampaign embed_imagescampaigns
campaign_facebookTEXTCampaign facebookCampaign facebookcampaigns
campaign_formidTEXTCampaign form IDCampaign form IDcampaigns
campaign_forwardsNUMERICCampaign forwardsCampaign forwardscampaigns
campaign_hardbouncesNUMERICCampaign hard bouncesCampaign hard bouncescampaigns
campaign_htmlunsubNUMERICCampaign html unsubCampaign html unsubcampaigns
campaign_htmlunsubdataTEXTCampaign html unsub dataCampaign html unsub datacampaigns
campaign_idTEXTCampaign IDCampaign IDcampaigns
campaign_ip4TEXTCampaign ip4Campaign ip4campaigns
campaign_laststepTEXTCampaign last stepCampaign last stepcampaigns
campaign_ldateDATECampaign date last sent to contactDate the campaign last sent to a contactcampaigns
campaign_linkclicksNUMERICCampaign link clicksCampaign link clickscampaigns
campaign_mail_cleanupTEXTCampaign mail_cleanupCampaign mail_cleanupcampaigns
campaign_mail_sendTEXTCampaign mail_sendCampaign mail_sendcampaigns
campaign_mail_transferTEXTCampaign mail transferCampaign mail transfercampaigns
campaign_mailer_log_fileTEXTCampaign mailer_log_fileCampaign mailer_log_filecampaigns
campaign_managetextTEXTCampaign manage textCampaign manage textcampaigns
campaign_mdateDATECampaign modification dateCampaign modification datecampaigns
campaign_opensNUMERICCampaign opensCampaign openscampaigns
campaign_publicTEXTCampaign publicCampaign publiccampaigns
campaign_realcidTEXTCampaign realcidCampaign realcidcampaigns
campaign_recurringTEXTCampaign recurringCampaign recurringcampaigns
campaign_reminder_fieldTEXTCampaign reminder fieldCampaign reminder fieldcampaigns
campaign_reminder_formatTEXTCampaign reminder formatCampaign reminder formatcampaigns
campaign_reminder_last_cron_runTEXTCampaign reminder last cron runCampaign reminder last cron runcampaigns
campaign_reminder_offsetTEXTCampaign reminder offsetCampaign reminder offsetcampaigns
campaign_reminder_offset_signTEXTCampaign reminder offset signCampaign reminder offset signcampaigns
campaign_reminder_offset_typeTEXTCampaign reminder offset typeCampaign reminder offset typecampaigns
campaign_reminder_typeTEXTCampaign reminder typeCampaign reminder typecampaigns
campaign_repliesNUMERICCampaign repliesCampaign repliescampaigns
campaign_replysysTEXTCampaign replysysCampaign replysyscampaigns
campaign_responder_existingTEXTCampaign responder existingCampaign responder existingcampaigns
campaign_responder_offsetTEXTCampaign responder offsetCampaign responder offsetcampaigns
campaign_responder_typeTEXTCampaign responder typeCampaign responder typecampaigns
campaign_scheduleTEXTCampaign scheduleCampaign schedulecampaigns
campaign_scheduleddateDATECampaign scheduled dateCampaign scheduled datecampaigns
campaign_sdateDATECampaign start sending dateDate the campaign started sendingcampaigns
campaign_segmentidTEXTCampaign segment IDCampaign segment IDcampaigns
campaign_send_amtNUMERICCampaign total contacts sentTotal amount of contacts actually sent this campaigncampaigns
campaign_sendidTEXTCampaign send IDCampaign send IDcampaigns
campaign_seriesidTEXTCampaign series IDCampaign series IDcampaigns
campaign_socialsharesNUMERICCampaign social sharesCampaign social sharescampaigns
campaign_softbouncesNUMERICCampaign soft bouncesCampaign soft bouncescampaigns
campaign_sourceTEXTCampaign sourceCampaign sourcecampaigns
campaign_split_contentTEXTCampaign split contentCampaign split contentcampaigns
campaign_split_offsetTEXTCampaign split offsetCampaign split offsetcampaigns
campaign_split_offset_typeTEXTCampaign split offset typeCampaign split offset typecampaigns
campaign_split_typeTEXTCampaign split typeCampaign split typecampaigns
campaign_split_winner_awaitingTEXTCampaign split winner awaitingCampaign split winner awaitingcampaigns
campaign_split_winner_messageidTEXTCampaign split winner message IDCampaign split winner message IDcampaigns
campaign_statusTEXTCampaign statusCampaign statuscampaigns
campaign_subscriberclicksNUMERICCampaign subscriber clicksCampaign subscriber clickscampaigns
campaign_surveyTEXTCampaign surveyCampaign surveycampaigns
campaign_textunsubNUMERICCampaign text unsubCampaign text unsubcampaigns
campaign_textunsubdataTEXTCampaign text unsub dataCampaign text unsub datacampaigns
campaign_threadidTEXTCampaign thread IDCampaign thread IDcampaigns
campaign_total_amtNUMERICCampaign determined total contactsTotal amount of contacts determined to receive this campaigncampaigns
TEXTCampaign track linksCampaign track linkscampaigns
campaign_tracklinksanalyticsTEXTCampaign track links analyticsCampaign track links analyticscampaigns
campaign_trackreadsTEXTCampaign track readsCampaign track readscampaigns
campaign_trackreadsanalyticsTEXTCampaign track reads analyticsCampaign track reads analyticscampaigns
campaign_tweetTEXTCampaign tweetCampaign tweetcampaigns
campaign_typeTEXTActiveCampaign campaign typeActiveCampaign campaign typecampaigns
campaign_uniqueforwardsNUMERICCampaign unique forwardsCampaign unique forwardscampaigns
campaign_uniquelinkclicksNUMERICCampaign unique link clicksCampaign unique link clickscampaigns
campaign_uniqueopensNUMERICCampaign unique opensCampaign unique openscampaigns
campaign_uniquerepliesNUMERICCampaign unique repliesCampaign unique repliescampaigns
campaign_unsubreasonsNUMERICCampaign unsub reasonsCampaign unsub reasonscampaigns
campaign_unsubscribesNUMERICCampaign unsubscribesCampaign unsubscribescampaigns
campaign_updatesDATECampaign updatesCampaign updatescampaigns
campaign_userTEXTCampaign userCampaign usercampaigns
campaign_useridTEXTCampaign user IDCampaign user IDcampaigns
campaign_waitpreviewTEXTCampaign waitpreviewCampaign waitpreviewcampaigns
campaign_willrecurTEXTCampaign willrecurCampaign willrecurcampaigns
contact_adateDATEContact adateContact adatecontacts
contact_bounced_dateDATEContact bounced dateContact bounced datecontacts
contact_bounced_hardTEXTContact bounced hardContact bounced hardcontacts
contact_bounced_softTEXTContact bounced softContact bounced softcontacts
contact_cdateDATEContact creation dateContact creation datecontacts
contact_deletedTEXTContact deletedContact deletedcontacts
contact_edateDATEContact edateContact edatecontacts
contact_emailTEXTContact emailContact emailcontacts
contact_email_domainTEXTContact email domainContact email domaincontacts
contact_email_localTEXTContact email localContact email localcontacts
contact_first_nameTEXTContact first nameContact first namecontacts
contact_gravatarTEXTContact gravatarContact gravatarcontacts
contact_hashTEXTContact hashContact hashcontacts
contact_idTEXTContact IDContact IDcontacts
contact_ipTEXTContact ipContact ipcontacts
contact_last_nameTEXTContact last nameContact last namecontacts
contact_organizationTEXTContact organizationContact organizationcontacts
contact_orgidTEXTContact orgidContact orgidcontacts
contact_phoneTEXTContact phoneContact phonecontacts
contact_rating_tstampTEXTContact rating_tstampContact rating_tstampcontacts
contact_segmentio_idTEXTContact segmentio_idContact segmentio_idcontacts
contact_sentcntNUMERICContact sentcntContact sentcntcontacts
contact_socialdata_lastcheckTEXTContact socialdata_lastcheckContact socialdata_lastcheckcontacts
contact_uaTEXTContact uaContact uacontacts
contact_udateDATEContact update dateContact update datecontacts
datasourceTEXTData SourceThe name of the Windsor connector returning the row
deal_accountTEXTDeal accountDeal accountdeals
deal_activitycountNUMERICDeal activity countDeal activity countdeals
deal_cdateDATEDeal creation dateDeal creation datedeals
deal_contactTEXTDeal contactDeal contactdeals
deal_currencyTEXTDeal currencyDeal currencydeals
deal_customer_accountTEXTDeal customer accountDeal customer accountdeals
deal_descriptionTEXTDeal descriptionDeal descriptiondeals
deal_edateDATEDeal edateDeal edatedeals
deal_groupTEXTDeal groupDeal groupdeals
deal_idTEXTDeal IDDeal IDdeals
deal_mdateDATEDeal modification dateDeal modification datedeals
deal_nextdateDATEDeal next dateDeal next datedeals
deal_nextdealidTEXTDeal next deal IDDeal next deal IDdeals
deal_nexttaskidTEXTDeal next task IDDeal next task IDdeals
deal_organizationTEXTDeal organizationDeal organizationdeals
deal_ownerTEXTDeal ownerDeal ownerdeals
deal_percentPERCENTDeal percentDeal percentdeals
deal_stageTEXTDeal stageDeal stagedeals
deal_statusTEXTDeal statusDeal statusdeals
deal_task_assigneeTEXTDeal task assigneeDeal task assigneedeal_tasks
deal_task_automationTEXTDeal task automationDeal task automationdeal_tasks
deal_task_cdateDATEDeal task creation dateDeal task creation datedeal_tasks
deal_task_deal_tasktypeTEXTDeal task typeDeal task typedeal_tasks
deal_task_done_automationTEXTDeal task done automationDeal task done automationdeal_tasks
deal_task_duedateDATEDeal task due dateDeal task due datedeal_tasks
deal_task_edateDATEDeal task edateDeal task edatedeal_tasks
deal_task_idTEXTDeal task IDDeal task IDdeal_tasks
deal_task_noteTEXTDeal task noteDeal task notedeal_tasks
deal_task_outcome_infoTEXTDeal task outcome infoDeal task outcome infodeal_tasks
deal_task_outcomeidTEXTDeal task outcome IDDeal task outcome IDdeal_tasks
deal_task_relidTEXTDeal task relidDeal task reliddeal_tasks
deal_task_reltypeTEXTDeal task reltypeDeal task reltypedeal_tasks
deal_task_statusTEXTDeal task statusDeal task statusdeal_tasks
deal_task_titleTEXTDeal task titleDeal task titledeal_tasks
deal_task_udateDATEDeal task update dateDeal task update datedeal_tasks
deal_task_userTEXTDeal task userDeal task userdeal_tasks
deal_titleTEXTDeal titleDeal titledeals
deal_valueNUMERICDeal valueDeal valuedeals
deal_win_probabilityNUMERICDeal win probabilityDeal win probabilitydeals
deal_win_probability_mdateDATEDeal win probability modification dateDeal win probability modification datedeals
list_analytics_domainsTEXTList analytics_domainsList analytics_domainslists
list_analytics_sourceTEXTList analytics_sourceList analytics_sourcelists
list_analytics_uaTEXTList analytics_uaList analytics_ualists
list_carboncopyTEXTList carboncopyList carboncopylists
list_cdateDATEList creation dateList creation datelists
list_deletestampTEXTList deletestampList deletestamplists
list_facebook_sessionTEXTList facebook sessionList facebook sessionlists
list_fulladdressTEXTList full addressList full addresslists
list_get_unsubscribe_reasonTEXTList get_unsubscribe_reasonList get_unsubscribe_reasonlists
list_idTEXTList IDList IDlists
list_nameTEXTList nameList namelists
list_optinmessageidTEXTList optinmessageidList optinmessageidlists
list_optinoptoutTEXTList optin optoutList optin optoutlists
list_optoutconfTEXTList optout confList optout conflists
list_p_embed_imageTEXTList p_embed_imageList p_embed_imagelists
TEXTList p_use_analytics_linkList p_use_analytics_linklists
list_p_use_analytics_readTEXTList p_use_analytics_readList p_use_analytics_readlists
list_p_use_captchaTEXTList p_use_captchaList p_use_captchalists
list_p_use_facebookTEXTList p_use_facebookList p_use_facebooklists
list_p_use_trackingTEXTList p_use_trackingList p_use_trackinglists
list_p_use_twitterTEXTList p_use_twitterList p_use_twitterlists
list_privateTEXTList privateList privatelists
list_require_nameTEXTList require nameList require namelists
list_send_last_broadcastTEXTList send_last_broadcastList send_last_broadcastlists
list_sender_addr1TEXTList sender addr1List sender addr1lists
list_sender_addr2TEXTList sender addr2List sender addr2lists
list_sender_cityCITYList sender cityList sender citylists
list_sender_countryCOUNTRYList sender countryList sender countrylists
list_sender_nameTEXTList sender nameList sender namelists
list_sender_phoneTEXTList sender phoneList sender phonelists
list_sender_reminderTEXTList sender reminderList sender reminderlists
list_sender_stateTEXTList sender stateList sender statelists
list_sender_urlTEXTList sender URLList sender URLlists
list_sender_zipTEXTList sender zipList sender ziplists
list_stringidTEXTList string IDList string IDlists
list_subscription_notifyTEXTList subscription_notifyList subscription_notifylists
list_to_nameTEXTList to_nameList to_namelists
list_twitter_tokenTEXTList twitter_tokenList twitter_tokenlists
list_twitter_token_secretTEXTList twitter token secretList twitter token secretlists
list_udateDATEList update dateList update datelists
list_unsubscription_notifyTEXTList unsubscription notifyList unsubscription notifylists
list_userTEXTList userList userlists
list_useridTEXTList user IDList user IDlists
message_cdateDATEMessage creation dateMessage creation datemessages
message_charsetTEXTMessage charsetMessage charsetmessages
message_ed_instanceidTEXTMessage ed_instanceidMessage ed_instanceidmessages
message_ed_versionTEXTMessage ed_versionMessage ed_versionmessages
message_encodingTEXTMessage encodingMessage encodingmessages
message_formatTEXTMessage formatMessage formatmessages
message_fromemailTEXTMessage from emailMessage from emailmessages
message_fromnameTEXTMessage from nameMessage from namemessages
message_hiddenTEXTMessage hiddenMessage hiddenmessages
message_htmlTEXTMessage htmlMessage htmlmessages
message_htmlfetchTEXTMessage html fetchMessage htmlfetchmessages
message_idTEXTMessage IDMessage IDmessages
message_mdateDATEMessage modification dateMessage modification datemessages
message_nameTEXTMessage nameMessage namemessages
message_preheader_textTEXTMessage preheader textMessage preheader textmessages
message_preview_dataTEXTMessage preview dataMessage preview datamessages
message_preview_mimeTEXTMessage preview mimeMessage preview mimemessages
message_priorityTEXTMessage priorityMessage prioritymessages
message_reply2TEXTMessage reply2Message reply2messages
message_subjectTEXTMessage subjectMessage subjectmessages
message_textTEXTMessage textMessage textmessages
message_textfetchTEXTMessage text fetchMessage text fetchmessages
message_userTEXTMessage userMessage usermessages
message_useridTEXTMessage user IDMessage user IDmessages
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date