PipelineDealsStageConversions
Returns stage-level deal conversion statistics for a specific pipeline over a given time period, showing the conversion rate between each pair of consecutive stages.
View-Specific Information
SELECT
The provider uses the Pipedrive API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| PipelineId | = |
For example, the following queries are processed server-side:
SELECT * FROM PipelineDealsStageConversions
SELECT * FROM PipelineDealsStageConversions WHERE PipelineId = 4
Columns
| Name | Type | References | Description |
| PipelineId | Integer | The ID of the pipeline for which stage conversion statistics are retrieved. | |
| ConversionRate | Integer | The percentage of deals that moved from the source stage to the destination stage during the specified period. | |
| FromStageId | String | The ID of the pipeline stage deals moved from. | |
| ToStageId | Integer | The ID of the pipeline stage deals moved to. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| UserId | Integer | ID of the user who's pipeline statistics to fetch | |
| StartDate | Date | Start of the period | |
| EndDate | Date | End of the period |