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
Run the calculator
Type your daily budget, how many ad sets share it, and your cost per purchase or lead. Read the max CPA, events per ad set per week and the verdict: OK, merge, close, or step up the funnel.
Pick the event
On the Event ladder, type what each funnel step costs you. The tab picks the first event, from purchase down, that one ad set can hit about 50 times a week.
Build the starter account
Tick off the Starter checklist: one Sales campaign with one budget, one broad ad set with Advantage+ audience and placements, 6–10 genuinely different ads, the event from the ladder.
Leave it for 7 days
No budget, audience or ad changes for a week. Then add new ads in one batch, check cost per purchase, and re-run the calculator. Switch back to purchase once purchases reach about 50 a week.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Number | Formula | Default |
|---|---|---|
| Events needed per week | Meta: about 50 in the week after the last significant edit | 50 |
| Max CPA to leave learning | Daily budget × 7 ÷ events needed | - |
| Events per ad set, as split | (Budget ÷ ad sets) × 7 ÷ cost per result | - |
| Events in one ad set | Budget × 7 ÷ cost per result | - |
| Budget one ad set needs | Cost per result × 50 ÷ 7 | - |
| Event to optimize for | First event from purchase down that reaches 50 a week | Purchase, checkout, add to cart, view content |
| Starter structure | 1 campaign, 1 broad ad set, 6–10 different ads | Our recommendation |
Worked review example
Fictional store on $100/day at a $35 cost per purchase: the max CPA to leave learning is $14. Split across 5 ad sets, each gets 4 purchases a week; in one ad set, 20. One ad set needs $250/day to reach 50 purchases a week.
On the event ladder, initiate checkout at $18 gives 38.9 a week (not enough) and add to cart at $9 gives 77.8, so the ad set optimizes for add to cart while cost per purchase is watched weekly.
What this template does and does not establish
About 50 is Meta's soft guidance, and Learning limited is an efficiency signal, not a penalty. The maths assumes a steady cost per result. Optimizing for a higher-funnel event can buy cheap actions that never become sales. The starter structure is our recommendation, not a Meta rule.
Primary references
- Meta: About learning limited
- Meta: Performance marketing (combine ad sets; time in learning)
- Meta: About managing ad volume
