Automated Tour Capacity and Revenue Report
Every Monday, WebRun opens Peek Pro and pulls last week's booking data across all tour types, calculates seats sold, capacity fill rate, and gross revenue per tour, writes a detailed breakdown to Google Sheets, and posts a concise performance summary to Slack so operators know exactly which tours are performing and which have open seats.
How do I automatically get a weekly capacity and revenue report for my tours?
Every Monday, WebRun pulls last week's booking data from Peek Pro across all tour types, calculates seats sold, fill rate, and gross revenue per tour, writes a full breakdown to Google Sheets, and posts a performance summary to Slack. Operators see which tours are packed and which need a pricing or marketing nudge.
- Operators see each tour's fill rate and revenue in one Slack message every Monday
- Underperforming tours are flagged before the week begins, enabling fast pricing or promotion decisions
- A cumulative Google Sheet builds a historical performance record for seasonal planning
Built for tour operators · activity company managers · multi-tour businesses · adventure tourism operators
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.peekpro.comin a real browser with your saved login - no setup, no API keys. -
1
Peek Pro - pull last week's booking and capacity data
peekpro.com
WebRun opens Peek Pro to pull last week's booking and capacity data. - Open Peek Pro and navigate to the bookings or reports section for last week
- For each tour type, collect: number of sessions run, total seats available, seats sold, cancellations, and gross revenue
- Note any tours with fill rates below 50% and any that sold out and turned away guests
Done when All last week's capacity and revenue data is collected per tour type.
-
2
Google Sheets - calculate and log capacity and revenue report
google.com
WebRun opens Google Sheets to calculate and log capacity and revenue report. - Open the weekly capacity report Google Sheet
- Write a row per tour type with: sessions run, seats available, seats sold, fill rate percentage, cancellations, and gross revenue
- Add a summary row with totals and a highlighted fill-rate column to flag underperformers
Done when The full capacity and revenue breakdown is written to Google Sheets with fill-rate flags.
-
3
Slack - post weekly performance summary
slack.com
WebRun opens Slack to post weekly performance summary. - Post a concise weekly performance message to the ops or management Slack channel
- Include total gross revenue, overall fill rate, and the top three and bottom three tours by fill rate
- Flag any tours that had a fill rate below 50% with a note to consider pricing or promotion
- Link to the full Google Sheet for detailed data
Done when The team has last week's capacity and revenue summary in Slack with actionable 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
Can it break down capacity by individual departure time rather than just tour type?
Yes. Configure the report to group by tour name and start time, and the Google Sheet will show fill rates per slot so you can see which departure times are consistently underbooked.
Does it track revenue net of OTA commissions?
The default report uses gross revenue from Peek Pro. To show net revenue, upload your OTA commission rates to the Google Sheet and the workflow will calculate a net column alongside gross.
Can it flag tours that are consistently underselling so I can take action?
Yes. Tours with a fill rate below your configured threshold are highlighted in the Google Sheet and called out in the Slack summary, giving you a clear weekly prompt to adjust pricing or run a promotion.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.