Video Content
- Link to the template
- Link to the example spreadsheet
How to use a Tess AI template to analyze customer satisfaction survey results, such as NPS (Net Promoter Score), CSAT (Customer Satisfaction Score), or others, from data in a spreadsheet.
Context: The challenge of analyzing large volumes of responses in satisfaction surveys, especially when there are many open-text comments, is significant. The template automates this analysis, providing a concise summary and relevant insights!
Template Features: The template allows for:
- Analyzing data from a spreadsheet (Google Sheets or Excel, if preferred).
- Identifying positive and negative comments.
- Extracting insights and trends.
- Generating improvement recommendations.
How to Use the Template: The user needs to provide:
- The link to the spreadsheet with the research data.
- The range of cells to be analyzed.
- The maximum number of rows for the response.
Integration with Google Sheets: The template integrates directly with Google Sheets, facilitating access.
Positive Comments: Grouped by theme (e.g., quality, ease of use) with examples.
Negative Comments: Grouped by theme (e.g., difficulty of use, confusing interface) with examples.
Recommendations: Suggestions for enhancing positive points and addressing issues identified in negative comments.
Conclusion: An overview of the analysis results.
Example of Use: A practical example with a spreadsheet containing contact name, email, NPS score, date, and comment. The template analyzes comments and generates a summary with:
Additionally, the example uses a text template, but it is also possible to create a chat template to interact with the results!
Simplify the analysis of customer satisfaction surveys, saving time and providing valuable insights for decision-making!