Exports · Zendesk Support

Zendesk ticket export to dashboard

Upload the file you already download from Zendesk Support. Every Number reads it with no setup, picks a screen, and puts a receipt on every number.

The question behind this file

Are first reply and full resolution times on target this month, and which groups and channels drive reopens and bad ratings?

What you get

By person

One row per person, with their numbers side by side.

Assignee says who handled each ticket, so reply and resolution times are compared person by person.

You can switch it to Ratings, Breakdown, This period vs last, Key numbers under “How it's read”.

Click any number for its receipt: the rule, the rows it used, and the rows it left out.

Getting the file

  1. Download it from Zendesk Support

    In Admin Center, click Account, then Tools, then Reports, and export tickets as CSV. Zendesk emails a link to the files. Data export is off by default, so the account owner asks Zendesk to turn it on first.

    Zendesk Support's guide

  2. Know what a row is

    One row is one ticket, values as of export time.

  3. Upload it as it is

    No cleanup first. Title rows, totals rows and repeated headers are skipped and listed in each receipt.

The 40 columns we tested with, from Zendesk Support's documentation

ID · Requester · Requester ID · Requester external id · Requester email · Requester domain · Submitter · Assignee · Group · Subject · Tags · Status · Priority · Via · Ticket type · Created at · Updated at · Assigned at · Organization · Due date · Initially assigned at · Solved at · Resolution time · Satisfaction Score · Group stations · Assignee stations · Reopens · Replies · First reply time in minutes · First reply time in minutes within business hours · First resolution time in minutes · First resolution time in minutes within business hours · Full resolution time in minutes · Full resolution time in minutes within business hours · Agent wait time in minutes · Agent wait time in minutes within business hours · Requester wait time in minutes · Requester wait time in minutes within business hours · On hold time in minutes · On hold time in minutes within business hours

How we know

This file is one of the 100 in our reading test. The column names are Zendesk Support's; the rows were generated to fit them, since we don't have your file. Your export may have more or fewer columns, and Every Number shows how it read each one before you build.