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?
The best approach here would be to create several metrics
For example for users with one call you can create this metric :
It will give you the exact number of user that have called only once based on your time filter
Two touch metric
Over than 5 :
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!