Account with last activity > 30 days



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

Which accounts need your attention?

Query Text

SELECT a."LastActivityDate" 'Last Activity', u."Name" 'Account Owner', a."Name" 'Account Name', a."BillingState", a."Type", a."Rating", a."LastModifiedDate"
  FROM "Account" a
  LEFT OUTER JOIN "User" u ON a."OwnerId"=u."Id"
  WHERE date("LastActivityDate") < date('now', 'localtime', '-30 days') 

Open Query