Free editable template

How many ads to find a winner: calculator

Set a weekly testing pace from real odds instead of hope. Pick a hit rate (Motion's 5% overall, your spend tier, or your own from past tests), how sure you want to be and your spend per test ad; the calculator gives ads to test, the test budget, the weeks it takes at your pace and your chance of a winner this month.

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

Pick a hit rate

On the Calculator tab, choose Motion's overall 5%, your monthly spend tier, your own hit rate from the Test log, or a custom number.

Set your target and costs

Type how sure you want to be (90% is a good default), how much each new ad spends before you judge it, and how many new ads you really launch a week.

Read the answer

Ads to test, the test budget, the weeks it takes and your chance of a winner in the next four weeks, with a verdict: on pace, slow or too slow. The Odds table shows 1 to 100 ads with a chart.

Log your tests

Paste every new ad you've tested with its lifetime spend into the Test log. It finds Motion-style winners (10x your median spend and $500+), lets you mark which were profitable, and gives your own hit rate.

Preview the worksheet

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

NumberFormulaDefault
Hit rateWinners ÷ new ads testedMotion: about 5% (3.7% under $10K a month, 8.2% at $1M+)
WinnerSpent 10x the account's median ad spend and at least $500Motion's definition
Chance of at least one winner1 − (1 − hit rate)^adsAt 5%
Ads to testln(1 − how sure) ÷ ln(1 − hit rate), rounded up90% sure
Test budgetAds to test × test spend per adYour spend per test ad
WeeksAds to test ÷ new ads per weekYour real pace
Chance this month1 − (1 − hit rate)^(4 × ads per week)4 weeks
Your hit rateScaled and profitable winners ÷ ads loggedFrom the Test log

Worked review example

Fictional store at a 5% hit rate with $100 of test spend per new ad: 45 ads for a 90% chance of one winner, a $4,500 test budget, 9 weeks at 5 new ads a week, and a 64% chance of a winner in the next 4 weeks.

From 40 logged ads with a $155 median spend, 2 spent more than $1,550 (5% Motion-style hit rate); only 1 was profitable, so the stricter hit rate is 2.5% and a 90% chance needs 91 ads.

What this template does and does not establish

Motion's winner means an ad Meta scaled (10x median spend and $500+), not a proven profitable ad. The odds assume each ad is an independent shot at the same hit rate; a team that learns between rounds should beat them. Motion's sample is its own customers. Your spend per test ad decides how reliable each verdict is and is not set by this calculator.

Primary references

Continue the work