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.

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.


