Registration stock with attendance band and capacity lineWeeks on x-axis; people on y-axis
Marketing & Advertising
Event Marketing Forecast Calculator
Forecast an event as a weekly registration stock-flow system. The calculator retains active registrations after cancellations, adds a changing acquisition flow, converts the stock to expected attendance, compares demand with venue capacity, and grows campaign spend on a separate path. It supports promotion throttling, waitlist timing, room and catering decisions, and weekly plan-versus-actual review.
Input evidence: use net new registrations after deduplication but before modeled cancellations, separate staff and speakers from capacity, and calibrate growth from the same campaign phase.
Forecast final registrations-
Forecast checked-in attendees-
Capacity fill-
Capacity crossing-
Cumulative campaign spend-
Spend per attendee-
Registration pace and seat risk
Forecast the live registration stock, checked-in demand, and capacity crossing
The model retains existing registrants, adds a growing acquisition flow, and converts the final stock through the show-rate gate.
| Week | Opening registrations | Cancellations | New registrations | Closing registrations | Expected attendees | Capacity fill | Campaign spend | Cumulative spend |
|---|
How to use
Turn weekly registration pace into an operating forecast
- Set the event horizon and current registration stock.
- Enter current weekly acquisition pace and expected growth.
- Apply a cancellation rate to the opening stock each week.
- Convert the final stock through the comparable show rate.
- Review capacity crossing and spend efficiency before changing promotion.
Forecast fundamentals
Five moving parts drive the seat forecast
Opening stock
Active registrations entering a week.
Cancellation outflow
Registered people removed during the week.
Acquisition inflow
New valid registrations added.
Show-rate gate
Final registrations converted to attendance.
Capacity crossing
First week forecast attendance exceeds seats.
Result interpretation
Operate from attendance demand, not registration count alone
Final registrations describe the database stock; forecast attendees describe likely physical demand. A crossing signals when waitlist, room, catering, and promotion decisions become urgent. Spend per attendee is an acquisition reference, not total event cost.
Method
Use a stock-flow recurrence
Each week retains the noncancelled opening stock and adds a geometrically changing acquisition flow. Spend follows its own growth path so volume and cost can diverge.
Pace calibration
Campaign phases rarely share one growth rate
Separate announcement, agenda release, speaker promotion, deadline, and last-chance phases when evidence supports different slopes.
Capacity operations
A forecast crossing is a decision date
It should trigger waitlist rules, overflow design, contract review, catering cut-offs, and a promotion throttle rather than a passive warning.
Show-rate uncertainty
Attendance is a band, not a point
Weather, travel, event format, reminder cadence, price, and audience seniority can move show rate materially.
How to read the visual
Compare the registration curve, attendance band, and capacity line
The x-axis is week and y-axis is people. The upper curve is active registrations; the shaded band is plausible attendance around the entered show rate; the horizontal line is venue capacity. Growth changes curve steepness, cancellations change stock erosion, and capacity changes only the gate. The forecast misleads if weekly campaign phases or duplicate registrations are ignored.
Detailed calculation process
Formula and intermediate steps: Roll registration stock and spend forward
1. Cancellations_t = Opening_t x cancellation rate
2. New_t = New_1 x (1 + registration growth)^(t-1)
3. Closing_t = Opening_t - Cancellations_t + New_t
4. Attendance_t = Closing_t x show rate
5. Spend_t = Spend_1 x (1 + spend growth)^(t-1)
- R_t
- closing registrations in week t; people
- c
- weekly cancellation rate; decimal/week
- N_t
- new registrations; people/week
- g
- weekly acquisition growth; decimal/week
- s
- final show rate; decimal
- M_t
- campaign spend; currency/week
Default substitution and reconciliation
Week one cancellations equal 84 x 1.8%; new registrations equal 34; closing stock equals opening minus cancellations plus new. Week two opens with week one's close and grows new flow by 9%. Summing the separately grown spend series reconciles to cumulative spend. Final check: each closing registration balance equals opening registrations minus cancellations plus new registrations, and the separately summed weekly spend matches the cumulative spend result card.
Evidence
Keep the weekly source table
Retain registration timestamps, cancellation records, deduplication logic, campaign spend, source tags, seat exclusions, comparable show rates, and venue capacity documentation.
Limitations
The recurrence is deterministic
It excludes channel-specific conversion, registration caps, waitlist behavior, phase changes, ticket tiers, group registrations, walk-ins, seasonality, stochastic uncertainty, and campaign saturation.
Glossary
Forecast terms
- Registration stock
- Active valid registrations at a point in time.
- Inflow
- New registrations added.
- Outflow
- Cancellations removed.
- Show rate
- Checked-in attendees divided by final registrations.
- Capacity crossing
- First period expected attendance exceeds seats.
- Pace
- Registrations acquired per week.
Practical cases
Two operating responses
Early capacity crossing
The team opens a waitlist and stops broad promotion while preserving high-fit invitations.
Slow final-month pace
The team tests the show-rate assumption and channel conversion before simply increasing spend.
Important note
Before relying on this result
The deterministic forecast excludes channel-specific conversion, waitlist behavior, ticket tiers, walk-ins, phase changes, stochastic uncertainty, campaign saturation, and nonlinear venue constraints.
Additional Event Marketing Forecast Calculator questions
Why model registrations as a stock?
Existing registrations persist unless cancelled, while new registrations are a weekly inflow.
Why is attendance shown as a band?
Show rate is uncertain; a band makes that operating risk visible even though the headline uses the entered point rate.
Does capacity include staff and speakers?
Enter the attendee capacity available after all nonattendee seat exclusions.
Can one growth rate cover every campaign phase?
Often not. Use separate scenarios or revise the rate as announcement, agenda, deadline, and last-chance phases change.