Last Activity Date in Salesforce

One of the most important fields to track in Salesforce is Last Activity Date. If you’re assigning Accounts to sales reps, you’ll likely want to track the last activity on those Accounts so Accounts that aren’t being actively worked can be re-assigned. Further, you may want to track currently open Opportunities based on their Last Activity Date to ensure that open Opportunities are actively being worked. Activity often correlates to setting Opportunities and moving Opportunities through the pipeline.

If you’re using Outreach, in Outreach under Settings >> Plugins >> Salesforce >> Contacts you can set which Activities from Outreach to track back to Contacts in Salesforce:

With this you can track in Salesforce who is opening your emails and clicking your links – both are indicators of potential interest in what you’re selling. The Last Activity Date on Accounts in Salesforce, though, is comprehensive of every activity on the Account. Therefore, you may find you want a custom Last Activity field in Salesforce to capture the date of certain outbound activities. This helps to differentiate any activity vs. pre-defined outbound activities. To do this, create a custom Date field (‘Last Activity Date’) on the Account object in Salesforce, then use a flow to set this field based on pre-defined activities coming from Outreach – for example ‘Outbound’ Emails from ‘Outreach’:

That’s a simple flow in Salesforce that fires on Activity create (after create), only fires if the activity meets the defined input criteria, then gets the parent Account and sets the current date. This way, you can track activities users take on Accounts based on your own defined criteria instead of what Salesforce offers out of the box. Finally, since this new Last Activity Date is on the Account, you can use a simple formula field to pull this field down to Opportunities for Opportunity Last Activity tracking,

Picture of Scott Ferrebbe Founder of Lighthill CRM in a light blue shirt and dark blue blazer with the top two buttons of the shirt unbuttoned revealing a white undershirt

The 3 best ways I can help you right now...

  1. Click here to schedule a call with one of our CRM Specialists.
  2. Click here to download our CRM Reality Checklist for Sales Superheroes
  3. Follow me on LinkedIn for exclusive tips, how-tos, resources, etc.

Share:

Facebook
Threads
X
LinkedIn
Email

More content...

3 easy steps to a CRM you can trust

Success Call

Share what’s broken and what “good” looks like.

Plan & Build

Get a simple plan to fix processes, data, and connections.

Launch & Win

Go live, trust your dashboards, and hit your numbers.

You’ll move from CRM chaos to predictable performance with one clear source of truth.

Trust your dashboard.
Lead with confidence.

Pick a time that works for you, and get a simple plan to make your CRM match reality.

Complete the form and we’ll get you scheduled for a CRM Success Call.

THANK YOU!

Click on the PDF below to download

Thank You!

We have your message and one of our CRM Specialists will get back to you shortly.