DealPipelineStages
Defines stages within a deal pipeline, offering structure to sales processes and enabling stage-based reporting.
Table Specific Information
Deal pipeline stages represent the individual stages of a given pipeline that a Deal may currently be on.
SELECT
When selecting deal pipeline stages, they can only be filtered by the PipelineId. For example:
SELECT * FROM DealPipelineStages WHERE PipelineId = 12345
Columns
| Name | Type | References | Description |
| PipelineId [KEY] | String |
DealPipelines.PipelineId | Unique identifier assigned to the deal pipeline. |
| StageId [KEY] | String | Unique identifier assigned to the specific stage in the pipeline. | |
| PipelineName | String | Name of the deal pipeline as displayed in HubSpot. | |
| PipelineIsActive | Boolean | Boolean flag indicating whether the pipeline is currently active. | |
| StageName | String | Name of the individual stage within the deal pipeline. | |
| StageIsActive | Boolean | Boolean flag indicating whether the stage is currently active. | |
| StageClosedWon | Boolean | Boolean flag indicating whether the stage represents a closed and won deal. | |
| StageDisplayOrder | Integer | Numeric value specifying the display order of the stage within the pipeline. | |
| StageProbability | Double | Estimated probability percentage of successfully closing the deal at this stage. |