fivetran / fivetran/dbt_intercom

[Feature] Add new Intercom fields for real-time performance tracking based on conversation type and rating

Open
#27 0 comments 0 reactions 0 assignees View on GitHub
type:enhancement
Dominant language
No language data
Stars
6
Forks
10
PR merge metrics
No merged PRs in 30d

Description

### Is there an existing feature request for this?

- [X] I have searched the existing issues

### Describe the Feature

Several metrics are useful for assessing performance more rapidly in Intercom and can be mostly identified via case statements and aggregations.

## Live conversation metrics
Intercom has four states of a conversation: Open, idle, snoozed, closed. Making it easier to track the former three conversation types will allow for better live tracking of Intercom data for end customers.

* Open and snoozed tickets can be derived in `conversations_metrics` model by `conversation_state` based on Intercom API, but aggregates need to be calculated upstream for `total_conversations_open`, `total_conversations_snoozed` in `admin_metrics` and `company_metrics`.
* For idle, `is_idle` boolean can be created in `conversation_metrics` based on lack of `first_admin_response_at` value. Idle conversations can be derived by null values in `first_admin_response_at`. `total_conversations_idle` can then be calculated upstream in `admin_metrics` and `company_metrics`.
* Stretch:`total_conversations_participated` gives us a potential true denominator for each of these metrics--we could examine the conversation parts model. This should be fairly doable for `company_metrics`, but might need some creativity for `admin_metrics` as we'll need to break down which teammates participated in which conversations. We might need to dis-aggregate `all_conversation_admins` to associate conversations with admins.

## Conversation ratings
Intercom has the satisfaction rating to assess CSAT for most customers, looking at the % of conversations that have received a 4 or 5 star rating (a 😀 or 🤩 review from a customer after an Intercom conversation has concluded).

An `is_satisfied` boolean in `conversation_metrics` would be the easiest solve, and then upstream `satisfaction_ratings` to count those totals in `company_metrics` and admin_metrics`.

### Describe alternatives you've considered

Most of these metrics can probably be derived in the current models, but would require a ton of filtering on the dashboards themselves to generate. This provides simpler model metrics from which to perform aggregate calculations.

### Are you interested in contributing this feature?

- [X] Yes.
- [ ] Yes, but I will need assistance and will schedule time during your [office hours](https://calendly.com/fivetran-solutions-team/fivetran-solutions-team-office-hours) for guidance.
- [ ] No.

### Anything else?

_No response_

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.