Rollup Helper Use Case Library | Passage Technology

Track your first response time for a lead using Rollup Helper

Written by Passage Technology | May 07, 2014

Problem

Research shows that your best shot at reaching someone is right after their first interaction/lead is inserted into your CRM. As a sales manager, you need to track the speed with which your staff follows up on leads, but there is no field for this in Salesforce to easily report on or put into list views.

Solution

  1. Create a custom datetime field on Lead called 'First Response'. This field will be calculated by Rollup Helper using your lead's tasks.
  2. Create a number formula field on Lead called 'First Response Lead Time' as follows: (CreatedDate - First_Response__c)*1440
  3. Create a MIN rollup off the CreatedDate of a Task and roll it up to the Lead object using Rollup Helper (see the video for the exact steps). You will want to make sure to apply any filters to filter out automated or non-sales related tasks.