marketing_campaigns

source

Outbound campaigns and their audience.

Definition

Campaign-level metadata — channel, audience segment, optional promo code distributed via the campaign. Joined to `marketing_sends` for per-customer engagement. `name` is renamed to `campaign_name` downstream to avoid the SQL keyword.

7 of 7

Column

Description

Tests · PII

campaign_id

Primary key — BIGSERIAL.

2 tests

name

Campaign display name (renamed to `campaign_name` downstream).

channel

`email` / `push` / `sms`.

1 test

audience_segment

Cohort slug — `all` / `consumer` / `business` / `enterprise` / `inactive_30d`. Nullable.

promotion_id

FK to `promotions.promotion_id`. Nullable.

send_at

When the campaign sent. TIMESTAMPTZ.

created_at

Row insert timestamp in the source DB.