stg_postgres__marketing_sends

staging view 1 PII columns

Marketing touches with engagement funnel timestamps.

Definition

Per-customer touch from a marketing campaign. Seeder gates sends on the active consent state at send-time; mid-window consent withdrawals are NOT reflected here — for compliance reporting, pair with `mart_consent_current` instead of using this surface alone. Boolean flags (`is_delivered` etc.) are derived in `int_marketing_engagement`.

12 of 12

Column

Description

Tests · PII

marketing_send_id

Primary key — UInt64.

2 tests

campaign_id

FK to `stg_postgres__marketing_campaigns.campaign_id`. NOT NULL.

2 tests

customer_id

FK to `stg_postgres__customers.customer_id`. NOT NULL.

customer +17 PII2 tests

sent_at

When the send was emitted. DateTime64(6).

1 test

sent_day

`toDate(sent_at)`. Partition key for daily marts.

delivered_at

When the provider confirmed delivery. Null on bounce.

opened_at

When the recipient opened (email/push). Null when not opened.

clicked_at

When the recipient clicked an in-message link. Null when not clicked.

unsubscribed_at

When the recipient unsubscribed via this send. Null when no unsubscribe.

bounce_reason

Provider reason on bounce. Nullable. Behavioural — kept under consent purpose.

PII

source_created_at

Row insert timestamp from the source DB. DateTime64(6).

airbyte_extracted_at

When Airbyte extracted this row from postgres-source.