Connectors
ActiveCampaign
Connectors
ActiveCampaign
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.