fivetran / fivetran/dbt_intercom

[Feature] add breakdown of what platform a user was using to reach out (web, email, iphone, android)

Open
#61 1 comment 1 reaction 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

title is self descriptive, fairly simple enhancement to the model for models/intercom__conversation_enhanced.sql

### How would you implement this feature?

models/intercom__conversation_enhanced.sql

look at contact history joined to conversation_contact_history
if the browser is not null, they reached out as web chat, if email is not null they emailed, if andrioid device is not null then they are on an android app, and same for IOS, its a simple case statement that we then join into the final model

### Describe alternatives you've considered

adding a downstream model doing this join, but we are already doing it here so figured why calculate twice?

### Are you interested in contributing this feature?

- [x] Yes.
- [ ] Yes, but I will need assistance.
- [ ] 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.