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
Plan
On the Planner tab, type audience size, daily budget, CPM and the frequency you want to watch for. Read the day it arrives, the reach and spend by then, and the day-by-day chart.
Calibrate each ad set
On the Calibrate tab, add one row per live ad set: days since it started, impressions, reach and spend for that range. The tab gives your effective audience, days to target and a status.
Use the effective audience
Copy an ad set's effective audience into the Planner to test a budget change before you make it.
When frequency climbs
Follow the checklist tab: is cost per result rising, has reach stopped growing, is it one ad or all of them, is CPM moving.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| Rule | Condition | Default |
|---|---|---|
| Frequency | Impressions ÷ reach | Meta's definition |
| Impressions a day | Daily budget ÷ CPM × 1,000 | |
| Reach model | Audience × m × (1 − e^(−1/m)), m = impressions ÷ audience | Skewed delivery |
| Day to target | (−1 ÷ ln(1 − 1/target)) × audience ÷ impressions a day | Target 7 |
| Effective audience | Impressions ÷ (−1 ÷ ln(1 − 1/frequency)) | From 7+ days of data |
| Days left | Day to target − days so far | Same daily impressions |
| Under 2 weeks | Day to target under 14 | Red |
| Frequency cap | Only Reach optimisation offers one under the auction buying type | Per Jon Loomer, updated Mar 2025 |
| Target of 7 | A convention, usually traced to an 1885 book | 7 |
Worked review example
Fictional ad set: 80,000 people, $500 a day, $12.50 CPM (40,000 impressions a day). Reach is 63,000 by day 4 and 70,800 by day 8; frequency reaches 7 on day 13 after $6,500 of spend.
A broad prospecting ad set after 7 days: 280,000 impressions, 55,600 reach, frequency 5.03. Effective audience about 62,000 people; frequency 7 on day 10, so 3 days left.
What this template does and does not establish
The reach model is a planning assumption about how unevenly Meta serves people, not Meta's delivery system; calibrate it against your own numbers and re-check weekly. CPM moves daily. The target of 7 is a convention; the 1885 source is quoted through a secondary source. The frequency-cap rule comes from Jon Loomer's guide (updated March 2025), so check Ads Manager. Example numbers are fictional. No account connection, macros or automatic changes.
Primary references
- Jon Loomer: Meta Ads glossary (frequency, reach)
- Jon Loomer: Meta needs frequency capping
- Branding Strategy Insider: advertising frequency theory circa 1885
