Reports & Analytics
Booking Reports - Analyze Reservation Patterns
Booking reports show your reservation volume over time, cancellation rates, how far in advance customers book (lead time), and booking patterns by day and time.
Booking reports help you understand when and how customers make reservations. Analyze patterns, spot trends, and optimize your operations.
---
Booking Volume
Total Bookings
Number of reservations in the selected period.
Breakdown by status:
| Status | Count | % |
|---|---|---|
| Completed | 145 | 72% |
| Reserved | 35 | 17% |
| Cancelled | 15 | 7% |
| No-Show | 5 | 2% |
| Refunded | 4 | 2% |
Bookings Over Time
Line chart showing booking volume by day, week, or month.
Look for: - Overall trends (growing, declining, stable) - Seasonal patterns - Spikes around holidays or events - Unusual dips (weather, issues)
---
Booking Trends
Activity Chart
Shows daily activity including: - New bookings created - Bookings completed - Cancellations - Refunds
Toggle each series to focus on what matters.
Booking Velocity
7-day rolling average of new bookings.
Velocity: 8.3 bookings/day ↑ 12%Momentum indicator: - ↑ Increasing = Growing demand - → Flat = Stable - ↓ Decreasing = Slowing demand
---
Cancellation Analysis
Cancellation Rate
Cancellation Rate = Cancelled ÷ Total × 100%Example: @@FENCE2@@
Cancellations Over Time
Track if cancellations are increasing or decreasing.
Warning signs: - Sudden spike in cancellations - Consistent increase over time - Rate above 15%
Cancellation Reasons
If you track cancellation reasons:
| Reason | Count | % |
|---|---|---|
| Schedule change | 6 | 40% |
| Weather concern | 4 | 27% |
| Found alternative | 3 | 20% |
| Other | 2 | 13% |
Reducing Cancellations
Based on data: - Weather concerns → Offer weather protection - Schedule changes → Flexible rescheduling policies - Last-minute cancels → Strengthen deposit requirements
---
Lead Time Analysis
What Is Lead Time?
How far in advance customers book before their rental date.
Lead Time Distribution
| Lead Time | Bookings | % |
|---|---|---|
| Same day | 25 | 12% |
| 1-3 days | 45 | 22% |
| 4-7 days | 55 | 27% |
| 8-14 days | 40 | 20% |
| 15-30 days | 25 | 12% |
| 30+ days | 15 | 7% |
Average Lead Time
Average: 9.2 days before rentalStrategic Insights
High last-minute bookings (same day + 1-3 days): - Local customer base - Walk-in traffic important - Less predictable demand
High advance bookings (15+ days): - Destination/tourist market - More predictable operations - Early bird discounts effective
---
Duration Analysis
Rental Duration Distribution
How long customers rent:
| Duration | Bookings | % |
|---|---|---|
| 2 hours | 35 | 17% |
| Half day (4 hrs) | 65 | 32% |
| Full day (8 hrs) | 75 | 37% |
| Multi-day | 30 | 14% |
Average Duration
Average rental: 5.8 hoursRevenue by Duration
| Duration | Revenue | AOV |
|---|---|---|
| 2 hours | $3,500 | $100 |
| Half day | $9,750 | $150 |
| Full day | $18,750 | $250 |
| Multi-day | $10,500 | $350 |
Insight: Longer rentals have higher AOV—encourage with per-hour discounts.
---
Day and Time Patterns
Bookings by Day of Week
When bookings are made (not when rentals occur):
| Day | Bookings Made |
|---|---|
| Sunday | 28 |
| Monday | 35 |
| Tuesday | 32 |
| Wednesday | 30 |
| Thursday | 38 |
| Friday | 22 |
| Saturday | 15 |
Insight: Customers often book during the workweek for weekend rentals.
Demand Heatmap
Visual grid showing when rentals occur:
Mon Tue Wed Thu Fri Sat Sun
8am ░░ ░░ ░░ ░░ ▒▒ ██ ██
10am ░░ ░░ ░░ ▒▒ ██ ██ ██
12pm ▒▒ ▒▒ ▒▒ ▒▒ ██ ██ ██
2pm ▒▒ ▒▒ ▒▒ ▒▒ ██ ██ ██
4pm ░░ ░░ ░░ ▒▒ ▒▒ ▒▒ ▒▒
6pm ░░ ░░ ░░ ░░ ░░ ░░ ░░
░░ = Low ▒▒ = Medium ██ = HighPeak times: Saturday/Sunday 10am-2pm
---
Source Analysis
How Customers Book
| Source | Bookings | % |
|---|---|---|
| Website | 150 | 75% |
| Dashboard (Staff) | 40 | 20% |
| Phone (via staff) | 10 | 5% |
Conversion Insights
Track where bookings come from to optimize marketing.
---
Repeat vs. New Customers
Customer Breakdown
| Type | Bookings | % |
|---|---|---|
| New customers | 120 | 60% |
| Returning customers | 80 | 40% |
Repeat Booking Rate
Repeat Rate = Returning ÷ Total × 100%Benchmark: 30-40% repeat rate is healthy
Building Loyalty
- Follow up after rentals
- Offer loyalty discounts
- Collect and act on feedback
---
Booking Quality Metrics
Completion Rate
Bookings that result in actual rentals:
Completion Rate = (Completed + Rented) ÷ Total × 100%No-Show Rate
Reserved bookings where customer didn't arrive:
No-Show Rate = No-Shows ÷ Reserved × 100%Benchmark: Under 5% is good
Attendance Rate
Attendance Rate = 100% - No-Show Rate---
Using Booking Data
Staffing Decisions
- Staff more heavily during peak booking times
- Reduce coverage during slow periods
Pricing Decisions
- Premium pricing for high-demand times
- Discounts for slow periods
- Early bird pricing for advance bookings
Marketing Decisions
- Target campaigns before booking peaks
- Promote during slow periods
- Focus on channels that convert
---
Related Articles
Need more? Search the live help desk or email wecare@recsystems.com.