Reporting by reservation type and reservation agent

Problem / context

Review and feedback reporting can't be broken out by reservation type (for example owner stay, direct, OTA, or other PMS reservation types) or by the reservation agent who booked or handled the stay. Teams want to see how outcomes differ across these groups and use that in agent coaching.

Requested capability

Group and filter review and feedback reporting by reservation type and by reservation agent.

Detail / spec

• Ingest reservation type and reservation agent from the PMS (starting with Track) on each reservation.
• Add both as filters and group-by dimensions in review and feedback reporting.
• Show per-group metrics: review volume, average rating, feedback request response rate, and sentiment.
• Agent view: tie each agent's handled reservations to guest sentiment during the stay and the eventual review outcome, so managers can compare agents working the same market or shift.
• Include both dimensions in exported reports and scheduled reports.

Acceptance criteria

• Reports can be filtered and grouped by reservation type and reservation agent.
• Agent-level metrics reconcile to the underlying reservations and reviews.
• Both fields appear in CSV exports and scheduled reports.