Skip to main content

Peliqan

Salesforce

Opportunities by stage

SQL query for Salesforce

Get opportunities by stage from Salesforce data.

SELECT StageName, COUNT(Id) AS OpportunityCount FROM Opportunity GROUP BY StageName

Salesforce data model

Salesforce
Account

Salesforce
Campaign

Salesforce
Case

Salesforce
Contact

Salesforce
Contract

Salesforce
Invoice

Salesforce
Invoice Line

Salesforce
Identity Verification Event

Salesforce
Legal Entity

Salesforce
Lead

Salesforce
Lead Status

Salesforce
Login Event

Salesforce
Opportunity

Salesforce
Opportunity Line Item

Salesforce
Order

Salesforce
Order Item

Salesforce
Organization

Salesforce
Partner

Salesforce
Payment

Salesforce
Payment Method

Salesforce
Payment Line Invoice

Salesforce
Pricebook

Salesforce
Pricebook Entry

Salesforce
Refund

Salesforce
Task

Salesforce
User Login

Salesforce
Work Order Line Item

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.