Skip to content

Weekly Occupancy and Revenue Digest

Example prompt: "Every Sunday at 6pm, read our 'Bookings' Google Sheet for the week just ended and the four weeks ahead. Compute occupancy, ADR, and average lead-time, flag any rooms with low forward bookings, and email the owner a one-page digest plus a Slack summary in #manager."

The Problem

The owner of a small property knows last week was a good week or a quiet week, but quantifying it requires opening the booking sheet on a Sunday evening and doing the arithmetic by hand. The forward picture is worse — knowing which week three out is looking thin, or which room has now had three quiet weeks in a row, requires holding a calendar in your head while scrolling through rows. The numbers either do not get computed at all, or they get computed once a month when the bookkeeper asks for them, by which point the forward weeks the report would have flagged are too close to do anything about.

How GloriaMundo Solves It

We run the same arithmetic the owner would do by hand and present it in a one-page doc with the forward weeks called out. A code step computes occupancy, ADR, RevPAR, and average lead-time for the week just ended, comparing each to the same week last year if the sheet holds the history. A second pass walks the next four weeks and finds rooms that have zero bookings (cold rooms) and weeks that are below a sensible threshold with a short lead-time. An LLM step turns the numbers into a one-page Google Doc with a headline paragraph, the forward four weeks broken down, the source mix, and a 'Things to look at' section that only fires on specific anomalies (no recommendations the data cannot support). The doc lives in the 'Weekly Digests' Drive folder, the owner gets a Gmail link, and a one-liner lands in #manager on Slack so the headline travels even if the doc does not get opened. Glass Box preview shows the computed numbers and the draft doc before anything reaches the owner.

Example Workflow Steps

  1. Trigger (schedule): Every Sunday at 6pm.
  2. Step 1 (integration): Read the 'Bookings' tab and the 'Rooms' tab.
  3. Step 2 (code): Compute occupancy, ADR, RevPAR, and average lead-time for the week just ended, pro-rated for stays that straddle the boundary; compare to the same week last year where the history exists.
  4. Step 3 (code): Walk the next four weeks: per-week occupancy on the books, unsold room-nights, cold rooms (zero bookings), source mix.
  5. Step 4 (llm): Draft a one-page Google Doc 'Weekly Digest — [week-ending date]' with headline numbers, forward four weeks, source mix, and a 'Things to look at' section that fires only on specific anomaly thresholds.
  6. Step 5 (integration): Save the doc into the 'Weekly Digests' Drive folder; email the link to the owner via Gmail.
  7. Step 6 (integration): Post a one-line summary in #manager on Slack.

Integrations Used

  • Google Sheets — bookings, rooms, and the historical comparison source
  • Google Docs — the weekly digest, one per Sunday in 'Weekly Digests'
  • Google Drive — the stable folder so the owner always knows where to look
  • Gmail — the Sunday-evening link to the owner
  • Slack — the #manager one-liner so the headline travels

Who This Is For

Owners and managers of small properties (one to a dozen rooms) who currently rely on a monthly bookkeeper report or a gut feel for how the week went and what is coming. The workflow gives the same numbers a property management system would surface, on the schedule that lets the owner act on the forward weeks while there is still time to do something.

Time & Cost Saved

Computing the numbers by hand takes an hour to ninety minutes on a Sunday evening once a month, longer if the spreadsheet is busy. Most owners do not do it weekly because the marginal hour is not worth it, so the forward-week flag only surfaces when the week is too close to influence. The workflow makes the weekly cadence free, which is the point: a three-weeks-out cold room is something a rate adjustment or a quick OTA promotion can fix; a one-week-out cold room is mostly just lost revenue. The bigger gain is the consistency — the owner reads the same one-page doc every Sunday and starts to recognise patterns (the same week of last year was busier, the Vrbo share has slipped two weeks running) that a once-a-month report would smear out.