Connect Zendesk Support to Google Data Studio with Windsor.ai

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

Zendesk Field Reference
+
data integration

All your marketing data in one place, just in a few clicks.

In just a few clicks, Windsor.ai integrates all of your marketing data. Simply select and authenticate the connectors you want to use. You don’t even need to write a single line of code to connect your data. You can blend and visualize your marketing data in your preferred reporting platform after a few minutes of setup.

Automate and save time.

No more using CSV dumps and spreadsheets to bring together data from different platforms. Windsor.ai automates collecting all marketing data and minimizes time spent on preparing and formatting, saving you a lot of time and boosting the quality of your reports.
Spend less time on manual data loading and spreadsheets. Focus on what matters: Growing your business!
Data Automation
data warehouse

Use all your data where and when you need it.

We make sure that all the data we integrate is fresh and accessible to marketers, whenever they want. You can push your data from Windsor.ai to a variety of data destinations, including cloud storage services (Google BigQuery, Amazon S3, Azure, Snowflake), data visualization tools (Google Data Studio, Power BI, Tableau), and spreadsheets (Excel, Google Sheets).

About Zendesk Support

Zendesk is a service-first CRM company designed to improve customer relationships. Zendesk Support, one of Zendesk’s core products, provides a central location for businesses to receive, track, and respond to customer inquiries, complaints, and feedback collected across various channels, including email, phone, chat, and social media. The platform has a reputation for being user-friendly and customizable, with many integrations available to help businesses streamline their customer support workflows. More than 160,000 companies of all sizes, from small startups to large corporations, utilize Zendesk to enhance their customer service and customer experience across 160 countries.

Learn more about Zendesk Support

About Google Data Studio

Looker Studio or formerly known as Google Data Studio is a data visualization platform that helps businesses convert data into customizable informative reports and dashboards. It provides a simple and intuitive interface for users to create interactive reports and visualizations with their data. Data analysis using Google Data Studio provides businesses with valuable information that they can use to make informed decisions about their operations.

 

Learn more about Google Data Studio

Why integrate Zendesk Support with Google Data 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.

 

  • 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 from Zendesk Support. The insights are retrieved at the account, campaign, placement and line item level.

 

Once the user successfully logs into the connector it’s possible to choose the metrics and dimensions to create a report.

Prerequisites

To set up the connector, the user should have:

  • Access to a Zendesk Support account.
  • Google account for Zendesk Support to Google Data Studio integration.
  • A Windsor account. Start your free trial now.

(Visit our privacy policy and terms of use)

How to connect Zendesk Support to Google Data Studio?

You need to select Zendesk Support as a data Source and grant access to Windsor.ai. You should need to enter Zendesk subdomain alongside your e-mail address and password to grant access.

Zendesk Support Windsor.ai Onboarding

Select the fields on the right to later use in your data source. For example, you can include metrics such as Status, Subject, or Tags.

select fields on the right

Go to “Select Destination” and choose Google Data Studio.

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

Windsor.ai: All your marketing data in one place

Power up your marketing performance with result-driven marketing solutions

  • Connect all your marketing, CRM, and analytics data from 50+ platforms and stream it to any spreadsheet tool, BI platform, or data warehouse.
  • The setup is done in minutes. No coding is required.
  • Currently, we support more than 3000 dimensions and metrics.
  • See the value and return on every marketing touchpoint.
  • Our marketing attribution software platform provides marketers with a 15-44% increase in marketing ROI.

Google Data Studio Templates for Zendesk Support

Do you plan to connect and visualize Zendesk Support data in Google Data Studio?

 

These free and customizable Google Data Studio Zendesk Support templates will assist you in visualizing your data for easy reporting and analysis.

Google Data Studio Tutorials for Zendesk Support

Would you like to take your Google Data Studio Zendesk Support dashboards to the next level?

 

Here are some of our favorite tutorials to help you:

Available Zendesk Support Metrics and Dimensions

NameTypeDescription
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.
Assignee EmailTEXTWrite only. The email address of the agent to assign the ticket to.
Assignee IdTEXTThe agent currently assigned to 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.
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.
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.
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.
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.
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.
StatusTEXTThe state of the ticket. Allowed values are new, open, pending, hold, solved, or closed.
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.