Subscriber stock-flow area with revenue columnsNew acquisition, churn, delivery, response, and seasonal lift remain visible by month
Marketing & Advertising
Email Campaign Forecast Calculator
Forecast the marketable email list as a stock that gains new subscribers and loses churn each month. The average list determines send volume, which moves through delivery, open, click-to-open, and order conversion stages. A documented peak-period lift changes response without rewriting subscriber or delivery assumptions.
Forecast revenue—
Ending active subscribers—
Total delivered emails—
Forecast orders—
Net list growth—
Peak monthly revenue—
Subscribers lost to churn—
Revenue per delivered email—
List stock and commercial flow
Forecast subscriber inventory and monthly revenue on one calendar
Active subscribersMonthly revenuePeak period
| Month | Opening list | New | Churned | Ending list | Delivered | Opens | Clicks | Orders | Revenue |
|---|
How to use the email campaign forecast calculator
Forecast the subscriber stock before projecting engagement and revenue
- Enter the active, marketable subscriber count at the start of month one.
- Add expected monthly acquisition and remove churn from each month’s opening list.
- Use the average monthly list to estimate attempted sends, then apply delivery, open, click-to-open, and purchase rates in sequence.
- Enter a peak-period response lift only when a documented season or event changes engagement assumptions.
- Review both the chart and monthly ledger; the ending list in one row must become the opening list in the next.
Email forecast fundamentals
The list is an inventory that gains and loses eligible subscribers
A flat-audience forecast hides acquisition and churn. This model treats active subscribers as a monthly stock, calculates send volume from the average stock, and then moves delivered messages through an explicit engagement funnel. Seasonal response changes orders and revenue but does not create subscribers by itself.
Detailed calculation process
Reconcile the list roll-forward before applying the response funnel
Lm,end = Lm,open + Am − Lm,openuThe next month opens with this ending active list.
Dm = [(Lm,open + Lm,end) ÷ 2] × f × dDm is delivered email volume based on the average list in the month.
Ordersm = Dm × o × sm × c × vEach rate keeps its own denominator: delivered-to-open, open-to-click, and click-to-order.
Revenuem = Ordersm × AOVThe model uses one entered order value and does not infer margin or repeat value.
Default month-one worked example
Subscriber growth and churn reconcile before 341,756 delivered emails
Churned subscribers = 85,000 × 1.2% = 1,020Ending list = 85,000 + 4,500 − 1,020 = 88,480Average list = (85,000 + 88,480) ÷ 2 = 86,740Delivered = 86,740 × 4 × 98.5% = 341,755.60Opens = 341,755.60 × 38% = 129,867.13Clicks = 129,867.13 × 12% = 15,584.06Orders = 15,584.06 × 3.6% = 561.03Revenue = 561.03 × $84 = $47,126.18 When the entered peak period begins, the lift multiplies the open-response stage. It does not rewrite delivery, subscriber acquisition, or churn.
Forecast operating evidence
Inputs to refresh before each planning cycle
- Marketable subscriber count after suppression and consent filters
- Gross acquisition and attrition measured on the same monthly boundary
- Send frequency by segment rather than calendar count alone
- Unique-open and click definitions from one analytics system
- Order value and conversion window consistent with the revenue report
Model limitations
A deterministic planning schedule cannot reproduce inbox behavior
The forecast excludes cohort-specific churn, deliverability degradation, frequency fatigue, privacy-related open inflation, delayed purchases, refunds, inventory limits, segment mix, acquisition seasonality, customer overlap, margin, and uncertainty intervals. The peak lift applies from its start month through the horizon unless changed.
Forecast interpretation
Investigate stock problems before trying to fix the response rate
If revenue weakens because the active list is shrinking, an optimistic open-rate assumption does not repair the acquisition and churn imbalance. Conversely, a growing list can conceal deteriorating value per delivered message. Review ending list, delivered volume, orders, and revenue per delivered email together.
Practical examples
Email Campaign Forecast Calculator in real planning situations
- Project whether acquisition outpaces monthly list attrition over twelve months.
- Connect active-list growth with delivered volume, orders, and revenue.
- Isolate a peak-season response assumption from the underlying subscriber roll-forward.
Important note
Before relying on this result
The forecast is deterministic and excludes cohort-specific churn, deliverability deterioration, frequency fatigue, privacy-related open inflation, delayed orders, refunds, uncertainty, segment mix, margin, and inventory constraints.
Additional Email Campaign Forecast Calculator questions
Why use the average monthly list?
It approximates the population available during the month rather than assuming every acquisition existed on day one.
Does peak lift increase the subscriber list?
No. It changes response from the peak start month onward; acquisition and churn still control the list.
Is open rate always reliable?
No. Privacy features and image-loading behavior can affect opens, so use a definition consistent with the reporting source.