Start with the day groups
Weekly occupancy alone does not show which nights are strong and which remain empty. An identical total can conceal sales concentrated on weekdays or on the weekend. Divide stay nights into explicit day groups, calculate each against its own available room-nights, then rebuild the weekly total. This is a way to inspect a pattern before deciding, not a recommendation to raise prices or discount. Every number below belongs to a wholly fictional example, not a real property, customer or Stayax result.
Fix the date basis and unit
Here weekdays mean Monday to Friday and the weekend means Saturday and Sunday. A property may choose different groups, but both comparison periods must keep the same definition. Record the stay night rather than the date a booking was created. Cloudbeds’ official reporting documents distinguish stay dates, rooms sold and capacity. Those field distinctions support this worksheet; they do not supply our fictional pattern, a weekend forecast or any claimed capability of another product.
Build a fictional 20-room week
Assume all 20 rooms are available on every night, with no capacity changes, day use or complimentary stays. Rooms sold from Monday through Sunday are 10, 12, 14, 16, 18, 19 and 17. These are room-nights, not guests or reservation counts. The first five nights contribute 70 and the last two contribute 36: together 106 sold room-nights. Available capacity is separately 20 × 5 = 100 and 20 × 2 = 40, giving 140 for the week.
Do not average unequal groups equally
Weekday occupancy is 70 / 100 = 70%; weekend occupancy is 36 / 40 = 90%. Averaging the percentages equally gives 80%, which is not weekly occupancy. The correct result is 106 / 140 × 100 = 75.71%, rounded here to two decimals. The weighted check is 70% × 5/7 + 90% × 2/7. Five nights and two nights cannot have equal weight. If capacity varies, use available room-nights as weights rather than simply counting nights.
The same total can hide the opposite pattern
Consider a separate fictional pattern: sell 80 of the same 100 weekday room-nights and 26 of the same 40 weekend room-nights. The total is still 106 and weekly occupancy remains 75.71%. Yet weekdays are at 80% and the weekend at 65%. The stronger group has reversed. A weekly headline cannot distinguish the patterns. This is neither a forecast nor a claim that real reservations moved between dates; it is an independent arithmetic comparison showing what aggregation leaves out.
Empty capacity is not demand
Returning to the first pattern, unused capacity is 100 − 70 = 30 weekday room-nights and 40 − 36 = 4 weekend room-nights. These are numerical gaps, not proof of additional demand or achievable sales. Inspect the individual dates before treating either group as one opportunity. Monday and Friday may call for different questions. Keep any verified demand observation in another column, and label the assumption connecting it to an action. A correct capacity calculation does not validate a sales target.
Translate percentage points into room-nights
Adding 10 percentage points to weekday occupancy means moving from 70% to 80%: 10 additional room-nights against 100 capacity. Weekly occupancy would become 116 / 140 = 82.86%. Raising the weekend from 90% to 100% also adds 10 points, but requires only 4 room-nights against 40 capacity; the week becomes 110 / 140 = 78.57%. Both hypothetical changes together produce 120 / 140 = 85.71%. These are arithmetic scenarios, not campaign results. Percentage points and percentage growth are different descriptions.
Compare like periods
For the next review, keep the same day groups, data cut-off and reservation statuses. Do not compare a completed week with an unfinished future booking week and immediately call the difference a performance change. Record holidays or local events as annotations without silently redefining the groups. Look across several comparable periods before suggesting persistent behaviour. Put the extraction date, included statuses and exclusions beside the worksheet so another team member can reproduce the comparison rather than interpreting a different version of the same number.
Keep the decision sheet separate from revenue claims
Write the observation first: for example, “30 empty weekday room-nights, unevenly distributed.” Add the open question, such as which dates have evidence of demand. Only then define a small action to investigate and a review date. More room-nights do not automatically mean more profit; this example contains no price, cost or revenue calculation. The meeting should produce a testable question for the appropriate dates, not an automatic discount or one price for the whole week. Keep the weekly headline alongside both groups and their raw counts.