Account with last activity > 30 days



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

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