Examples
Examples
Try the starting example
- Contact records: unique contact ID, supplied case ID, period label
- C1,A,P1 C2,A,P1 C3,B,P1 C4,A,P2 C5,C,P2
- Contacts by period
- P1: 3; P2: 2
- Distinct cases by period
- P1: 2; P2: 2
- Contacts beyond one per case / contacts (%)
- P1: 33.3333333333; P2: 0
- Contacts per distinct case
- P1: 1.5; P2: 1
- Case IDs present in multiple periods
- A
Try another scenario
- Contact records: unique contact ID, supplied case ID, period label
- C1,A,P1 C2,B,P1 C3,C,P1 C4,A,P2 C5,C,P2
- Contacts by period
- P1: 3; P2: 2
- Distinct cases by period
- P1: 3; P2: 2
- Contacts beyond one per case / contacts (%)
- P1: 0; P2: 0
- Contacts per distinct case
- P1: 1; P2: 1
- Case IDs present in multiple periods
- A, C
Calculation method
Calculation method
Contacts by period
Count unique contact records, preserving first period appearance.
Distinct cases by period
Count supplied case identifiers separately within each period.
Contacts beyond one per case / contacts (%)
100×(contacts−distinct cases)/contacts; repeated contact is not necessarily a duplicate event.
Contacts per distinct case
Period contacts/distinct cases.
Case IDs present in multiple periods
List case IDs observed under more than one period label.
Symbols and units
- a
- Contact records: unique contact ID, supplied case ID, period label
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- A supplied case-ID contact-frequency audit, not automatic identity resolution or a recommendation to delete contacts. Period boundaries and case attribution are defined externally.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
Zendesk: response metrics and business-hour definitions; this tool uses its displayed convention ↗
Background reading; this does not imply endorsement or independent review of SumFizz.