Free editable template

Meta ad frequency calculator

See audience saturation coming instead of finding it in your cost per result. The Planner gives the day a target frequency arrives, the reach and spend by then, and a day-by-day chart. The Calibrate tab finds the audience Meta is actually reaching for every live ad set and flags the ones with under a week left.

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

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.

RuleConditionDefault
FrequencyImpressions ÷ reachMeta's definition
Impressions a dayDaily budget ÷ CPM × 1,000
Reach modelAudience × m × (1 − e^(−1/m)), m = impressions ÷ audienceSkewed delivery
Day to target(−1 ÷ ln(1 − 1/target)) × audience ÷ impressions a dayTarget 7
Effective audienceImpressions ÷ (−1 ÷ ln(1 − 1/frequency))From 7+ days of data
Days leftDay to target − days so farSame daily impressions
Under 2 weeksDay to target under 14Red
Frequency capOnly Reach optimisation offers one under the auction buying typePer Jon Loomer, updated Mar 2025
Target of 7A convention, usually traced to an 1885 book7

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

Continue the work