dim_campaign


Description

All campaigns or ‘marketing initiatives designed to promote contract sales’, that are whitelisted for this DWH instance. A campaign can be associated to customers (fct_lead_lifetime), contracts and vouchers.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
campaign_id int8 19 null
fct_lead_lifetime.campaign_id fct_lead_lifetime_campaign_id_fkey R

The primary key of this table. System column calculated by the source System.
name varchar 256 null

The name of the campaign.
description varchar 256 null

The description of the campaign or UNKNOWN.
external_identifier varchar 256 null

The external identifier of the campaign.
archived bool 1 null

Permanently removed but kept for historic relations.
created_date_time timestamptz 35 null

Timestamp when the campaign was added into the source system.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags behind source system).

Relationships

Close relationships within degrees of separation