Introduction
ActiveCampaign is an email marketing and marketing-automation platform with built-in CRM capabilities. The Active Campaign connector retrieves email campaigns and their per-campaign performance metrics from the ActiveCampaign REST API v3. 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 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
Active Campaign is a cache-only connector. 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. Reports refresh twice daily, at 06:30 UTC and 13:30 UTC. The ActiveCampaign API returns aggregate per-campaign metrics rather than time-series rows, so there are no date-range query parameters on the sync.Architecture levels
Account → Email campaign Metrics are reported per campaign, without intra-campaign granularity.Metrics
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
Campaign
Time
Active Campaign returns cumulative per-campaign totals; these time breakdowns are Adriel-side groupings that bucket campaigns by their send date.
Limitations
- Beta connector — Active Campaign is currently in beta; coverage and behavior may change.
- Campaign-level reporting only — metrics are reported per campaign as cumulative totals. There is no intra-campaign send-level or recipient-level granularity in the API response.
- Cumulative aggregates, not time series — the ActiveCampaign API does not accept date-range parameters for campaign reports (Campaigns endpoint reference). Date filters scope which campaigns appear rather than narrowing the per-campaign totals; time filtering is applied to campaign created and sent timestamps.
- Full snapshot replace — each 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
- How to connect Active Campaign to Adriel (paired how-to)
- Mailchimp data reference — for another email marketing source
- Klaviyo data reference — for another email and CRM source
