Free editable template

1-star review ad kit: turn objections into hooks

Paste your bad reviews, check the suggested objection tag on each, and the workbook ranks the objections by how often and how angrily they come up. Each one is marked 'ad can answer', 'ad can filter' or 'fix first', and your top three ad-fixable objections come back as hooks with your product name filled in. An AI prompt tab tags hundreds of reviews at once.

By GaaS editorial · Sources checked · 8 worksheet rows

Open the CSV in Excel, or import it into Google Sheets and choose comma-separated values. Save your working copy in a controlled location. The CSV contains the rows below and space for your notes; it has no macros, formulas or live account connection. The separate Excel workbook contains editable example inputs and formulas that update the forecast.

How to use the template

Paste your bad reviews

Export reviews from your store's review app, marketplaces and Google profile (most export a CSV; otherwise copy and paste). Paste date, star rating, review text and source into the Reviews tab. Keep the last 6 to 12 months; the sheet ignores 4 and 5-star rows. Leave out names, emails and order numbers.

Check the objection tags

Each review gets a suggested objection from the Keywords tab. Read them: keyword matching is a first draft. Type the right objection in the override column when a suggestion is wrong or says Untagged, and add keywords for your product. For hundreds of reviews, use the AI prompt tab and paste the answers into the override column.

Rank and sort

The Objection ranking tab counts each objection by star rating, scores it (1-star x3, 2-star x2, 3-star x1 by default) and ranks it. Each objection is marked ad can answer, ad can filter or fix first; the ad rank skips fix-first objections, which go to whoever owns the product or operations.

Write and test the hooks

The Top 3 hooks tab gives three hooks for each of your top three ad-fixable objections, with your product name filled in; the Hook bank has more. Lead with the objection, answer it with proof in the body, and test the hooks on the same ad body. Check returns by ad as well as cost per purchase.

Preview the worksheet

Every row shown here is included in the download. Scroll the table horizontally on a small screen.

ObjectionExample reviewStars
Too hotWay too hot. I woke up drenched in sweat every night and sent it back.1
Too heavyFar too heavy. I felt trapped under it.1
Smaller than expectedMuch smaller than the photos. Looks like a lap blanket on a queen bed.1
Didn't help sleepTwo weeks in and it made no difference to my sleep.1
PriceOverpriced for what it is.2
Cover and washingThe cover is a nightmare to get back on after washing.1
ShippingIt took three weeks to arrive and nobody answered my emails.1
Smell on arrivalStrong chemical smell out of the box.1

Worked review example

Fictional weighted-blanket brand (Hearthside), 36 reviews of 1 to 3 stars from six weeks: 9 say the blanket is too hot (score 20), 6 too heavy (12), 4 shipping (11), 5 smaller than expected (10). A quarter of all bad reviews share one objection.

Shipping ranks third but is 'fix first', so the ad ranking skips it. The top three ad-fixable objections become hooks: 'If you run warm, don't buy this one', how to pick the weight, and the blanket on a real queen bed with a tape measure. Price, the objection owners worry about most, comes last.

What this template does and does not establish

Keyword tagging is a first draft and mis-tags sarcasm and mixed reviews; read the suggestions. Reviewers are not a random sample of buyers. Score weights are defaults, not a standard. The example reviews are fictional. Quote reviews only where your platform's terms or the customer allow it, never reword a quote to change its meaning, and never suppress negative reviews. Not legal advice.

Primary references

Continue the work