dim_lead_stage


Description

A custom stage describing where a lead is in the pipeline.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
lead_stage_id int8 19 null
fct_lead_lifetime.lead_stage_id erp_v2_fct_lead_lifetime_lead_stage_id__erp_v2_dim_lead_stage_lead_stage_id_fkey_38cc29024b18 R
fct_lead_stage_history.lead_stage_id erp_v2_fct_lead_stage_history_lead_stage_id__erp_v2_dim_lead_stage_lead_stage_id_fkey_9ca022e7a4b5 R

The primary key of this table. System column calculated by the source System.
stage_label varchar 65535 √ null

Name of this lead stage (e.g. “New Inquiry”, “Contacted”, “Trial Booked”).
stage_position int4 10 √ null

The ordering position of this stage within its pipeline. Lower values appear earlier in the funnel.
stage_group_id int8 19 √ null

The pipeline (group of stages) this stage belongs to.
stage_group_label varchar 65535 √ null

The name of the pipeline (group of stages) this stage belongs to.
is_archived bool 1 √ null

Whether this stage has been archived and is no longer used in the active pipeline.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).
data_landing_time timestamptz 35 getdate()

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation