Camp Enrollment Reports: Campers, Session Bookings and Open Places
- A camp enrollment report should count distinct campers and camper-session bookings separately, because a camper booked for three weeks is one camper and three bookings.
- Report open places by session: in the fictional example, a season 80% booked overall still has one full week and one with 12 open places.
- In the worked example, 49 distinct campers hold 72 bookings, about 1.47 sessions per camper, and 19 of them, about 38.8%, attend more than one session.
- Reconcile each session from its previous count using new confirmations, cancellations, and transfers, and show protected holds and waitlist entries in their own columns.
A useful camp enrollment report separates individual campers from session bookings and shows availability for each session. It should also explain changes since the last report: new registrations, cancellations, and transfers. A camper booked for three weeks, for example, is one camper and three session bookings.
Without those definitions, two accurate-looking reports can disagree. One may count 60 people while another counts 90 bookings because some children attend more than one week.
This guide builds a small, clearly defined report for a day-camp operator. The calculations are hypothetical planning examples, not industry benchmarks or a formula for legal capacity.
Choose the decision before choosing the metric
A camp director may need to answer several different questions:
- How many individual children are attending this season?
- Which sessions have approved places available?
- Which bookings are confirmed versus awaiting a decision?
- How many places changed since last week?
- Which sessions have unresolved preparation or payment tasks?
Keep these questions separate. A “total enrollments” figure with no definition cannot reliably answer all of them.
State the reporting date, time, included locations, season, and booking statuses. When comparing reports, use the same definitions and cutoff.
Define the camp enrollment counts
| Measure | Definition for this report |
|---|---|
| Distinct campers | Individual children with at least one confirmed session booking |
| Confirmed camper-session bookings | One confirmed camper in one session counts as one |
| Approved session places | Places the director has approved for booking in that session |
| Open session places | Approved session places minus confirmed bookings and separately protected holds |
| Waitlist entries | Requests for sessions without a confirmed place |
| Attended camper-days | Actual daily attendance within the reporting period |
A camper booked for three weeks contributes one distinct camper and three camper-session bookings.
These are suggested definitions for a management report. Match them to your operating rules and software, document any differences, and keep the definitions visible.
Do not count a waitlist entry as a confirmed booking. Also avoid assuming every waitlist entry represents a different child or a family still willing to take an available place.
Worked example: enrollment by session across three weeks
Assume a fictional camp has three one-week sessions. Each has 30 director-approved bookable places. There are no temporary holds in this example.
| Session | Approved places | Confirmed bookings | Open places | Booked share |
|---|---|---|---|---|
| Week A | 30 | 24 | 6 | 80.0% |
| Week B | 30 | 30 | 0 | 100.0% |
| Week C | 30 | 18 | 12 | 60.0% |
| Season total | 90 session places | 72 bookings | 18 | 80.0% |
Booked share is confirmed bookings divided by approved places, multiplied by 100.
The season total describes 90 places across three different weeks. It does not mean the camp can accommodate 90 children at one time.
The overall 80% figure also hides an important difference: Week B has no open places, while Week C has 12. An offer or marketing decision should use the session-level view.
Count distinct campers separately from bookings
Suppose the 72 bookings belong to:
- 30 campers attending one session each: 30 bookings
- 15 campers attending two sessions each: 30 bookings
- 4 campers attending three sessions each: 12 bookings
That produces 49 distinct campers and 72 camper-session bookings.
The average is 72 ÷ 49, or about 1.47 sessions per camper. That may be useful for describing the season, but it does not reveal which sessions any particular camper attends.
You could also say 19 of the 49 campers attend more than one session, or about 38.8%. Call that a multi-session share. It is not a returning-camper retention rate.
A returning-camper measure requires a defined previous period and a comparison of the same individuals. Do not label repeat bookings within one summer as annual retention.
Explain movement between reporting dates
For each session, reconcile the opening count to the closing count.
Imagine Week C had 18 confirmed bookings in the prior report. Since then, the camp recorded five new confirmations, two cancellations, three transfers in, and one transfer out.
18 + 5 − 2 + 3 − 1 = 23 confirmed bookings
| Movement | Bookings |
|---|---|
| Previous confirmed count | 18 |
| New confirmations | +5 |
| Cancellations | −2 |
| Transfers in | +3 |
| Transfers out | −1 |
| Current confirmed count | 23 |
Against 30 approved places, Week C now has seven open places, before any separately protected holds.
A transfer within the same set of reported sessions moves a booking between rows. It should not increase the overall season total. If the total changes, check for an added session, a cancellation, or a reporting-boundary issue.
Preserve the underlying change records so someone can explain the movement rather than only overwrite last week’s total. Count a transfer here only once it is complete; the camp session transfer checklist walks through that process.
Treat holds and waitlists explicitly
If your camp temporarily protects a place while an offer is open, show it in a separate column.
For example: 30 approved places, 23 confirmed bookings, two protected holds, and five freely available places. Do not count the two holds as confirmed and also subtract them a second time.
Define when a hold begins, when it expires, and who releases it. Apply your policy before making the place available again.
Show waitlist demand by session. If one camper joins three waitlists, that is three session requests from one person. Report it that way rather than calling it three new campers.
Turn the report into an action list
| Finding | Useful next question |
|---|---|
| Session is full and waitlist is active | Are current requests eligible and still interested under the camp’s process? |
| Many open places in one session | Are dates, hours, or program details causing a mismatch? |
| Confirmed bookings changed unexpectedly | Which transfers, cancellations, or filters explain the difference? |
| Several protected holds are old | Does each still meet the camp’s hold policy? |
| Registration and group totals disagree | Which confirmed campers need assignment or correction? |
Open places are not an instruction to cut prices or increase allowed enrollment. Confirm the operating plan and understand the reason before choosing an action.
Add an owner and review date to significant exceptions. Keep private camper details in restricted records; a summary for management can use totals and references.
Keep payment and attendance beside enrollment
A confirmed booking, a paid balance, and actual attendance are different facts.
Payment reporting should distinguish completed payments, credits, and transactions still processing. Attendance reporting should use actual dates and check-in records. Do not call projected session charges “collected revenue.”
For a session that has not started, compare registrations with approved places. After it runs, review attendance and operational outcomes separately. This avoids treating a future reservation as care already delivered.
Make the camp enrollment report repeatable
Write a short report definition containing the date range, included sessions, status rules, hold treatment, and responsible owner. Save the configuration or document the filters.
Review the same report at consistent points in the registration cycle. Compare equivalent lead times before camp, rather than reading a later snapshot’s higher bookings as proof of better performance.
Bloomily’s camp page describes weeks with their own capacity and count, a waiting list for full weeks, and camp groups. When evaluating reporting in camp management software, bring the fictional three-session example above and ask the provider to reproduce the counts. Confirm which views and exports are available instead of assuming every metric is built in.