nurture_campaign_steps


Description

A row in this table represents a discrete step in a specific nurture campaign. Can be used to analyze how many campaign steps have been executed, and how many are lined up for the future.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
nurture_campaign_step_id varchar 2147483647 null
nurture_campaign_step_archives.nurture_campaign_step_id nurture_campaign_step_archives_nurture_campaign_step_id_fkeyN
nurture_campaign_step_delays.nurture_campaign_step_id nurture_campaign_step_delays_nurture_campaign_step_id_fkeyN
nurture_campaign_step_emails.nurture_campaign_step_id nurture_campaign_step_emails_nurture_campaign_step_id_fkeyN
nurture_campaign_step_snoozes.nurture_campaign_step_id nurture_campaign_step_snoozes_nurture_campaign_step_id_fkeyN

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

nurture_campaign_id varchar 2147483647 null
nurture_campaigns.nurture_campaign_id nurture_campaign_steps_nurture_campaign_id_fkeyN

The ID of a specific nurture campaign.

action_type varchar 2147483647 null
nurture_campaign_action_enum.nurture_campaign_action_id nurture_campaign_steps_action_type_fkeyN

The type of action performed by this step, enumerated by nurture_campaign_action_enum.

delay_type varchar 2147483647 null
nurture_campaign_delay_enum.nurture_campaign_delay_id nurture_campaign_steps_delay_type_fkeyN

The type of delay to apply.

estimated_delay_expires_at timestamp 29,6 null

When the delay is expected to expire.

delay_expired_at timestamp 29,6 null

When the delay expired.

sort_rank numeric 131089 null

Numeric order of this step in the nurture campaign.

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

row_updated_at timestamp 29,6 CURRENT_TIMESTAMP

Date this entity was updated in the database. Useful to setup incremental refreshes of the data in your periodic ETL job.

Indexes

Constraint Name Type Sort Column(s)
nurture_campaign_steps_pkey Primary key Asc nurture_campaign_step_id
nurture_campaign_steps_account_id_index Performance Asc account_id
nurture_campaign_steps_nurture_campaign_id_idx Performance Asc nurture_campaign_id

Relationships