> ## Documentation Index
> Fetch the complete documentation index at: https://docs.adriel.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Data reference
> Metrics, breakdowns, refresh cadence, and limits for the Active Campaign data source in Adriel.
## 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-sources/a-f/active-campaign/how-to-connect).
## 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
| Metric | Description | Data type | API Key |
| ------------------ | ---------------------------------------------- | --------- | ----------------- |
| Emails sent | Total emails sent on the campaign. | Number | `mail_send` |
| Emails transferred | Emails transferred during delivery. | Number | `mail_transfer` |
| Send amount | Send-amount value reported by ActiveCampaign. | Number | `send_amt` |
| Total amount | Total-amount value reported by ActiveCampaign. | Number | `total_amt` |
| Updates | Update events on the campaign. | Number | `updates` |
| Active RSS items | Active RSS items linked to the campaign. | Number | `activerss_items` |
| Wait preview | Wait-preview value reported by ActiveCampaign. | Number | `waitpreview` |
### Email engagement
| Metric | Description | Data type | API Key |
| --------------------- | ------------------------------------------------------------------------ | --------- | ----------------------- |
| Opens | Total opens across recipients. | Number | `opens` |
| Unique opens | Distinct openers. | Number | `uniqueopens` |
| Verified opens | Opens confirmed as legitimate by ActiveCampaign's verification. | Number | `verified_opens` |
| Verified unique opens | Distinct verified openers. | Number | `verified_unique_opens` |
| Link clicks | Total link clicks. | Number | `linkclicks` |
| Unique link clicks | Distinct clickers across links. | Number | `uniquelinkclicks` |
| Forwards | Total forwards. | Number | `forwards` |
| Unique forwards | Distinct forwarders. | Number | `uniqueforwards` |
| Social shares | Social shares of the campaign. | Number | `socialshares` |
| Replies | Total replies received. | Number | `replies` |
| Unique replies | Distinct replying recipients. | Number | `uniquereplies` |
| System replies | System-generated replies (auto-responses, bounce messages, and similar). | Number | `replysys` |
### Bounces & unsubscribes
| Metric | Description | Data type | API Key |
| ------------------- | ---------------------------------------------------- | --------- | -------------- |
| Hard bounces | Permanent delivery failures. | Number | `hardbounces` |
| Soft bounces | Transient delivery failures. | Number | `softbounces` |
| Unsubscribes | Unsubscribe events. | Number | `unsubscribes` |
| Unsubscribe reasons | Count of reason selections submitted on unsubscribe. | Number | `unsubreasons` |
## Breakdowns
### Campaign
| Breakdown | Description | API Key |
| ------------- | -------------------------------------------------- | -------------------------- |
| Campaign ID | ActiveCampaign campaign identifier. | `campaign_id` |
| Campaign name | Campaign display name. | `campaign_name` |
| Data source | Name of the connected Active Campaign data source. | *Adriel-provided metadata* |
### Time
Active Campaign returns cumulative per-campaign totals; these time breakdowns are Adriel-side groupings that bucket campaigns by their send date.
| Breakdown | Description |
| ------------------- | ------------------------------------------------------------------------------------------------------------------------------ |
| Weekly (Start: Mon) | Split reports by ISO week, starting Monday. The range may be capped at one year, so data outside that window can be truncated. |
| Monthly | Split reports by calendar month. |
| Quarterly | Split reports by calendar quarter. |
| Yearly | Split reports by calendar year. |
## 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](https://developers.activecampaign.com/reference/list-all-campaigns)). 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
* [ActiveCampaign API v3 overview](https://developers.activecampaign.com/reference/overview)
* [Campaigns endpoint reference](https://developers.activecampaign.com/reference/list-all-campaigns)
## See also
* [How to connect Active Campaign to Adriel](/data-sources/a-f/active-campaign/how-to-connect) (paired how-to)
* [Mailchimp data reference](/data-sources/g-n/mailchimp/data-reference) — for another email marketing source
* [Klaviyo data reference](/data-sources/g-n/klaviyo/data-reference) — for another email and CRM source