I'm looking for the best way to track issues for every conversation our users initiate. We have previously used conversation tagging but it resulted in 100+ tags that were difficult to sort through and manage since we also use customer tags heavily.

I'd like to be able to track the core issue associated with each conversation.

Ideal categories I can choose for each conversation:

• Issue Type drop down list (feature request, bug, feedback, question, etc)
• Product Area drop down list (login, registration, dashboard, profile, etc)
• Specific description of issue (should be able to tag multiple conversations with the same issue description)
• Date of Issue (should be automatic based on the conversation data)

I need to be able to provide timely reports to management including:

• Total issue volume over the last 2-4 weeks
• Issue volume by Issue Type
• Issue volume by Product Area
• Issue volume by Specific Issue

The goal would be to resolve customer issues within the product, before users escalate.

So far I've tried intercom's built in conversation tags, Jira, Trello, Notion and a few other solutions. None of which are able to easily give me timely data in a format that I can easily turn into a report.

I'd even be happy somehow integrating Intercom with google sheets! 😅

If you know of an integration or another solution that might help me, I'd be forever grateful!