stg_postgres__marketing_campaigns

staging view

Campaigns, with day-truncated send time.

Definition

Campaign-level metadata — channel, audience segment, optional promo. Joined to `stg_postgres__marketing_sends` on `campaign_id` for engagement-funnel marts. No per-customer rows here, so non-PII at the model level.

9 of 9

Column

Description

Tests · PII

campaign_id

Primary key — UInt64.

3 tests

campaign_name

Display name (renamed from `name` to avoid the SQL keyword).

channel

`email`, `push`, or `sms`.

1 test

audience_segment

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

promotion_id

FK to `stg_postgres__promotions.promotion_id`. Nullable.

send_at

When the campaign sent. DateTime64(6).

send_day

`toDate(send_at)`. Convenience for daily marts.

source_created_at

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

airbyte_extracted_at

When Airbyte extracted this row from postgres-source.