ActiveCampaign is an easy-to-use integrated marketing automation, email marketing, and automated sales platform. This article will provide general expectations regarding functionality and give you an overview of the ActiveCampaign/Grow integration.
ActiveCampaign is only available as a warehoused data source.
Connecting to ActiveCampaign
Here are the steps to connect your ActiveCampaign account to Grow:
-
Select the Data tab next to the Dashboard.
This takes you to the Data Overview page. - Click on the Connections button.
- Select the blue Connect button at the end of the Your Top Data Sources options.
- From the list of Connections, search and select ActiveCampaign.
- Click on Connect to ActiveCampaign.
-
Enter your API Key and API
URL (for the API URL, only include "https://[subdomain]").
To get your API Key and API URL, - Log in to your ActiveCampaign account.
- Navigate to your profile > My Settings.
- Select Developer from the left-hand menu.
- Copy your API Key and API URL.
- Click on Submit.
Data Warehouse
ActiveCampaign is on the Grow Data Warehouse, which is the only available method to access this data source. For more information about warehousing your data, visit the Data Warehouse Help Article.
Tables
Below is a list of warehoused tables available through ActiveCampaign, along with a short description of each.
- Accounts: Id, name, accountUrl, contact counts, deal counts, among other information.
- Automations: Id, name, status, created date, among other information.
- Campaigns: Id, type, name, opens, clicks, forwards, bounces, unsubscribes, among other information.
- Connections: Service, name, connection type, sync status, sync request time.
- Contact Deals: Email, first name, last name, deals, pipelines, stages, among other information.
- Contacts: Email, first name, last name, hard bounces, soft bounces, among other information.
- Deal Groups: Id, title, currency, stages, among other information.
- Deal Stages: Id, group, title, color, order, deal orders, among other information.
- Deal Task Types: Status, title, outcomes, among other information.
- Deal Tasks: Type, user, assignee, title, status, notes, links, among other information.
- Deals: Deals, pipelines, stages, custom fields (Coming Soon).
- eCommerce Customers (Coming Soon): Email, total revenue, total orders, total products, average revenue per order.
- eCommerce Order Product (Coming Soon): Id, order id, sku, name, description, price, quantity, url.
- eCommerce Orders (Coming Soon)
- Lists: ID, name, subscriber count, among other list information.
- Messages: Subject files and ID, among other list information.
- Tags: Tags, tag type, description, subscriber count.
- Users: Username, first name, last name, email, phone number, language, time zone.
Warehousing Your Data
-
In the Connections Overview Page, click on your ActiveCampaign connection.
This opens the Connection Details page. - Select the Manage Connection button inside the Connection Details section to open the warehouse table selection flow.
- Select the data you want stored in the Data Warehouse and click the Sync & Store button at the bottom of the Manage Connection page.
This begins the initial population of your warehouse with the tables you defined. Populating your data warehouse for the first time may take a while, sometimes up to several hours.
You may continue working within the app while your data is In Queue or Processing.
Sync Interval
Full Sync
The default sync interval is 12 hours per table for all warehoused tables.
Incremental Sync
When incremental sync is available, the default incremental sync interval is 1 hour, while the default full sync interval is 1 week.
Incremental sync is not currently available for ActiveCampaign warehoused tables.
To learn more about sync intervals and how to adjust the default settings, please visit this section of the Data Warehouse help article.
API Documentation
This is for reference only. You should not need to consult this to use the connection in Grow.
FAQs + Tips and Tricks
CRM and Leads Data
The integration does not currently support reports for leads or CRM data outside of the provided reports listed above.