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.
| Number | Formula | Default |
|---|---|---|
| Hit rate | Winners ÷ new ads tested | Motion: about 5% (3.7% under $10K a month, 8.2% at $1M+) |
| Winner | Spent 10x the account's median ad spend and at least $500 | Motion's definition |
| Chance of at least one winner | 1 − (1 − hit rate)^ads | At 5% |
| Ads to test | ln(1 − how sure) ÷ ln(1 − hit rate), rounded up | 90% sure |
| Test budget | Ads to test × test spend per ad | Your spend per test ad |
| Weeks | Ads to test ÷ new ads per week | Your real pace |
| Chance this month | 1 − (1 − hit rate)^(4 × ads per week) | 4 weeks |
| Your hit rate | Scaled and profitable winners ÷ ads logged | From 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
- Motion Creative Benchmarks 2026: Winners are rare
- Motion Creative Benchmarks 2026: Portfolio breakdown by tier
