The Active Campaign Reverse ETL connector enables streaming data from a user determined warehouse to the Active Campaign platform in an automated manner.
Check more about Active Campaign api documentation here.
This sync can be used to load data of accounts from your data warehouse into Active Campaign platform.
This sync can be used to load data of Account Contact Associations from your data warehouse into Active Campaign platform.
This sync can be used to load data of contacts from your data warehouse into Active Campaign platform.
Update List Status for a Contact
This sync can be used to subscribe a contact to a list or unsubscribe a contact from a list in your Active Campaign platform.
Amazon Redshift to Active Campaign
1. Setup a Data Warehouse - Go to Data Warehouses Tab and add a Redshift Warehouse.
*To understand how to add a Redshift Data Warehouse check out this video.
2. Setup a Data Model - Navigate to Data Models tab and click on Create New. Name your Data Model and select your data warehouse from the drop down. Write a SQL query to fetch data from your warehouse.
(Eg. Select * from Schema_Name.Table_Name)
*A simple “select” statement will work, although you can write complex SQL queries in the data model field itself or use our no-code segment builder to filter your data without writing complex SQL Queries.
3. Configure your Data Destination - Navigate to Destinations tab and select Salesforce.