Description

ActiveCampaign specializes in email marketing, transactional email, marketing automation, and sales automation.

Connector Details

Name	Value
Platform	ActiveCampaign
Auth Type	API Keys
Direction	Bidirectional

Triggers

See the table below for the list of real-time triggers supported by the ActiveCampaign connector.

Name	Description
Contact added	Triggered when a contact is added
Contact updated	Triggered when a contact is updated

Supported Data

See the table below for the list of data you can read with the ActiveCampaign connector.

Table Name	Fields
accounts	name, account_url, created_timestamp, updated_timestamp, contact_count, deal_count, id
account_contacts	account, contact, job_title, created_timestamp, updated_timestamp, id
account_custom_fields	id, field_label, field_type, field_options, field_default, field_default_currency, is_form_visible, is_required, display_order, personalization, known_field_id, hide_field_flag, created_timestamp, updated_timestamp
account_custom_field_values	id, account_custom_field_metum_id, account_id, custom_field_id, created_timestamp, updated_timestamp, field_value
addresses	company_name, address1, address2, city, state, district, zip, country, allgroup, is_default, id
automations	name, cdate, mdate, userid, status, entered, exited, hidden, defaultscreenshot, screenshot, id
brandings	groupid, site_name, site_logo, site_logo_small, header_text_value, header_html_value, footer_text_value, footer_html_value, copyright, version, license, help, admin_template_htm, admin_template_css, public_template_htm, public_template_css, favicon, id
calendars	title, type, userid, notification, cdate, mdate, token, id
campaigns	type, userid, segmentid, bounceid, realcid, sendid, threadid, seriesid, formid, basetemplateid, basemessageid, addressid, source, name, cdate, mdate, sdate, ldate, created_timestamp, updated_timestamp, send_amt, total_amt, opens, uniqueopens, linkclicks, uniquelinkclicks, subscriberclicks, forwards, uniqueforwards, hardbounces, softbounces, unsubscribes, unsubreasons, updates, socialshares, replies, uniquereplies, status, public, mail_transfer, mail_send, mail_cleanup, mailer_log_file, tracklinks, tracklinksanalytics, trackreads, trackreadsanalytics, analytics_campaign_name, tweet, facebook, survey, embed_images, htmlunsub, textunsub, htmlunsubdata, textunsubdata, recurring, willrecur, split_type, split_content, split_offset, split_offset_type, split_winner_messageid, split_winner_awaiting, responder_offset, responder_type, responder_existing, reminder_field, reminder_format, reminder_type, reminder_offset, reminder_offset_type, reminder_offset_sign, reminder_last_cron_run, activerss_interval, activerss_url, activerss_items, ip4, laststep, managetext, schedule, scheduleddate, waitpreview, deletestamp, replysys, id, user, automation
campaign_links	campaignid, messageid, link, name, ref, tracked, uniquelinkclicks, linkclicks, id, campaign, message, created_timestamp, updated_timestamp, created_by, updated_by
contacts	cdate, email, first_name, last_name, orgid, segmentio_id, bounced_hard, bounced_soft, bounced_date, ip, ua, hash, socialdata_lastcheck, email_local, email_domain, sentcnt, rating_tstamp, gravatar, deleted, adate, udate, edate, score_values, account_contacts, id, organization, anonymized, email_empty, created_utc_timestamp, updated_utc_timestamp, created_timestamp, updated_timestamp, deleted_at, created_by, updated_by
contact_automations	contact, seriesid, startid, status, batchid, adddate, remdate, timespan, lastblock, lastlogid, lastdate, completed_elements, total_elements, completed, complete_value, id, automation
contact_custom_fields	title, descript, type, isrequired, perstag, defval, show_in_list, rows, cols, visible, service, ordernum, cdate, udate, id
contact_custom_field_options	field, orderid, value, label, isdefault, cdate, udate, id
contact_custom_field_rels	field, relid, dorder, cdate, id
contact_custom_field_values	contact, field, value, cdate, udate, id, owner, created_by, updated_by
contact_deals	deal, contact, role, cdate, created_timestamp, updated_timestamp, created_by, updated_by, id
deal_stages	card_region1, card_region2, card_region3, card_region4, card_region5, cdate, color, deal_order, group, id, order, title, udate, width
deal_groups	allgroups, allusers, autoassign, cdate, currency, id, stages, title, udate
deal_custom_fields	id, field_label, field_type, field_options, field_default, field_default_currency, is_form_visible, is_required, display_order, personalization, known_field_id, hide_field_flag, created_timestamp, updated_timestamp
deal_custom_field_values	id, deal_custom_field_metum_id, deal_id, custom_field_id, created_timestamp, updated_timestamp, field_value
deals	hash, owner, contact, organization, group, stage, title, description, percent, cdate, mdate, nextdate, nexttaskid, value, currency, win_probability, win_probability_mdate, status, activitycount, nextdealid, edate, id, is_disabled, next_task, account, customer_account
ecommerce_connections	service, externalid, name, is_internal, status, sync_status, last_sync, logo_url, link_url, cdate, udate, id
ecommerce_customers	connectionid, externalid, email, total_revenue, total_orders, total_products, avg_revenue_per_order, avg_product_category, tstamp, id, connection
ecommerce_orders	externalid, source, email, currency, connectionid, order_url, shipping_method, total_price, shipping_amount, tax_amount, discount_amount, external_created_date, external_updated_date, total_products, created_date, updated_date, state, connection, order_products, customer, order_date, tstamp, id
ecommerce_order_products	orderid, connectionid, externalid, sku, name, description, price, quantity, category, image_url, product_url, created_date, updated_date, tstamp, id, ecom_order
forms	name, action, actiondata, submit, submitdata, url, layout, title, body, button, thanks, style, options, cfields, parentformid, userid, addressid, cdate, udate, entries, aid, defaultscreenshot, recent, contacts, deals, id, address
groups	title, descript, unsubscribelink, optinconfirm, p_admin, pg_list_add, pg_list_edit, pg_list_delete, pg_list_headers, pg_list_emailaccount, pg_list_bounce, pg_message_add, pg_message_edit, pg_message_delete, pg_message_send, pg_contact_add, pg_contact_edit, pg_contact_delete, pg_contact_merge, pg_contact_import, pg_contact_approve, pg_contact_export, pg_contact_sync, pg_contact_filters, pg_contact_actions, pg_contact_fields, pg_user_add, pg_user_edit, pg_user_delete, pg_group_add, pg_group_edit, pg_group_delete, pg_template_add, pg_template_edit, pg_template_delete, pg_personalization_add, pg_personalization_edit, pg_personalization_delete, pg_automation_manage, pg_form_edit, pg_reports_campaign, pg_reports_list, pg_reports_user, pg_reports_trend, pg_startup_reports, pg_startup_gettingstarted, pg_deal, pg_deal_delete, pg_deal_reassign, pg_deal_group_add, pg_deal_group_edit, pg_deal_group_delete, pg_saved_responses_manage, sdate, req_approval, req_approval1st, req_approval_notify, socialdata, id
lists	stringid, userid, name, cdate, p_use_tracking, p_use_analytics_read, p_use_analytics_link, p_use_twitter, p_use_facebook, p_embed_image, p_use_captcha, send_last_broadcast, private, analytics_domains, analytics_source, analytics_ua, twitter_token, twitter_token_secret, facebook_session, carboncopy, subscription_notify, unsubscription_notify, require_name, get_unsubscribe_reason, to_name, optinoptout, sender_name, sender_addr1, sender_addr2, sender_city, sender_state, sender_zip, sender_country, sender_phone, sender_url, sender_reminder, fulladdress, optinmessageid, optoutconf, deletestamp, udate, created_timestamp, updated_timestamp, created_by, updated_by, id, user
messages	userid, ed_instanceid, ed_version, cdate, mdate, name, fromname, fromemail, reply2, priority, charset, encoding, format, subject, preheader_text, text, html, htmlfetch, textfetch, hidden, preview_mime, preview_data, id, user
saved_responses	title, subject, body, ldate, last_sent_user_id, cdate, mdate, id
scores	reltype, name, descript, status, cdate, mdate, id
segments	name, logic, hidden, seriesid, created_timestamp, updated_timestamp, created_by, updated_by, id
tags	tag_type, tag, description, cdate, created_timestamp, updated_timestamp, created_by, updated_by, id
task_types	cdate, defduration, id, status, title, udate
tasks	id, duedate, edate, status, title, note, relid, reltype, deal_tasktype, cdate, udate, automation, done_automation, user, assignee, owner
templates	userid, ed_instanceid, ed_version, name, subject, content, categoryid, used, waitpreview, importnum, mdate, preview_content, modified, hidden, screenshot, id
users	username, first_name, last_name, email, phone, signature, local_zoneid, password_updated_utc_timestamp, cdate, udate, mfa_enabled, id
webhooks	cdate, listid, name, url, events, sources, id
activities	tstamp, subscriberid, reference_type, reference_id, reference_action, json_data, userid, permission, reference_model_name, reference, id, user
automation_blocks	automation, parent, ordernum, params, deleted, cdate, mdate, id
bounce_logs	tstamp, bounceid, subscriberid, campaignid, messageid, codeid, email, error, source, created_timestamp, updated_timestamp, created_by, updated_by, id, bounce, contact, campaign, message, code
campaign_lists	campaignid, listid, userid, list_amt, cdate, udate, name, id, user, list, campaign
campaign_messages	messageid, campaignid, percentage, sourcesize, send_amt, total_amt, opens, uniqueopens, linkclicks, uniquelinkclicks, subscriberclicks, forwards, uniqueforwards, hardbounces, softbounces, unsubscribes, unsubreasons, updates, socialshares, replies, uniquereplies, spamcheck_score, spamcheck_max, initial_split_percentage, screenshot, subject, id, campaign, message
configs	keyname, section, item, userid, val, cdate, udate, created_timestamp, updated_timestamp, created_by, updated_by, id, owner
contact_data	contact, tstamp, geo_tstamp, geo_ip4, geo_country2, geo_country, geo_state, geo_city, geo_zip, geo_area, geo_lat, geo_lon, geo_tz, geo_tz_offset, ga_campaign_source, ga_campaign_name, ga_campaign_medium, ga_campaign_term, ga_campaign_content, ga_campaign_customsegment, ga_first_visit, ga_times_visited, fb_id, fb_name, tw_id, created_timestamp, updated_timestamp, created_by, updated_by, id
contact_emails	messageid, seriesid, messageheader, userid, d_id, subscriberid, account, ip, sdate, source, id, user, deal, contact, message
contact_lists	contact, list, form, seriesid, sdate, udate, status, responder, sync, unsubreason, campaign, message, first_name, last_name, ip_4sub, sourceid, autosync_log, ip4_last, ip_4unsub, created_timestamp, updated_timestamp, created_by, updated_by, unsubscribe_automation, id, automation
contact_tags	contact, tag, cdate, created_timestamp, updated_timestamp, created_by, updated_by, id
contact_conversions	contact, conversion, conversion_trigger, converted_by_type, converted_by_id, trigger_type, modifier, value, currency, dynamic, cdate, id, conversiontrigger, converted_by
conversions	name, value, currency, limit, enforcelimit, cdate, udate, id
conversion_triggers	conversion, trigger_type, modifier, value, dynamic, retroactive, cdate, udate, automation_block, id
deal_activities	d_id, d_stageid, userid, data_id, data_type, data_action, data_oldval, cdate, sortdate, is_addtask, deleted, seriesid, id, deal, stage, user, automation
deal_group_users	deal_group, user, cdate, id
ecommerce_order_activities	orderid, connectionid, customerid, externalid, externalcheckoutid, source, order_number, email, total_price, discount_amount, shipping_amount, tax_amount, total_products, currency, shipping_method, store_name, logo_url, order_url, state, external_created_date, external_updated_date, abandoned_date, created_date, updated_date, id, connection, order
email_activities	subscriberid, userid, d_id, account, reltype, relid, from_name, from_address, to_address, cc_address, subject, message, message_html, tstamp, id, contact, deal, user, reference
goals	blockid, seriesid, name, cdate, dirty_stats, id, automation, automation_block
site_messages	name, automation, template, ldate, id
sms	userid, seriesid, msg, tstamp, tf_day, tf_hr_from, tf_hr_to, sent, failed, unsubscribes, replies, uniquereplies, sdate, ldate, id, user, automation

Credentials Setup

Follow the steps below to get the credentials you need to use the ActiveCampaign connector.

The first thing you need to do to access your ActiveCampaign API url and API token is log in to ActiveCampaign.

Once you are logged in, you should go ahead and click on the Settings button in the bottom left side of the page.

Next, you should now go ahead and click on the Developer tab within your settings.

On this page, you will be able to find both your ActiveCampaign API url and your API key. Copy these credentials into hotglue.