Search the Complaint: Product Validation Scorecard
Score up to 5 product ideas against real complaints, so you build the one people already want to pay for.
You have five product ideas and no idea which one to build. So you pick the one you're most excited about, spend six weeks on it, and launch to crickets. Here's the fix. Search the complaint, not the category. "Meal planning" is a category. "My kids won't eat anything I cook" is a complaint. People pay to make complaints stop. This Google Sheet makes you go find those complaints first, then scores every idea and tells you straight: Build it, Test with a pre-sale, or Not yet. It comes filled in for Maya, so you're never staring at an empty sheet.
What's inside
- START HERE: how it works in 4 steps, 7 places to find complaints (with exactly what to search), and the rule: if you can't find 10 complaints, don't build it yet.
- Complaint Log: name your 5 ideas, then paste up to 75 real complaints with the source, date, exact words, link and how painful it is. Counts, average pain and "how many more you need" fill in on their own.
- Scorecard: each idea scored on 8 questions, weighted. Complaints and pain come straight from your log. You get a score out of 100, a rank, a verdict and your next step. Your top idea glows gold.
- Pre-sale Test: your top idea drops in automatically. Pick pre-sale or waitlist, set a goal number and a date, follow the 6 steps, log 7 days of results, and the sheet tells you what the numbers say.
- Example: Maya, a fictional meal-planning coach, with 5 ideas, 17 sample complaints, her scores and her 7-day pre-sale. Live formulas.
Who it's for
Bloggers, coaches and creators about to make their first (or next) digital product: a template, a printable, an ebook, a mini course, a workshop. If you've got a notes app full of ideas and you keep stalling on which one, start here. No spreadsheet skills needed. You type in the pink boxes. That's it.
How to use it
- Make your copy, name your ideas, and spend 30 minutes a day for a week pasting real complaints into the Complaint Log.
- Score each idea on the Scorecard. Be honest. Read the verdict.
- Pre-sell the winner for 7 days on the Pre-sale Test tab, then build it with buyers already waiting.
FAQ
Do I need Excel?
No. It's built for free Google Sheets. You also get the .xlsx if you'd rather use Excel or Numbers.
What if my audience is tiny?
Then this matters even more. Most complaints come from Reddit, Facebook groups, YouTube and reviews, not your own followers. The pre-sale goal scales to the people you can actually reach.
What if I can't find 10 complaints?
That's the sheet doing its job. Keep looking for a week, or pick another idea. It's a lot cheaper than building something nobody asked for.
Can I change the scoring?
Yes. Every weight and every verdict rule is a blush cell you can type over. My defaults favor proof.