Active Campaign
ActiveCampaign is a versatile and powerful marketing automation platform designed to help businesses engage with their customers through personalized and automated communication. It offers a wide range of tools and features for email marketing, marketing automation, CRM, and customer support.
Features
Feature name | Supported | |
---|---|---|
Bulk upload | True | |
Operation modes | True | Upsert |
π§ Setup Guide
To connect ActiveCampaign to Weld, you need an ActiveCampaign account with Administrator permission.
Step 1 - Get API Key
- Log in to your ActiveCampaign account as an Administrator.
- On the left-hand navigation menu, click Settings > Developer.
- Go to the API Access section, copy the URL and API Key. You will need them to configure Weld.
Step 2 - Begin Configuration
- In the connector setup form, enter the destination schema name of your choice.
- Enter the API Key that you copied from step 1.
- Enter the URL copied from step 1.
Step 3 - Data To Sync
- Select the pre-built reports you wish to include in the sync.
You can view the schema, remove columns or hash sensitive information.
Step 4 - Configure Sync
- Select how often you would like the data to sync.
- Provide a unique destination table name.
Weld will take over from here and commence syncing data from your ActiveCampaign account.
π§ Setup Guide - Reverse ETL
Active Campaign reverse ETL allows you to sync data on a schedule from your Weld App automatically into Active Campaign.
- contact (
upsert
only)
Prerequisites
To connect ActiveCampaign to Weld, you need an ActiveCampaign account with Administrator permission.
Step 1 - Destination
- In the sidebar, click Reverse ETL to navigate to the Reverse ETL page.
- If youβre setting up your first Reverse ETL sync, the setup guide will launch automatically. Otherwise, click Add Reverse ETL Sync to start a new setup.
- From the list of available destinations, find ActiveCampaign. Select an existing connection if available, or click to create a new one. Youβll be prompted to authorize the connection if itβs your first time setting it up.
- Log in to your ActiveCampaign account as an Administrator.
- On the left-hand navigation menu, click Settings > Developer.
- Go to the API Access section, copy the URL and API Key. You will need them to configure Weld.
- In the connector setup form, enter the destination schema name of your choice.
- Enter the API Key and URL that you copied from step 3.
Step 2 - Target Details
The Active Campaign connection does not have additional configuration - This will be skipped.
Step 3 - Map Data
Define how your source data should sync with your destination
Source
Choose the SQL model that contains the data that you would like to send to Active Campaign
SQL Model tips for Active Campaign Reverse-ETL
- Your SQL model
should have one row per Contact.
- Requires Primary key
Destination Object
Select the destination object you want to sync data to:
contacts
Sync Mode
Choose how you would like to sync your data:
Upsert
- Inserts new records and updates already synced data
Choose Identifier
Select the unique identifier field to match your record between your source and destination (this is usually the email or ID).
Field Mapping
Configure the field mapping between your source and destination. Map the column from your source model to the property in Active Campaign.
Step 4 - Schedule Sync
Decide how often you want your data to sync. Pick a frequency that matches your needs to keep your destination always up-to-date. You can choose to have the sync running on an independent schedule or as part of an orchestration workflow.
Step 5 - Review and Save
Click "Start Sync" to save your configuration and start the sync process.