# Review Analysis Report — Template

> Fill every bracketed field. Delete this quote block before sharing. Keep numbers and quotes; cut adjectives.

## 1. Overview

- **Product / SKU:** [name + ASIN/SKU]
- **Variants covered:** [colors / sizes / models]
- **Reviews analyzed:** [N analyzed] (of [N pulled]; removed [N] duplicates, [N] flagged fake/incentivized)
- **Date range:** [YYYY-MM-DD] to [YYYY-MM-DD]
- **Average rating:** [x.x] / 5
- **Star-vs-text mismatch rate:** [x]% (recoded to text)
- **Analyst / date:** [name] — [YYYY-MM-DD]
- **Baseline for re-run:** [yes/no] — next re-run due [date]

**Rating distribution**

| Stars | Count | % |
| --- | --- | --- |
| 5 | [n] | [%] |
| 4 | [n] | [%] |
| 3 | [n] | [%] |
| 2 | [n] | [%] |
| 1 | [n] | [%] |

## 2. Aspect-Based Sentiment

> % is of reviews that *mention* the aspect, not of all reviews. Trend compares earliest vs latest time window.

| Aspect | Positive % | Negative % | # Mentions | Trend (improving / stable / worsening) |
| --- | --- | --- | --- | --- |
| [Quality / durability] | [%] | [%] | [n] | [trend] |
| [Sizing / fit] | [%] | [%] | [n] | [trend] |
| [Shipping / packaging] | [%] | [%] | [n] | [trend] |
| [Accuracy vs listing] | [%] | [%] | [n] | [trend] |
| [Value / price] | [%] | [%] | [n] | [trend] |
| [Usability] | [%] | [%] | [n] | [trend] |
| [Customer service] | [%] | [%] | [n] | [trend] |

## 3. Top Pain Points (ranked by severity)

> Severity = frequency x impact (return / refund / safety / rating drag), 1-5.

| # | Issue | Count (% of reviews) | Severity | Sample quote (verbatim, de-identified) | Route |
| --- | --- | --- | --- | --- | --- |
| 1 | [issue] | [n] ([%]) | [1-5] | "[quote]" — [review ID] | [PRODUCT / COPY / BOTH] |
| 2 | [issue] | [n] ([%]) | [1-5] | "[quote]" — [review ID] | [route] |
| 3 | [issue] | [n] ([%]) | [1-5] | "[quote]" — [review ID] | [route] |
| 4 | [issue] | [n] ([%]) | [1-5] | "[quote]" — [review ID] | [route] |
| 5 | [issue] | [n] ([%]) | [1-5] | "[quote]" — [review ID] | [route] |

## 4. Feature Requests

| Request | Count | Effort (L/M/H) | Linked pain point? | Notes |
| --- | --- | --- | --- | --- |
| [request] | [n] | [L/M/H] | [yes — issue #] | [note] |
| [request] | [n] | [L/M/H] | [no] | [note] |
| [request] | [n] | [L/M/H] | [yes — issue #] | [note] |

## 5. Prioritized Action List

### Product fixes (build / source / engineer)

| Priority | Fix | Targets issue(s) | Owner | Expected impact | ETA |
| --- | --- | --- | --- | --- | --- |
| P1 | [fix] | [#] | [team] | [e.g., -X% returns] | [date] |
| P2 | [fix] | [#] | [team] | [impact] | [date] |

### Listing-copy edits (ship this week)

| Priority | Edit | Targets issue(s) | Owner | Expected impact | ETA |
| --- | --- | --- | --- | --- | --- |
| P1 | [edit — bullet / photo / chart / A+] | [#] | [team] | [e.g., fewer "smaller than expected" returns] | [date] |
| P2 | [edit] | [#] | [team] | [impact] | [date] |

## 6. Notes & Caveats

- **Fake/incentivized review rate:** [%] — [pattern observed]
- **Coverage gaps:** [variants/periods with thin data]
- **Confidence:** [high/medium/low] — [why]