As a Sales Manager, I need to know how many outbound call attempts it takes to achieve a discussion. Additionally, so that my reps are more productive, I need a filtered list view of the prospects that they should call that includes the results from previous calls.
Use Rollup Helper to count the number of calls except those that resulted in a discussion and to rollup the Call Results. In order to have the count stop once a discussion is achieved, we will also need to use a workflow field update.
Create a custom picklist field on Task (Call Result). Example Values:
No Answer
Wrong Number
Disconnected Number
Left Voicemail
Left Message
Answer and Discussion
Create a text area field on Contact (Call Results)
Create a formula (checkbox) field on Contact (Answer and Discussion)
CONTAINS(Call_Results__c, 'Answer and Discussion')
Create a number field on Contact (Number of Calls)
Create a number field on Contact (Number of Calls to Get Discussion)
Create a Count Rollup
Rollup Helper Step 1) Select Contact as the Object you would like to roll up to.
Rollup Helper Step 2) Select “Number of Calls” as the field you would like to update.
Rollup Helper Step 3)
Select Task as the Child Object with Name ID-Task.WhoId as the relationship.
Select Deleted as the field on Task to use as a source.
Select Count
Add a New Custom Filter (Completed Calls, No Discussion)
Leave the Limit to box blank.
No sort order necessary
Specify Filter Criteria
Keep isDeleted = False
Status = Completed
Type = Call
Call Result != Answer and Discussion (be sure to use your custom picklist field, not the standard one)
Save and Run the rollup or run in real-time.
Create a Text Rollup.
Rollup Helper Step 1) Select Contact as the Object you would like to roll up to.
Rollup Helper Step 2) Select “Call Results” as the field you would like to update.
Rollup Helper Step 3)
Select Task as the Child Object with Name ID-Task.WhoId as the relationship.
Select Call Result (your custom one, not the standard) as the field on Task to use as a source for the rollup.
Select Text Separated By and New Line
Save and Run the rollup or run in real-time.
Create a Workflow Rule (Number of Calls to Obtain Discussion)
Object: Contact
Evaluation Criteria: created, and every time it's edited
Rule Criteria: Run the rule if the formula evaluates to true:
Answer_and_Discussion__c <> True
Immediate Workflow Action (Update “Number of Calls to Get Discussion”)
Specify New Field Value: Use a formula to set the new value.
Number_of_Calls__c
Save
Optional List View
Enter View Name (Attempted Contact No Discussion)
Specify Filter Criteria: Answer and Discussion = False
Select Fields to Display
Add “Number of Calls”
Add “Call Results” (This should be the results of your Rollup Helper Text rollup.
Restrict Visibility
Select desired visibility.
Save