Free operator sheet · Stays in your browser

Review Response
Log.

Platform, reviewer, stars, theme tag, response date, responder, follow-up needed. Catches the recurring complaint hiding in the 3-star reviews.

Pack: Trust & Reviews Cadence: Weekly Private — runs in your browser

Fill it in

Review Response Log

Type your numbers — the math runs in your browser. Print it, save it as a CSV, or save it to your Workshop.

Worked example 60-seat neighborhood bistro, two weeks of reviews See what a Tuesday-morning fill-in looks like

What they typed in

Reviews logged (across Google, Yelp, OpenTable)18
Negatives (≤3 stars)3
Owner responses7
Owner responses to negatives1
Repeated theme in negativesDishroom noise (3 of 3)

What the sheet returned

Response rate38.9% · red
Negative response rate33.3% · red
Anomaly flagNegs unanswered (≥2)

The unanswered negatives are this Tuesday's first task — three customers named the same dishroom-noise issue with no public response. The pattern is also the punch list: schedule the dishroom acoustic fix that's been on the maintenance log since February. The reply and the fix are the same conversation, three weeks apart.

Composite-typical numbers — not a real shop. Use the rhythm, not the figures.

Period
Reviews this period
Date Platform Reviewer Stars Theme Responded Responder Follow-up
Negatives (1–2 stars) must be responded to within 48 hours, every time.
Response rate this period 0%
Response rate on negatives (≤2 stars) —
Top recurring theme —

Log every review. Theme tags surface the patterns; responses set the public tone. Aim for 100% response on negatives and ≥50% overall.

Keyboard: ⌘P print · ⌘S download CSV · ⌘↵ save to Workshop

When to use it

Pull this sheet out when —

  • Weekly — fifteen minutes, with the GBP / Yelp / Tripadvisor inboxes open.
  • After every 1- or 2-star review — those need a response within 48 hours, every time.
  • When a complaint theme repeats — the log surfaces the pattern that one-off reviews hide.
Common mistakes

What operators get wrong

  • Responding only to 5-stars. Google reads the response rate on negatives as a quality signal.
  • Generic responses ("thanks for your feedback") on detailed complaints. The reviewer wrote 200 words; respect them.
  • Logging the response date but not the THEME tag. Without themes, you cannot run the pattern review.
Pairs with

The tools, terms, and articles this sheet sits next to.

Tools

Glossary

  • None yet.

Reading

Free, no signup. Your numbers never leave this page.