My team is attempting to calculate conversation metrics in Power BI, using the data piped into our data lake. We’re attempting to count the number of replies across all conversations over a particular time period. I know the part_author is “Admin,” but what conversation_part values constitute a reply? We want to match the metrics provided via the in-app reporting tool.
Reply Conversation Parts
Best answer by Emilygav
Hey there
To calculate the number of replies across all conversations over a particular time period, you should focus on conversation parts where the part_type is comment. This indicates a reply made by a teammate or admin.
Here’s how you might proceed:
- Filter Conversation Parts: Look for conversation parts with part_type = comment and ensure they fall within your specified date range
- Count Unique Conversations: Count the unique number of conversations that include these parts to get the number of replies
Please note that the count_conversation_parts under statistics includes all conversation parts, including the initial message, while conversation_parts.total_count excludes the first message. This distinction is important when calculating replies, as you should focus on parts beyond the initial message.
Hope this helps! 💪🏼
Reply
Join the Intercom Community 🎉
Already have an account? Login
Login to the community
No account yet? Create an account
Intercom Customers and Employees
Log in with SSOEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.