fivetran / fivetran/dbt_intercom
[Feature] add breakdown of what platform a user was using to reach out (web, email, iphone, android)
- 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.