This article guides you in creating an export of your conversations and offers suggestions for questions you can ask ChatGPT to gain valuable insights from your data.
You can easily create an export of all your conversations and then have them analyzed by ChatGPT.
How to create an export of your conversations
To create an export of your conversations, follow these steps:
- Navigate to 'Statistics': After logging into Watermelon, go to the menu on the left and click on 'Statistics'.
- Create an export: In the upper right corner of the screen, you will see the option 'Export Conversations'. Click on this.
- Choose your export options: You can now select which conversations you want to export: only those with agents or all conversations. Make your selection and click 'Export'.
- Download your export: A pop-up will appear for you to download your export. Save the export to your desired location.
Now that you have created an export of your conversations, you can use it in ChatGPT for further analysis.
How to use your export in ChatGPT
With your downloaded CSV file, you can now use ChatGPT to conduct in-depth analyses of your conversations. Upload the file to ChatGPT and ask targeted questions to gain valuable insights.
Example questions
Here are some example questions you can ask:
- Top 5 topics: "What are the top 5 most discussed topics in these conversations?"
- Top 5 frequently asked questions (FAQs): "What are the top 5 frequently asked questions in these conversations?"
- Sentiment analysis: "Can you perform a sentiment analysis on the conversations and indicate what percentage is positive, negative, or neutral?"
- Identifying feedback and complaints: "Can you extract the main feedback and complaints from customers in these conversations?"
- Identifying popular products or services: "Which products or services are mentioned the most in the conversations?"
- Identifying improvement areas for the chatbot: "Based on these conversations, what improvement areas can you identify for our chatbot?"
By asking these questions to ChatGPT, you can obtain detailed insights that help improve your customer service, enhance your chatbot’s efficiency, and better understand what matters to your customers.
Important note on file size and text amount
Please note that there is a limit to the file size and amount of text you can upload or input at once. If you have a very large file with many conversations or a long list of questions you want to analyze, you may need to split the file into smaller parts or submit the text multiple times.
How to split your file
- Split your CSV file: Use a spreadsheet program like Excel or Google Sheets to split your CSV file into smaller files. You can do this by selecting a limited number of rows for each file and then saving them as separate files.
- Submit your text in parts: If you want to ask multiple questions or analyze longer texts, submit them in parts. You can do this by breaking your text into multiple sections and offering them to ChatGPT one by one.
By splitting your files and texts, you ensure that you can make optimal use of ChatGPT without running into limitations. This allows you to still perform comprehensive analysis but in manageable steps.
Conclusion
Exporting your conversations from Watermelon and analyzing them with ChatGPT provides a powerful way to gain insights and further optimize your customer service. Follow the simple steps to export your conversations, use the example questions as a starting point for your analysis, and discover valuable trends and patterns in your customer interactions.