Skip to main content

​
Introduction

ActiveCampaign is an email marketing and marketing-automation platform with built-in CRM capabilities. The Active Campaign connector retrieves email campaigns and their performance metrics from the ActiveCampaign REST API v3. Two data source types are available: one that reports lifetime totals per campaign, and one that reports daily stats per campaign. As a CRM connector, campaign breakdowns are standardized so widgets can aggregate alongside other sources without additional configuration. The Active Campaign connector is currently in beta. To connect this data source, see How to connect Active Campaign to Adriel.

​
Data source types

The data source type is chosen when an Active Campaign data source is added, and it can’t be switched later. Existing Active Campaign data sources use the Campaigns (all-time totals) type and are unchanged. To report by date, add a new data source from the same Active Campaign connection and select Campaign stats by date — no new credentials are needed.
Opens and clicks can differ between the two types for the same campaign, because ActiveCampaign counts them differently when filtering by date. Campaign stats by date matches ActiveCampaign’s own day-by-day numbers; over a multi-day range, its unique metrics are summed by day (see Campaign stats by date). Sends and bounces match between the two types.

​
Data refresh strategy

​
Architecture data

Account structure — the connected ActiveCampaign account and its email campaign list — is resolved at connection time and refreshed alongside reports data.

​
Reports data: Campaigns (all-time totals)

The Campaigns (all-time totals) type is a cache-only data source. Report data comes from the most recent cached snapshot rather than a live call at dashboard load. Each sync writes the full campaign list to a temporary table, then atomically swaps it with the production snapshot, so a partial or failed refresh leaves the previous snapshot intact rather than producing empty results. Every run is a full snapshot replace — there is no incremental fetch and no upsert key. Cached rows are stored as JSON. Refresh schedule. Campaigns (all-time totals) data refreshes twice daily, at 21:30 UTC and 04:30 UTC (06:30 and 13:30 KST). This type stores one cumulative total per campaign rather than time-series rows.

​
Reports data: Campaign stats by date

The Campaign stats by date type stores daily stats per campaign. Report data comes from the cache, and date filters narrow the numbers to the selected range. The first sync loads the last 365 days. Each later refresh updates the last 30 days, so stats for older days stay as they were last loaded. Because the data is cached, the longer the data source stays connected, the more historical data is stored. Refresh schedule. Campaign stats by date data refreshes once a day, at 22:00 UTC (07:00 KST).

​
Architecture levels

Account → Email campaign In the Campaigns (all-time totals) type, metrics are reported per campaign as lifetime totals, without intra-campaign granularity. In the Campaign stats by date type, metrics are reported per campaign per day.

​
Metrics

The tables in this section and in Breakdowns apply to the Campaigns (all-time totals) type. For the Campaign stats by date type, see Campaign stats by date.
How to read the columns Data type uses this vocabulary: Number, Currency, Percentage, Ratio, Duration, Date, Text, URL, Array, Boolean. API Key in code style like opens is the literal ActiveCampaign API field name. Italic text describes how a value is produced when it doesn’t map cleanly to a single API field.

​
Campaigns & sends

​
Email engagement

​
Bounces & unsubscribes

​
Breakdowns

These breakdowns apply to the Campaigns (all-time totals) type.

​
Campaign

​
Time

In the Campaigns (all-time totals) type, Active Campaign returns cumulative per-campaign totals; these time breakdowns are Adriel-side groupings that bucket campaigns by their send date. To split the numbers themselves by date, use the Campaign stats by date type.

​
Campaign stats by date

The Campaign stats by date type stores daily stats for each campaign, starting from the last 365 days on the first sync, so data can be viewed per day, week, month, quarter, or year. Date filters narrow the numbers to the selected range. To add this type, see Add Campaign stats by date to an existing connection.

​
Metrics

Total opens, total link clicks, and unique link clicks are not available by date. For a date range, ActiveCampaign provides only distinct openers and clickers. Lifetime totals for these metrics remain available in the Campaigns (all-time totals) type.
Unique opens, verified unique opens, subscriber clicks, and unique forwards count distinct contacts per day. Across a multi-day range, the daily figures are added together, so a contact active on several days is counted once per day and the total can be higher than ActiveCampaign’s own unique count for the same range. For an exact figure, view these metrics one day at a time.

​
Breakdowns

​
Open and click rates

Opens and clicks are counted on the day they happen, not on the day the campaign was sent. A daily open or click rate can therefore go above 100% — for example, on a day with few sends but many opens from an earlier send. Rates are best viewed by month or longer. To report a click rate, create a custom metric with the formula Subscriber clicks ÷ Send amount (subscriberclicks ÷ send_amt). A custom metric that uses unique link clicks, such as an existing click rate built for the Campaigns (all-time totals) type, returns 0 with Campaign stats by date because unique link clicks isn’t available in this type.

​
Limitations

  • Beta connector — Active Campaign is currently in beta; coverage and behavior may change.
  • Campaign-level reporting only — metrics are reported per campaign. There is no send-level or recipient-level granularity.
  • Cumulative aggregates in the Campaigns (all-time totals) type — the Campaigns (all-time totals) type reports one lifetime total per campaign. Date filters scope which campaigns appear rather than narrowing the per-campaign totals; time filtering is applied to campaign created and sent timestamps. To narrow the numbers by date, use the Campaign stats by date type.
  • No total opens or link clicks by date — the Campaign stats by date type doesn’t include total opens, total link clicks, or unique link clicks. Use unique opens and subscriber clicks instead, or the Campaigns (all-time totals) type for lifetime totals.
  • Unique metrics are summed by day — in the Campaign stats by date type, unique opens, verified unique opens, subscriber clicks, and unique forwards are daily distinct counts added together across the range, not de-duplicated across it. Multi-day totals can be higher than ActiveCampaign’s own unique counts.
  • 620-campaign cap — both types read the campaign list 20 per page, up to 31 pages, for a cap of 620 campaigns per data source. The same cap applies to automations. Above the cap, the data source fails to refresh; nothing is partially loaded. Daily stats and bounce records have no limit.
  • Full snapshot replace in the Campaigns (all-time totals) type — each Campaigns (all-time totals) refresh replaces the entire campaign snapshot; there is no incremental sync.
  • Account-specific API URL — each ActiveCampaign account has its own api-us1.com (or regional equivalent) base URL, which must be supplied at connection time; a generic host will not resolve to the correct account.

​
API references

​
See also