Email Campaigns

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)

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

Query it

{
  "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
    }
  }
}

AI Operating Guide

Vertical Intelligence

Getting Started

Governance

Resources

Sales & Commerce

Procurement

Marketing & Outreach

What it is

How it gets data

Fields

Query it

​What it is

​How it gets data

​Fields

​Query it

What it is

How it gets data

Fields

Query it