fivetran / dbt_intercom

Data models for Fivetran's Intercom connector built using dbt.
https://fivetran.github.io/dbt_intercom/
Apache License 2.0
4 stars 6 forks source link

[Feature] Add SLA metrics to Intercom reports #26

Open fivetran-avinash opened 2 years ago

fivetran-avinash commented 2 years ago

Is there an existing feature request for this?

Describe the Feature

SLA metrics are becoming a more crucial reporting mechanism for Intercom customers, particularly with how customer success teams evaluate the effectiveness of their teammates.

This feature would add the following data:

Describe alternatives you've considered

The SLA metrics we get directly from Intercom do have 'hit', 'miss', 'cancelled' values according to documentation. So we could technically get aggregate SLA hit and miss rate over a particular time period if we want to scope down.

However, we do not know what the actual SLA targets are, customer-by-customer, as they are configurable goals that could very much differ. It'd be better if we set SLA goal metrics on our end based on targets.

If median_next_response_time is too complicated to calculate, it might be worth discussing whether we parse down this to request to only the first_response SLA targets.

Are you interested in contributing this feature?

Anything else?

Read more on Intercom SLA performance here.