Automated Limo Weekly Bookings Revenue Report
Every Monday, WebRun opens Limo Anywhere, pulls the previous week's completed and cancelled trips, calculates total bookings, revenue, no-show rate, and top vehicle type, then logs the data to a Google Sheet and posts a concise summary to Slack.
How do I automatically get a weekly bookings and revenue report for my limo business?
Every Monday, WebRun pulls the previous week's completed and cancelled trips from Limo Anywhere, calculates total bookings, gross revenue, cancellation rate, and vehicle performance, then appends the metrics to a Google Sheet and posts a concise week-over-week summary to Slack. Owners and managers start the week informed without pulling a single report manually.
- Owners see last week's bookings and revenue in Slack before the workday starts
- A running Google Sheet builds a historical trend line without any manual data entry
- Week-over-week comparisons make it easy to spot dips before they become patterns
Built for limo company owners · chauffeured car operations managers · black car business executives · ground transportation fleet 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.limoanywhere.comin a real browser with your saved login - no setup, no API keys. -
1
Limo Anywhere - pull last week's trips and revenue
limoanywhere.com
WebRun opens Limo Anywhere to pull last week's trips and revenue. - Open Limo Anywhere and filter trips to those with a completion or cancellation date in the prior calendar week
- Count total bookings, completed trips, cancellations, and no-shows
- Sum gross revenue, average trip value, and revenue by vehicle type for the week
Done when Last week's trip counts, cancellation rate, and revenue totals are captured.
-
2
Google Sheets - log weekly metrics
google.com
WebRun opens Google Sheets to log weekly metrics. - Append a new row to the weekly bookings report sheet with the date range and all captured metrics
- Calculate week-over-week change for total bookings and gross revenue
- Update the summary tab with the latest week so charts and trend lines refresh automatically
Done when The weekly bookings report sheet is updated with last week's metrics and trends.
-
3
Slack - post weekly bookings summary
slack.com
WebRun opens Slack to post weekly bookings summary. - Post a concise weekly summary to the management or ops Slack channel
- Include total bookings, gross revenue, cancellation rate, and the top-performing vehicle type
- Add a one-line week-over-week comparison so the team can see whether the business is up or down
Done when The management team has last week's performance summary in Slack at the start of the new week.
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
Which metrics does the report include?
It covers total bookings, completed trips, cancellations, no-shows, gross revenue, average trip value, revenue by vehicle type, and a week-over-week comparison for bookings and revenue.
Can it break down revenue by client type such as corporate versus leisure?
Yes. If client type is recorded in Limo Anywhere, WebRun reads it and includes a revenue-by-segment breakdown in the Google Sheet. The Slack summary shows the top-level totals by default.
Does it include data from all vehicles in the fleet?
Yes. It pulls all completed and cancelled trips across the entire fleet for the reporting week. You can filter to specific vehicle types or drivers in the Google Sheet after the data is logged.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.