Automated Camp Enrollment Revenue Report
Every Monday, WebRun opens CampBrain, pulls current enrollment numbers and collected revenue by session, logs the data to a Google Sheet, and posts a clean highlights digest to your leadership Slack channel so decision-makers start the week with current numbers.
How do I automatically get a weekly camp enrollment and revenue report?
WebRun opens CampBrain every Monday, pulls enrollment counts and collected revenue for each active session, and logs the data to a Google Sheet with week-over-week trend columns. It then posts a highlights digest to your leadership Slack channel with capacity fill rates and any sessions worth watching, so your team starts the week with current numbers.
- Leadership sees current enrollment and revenue every Monday without pulling a manual report
- Week-over-week trends are visible in Google Sheets over the full registration season
- Sessions nearing capacity or showing enrollment drops are flagged automatically
Built for camp directors · camp business managers · executive directors · youth program leaders
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.campbrain.comin a real browser with your saved login - no setup, no API keys. -
1
CampBrain - pull enrollment and revenue data
campbrain.com
WebRun opens CampBrain to pull enrollment and revenue data. - Open CampBrain and navigate to the Business Office reports for the current registration cycle
- Capture total enrolled campers by session, available spots remaining, and total revenue collected to date
- Note week-over-week changes in enrollment and revenue compared to the previous Monday's figures
Done when Current enrollment counts and revenue figures are captured for every active session.
-
2
Google Sheets - log to weekly revenue tracker
google.com
WebRun opens Google Sheets to log to weekly revenue tracker. - Open the camp enrollment and revenue tracker Google Sheet
- Add a new row for this week with session names, enrollment counts, capacity, and revenue collected
- Calculate week-over-week change columns so trends are visible at a glance
Done when This week's enrollment and revenue data is logged to the Sheet with trend columns updated.
-
3
Slack - post digest to leadership channel
slack.com
WebRun opens Slack to post digest to leadership channel. - Post a formatted digest to your leadership Slack channel with total enrollment, total revenue, capacity fill rates by session, and the week-over-week change
- Flag any session that is more than 90 percent full or has declined in enrollment since last week
- Include a link to the full Google Sheet for deeper analysis
Done when Leadership has this week's enrollment and revenue digest in Slack with trend flags.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does this replace my CampBrain financial reports?
No. It surfaces the key weekly numbers in Slack and logs them to a running Google Sheet so trends are visible over time. For detailed financial statements or audit-ready reports, you still use CampBrain directly.
Which sessions does it cover?
It covers all active sessions in the current registration cycle in CampBrain. Past sessions are excluded once their enrollment period closes.
How accurate is the revenue figure?
It reads the revenue collected figure from CampBrain's Business Office at the time of the Monday run. Payments processed after the run are captured the following Monday.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.