Announcing the Fivetran dbt Package for Zendesk Support

Refine customer success data modeling with more detailed ticket tracking
 Announcing the Fivetran dbt Package for Zendesk Support

Download the package

Our latest dbt (data build tool) package, created for Zendesk Support, will help you refine your ticket tracking by providing models that:

  • Attach response and resolution times, along with other contextual information, to Zendesk tickets
  • Create history tracking (slowly changing dimension type 2) for Zendesk ticket fields
  • Track SLA breaches as determined by your SLA policy configured in Zendesk
  • Support both business and calendar hour reporting to accommodate your support requirements

Zendesk API Challenges

The Zendesk Support API provides over 20 different endpoints to help you programmatically gather your data, but it presents quite a few challenges. For example, you’ll have to figure out how to: - Normalize the data in a way that preserves the relationships between tickets and their associated fields and accounts - Capture deleted objects - Apply your SLA policy to your analytics dashboards

What Fivetran Helps With

Our native Zendesk Support connector takes care of many of those challenges right out of the box. After the OAuth mechanism captures your authorized credentials, the API response is normalized into their respective tables, as laid out in our public documentation. This connector automatically detects when rows are updated in the source and applies those changes to the relevant rows in the destination tables, including when data has been deleted in Zendesk. Continuing to build on the data integrated by the connector, the dbt package creates tables that cover areas such as further insights into ticket field history tracking and alerting when SLA policies have been breached.

Download the package

Start analyzing your data
in minutes, not months

Launch any Fivetran connector instantly.
We have detected that you are using an adblocking plugin in your browser. We don't show ads, but we rely on advertising services, so it might restrict you from completing important functions or seeing important content. Please make sure you whitelist our website in your adblocking plugin.
Adblock Detection