Number of open deals by stage
SQL query for Pipedrive
Count the number of open deals in each stage.
SELECT stage, COUNT(*) FROM deals WHERE status = open GROUP BY stage
Pipedrive data model
Organizations
Persons
Deals
Activities
Stages
Organization Fields
Person Fields
Deal Fields
Users
Deals Flow
Pipelines
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed