Connect Zendesk Support to Looker Studio

Directly connect Zendesk Support to Looker Studio,in minutes, and in an easy-to-use format.

twitter ads google data studio integration

Analyze Your Marketing Metrics from Zendesk Support in GDS

Why integrate Zendesk Support with Looker Studio?

  • Google Data Studio can help you create customized dashboards and reports that allow you to monitor key metrics like ticket volume, response time, and resolution rate in one place.

 

  • Visualizing Zendesk Support data in Google Data Studio can enable you to easily spot trends and patterns in your customer support data such as spikes in support tickets on certain days of the week or during certain times of the year and help you make better decisions about staffing, training, and other aspects of your support operation.

 

  • The advanced visualization capabilities of Google Data Studio enable you to extract more insights from your Twitter Analytics data and make changes to your strategy to maximize your return on investment on social media.

 

  • By integrating Zendesk Support with Google Data Studio, you can automate data collection and reporting, reducing the risk of errors and freeing up time for your support team to focus on other tasks.

 

  • Connecting Zendesk Support to Google Data Studio can allow you to identify areas where your support team may be experiencing challenges or where your processes could be optimized that can increase efficiency and reduce costs.

 

About the Zendesk Support Google Data Studio Connector

The Zendesk Support Google Data Studio Connector pulls metrics and dimensions for Zendesk Support. The Insights are retrieved at the campaign and ad levels.

Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.

Prerequisites

To set up the connector, the user should have:

How to connect Zendesk Support to Looker Studio?

Do you plan to connect and visualize your Zendesk Support in Google Data Studio? Follow the Tutorial Below:

Select the fields on the right to later use in your data source. For example, you can include metrics such as Cost per Click, Cost per Action or Total Spend.select fields on the right

Go to “Select Destination” and choose Looker Studio.

select looker studio

Once done, select “connect” and authorize access to your data source.

zendesk support looker studio integration

 

Zendesk Support metrics & dimensions available for streaming into Google Data Studio

