Build a Salesforce Report to track activities completed daily by your team

With Salesforce connected to Mixmax, your team's daily activities can now sync to Salesforce. This ensures that important correspondence with prospects and customers are visible and accessible directly to your team within Salesforce.

You can build a report in Salesforce using the synced data to get insight into the daily activities completed by your team. 

Salesforce tasks have a "Last modified date" field. But there isn't an easy way to know the exact date & time when a task was completed. In the example below, we used the standard field on the Task object called Completed Date/Time. We will then use the Process Builder in Salesforce to build an automation that will automatically update the Completed Date/Time field with today's date anytime someone completes an activity. Then, we will use this Completed Date/Time field to build a report that will tell us the number of activities the team has completed in a specified time frame

Under the SETUP > Object Manager > Task object menu, use the standard field Completed Date/Time.

Create the automation in Process Builder

Next, create a Process Builder automation to update the Completed Date/Time field with today's date anytime someone completes a task activity.

  1. Go to Setup and search for Process Builder in the Quick Find
  2. Once the Process Builder opens up, click on New to start a new process
  3. Next, give your process a name, description, and select A record changes as trigger for the process, then Save 
  4. Next, click on Add Object, select Task, and select when a record is created or updated to start the process
  5. Then, we'll click on Add criteria
    • Give your criteria a name
    • Select All Conditions are met as desired criteria
    • Create the condition below for when the Status field is set to "Completed"
    • Click on Yes under Advanced to execute the action only when the specified change is made
  6. Next, we'll click on Add action
    • Select Update Records under Action Type
    • Give your action a name
    • Under Record Type , choose the option for Select the Task record that started your process
    • Under Criteria for Updating Records, select No criteria - just update the records!
    • Next, we'll select to update the Completed Date/Time field, choose Formula under Type, then click on Build a formula and type in TODAY() in the text field below
    • Click Use this formula, then click Save.

We would recommend doing the same for any email activity synced from Mixmax by adding another Criteria. This would allow you to use the Completed Date field to build a report for not only completed tasks, but also, for synced sent email messages. To do this:

  1. Click on Add criteria
    • Give your criteria a name
    • Select All Conditions are met as desired criteria
    • Create the condition below for when the Description field contains Insight provided by Mixmax
    • Select All of the conditions are met (AND)
    • Click Save
  2. Click on Add action and set the same action as above

Build the Report

Now that you have used the Completed Date/Time field, you can build a Salesforce report on sent emails and completed tasks for a specific time frame. Simply include a filter option for Completed Date when building your report. Here's a sample report setup to show completed Mixmax activities for the past 30 days:

This will show you sent email activities (new and replies), as well as call tasks from your team completed within the last 30 days.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.