Sales By Accounts



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