How can I create a report that shows when HTML emails were last opened. I can see this information when looking at a contact's past history. I have run the HTML Email Status report. It lists a very small number of emails that were sent and the date they were last opened. How can I get a complete list of emails sent and when they were last opened. I am not using Eistein Activity Capture.
The HTML Email Status Report only shows messages that were sent by the running user. The help article also mentions:
To make the HTML Email Status report available to others
Add your HTML Email Status report to a Salesforce.com Dashboard.
Set 'View Dashboard As' to the User that sent the email.
Save the dashboard.
There's no way to get all status from all users in a single report or view.