Start free
← All report templates

Gorgias · Free Data Studio template

Gorgias report template

See how fast your team replies, and where tickets wait.

Tickets created and resolved, first response and resolution times, SLA performance by priority, team and agent, and the open backlog. One editable report for a monthly support review.

A Google account is needed to save a copy.

Explore the report

Choose a page to see its charts and metrics.

Choose a report page to preview
Gorgias overview report page.
Know your ticket volume and reply speed. Open this page ↗
Gorgias resolution report page.
Find where tickets take longest. Open this page ↗
Gorgias open tickets report page.
See the backlog customers are waiting on. Open this page ↗
Gorgias start here report page.
Your reporting guide. Open this page ↗

Open interactive report ↗ · Download PDF · CSV

Make this report yours

  1. Preview the report

    Explore the pages, charts and filters.

  2. Save a free copy

    Add your logo and adjust the layout for your team or clients.

  3. Connect your account

    Choose the account you want this dashboard to report on.

Keep your dashboard up to date

Add Gorgias with your Gorgias subdomain, account email and an API key from a user who can see every ticket and view statistics. Datapipe reads your tickets with their first response times and SLA status and updates the Google Sheet behind your dashboard on your schedule.

GorgiasSelected account
DatapipePrepare & refresh
Google SheetsPrivate report data
Data StudioYour dashboard

Setup, pricing and metrics

What does this Gorgias report include?

Four pages: Start here, Overview, Resolution and Open tickets. Overview shows tickets created and resolved, average first response time and first responses within SLA, tickets by day, by channel and by contact reason. Resolution shows resolution time and SLA, tickets with a breached SLA, tickets resolved by day, resolution time by priority, and results by agent. Open tickets shows the current backlog by team, priority, status and agent, with the oldest open tickets.

How do I use this template with my own Gorgias account?

Add Gorgias as a data source in Datapipe with your Gorgias subdomain, account email and API key. Use the key of a user who can see every ticket and view statistics. Then create this dashboard and authorize Google Sheets separately. Datapipe reads your tickets and their first response times and SLA statuses, prepares three worksheets and your private Data Studio copy; scheduled refreshes update the same workbook.

How do the comparisons work?

Each card compares the dates you pick with the same number of days just before them. To fill those cards, each refresh reads the tickets created or updated since the start of that earlier period, so a 90-day dashboard reads about 180 days of ticket activity.

Where do response and resolution times come from?

First response time is Gorgias’s own measure for each ticket, read from Gorgias statistics. The report averages it over tickets with a reply; Gorgias’s reports often show the median, which is usually lower. Resolution time is calendar hours from creation to the latest close, so a ticket that was reopened counts until it was closed again.

How is SLA performance counted?

First responses within SLA divides tickets that met the first-response target in your Gorgias SLA policy by tickets whose target was met or missed. Resolved within SLA does the same for the resolution target on closed tickets. Tickets still inside their target are left out until it is met or missed. The SLA cards stay empty until you set up SLA policies in Gorgias.

Which days and tickets are included?

Days are in UTC. Tickets created counts tickets by the day they were created, and Tickets resolved by the day they were closed. Trashed and spam tickets are left out. Open tickets shows open and snoozed tickets at the latest refresh; an open ticket with no update since the start of the comparison period is not included.

Why aren’t satisfaction scores included?

This template uses the same pages as the other help desk templates, which don’t include satisfaction scores yet. Gorgias satisfaction surveys are available as their own report in Datapipe.

Is the template free?

The template, PDF and CSV are free. Datapipe plans apply to automatic refreshes for your account.

Make it your next report.