Comments (6)
from dbt_zendesk_source.
I've been investigating various time-based metrics from this model which are coming through with incorrect values compared to our Zendesk portal, and have a suspicion this might also be related to the 'agent' status of a used. I've gone through several example tickets where the time-based metrics are incorrect, and they all contain comments by agents who are no longer with the business (and therefore not active agents at the present time). By contrast, all the tickets I've tested where the time-based metrics are coming through correctly, are tickets where the only agents who handled the ticket, are still agents today.
I see this dependency table which the 'zendesk__ticket_metrics' model is reliant on 'end_user_comment_created_at', 'agent_responded_at'. So presumably if users who were agents at the time of the ticket, but the model is counting them as end-users, this will be causing incorrect calculations?
from dbt_zendesk_source.
Hi @nicksimba , thanks for reaching out and noticing this issue. This is definitely a limitation of Zendesk's data, as deactivated agents do get reclassified as users. This is a limitation on the connector as we do not sync user history data at this time.
I notice your configuration is "Running the Fivetran dbt transformations as they come". Do you happen to be using Quickstart? If so, the solution below will not work as you cannot configure variables in Quickstart.
If you aren't, we have a workaround we recently introduced! You can reclassify deactivated agents back from end-user
. You can see the instructions in the README here. You can see this logic in action in the stg_zendesk__user
table.
So you would use whatever specific criteria you need to reclassify your deactivated agents back from end-user
to agents
by set this variable in your dbt_project.yml
.
# dbt_project.yml
vars:
zendesk_source:
internal_user_criteria: "[INSERT YOUR SQL FILTER HERE TO GET THE FORMER AGENTS]"
So I would test that out if you have the ability to modify your dbt_project.yml
. If you are using Quickstart, this will not be possible at this time, and you will have to wait until we add variable configuration (which we do have on our roadmap).
Let me know if this approach makes sense!
from dbt_zendesk_source.
from dbt_zendesk_source.
Hi @nicksimba, awesome, looking forward to you testing and seeing if this variable configuration works for your purposes!
Thanks for the request! This is indeed something that has been requested a few times. The next best step would be to add your thoughts to this open feature request in our Fivetran Support Portal, and explain why this would be important. Agreed that it would make your job a lot easier in determining who is an agent or an admin!
from dbt_zendesk_source.
Hi @nicksimba , I believe the above mentioned approach should work for your purposes. The Support Portal would be the next best step for you if you want to proceed further. I will close this issue out.
Let me know if you have any questions!
from dbt_zendesk_source.
Related Issues (15)
- disabling `using_<source_table>` doesn't remove table from sources HOT 1
- BUG - order by causing resources exceeded error HOT 1
- BUG - Freshness checks fail for sources whose tables are excluded from sync HOT 1
- BUG - Freshness check fails for organization_tag HOT 5
- Pass-through columns for custom fields HOT 4
- An error occurs when the Destination is Snowflake. HOT 5
- [Feature] Support setting database and schema with environment variables HOT 1
- [Feature] Add source for `TICKET_CUSTOM_STATUS` table and accompanying staging models
- [Feature] Add phone to stg_zendesk__user HOT 4
- Update ERD link
- [Feature] Update collect_freshness config in src_zendesk.yml to account for dbt macro logic
- [Feature] update tmp models to use dbt_utils.star
- Custom Field Definition Not Working HOT 8
- update required dbt version to allow v0.19.0 HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbt_zendesk_source.