A question that is raised a lot by our customers and by customer of Salesforce is "Why isn't Last Activity Date being Populated by Email Messages"

This is due to the fact that Einstein Activity Capture data is not stored on Salesforce Servers rather within Amazon AWS.

Therefore, Einstein Activity Capture records may in fact look to be visible on your Lead, Contact, Account, and Opportunity records but those are not records to begin with. Rather those are items that are being streamed from Amazon AWS into your Salesforce org. Without having that record information in Salesforce, there is no way to use that data since it's being streamed from AWS.

You can also verify this yourself: if you click on any emails that appear under the activity timeline and click "View Full Email," you'll notice in the URL bar that there is no record ID associated. Rather, you will see the URL of what it's pulling from AWS. Therefore, without any record ID association, this can not be used under the Task and Events objects and therefore is inaccessible to be used in a formula field for Last Activity Date.

Salesforce is aware of this limitation and asks their users to upvote these ideas below so that the product team could prioritize this.

Ideas Exchange:

Other Items to Note (Activity Metrics):

Salesforce does provide Activity Metrics as part of Einstein Activity Capture for Email Activity however you must first purchase licenses for Salesforce Inbox. Salesforce Inbox is an email productivity platform that integrates directly with Salesforce. It allows you to manage customer communications directly from Salesforce, eliminating the need to switch between different platforms. With Salesforce Inbox, you can: Send and receive emails. Schedule appointments.

However, even with Activity Metrics enabled with Salesforce Inbox, these metrics are coming from Amazon AWS and therefore still exhibits the same limitations when it comes to utilizing Last Activity Date for Task and Events.

​