Free editable template

Creative testing budget calculator and test log

Decide how many new ads your budget can really test each month, set the spend each ad gets before you keep or cut it, and log every test against the same rule. The workbook mirrors the online calculator, adds a budget table, a testing calendar and a 40-row test log.

By GaaS editorial · Sources checked · 10 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

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 nameRoundAngle
R1-pain-ugc-v11Problem/pain
R1-gift-static-v11Gift
R1-proof-carousel-v11Social proof
R2-pain-ugc-v22Problem/pain
R2-offer-static-v12Offer
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

Continue the work