Rollup Helper is a free Salesforce solution that lets you roll up any Salesforce data. You can quickly configure count, average, percent, lookup, text, formula, sum, max, min, hierarchy, multi-currency rollups, and more. Roll up the data your users need on records, list views, or reports!
Use Case: Number of opened emails per Contact, Lead, or Account
Have you ever considered sorting your Leads or Contacts in Salesforce by engagement? For example, how to sort Contacts/Leads by the number of times they opened your emails sent via Mixmax sequences? All that is possible with the Rollup Helper. Here is how:
Install Rollup Helper in your Salesforce organization. For more details, see how to install Salesforce packages.
Go to Rollup Helper using the App Launcher and click Create a new Rollup. Create a custom "Number of opened emails" field on the Contact, Account, or Lead object with the Task object as the source of your rollup.
Set Count as the source field Type.
Add a new custom filter with the following logic on the filter criteria:
isDeleted equals false
subject contains Opened (will be automatically formatted as '%Opened%')
2. Use the "Number of opened emails" field in your Salesforce list views and reports:
That's it! Now you have an easy and powerful solution to sort your Contacts, Accounts, or Leads by engagement!