Sales By Accounts

Salesforce

 

Salesforce is the most popular cloud CRM with a focus on sales and support. Skyvia requires Salesforce Enterprise edition or higher.

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