Product review summary
Aggregate customer reviews into a structured summary with sentiment breakdown and key themes.
Ingredients
- Product review dataset (CSV or JSON array)
- Sentiment analysis prompt template
- Theme extraction prompt template
- Summary generation prompt template
Steps
- 1Load the review dataset and validate each entry has a rating and body text.
- 2Run sentiment analysis on every review body. Classify as positive, neutral, or negative with a confidence score.
- 3Extract recurring themes from positive and negative reviews separately. Group similar mentions.
- 4Generate a structured summary: overall sentiment distribution, top 3 praised themes, top 3 criticized themes, and a one-paragraph executive summary.
Output
A JSON object with sentiment counts, theme arrays, and a markdown summary block ready for dashboard rendering or report generation.