Goal: To build dashboards that reflect our specific operational KPIs, which may not be present in the standard reports.
Analysis and Possibilities: The native reports offer an excellent overview. For our custom KPI needs, our current approach is to export data via CSV and process it in an external BI tool (like Power BI or Google Sheets). We also noted the existence of an API. Would using the API to feed our BI tool be the most robust and scalable alternative?
Inquiry: For creating highly customized reports, is exporting data (manually or via API) to an external BI tool the workflow you would recommend? Are there any limitations in the QA data API that we should be aware of before proceeding down this path?
Thanks for sharing your goal and analysis — you’re on the right track!
Using the Zendesk API to feed your external BI tool is indeed a robust and scalable approach for building highly customized dashboards tailored to your specific KPIs. The API allows for automated data exports, which helps maintain up-to-date reporting without the manual effort involved in CSV exports.
There are a few considerations when working with the Zendesk API:
-
Rate limits: The API has rate limits that vary depending on your plan, so you’ll want to design your data extraction logic to handle these gracefully.
-
Data granularity: Some data may require combining multiple endpoints or additional processing to reflect exactly what you need.
-
Historical data: While the API provides current and historical data, very large data sets may require incremental pulls and thoughtful data management.
Overall, integrating via API is a common best practice for scalable.I hope that helps! Feel free to contact our Support team via the messaging widget for any further assistance or if you have more questions as you work through integrating Zendesk data with your BI tools. We're always here to help ensure your reporting setup meets your operational needs smoothly and efficiently.
Best of luck with your dashboards, and don’t hesitate to reach out!