marketing_sends

source 1 PII columns

Marketing touches — sent, opened, clicked, unsubscribed.

Definition

Per-customer marketing touch with the engagement funnel timestamps (`sent_at` → `delivered_at` → `opened_at` → `clicked_at`, or `unsubscribed_at` / `bounce_reason` on the negative path). Seeder gates on the active consent state at send-time; for live compliance reporting, pair this surface with `mart_consent_current` rather than relying on it alone.

10 of 10

Column

Description

Tests · PII

marketing_send_id

Primary key — BIGSERIAL.

2 tests

campaign_id

FK to `marketing_campaigns.campaign_id`. NOT NULL. ON DELETE CASCADE.

1 test

customer_id

FK to `customers.customer_id`. NOT NULL.

customer +17 PII1 test

sent_at

When the send was emitted.

delivered_at

When the provider confirmed delivery. Null on bounce.

opened_at

When the recipient opened. Null when not opened.

clicked_at

When the recipient clicked. Null when not clicked.

unsubscribed_at

When the recipient unsubscribed. Null when no unsubscribe.

bounce_reason

Provider reason on bounce. Nullable. Behavioural PII under the marketing consent purpose.

PII

created_at

Row insert timestamp in the source DB.