SalesOffice Price Drop Intelligence Skill

What problem does it solve?

Analyzes SalesOffice logs to detect price drops across scans, enabling faster pricing trend insights and automated reporting for operational decisions.

Core Features & Use Cases

• Totals and breakdowns of price changes across logs, with a focus on downward moves
• Contextual attribution by hotel, room category, and board to identify where drops occur
• Per-scan-window metrics including downward rate, lowest observed price, and volume of changes
• Short-term probability estimates for a price drop in the next scan window
• Output artifacts: price_drop_events.csv, price_drop_by_scan.csv, price_drop_by_hotel.csv, and summary.json

Quick Start

Run analyzer.py on a CSV export or directly via DB connection to generate the price-drop reports in the report directory.