02-insights.md

routines/02-insights.md

Routine 2 · Insights

Schedule: Mondays 7:07. Repository: this one. Connectors: Google Drive only.

Prompt:

Read this week's report-<year>-<week>.json from the Drive folder "Validated". Only reports that passed the check outside the agent are there. If it is missing or older than 3 hours, stop.

1. Compare the next 7 days on the books with the last 7 days. Use last_7_days in the report. Do not calculate the difference yourself.
2. Call out every date with below_threshold true. The threshold is in the report.
3. Compare group pickup with allocation for each date: group_rooms_picked_up against group_rooms_allocated.
4. Cancelled events are not demand. Never use them as a reason for a busy or a quiet date.
5. Look at rooms_with_open_maintenance before the dates with the highest occupancy.
6. Write at most 5 insights to outputs/insights.json, in the format of schemas/insights.schema.json. Each one says what changed, why, what to look at, and the evidence: the file and the row (source_file and source_row of the report row). Add any report warnings that change how a number should be read.
7. Validate with python3 scripts/validate.py schemas/insights.schema.json outputs/insights.json and save it to "Outputs".