PipelineDealsMovements
Returns statistics for deals movements for given time period.
Select
The add-in will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
- PipelineId supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM PipeLineDealsMovements WHERE PipelineId = 4
Columns
| Name | Type | Description |
| PipelineId | Integer | ID of the pipeline. |
| AverageAgeInDaysAcrossAllStages | Integer | AverageAgeInDaysAcrossAllStages. |
| AverageAgeInDaysByStages | String | AverageAgeInDaysByStages. |
| DealsLeftOpenCount | Integer | DealsLeftOpenCount. |
| DealsLeftOpenDealsIds | String | DealsLeftOpenDealsIds. |
| DealsLeftOpenFormattedValuesUSD | String | DealsLeftOpenFormattedValuesUSD. |
| DealsLeftOpenValuesUSD | Integer | DealsLeftOpenValuesUSD. |
| LostDealsCount | Integer | LostDealsCount. |
| LostDealsDealsIds | String | LostDealsDealsIds. |
| LostDealsFormattedValuesUSD | String | LostDealsFormattedValuesUSD. |
| LostDealsValuesUSD | Integer | LostDealsValuesUSD. |
| MovementsBetweenStagesCount | Integer | MovementsBetweenStagesCount. |
| NewDealsCount | Integer | NewDealsCount. |
| NewDealsDealsIds | String | NewDealsDealsIds. |
| NewDealsFormattedValuesUSD | String | NewDealsFormattedValuesUSD. |
| NewDealsValuesUSD | Integer | NewDealsValuesUSD. |
| WonDealsCount | Integer | WonDealsCount. |
| WonDealsDealsIds | String | WonDealsDealsIds. |
| WonDealsFormattedValuesUSD | String | WonDealsFormattedValuesUSD. |
| WonDealsValuesUSD | Integer | WonDealsValuesUSD. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| UserId | Integer | ID of the user who's pipeline statistics to fetch. |
| StartDate | Datetime | Start of the period. Date in format of YYYY-MM-DD |
| EndDate | Datetime | End of the period. Date in format of YYYY-MM-DD |