Camp Registration Conversion: From Inquiry to Confirmed Camper

Camp registration conversion measures how a defined group moves from interest to confirmed enrollment. Before calculating a percentage, decide who belongs in the group and what “confirmed” means for your camp. Otherwise a busy inbox, duplicate forms and sibling registrations can make the same season look very different in separate reports.

This guide measures the inquiry-to-confirmation process. For remaining places by session, use the camp enrollment report. For repeat attendance across seasons, use the returning camper rate worksheet. Those answer different questions.

Choose the unit you are counting

For an enrollment funnel, one workable unit is a prospective camper for a particular session. Give that opportunity a stable reference. Two siblings interested in the same session are two opportunities. One child considering two sessions may be two opportunities if your report consistently uses camper-session units.

A family-level report can also be useful, but label it separately. Do not divide confirmed camper-session enrollments by the number of families who inquired and call the result a family conversion rate.

Merge repeat messages about the same opportunity. If you cannot identify which child or session an early inquiry concerns, keep it in an unassigned inquiry group until staff can classify it; disclose those exclusions alongside the report.

Define each stage before exporting

Use definitions your team can apply consistently:

• Inquiry: an identifiable camper-session opportunity with an expression of interest recorded during the chosen intake period.
• Started registration: that same opportunity has begun the registration process under your documented rule. A page view alone need not qualify.
• Confirmed camper: the opportunity meets the camp's written confirmation requirements by the reporting cutoff, such as required acceptance and the applicable payment condition.

Record the actual confirmation rule. A submitted form, a waitlist place and a pending payment should not silently count as confirmed if your policy requires more.

See the summer camp registration guide for the operational steps behind these stages. The worksheet organizes measurement; it does not change your camp's enrollment policy.

Keep the cohort and cutoff fixed

For example, select inquiries first recorded in April and check their progress as of May 15. Count started and confirmed records only from that April inquiry group. Do not add unrelated May registrations to the numerator.

Some campers register directly without a recorded inquiry. Report them separately rather than inventing an inquiry date. Recent cohorts may need more time to convert, so compare cohorts at similar elapsed times and disclose the cutoff.

Calculate with a fictional example

Suppose a deduplicated cohort contains 40 camper-session inquiries. By the cutoff, 24 have started registration and 18 meet the confirmation rule.

• Inquiry-to-start rate: 24 ÷ 40 × 100 = 60%.
• Start-to-confirm rate: 18 ÷ 24 × 100 = 75%.
• Inquiry-to-confirm rate: 18 ÷ 40 × 100 = 45%.

These are fictional calculations, not industry benchmarks. If a denominator is zero, show “not applicable” rather than 0%. Under these stage definitions, confirmed opportunities should not outnumber starts, and starts should not outnumber inquiries. Investigate inconsistent counts before interpreting the result.

Find the next operational action

Look at unfinished opportunities by reason: unanswered question, form incomplete, payment pending, waitlisted, declined or no longer interested. Assign an owner and next review date. An incomplete process may need a clearer instruction; a waitlisted camper may have no place available. Combining those reasons can hide the actual problem.

Review cancellation status separately. Choose whether your headline describes confirmation ever reached or active confirmation at the cutoff, and label it. For the latter, exclude cancellations as of the cutoff and retain their count in a separate line.

Use the family's contact preferences and your approved outreach process. The worksheet is not authorization to send messages or promise a place.

Use the worksheet

Create one row per camper-session opportunity. Enter stage dates, the cutoff, confirmation status, source and next action. The example row is fictional and the CSV has no calculations. Count only eligible rows in the cohort you selected and apply the formulas above.

Keep identifiable family details in the approved enrollment system. A reference number is enough for this review. Record unknown acquisition sources as unknown; do not guess that a registration came from Google because an article received visits that day.

Common questions

How should siblings count? Separately for a camper-session funnel; together only in an explicitly family-level report.

Is a form submission a conversion? It can be a stage, but confirmation must match your documented enrollment rule.

Does a higher rate prove an article caused more registrations? No. This operational funnel describes progression; attributing it to an article requires reliable source and conversion tracking.

Download the worksheet

Download the editable CSV worksheet. Open it in Excel, Google Sheets, or another spreadsheet application. The first data row is a fictional example; delete it before entering your own records. The file has no automatic calculations. Keep completed copies in your approved staff storage, not on a public link.