Profile where dead time occurs
booking_gap_profilePinpoint which weekdays and hours contain the most structural dead time, exposing the exact booking patterns that cause unsellable gaps.
Instructions
Show when structural dead time occurs, broken down by weekday and by hour of day.
The total dead-time figure from booking_gap_analyze says how much is lost. This says where to look. Dead time concentrated in one weekday or one part of the day usually points at a specific booking pattern rather than a general problem.
Gaps are distributed proportionally across the hours they span, so a 40-minute gap running 13:50-14:30 is attributed to both hours.
Args: same as booking_gap_analyze, plus
topCells (number, default 8): how many worst weekday x hour cells to list
Returns a text report with a weekday table, an hour-of-day bar chart, and the worst weekday x hour cells.
Use when: "which days are worst", "when does the fragmentation happen".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| bookings | No | Bookings as structured objects. Provide either this or bookingsCsv. | |
| currency | No | Currency symbol prefix, e.g. "¥". | |
| topCells | No | How many worst weekday x hour cells to list. | |
| periodEnd | No | Last date to analyse (YYYY-MM-DD). Defaults to the latest booking. | |
| resources | No | Resources to include even when they have no bookings in the period. | |
| hourlyRate | No | Optional hourly price, used to express dead time as an amount. No default. | |
| bookingsCsv | No | Bookings as pasted CSV or TSV with a header row. Column names are matched in English and Japanese (start/end/resource/date/status, 開始時刻/終了時刻/部屋/日付/ステータス). A separate date column plus HH:mm times is supported. | |
| periodStart | No | First date to analyse (YYYY-MM-DD). Defaults to the earliest booking. | |
| openingHours | Yes | Opening hours. Use "default" for the usual day and override individual weekdays as needed, e.g. {"default": [["09:00","22:00"]], "sun": [["10:00","18:00"]]}. Use "24:00" to close at midnight. | |
| timezoneOffset | No | Venue timezone offset, used only for inputs that carry an explicit offset or "Z". | +09:00 |
| turnoverMinutes | No | Cleaning or changeover time required between two bookings. | |
| minBookingMinutes | No | Shortest booking a customer is allowed to make. | |
| slotGranularityMinutes | No | Allowed booking start interval, measured from midnight (30 means :00 and :30). |