Recent searches


No recent searches

How to count the end-users with different calls within one week?

Answered


Posted Oct 31, 2023

We need to count:

  • One-touch call end-users: only call us 1 time within one week.
  • Two-touch call end-users: only call us 2 times within one week.
  • Three-touch call end-users: only call us 3 times within one week.
  • Four-touch call end-users: only call us 4 times within one week.
  • Five-touch call end-users: only call us 5 times within one week.
  • 5-10 call end-users: only call us more than 5 times but less than 10 times within one week.
  • 10 call end-users: only call us more than 10 times within one week.

    How should I write the formula?

0

1

1 comment

image avatar

Salim Cheurfi

Zendesk Customer Care

Hi Victoria,
 
The best approach here would be to create several metrics
For example for users with one call you can create this metric :
 
IF (COUNT(Inbound calls)=1) THEN [End-user ID]
ENDIF
 
It will give you the exact number of user that have called only once based on your time filter
 
Two touch metric
 
IF (COUNT(Inbound calls)=2) THEN [End-user ID]
ENDIF
Over than 5 :

IF (COUNT(Inbound calls)>5) THEN [End-user ID]
ENDIF
 
And so on, this allows you to report on user that called many times or only once based on your time filter (week, month etc..)
 
I hope this helps!

1


Please sign in to leave a comment.

Didn't find what you're looking for?

New post