Sales By Accounts

Salesforce

 

Salesforce is the most popular cloud CRM with a focus on sales and support.

Which accounts are responsible for sales

Query Text

SELECT Owner.Name AS "Opportunity Owner", Account.Name, Opportunity.Name AS "Opportunity Name", Opportunity.Fiscal AS "Fiscal Period", Opportunity.CloseDate, Opportunity.Type, Opportunity.Amount
  FROM Opportunity
LEFT OUTER JOIN Account ON Opportunity.AccountId = Account.Id
INNER JOIN User AS Owner ON Opportunity.OwnerId = Owner.Id
WHERE (Opportunity.IsClosed = True AND Opportunity.IsWon = True)
ORDER BY Account.Name
  

Open Query