Returning-Camper Rate: A Worksheet for Camp Directors
- Define the cohort, period and return status before calculating.
- Separate return rates, current-season returner share and repeat bookings.
- Show the full cohort alongside any documented eligibility adjustment.
A returning-camper rate measures how many campers from a defined earlier group came back in a later period. Count people, not session bookings, and state exactly what “came back” means in your report.
Download the editable CSV worksheet.
A camper who attends three weeks in one summer creates three session bookings but is still one person. The camp enrollment report guide explains those counts. Use this worksheet when the question is whether last season's campers returned this season.
Choose the definition before counting
Write down the two seasons, the report date and the status used for inclusion. For a completed-season report, you might count campers with recorded attendance. For an advance registration report, you might count confirmed registrations. Do not label confirmed future registrations as attendance.
Decide whether “returned” means the same camp, the same location or any program included in your report. Keep that scope fixed. A transfer to a different location can be a return for one definition and a non-return for another.
Use a stable camper reference. Review duplicate accounts before matching the two periods. Avoid matching only on a shared surname: siblings are separate campers.
Show the full cohort and any eligibility adjustment
Here is a fictional completed-season example. The counts are illustrative, not an industry benchmark.
| Measure | Example count | Definition |
|---|---|---|
| Previous-season campers | 100 | Unique campers with attendance in the previous season |
| Not eligible this season | 20 | Previously attended, but outside this season's published age range |
| Eligible previous campers | 80 | 100 minus the 20 documented exclusions |
| Eligible previous campers who returned | 48 | Matched campers with attendance in both seasons |
| Current-season campers | 120 | All unique campers with attendance this season |
The eligibility-adjusted returning-camper rate is 48 ÷ 80 = 60%. The return rate against the full previous cohort is 48 ÷ 100 = 48%. The share of current campers who are returners is 48 ÷ 120 = 40%. These answer different questions, so label all three correctly if you report them.
An adjusted rate depends on the exclusion rule. Record every reason and count, and also show the full-cohort result. Do not remove a camper from the denominator just because the family did not respond or chose another activity.
Build a reviewable working sheet
Use these columns in a restricted workbook:
| Camper reference | In prior cohort? | Eligible this season? | Exclusion reason | In current cohort? | Match reviewed? |
|---|---|---|---|---|---|
| C-001 | Yes | Yes | Not applicable | Yes | Yes |
| C-002 | Yes | No | Outside published age range | No | Yes |
| C-003 | Yes | Yes | Not applicable | No | Yes |
Keep uncertain matches marked unresolved. Investigate them before treating the resulting rate as final. If the eligible denominator is zero, report “not applicable,” not 0%.
The example assumes the 48 returners all belong to the eligible group. If an eligibility exception was approved for another camper, document the exception and revise the cohort rules consistently before calculating.
Make comparisons fair
Compare equivalent points in the registration calendar. This season's early registrations and last season's final attendance have different opportunities to accumulate returns.
If you break the report down by age group or location, include the group count beside each rate. A large change in a small group can come from only a few campers. Calculate the overall rate from total returners divided by the total eligible cohort; do not average percentages from groups of different sizes.
Turn the result into a question
A lower return rate does not explain why families did not return. Review available feedback, session availability and eligibility changes without inventing reasons for individual families.
Use the result in your next camp registration plan. Bloomily's camps overview describes session registration and rosters; use your own reviewed records for the cohort calculation. This worksheet is a reporting method, not a claim that the product has a built-in retention dashboard.