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

답변함


2023년 10월 31일에 게시됨

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개

      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


      댓글을 남기려면 로그인하세요.

      원하는 정보를 못 찾으셨나요?

      새 게시물