Pipeline
Stalled deals — open leads sitting too long in their current stage
Powers the Stalled deals panel on the Leads & pipeline screen — the operational counterpart to pipeline velocity. Velocity gives average time-in-stage; this lists the specific open deals that have exceeded the threshold and need working now.
Current-state query: a deal’s time-in-stage is measured from its most recent workflow transition to now, so it takes a threshold_days cut-off, not a period.
| Field | Meaning |
|---|---|
total_stalled | Open deals past the threshold |
stages[].count / value | Stalled deals and their open value per stage |
deals[] | The stalled deals (capped), worst first by days-in-stage |
GET
Stalled deals — open leads sitting too long in their current stage
Authorizations
Enter your JWT token in the format: Bearer
Query Parameters
Days in current stage before a deal counts as stalled. Defaults to 14.
Previous
Revenue by client categoryPowers the **Revenue by category** doughnut on the **Overview** screen and the horizontal bar chart on the **Sales analytics** screen.
Categories are driven by `LeadCategory` records (Direct, Agency, Digital, Government). Each row includes total contract value, deal count, and avg deal value for leads committed in the period.
Next
Stalled deals — open leads sitting too long in their current stage
