
File / Download
A free competitive analysis workbook for user researchers that takes you from a clear brief to a short literature review and real decisions, with AI prompts and a human check list at every step.
Competitive analysis can swallow weeks of your time and still end up as a slide of feature ticks that nobody remembers, with your team no clearer on what to do differently. I rebuilt my most popular template, the one dscout still shares, so every row leads back to a decision, every claim leads back to a source, and the whole thing comes together as a short literature review you can hand straight to stakeholders.
What's inside
A brief to write down the decision your analysis feeds, your research questions and the competitors you're looking at, including indirect competitors and substitutes like spreadsheets
A sources log covering everything from hands-on teardowns and app store reviews to pricing pages and analyst reports, with a summary, an exact quote and whether a human has checked each one
A goals and pain points tab that scores you and each competitor, then shows where you're behind, ahead or where nobody is meeting a need that matters to your users
A feature matrix, a heuristic review with a plain-words guide to each of Nielsen's ten heuristics, and a positioning and pricing tab
A themes tab that rates how strong the evidence is behind each theme and makes space for what contradicts it and what you still don't know
A decisions tab that turns themes into recommendations with an owner and a date
A literature review structure with eleven sections that pulls in your source numbers automatically
Six AI prompts for gathering sources, summarising them, mining reviews, drafting themes, drafting the literature review and pressure-testing it before you share it
A human check list covering the parts I would never hand over to AI, like using the product yourself and writing the recommendations
Every tab includes a worked example so you can see what a finished analysis looks like before you start your own.
It comes as a zip file. Unzip it, then open the spreadsheet in Excel, or upload it to Google Drive and open it with Google Sheets.