Returns deal timeline data grouped into time intervals, showing deal counts and values for each period based on a specified date field.

View-Specific Information

SELECT

The provider uses 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 provider.

Column	Supported Operators
UserId	=
ConvertCurrency	=
ExcludeDeals	=
FilterId	=
PipelineId	=
IntervalType	=
Amount	=
StartDate	=
FieldKey	=
IntervalType	=

For example, the following query is processed server-side:

SELECT * FROM DealsTimeline WHERE Amount = '3' AND StartDate = '2021-12-12' AND FieldKey = 'add_time' AND IntervalType = 'month'  

Note: The required columns are Amount, StartDate, FieldKey and IntervalType.

Columns

Name	Type	References	Description
Deals	String		JSON array of deals that fall within this timeline period.
PeriodEnd	Datetime		End date and time of this timeline interval.
PeriodStart	Date		Start date of this timeline interval.
TotalValues	String		JSON object containing aggregated deal value totals for this timeline interval.

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
StartDate	Date		Date where the first interval starts. Format: YYYY-MM-DD.
IntervalType	String		Type Of Interval. The allowed values are day, week, month, quarter.
Amount	Integer		The number of given intervals, starting from start_date, to fetch E.g 3 months.
FieldKey	String		The date field key which deals will be retrieved from.
UserId	Integer		User id.
FilterId	Integer		Type Of Interval. The allowed values are day, week, month, quarter.
ExcludeDeals	Integer		Whether to exclude deals list 1 or not 0. The allowed values are 0, 1.
ConvertCurrency	String		3-letter currency code of any of the supported currencies.
PipelineId	Integer		Pipeline Id.