nametypedescription
Agent Wait Time In Minutes (business)NUMERICNumber of minutes the agent spent waiting during calendar and business hours
Agent Wait Time In Minutes (calendar)NUMERICNumber of minutes the agent spent waiting during calendar and business hours
Allow AttachmentsBOOLEANPermission for agents to add add attachments to a comment. Defaults to true.
Allow ChannelbackBOOLEANIs false if channelback is disabled, true otherwise. Only applicable for channels framework ticket.
Assigned AtDATEWhen the ticket was assigned
Assignee EmailTEXTWrite only. The email address of the agent to assign the ticket to.
Assignee IdTEXTThe agent currently assigned to the ticket.
Assignee StationsNUMERICNumber of assignees the ticket had
Assignee Updated AtDATEWhen the assignee last updated the ticket
Attribute Value IdsTEXTWrite only. An array of the IDs of attribute values to be associated with the ticket.
Brand IdTEXTEnterprise only. The id of the brand this ticket is associated with.
Collaborator IdsTEXTThe ids of users currently CC'ed on the ticket.
CollaboratorsTEXTPOST requests only. Users to add as cc's when creating a ticket.
CommentTEXTWrite only. An object that adds a comment to the ticket.
Created AtDATEWhen this record was created.
Custom FieldsTEXTCustom fields for the ticket.
Custom Status IdTEXTThe custom ticket status id of the ticket.
Custom Status Updated AtDATEThe date and time the ticket's custom status was last updated
DateDATEAlias for Created At.
DescriptionTEXTRead-only first comment on the ticket. When creating a ticket, use comment to set the description.
Due AtDATEIf this is a ticket of type task it has a due date.
Email cc IdsTEXTThe ids of agents or end users currently CC'ed on the ticket.
Email ccsTEXTWrite only. An array of objects that represent agent or end users email CCs to add or delete from the ticket.
External IdTEXTAn id you can use to link Zendesk Support tickets to local records.
First Resolution Time in Minutes (business)NUMERICNumber of minutes to the first resolution time during calendar and business hours
First Resolution Time in Minutes (calendar)NUMERICNumber of minutes to the first resolution time during calendar and business hours
Follower IdsTEXTThe ids of agents currently following the ticket.
FollowersTEXTWrite only. An array of objects that represent agent followers to add or delete from the ticket.
Followup IdsTEXTThe ids of the followups created from this ticket. Ids are only visible once the ticket is closed.
Forum Topic IdTEXTThe topic in the Zendesk Web portal this ticket originated from, if any. The Web portal is deprecated.
From Messaging ChannelBOOLEANIf true, the ticket's via type is a messaging channel.
Full Resolution Time in Minutes (business)NUMERICNumber of minutes to the first resolution time during calendar and business hours
Full Resolution Time in Minutes (calendar)NUMERICNumber of minutes to the first resolution time during calendar and business hours
Group IdTEXTThe group this ticket is assigned to.
Has IncidentsBOOLEANIs true if a ticket is a problem type and has one or more incidents linked to it. Otherwise, the value is false.
IDTEXTAutomatically assigned when the ticket is created.
Initially Assigned AtDATEWhen the ticket was initially assigned
Is PublicBOOLEANIs true if any comments are public, false otherwise.
Macro IdTEXTWrite only. A macro ID to be recorded in the ticket audit.
Macro IdsTEXTPOST requests only. List of macro IDs to be recorded in the ticket audit.
MetadataTEXTWrite only. Metadata for the audit. In the audit object, the data is specified in the custom property of the metadata object.
Organization IdTEXTThe organization of the requester. You can only specify the ID of an organization associated with the requester.
PriorityTEXTThe urgency with which the ticket should be addressed. Allowed values are urgent, high, normal, or low.
Problem IdTEXTFor tickets of type incident, the ID of the problem the incident is linked to.
Raw SubjectTEXTThe dynamic content placeholder, if present, or the subject value, if not.
RecipientTEXTThe original recipient e-mail address of the ticket. Notification emails for the ticket are sent from this address.
ReopensNUMERICTotal number of times the ticket was reopened.
RepliesNUMERICThe number of public replies added to a ticket by an agent
Reply Time in Minutes (business)NUMERICNumber of minutes to the first reply during calendar and business hourss
Reply Time in Minutes (calendar)NUMERICNumber of minutes to the first reply during calendar and business hours
Reply Time in Seconds (business)NUMERICNumber of seconds to the first reply during calendar and business hourss
Reply Time in Seconds (calendar)NUMERICNumber of seconds to the first reply during calendar and business hours
RequesterTEXTWrite only.
Requester IdTEXTThe user who requested this ticket.
Safe UpdateBOOLEANWrite only. Optional boolean. Prevents updates with outdated ticket data (updated_stamp property required when true).
Satisfaction RatingTEXTThe satisfaction rating of the ticket, if it exists, or the state of satisfaction, offered or unoffered. The value is null for plan types that don't support CSAT.
Sharing Agreement IdsTEXTThe ids of the sharing agreements used for this ticket.
Solved AtDATEWhen the ticket was solved.
StatusTEXTThe state of the ticket. Allowed values are new, open, pending, hold, solved, or closed.
Staus Updated AtDATEWhen the status of the ticket was last updated
SubjectTEXTThe value of the subject field for this ticket.
Submitter IdTEXTThe user who submitted the ticket. The submitter always becomes the author of the first comment on the ticket.
TagsOBJECTThe array of tags applied to this ticket.
Ticket Form IdTEXTEnterprise only. The id of the ticket form to render for the ticket.
TypeTEXTThe type of this ticket. Allowed values are problem, incident, question, or task.
Updated AtDATEWhen this record last got updated.
Updated StampDATEWrite only. Datetime of last update received from API.
URLTEXTThe API url of this ticket.
ViaTEXTFor more information, see the Via object reference
Via Followup Source IdTEXTPOST requests only. The id of a closed ticket when creating a follow-up ticket.
Via IdTEXTFor more information, see the Via object reference
Voice CommentTEXTWrite only. See Creating voicemail ticket.
TodayDATEToday's date

Easily connect Zendesk Support to Looker Studio

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your Zendesk Support and Google Data Studio Integrations