skills.rest
amitpo23
amitpo23COMMUNITY
Explore all skills by this author →
GitHub

SalesOffice Price Drop Intelligence Skill

Parse SalesOffice logs to extract price drops and generate price_drop_* reports.

Updated Feb 24, 2026
Search Tags:#analytics#logs#reporting#price#price-drop#salesoffice
One-click install
npx skills add https://github.com/amitpo23/medici-price-prediction --skill salesoffice-price-drop-intelligence-skill
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: SalesOffice Price Drop Intelligence Skill
Source: https://github.com/amitpo23/medici-price-prediction/tree/main/skills/salesoffice-price-drop
Command: npx skills add https://github.com/amitpo23/medici-price-prediction --skill salesoffice-price-drop-intelligence-skill

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, pyodbc.

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.

Frequently Asked Questions about SalesOffice Price Drop Intelligence Skill

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I detect price drops from SalesOffice logs for hotels and room categories?▼

To detect price drops from SalesOffice logs, you parse log messages to extract OldPrice and NewPrice, compute the DropAmount, and aggregate the data by scan window and hotel context to generate actionable pricing trend reports.

What reports are generated when analyzing price drops in SalesOffice log data?▼

Analyzing SalesOffice log data generates price_drop_events.csv, price_drop_by_scan.csv, price_drop_by_hotel.csv, and a summary.json file containing per-scan metrics, downward rates, and hotel-level insights.

Can I estimate the probability of a future price drop in the next scan window?▼

Yes, the analysis provides short-term probability estimates for a price drop in the next scan window by calculating historical downward rates and volume of changes across per-scan-window metrics.

Does this price-drop analytics approach support contextual attribution by board and room category?▼

Yes, the analytics approach supports contextual attribution by hotel, room category, and board to identify exactly where downward price moves occur within your SalesOffice operations data.

Related Skills

Explore More Data & Analytics Skills→
kkn1125kkn1125

reporting

Generate daily business reports from raw logs and task records.

Community
Intermediate
ryantsairyantsai
434

dashboard-data-visualization

Create dashboard widgets visualizing metrics, health, and trends for KKTerm.

Community
Advanced
liangdabiaoliangdabiao
264

funnel-analysis

Analyze multi-step funnels to compute conversion rates and identify bottlenecks.

Community
Advanced
Mekann2904Mekann2904

log-analyzer

Analyze log files to extract error patterns and detect anomalies.

Community
Intermediate