Validation · Test and refine

Test Tracker

Record each test, what counted as a yes, and what happened.

Spreadsheet
4 pages
About 15 minutes to fill in
Google Sheets · Excel · PDF

Making this yourself would take about 6 hours: working out the steps, writing the examples and setting it up in Google, Microsoft and PDF. It's done for you.

This document

Test Tracker, all three formats

Validation pack

This one plus 2 more Validation documents

$15

The voice in this video is George's, made with AI.

What it's for

You're running small tests and want honest answers. It makes you decide what counts as a yes before you start, then tells you plainly whether you hit the bar.

What you'll need: About 15 minutes per test to set up, and a few minutes when each one ends. Google Sheets (free) or Microsoft Excel, or a notebook. Nothing to buy.

Pairs well with

Your First Small Test (design one test in depth)
What Did You Learn? (read a result carefully)

What you'll leave with

Every test in one place: your guess, what you'll do, and the YES bar you set in advance.
Start and end dates, money spent, and a countdown of days left.
A plain YES or NO for each finished test.
Your decision and the reason, written next to each result.

Look inside

Sample page from Test Tracker. Page 3: The Example tab, filled in by Ken. — Page 3: The Example tab, filled in by Ken.

Sample page from Test Tracker. Page 4: The Your Turn tab, ready for your own numbers. — Page 4: The Your Turn tab, ready for your own numbers.

How to use it

Work through the steps in order. Each one has a worked example and space to write your own answer.

Open the Start Here tabRead the steps, the color key and the free tools.
Look at the Example tabSee Ken's window washing tests.
Your Turn, the guess and the testWrite your guess in one plain sentence, then what you'll actually do.
Your Turn, the YES barBefore you start, write a number and what it counts. Don't change it later.
Your Turn, dates and moneyAdd start and end dates and any money spent.
Your Turn, the resultWhen it ends, type the number that happened and a short note.
Read the resultsThe Result column shows YES or NO. Pick your decision, write why, and plan the next test.

Tips

Never change the YES bar after the test starts. That's how people fool themselves.
Good tests cost little or nothing: a message, a flyer, a conversation.
Use the AI prompts on the Start Here tab to look for other explanations for your result.

Three formats, one purchase

Google SheetsMake a copy in your Google Drive and type straight into it.
Microsoft ExcelDownload and fill it in on your computer.
PDFPrint it and fill it in with a pen.

Validation pack

Also in the Validation pack

3 documents in all

Workbook8 pages
Your First Small Test
Design one small, cheap test with real people.
About 8 hours to make yourself
$7See what's inside
Workbook7 pages
What Did You Learn?
Turn one real result into a clear decision about what to do next.
About 7 hours to make yourself
$7See what's inside

Ready to start?

Pay once, keep it, and download it as often as you like.