Hubspot: Deal Stages

Description

• Each record represents a stage within a deal in Hubspot

Supported Data Sources

• HubSpot

Columns

Type	Name	Description
STRING	deal_stage_id	The unique deal stage identifier.
INTEGER	deal_id	The ID of the deal.
STRING	deal_name	The name you have given this deal.
DATETIME	date_stage_entered	The timestamp the deal stage was entered.
DATETIME	date_stage_exited	The Fivetran calculated exit time of the deal stage.
BOOLEAN	is_stage_active	Boolean indicating whether the deal stage active.
STRING	pipeline_stage_id	The ID of the deal's pipeline stage.
STRING	pipeline_stage_label	The label of the deal's pipeline stage.
STRING	pipeline_id	The ID of the deal's pipeline.
STRING	pipeline_label	The label of the deal's pipeline.
STRING	source	The relevant source of the deal stage.
STRING	source_id	Reference to the source.
BOOLEAN	is_pipeline_stage_active	Boolean indicating if the pipeline stage is active.
BOOLEAN	is_pipeline_active	Boolean indicating if the pipeline is active.
BOOLEAN	is_pipeline_stage_closed_won	Whether the stage represents a Closed Won deal.
INTEGER	pipeline_stage_display_order	Used to determine the order in which the stages appear when viewed in HubSpot.
INTEGER	pipeline_display_order	Used to determine the order in which the pipelines appear when viewed in HubSpot.
DECIMAL	pipeline_stage_probability	The probability that the deal will close. Used for the deal forecast.
BOOLEAN	is_deal_pipeline_deleted	Boolean indicating whether a record has been deleted in Hubspot and/or inferred deleted in Hubspot by Fivetran; _fivetran_deleted and is_deleted fields are equivalent.
BOOLEAN	is_deal_pipeline_stage_deleted	Boolean indicating whether a record has been deleted in Hubspot and/or inferred deleted in Hubspot by Fivetran; _fivetran_deleted and is_deleted fields are equivalent.
BOOLEAN	is_deal_deleted	Boolean indicating whether a record has been deleted in Hubspot and/or inferred deleted in Hubspot by Fivetran; _fivetran_deleted and is_deleted fields are equivalent.
STRING	deal_pipeline_stage_created_at	A timestamp representing when the deal_pipeline_stage was created.
STRING	deal_pipeline_stage_updated_at	A timestamp representing when the deal_pipeline_stage was updated.