Bookings Intelligence

A live, owner-friendly view of who, when and why · covers, no-shows, weather impact and the few decisions that move the dial
OF
The Old Forge Inn
Stratford-upon-Avon · Gastro pub + 6 rooms
Live · updated 11 May 2026
7 days
Covers / week
847
+6.4% vs prior 4-wk avg
net of vat
Avg spend / cover
£23.40
Food £17.80 · Drinks £5.60
⚠
No-show rate
7.3%
+1.1pp vs Q1 average
per cover
Profit / cover
£9.12
Food 64% GM · staff cost in
covers/seat
Table turnover
1.9x
Peak 2.4x Sat eve · 1.1x Tue lunch
!
The number we'd lead with
Tuesday lunch is running at 31% of capacity, while Friday and Saturday evenings hit 97% with a waiting list. A set lunch on Tue 12-3pm at £14.50 would be cost-neutral above 8 covers and you've already turned away 4 walk-ins on that slot this month.
Backed by 87 days of your own bookings data, cross-referenced against Met Office temp + rainfall and local competitor pricing scraped weekly.

Covers Heatmap · last 28 days

Each cell = average covers in that slot · darker = busier · red = at-or-above 90% of seated capacity
Quieter
Capacity Capacity per slot: 56 covers (42 restaurant + 14 bar tables)
Reliable peaks: Fri 18:00-21:00 and Sat 18:00-22:00 sit at 93-99% capacity. Currently turning away ~14 covers/week. Worth holding back a small allocation for walk-ins to capture the £28 avg drink-only spend.
Dead pockets: Tue 12-15, Wed 15-17, Sun 19-21. Three distinct opportunities, each has a different fix (set menu / closure / earlier last orders).
The Sunday cliff: Sunday roasts are full 12-15, then covers fall 87% after 17:00. You're paying full kitchen brigade for 11 covers across last 4 weeks.

Next 14 Days · Projected Covers vs Weather

Projection blends your bookings (taken to date) + forecast covers (lead-time model) + weather impact
Projected covers
Temp °C (right axis)
Rainfall mm (right axis)
Correlation we've built into your forecast: for every +1°C above 14°C you gain roughly 11 covers on the beer garden weekdays; rainfall above 4mm/day costs you ~18 covers on weekday evenings (walk-in drinks crowd). Tap a day on the chart for the full breakdown.

Three Decisions That Earn Their Keep

Specific, costed, with a number to track them by, not a generic playbook
1
Run a Tuesday set menu 12-3pm
Three courses £14.50 (food cost £5.10 GP 65%). Currently 31% capacity. Cost-neutral above 8 covers, in profit from cover 9 onwards.
target +22 covers/week · review after 4 weeks
2
Stop Sunday bookings under 2 hours notice
Sunday short-notice has a 47% no-show rate, against 5% for those booked >24hrs out. Worst single-slot cost: 4 Aug Sun 13:30, party of 8, £186 of food prepped.
save ~£320/month in prep waste
3
Bring last orders forward to 20:30 on Sun
After 19:00 Sun you average 2.7 covers across the entire restaurant. Two KPs and the head chef cost roughly £94/hr in NI-loaded labour.
save ~£1,880/year on kitchen wages (front-of-house unchanged)

No-Shows by Booking Source

Last 90 days · 412 bookings · 30 no-shows
Source (bookings)
No-show rate
Cost
OpenTable (148)
11.5%
£1,640
Phone (122)
7.4%
£860
Website widget (84)
4.8%
£380
Repeat customer (42)
2.4%
£90
Walk-in (16)
0.0%
£0
No-show rate by lead time
Lead time
Rate
%
Under 2 hours
31.8%
2-24 hours
12.1%
1-7 days
6.8%
1-4 weeks
3.4%
4+ weeks out
1.9%
Total no-show cost (last 90 days): £2,970 · covers lost: 96 · equivalent to 2.8 days of weekday trade.

Best Customer Cohort

The 47 people we'd send a thank-you to first
+41%
Tuesday lunch repeat visitors spend 41% more per cover than the venue average, and 3.2x more annually because they come back.
Cohort size 47 customers
Avg spend / visit £33.10
Visits / year (avg) 7.8
Annual value / customer £258
No-show rate 1.4%
Booking source 88% phone / repeat
Avg party size 2.4
Why it matters: if 6 of these 47 stop visiting (cohort attrition runs ~12% per year industry-wide), you lose £1,548/year. A handwritten Christmas card costs 86p.

Where the Bookings Come From

90-day channel mix · revenue weighted
Worth knowing: OpenTable takes £1 per cover plus a 2% commission on prix-fixe menus. That's £174/month at your current volume. Direct website widget is now 20% of bookings and rising 4pp/quarter, momentum your way.
Status
Sort
Date / time Guest Party Source Lead time Spend Per cover Status Notes
Built by Simply Button Solutions
"Big companies tell you what you want. I prefer to ask." · Demonstration dashboard with fictional bookings ·