Zum Inhalt springen
Search the hub

← All suppliers

Service

Zendesk

Customer service: tickets, users, CSAT — load, PII and support measures.

Templates only — grain, filters, custom fields and ownership are firm-specific.

Copy formulas into the KPI Definition Card, then adapt grain and filters.

Example

Tickets created

How many tickets were created in the period?

COUNT(*) WHERE created_at IN period
Grain
Ticket
Fields
Tickets.created_at
Dimensions
status, priority, group, channel

created_at as period filter.

Adapt: Use the Zendesk instance timezone.

Example

Tickets solved

How many tickets were solved in the period?

COUNT(*) WHERE solved_at IN period
Grain
Ticket
Fields
Tickets.solved_at, Tickets.status
Dimensions
priority, group, channel

solved_at vs status=Solved — stay consistent.

Adapt: Account for reopened tickets and backlog shift.

CSAT score

How satisfied are customers with support?

AVG(score) WHERE score IS NOT NULL
Grain
Satisfaction rating
Fields
Satisfaction Ratings.score, Satisfaction Ratings.ticket_id
Dimensions
group, channel

Only when satisfaction_ratings is loaded.

Adapt: Lock good/bad vs scale scoring model.

First reply time

How quickly does support respond to new tickets?

AVG(reply_time_in_minutes) FROM ticket_metrics
Grain
Ticket
Fields
Ticket Metrics.reply_time_in_minutes
Dimensions
priority, group, channel

Prefer ticket_metrics — more robust than manual calculation.

Adapt: Clarify business hours vs calendar hours.

Open tickets

How many tickets are currently open?

COUNT(*) WHERE status NOT IN (solved, closed)
Grain
Ticket
Fields
Tickets.status
Dimensions
priority, group, channel

Lock snapshot vs flow metric once.

Adapt: Count pending status as open depending on process.

Formula overview

Same formulas as a table — copy into KPI cards or SQL drafts.

Label Formula Grain Fields
Tickets created COUNT(*) WHERE created_at IN period Ticket Tickets.created_at
Tickets solved COUNT(*) WHERE solved_at IN period Ticket Tickets.solved_at, Tickets.status
CSAT score AVG(score) WHERE score IS NOT NULL Satisfaction rating Satisfaction Ratings.score, Satisfaction Ratings.ticket_id
First reply time AVG(reply_time_in_minutes) FROM ticket_metrics Ticket Ticket Metrics.reply_time_in_minutes
Open tickets COUNT(*) WHERE status NOT IN (solved, closed) Ticket Tickets.status

Tour