> ## Documentation Index
> Fetch the complete documentation index at: https://agents.concierca.ch/llms.txt
> Use this file to discover all available pages before exploring further.

# Email Campaigns

> One row per email campaign send — subject, audience size, opens, clicks, and attributed revenue. Agent-maintained.

## What it is

Campaign-level email marketing results. One row per send: the campaign name and subject, how many recipients it went to, how many opened and clicked, the revenue attributed to it, and its status. It is the rolled-up performance view of your email marketing — the numbers you compare campaign to campaign, not per-recipient detail.

## How it gets data

Populated by marketing agents and connectors (e.g. your email platform); not part of the standard onboarding catalog. Each row carries an `external_id` dedup key, so re-syncing the same campaign updates the row instead of duplicating it. Available to query once your workspace runs the relevant agents.

## Fields

| Field         | Type     | Description                                   |
| ------------- | -------- | --------------------------------------------- |
| `external_id` | text     | Source campaign id — the dedup/upsert key     |
| `campaign`    | text     | Campaign name                                 |
| `subject`     | text     | Email subject line                            |
| `sent_at`     | datetime | When the campaign was sent                    |
| `recipients`  | integer  | Number of recipients                          |
| `opens`       | integer  | Number of opens                               |
| `clicks`      | integer  | Number of clicks                              |
| `revenue`     | currency | Revenue attributed to the campaign            |
| `status`      | text     | Campaign status (e.g. draft, sent, scheduled) |

<Note>
  Also carries the system columns `id`, `tenant_id`, `workspace_id` (tenant isolation), `created_at`, and `updated_at`. They are managed automatically.
</Note>

## Query it

```json theme={null}
{
  "method": "tools/call",
  "params": {
    "name": "data_query",
    "arguments": {
      "view_slug": "email_campaigns",
      "filters": { "status": "sent" },
      "select_fields": ["campaign", "subject", "recipients", "opens", "clicks", "revenue", "sent_at"],
      "sort_by": "sent_at",
      "limit": 50
    }
  }
}
```