Export Zendesk data for BI and DWH

When data is spread across several systems, you need cross-system reporting. Operational reporting for your customer service team takes place directly in Zendesk Explore. For analysis that also draws on other data sources, you can use business intelligence tools such as Tableau, Looker or Power BI.

Data export from Zendesk to external BI solutions and data warehouses
Data export from Zendesk to external BI solutions and data warehouses

Connect Zendesk with other data

You want to combine ticket content from Zendesk with data from your CRM, ERP or shop in your BI database or data warehouse (DWH). First, the data needs to reach that destination. There are two basic approaches: push and pull.

How push and pull compare

Push: send data when an event occurs

With the push approach, Zendesk sends data to a backend system when a defined ticket event occurs. A trigger is configured to send the required information through a webhook to an API endpoint.

This endpoint is ideally located in the same environment as the database. It receives the information in JSON format and uses it to create a record in the BI database.

Pull: retrieve data regularly

With the pull approach, a process retrieves data from the Zendesk API, for example once or several times a day. Zendesk provides incremental export endpoints that can return new or updated data.

When the data is not time-critical, we often prefer pull. The APIs provide access to ticket data and other information, including users, organizations, group names and metrics. This approach also works well with on-premise databases.

We work with you to identify the approach that fits your requirements and IT architecture.

Which data is transferred?

Regular transfers to a BI database commonly include:

  • tickets, including custom fields
  • ticket comments
  • ticket metrics
  • users, including requesters, agents and custom fields
  • organizations, including custom fields
  • groups

How we implement the export

For pull exports, we usually create low-maintenance Python scripts. They retrieve data from Zendesk, for example once a night, and write it to the designated database.

Possible destinations include a range of databases and data warehouses, such as MSSQL, Oracle, PostgreSQL, Snowflake, AWS Redshift or Google BigQuery.

What the export gives you

  • cross-system reporting that combines ticket data with other company sources
  • answers to business questions, such as how total revenue relates to ticket volume, using Zendesk data and revenue information from your ERP or shop
  • straightforward technical methods for transferring data to your BI database
  • less manual reporting through automated data transfers for analysis across several sources

Learn more about connecting your systems with our Zendesk API Addons Middleware.

LinkedIn
WhatsApp
Facebook
X

More Blog Articles

About the Author

Scroll to Top