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
Fill the five planning inputs
Enter your monthly ad budget, value per conversion, target cost per acquisition (CPA), the share of budget for testing and how many target CPAs each new ad gets before you judge it. The workbook returns the testing budget, the spend per ad, how many new ads you can judge each month and how many days each round takes.
Size the round to the budget
If the month cannot fund one full round, launch fewer ads at once. Three genuinely different ideas teach more than ten small variations of one ad. The budget table shows what a bigger budget or a stricter judging rule would buy before you change anything.
Write the verdict rule before launch
The test log applies one rule to every ad: keep running below the spend threshold; keep and retest if CPA is at or under target; extend once if it converted but costs too much; otherwise cut. Agreeing the rule first stops you moving the goalposts after you see results.
Confirm winners with a real test
Keeping an ad after two or three conversions is screening, not proof. Before you rebuild the account around one ad, retest it against your current best ad with a controlled A/B test sized in advance.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Ad name | Round | Angle |
|---|---|---|
| R1-pain-ugc-v1 | 1 | Problem/pain |
| R1-gift-static-v1 | 1 | Gift |
| R1-proof-carousel-v1 | 1 | Social proof |
| R2-pain-ugc-v2 | 2 | Problem/pain |
| R2-offer-static-v1 | 2 | Offer |
| Rule: below threshold | ||
| Rule: at threshold, CPA at or under target | ||
| Rule: converted, CPA above target, under 1.5× threshold | ||
| Rule: no conversions at threshold, or past 1.5× | ||
| Your ad |
Worked review example
Fictional example: a $6,000 monthly budget with 20% for testing gives $1,200. At a $45 target CPA and a 2× judging multiple, each new ad gets $90 before a verdict, so the month can judge 13 new ads.
With three ads per round, the $40 daily testing budget judges a round in about 6.75 days. An ad that hits the target would show only two conversions by then: enough to cut clear losers, not enough to crown a winner.
What this template does and does not establish
The workbook is planning arithmetic and a log. It assumes a 30-day month and even spend across a round's ads, which ad platforms rarely deliver. The Poisson risk figures are a simple model of chance, not a prediction for your account. It does not connect to Meta or Google, and example rows are fictional, not benchmarks.
Primary references
- Meta for Developers: split testing and creative tests
- Meta Business Help Center: about the learning phase
- Meta Business Help Center: about A/B testing
