Skill · Sales and revenue
OTA rate difference check
Which rate change is based on a genuine like-for-like comparison under the same selling conditions?
Download skill package
ota-fiyat-kontrolu/ ├─ SKILL.md ├─ assets/ │ └─ ornek-girdi.xlsx └─ ornekler/ ├─ analiz.xlsx └─ yonetim-ozeti.docx
SKILL.md instructions and sample files in one package
How to use
- Download the package.
- In an assistant that supports skills (e.g. Claude), upload the package as a skill. In other assistants, paste the SKILL.md text into the chat.
- Attach your own Excel export and send the message below. The assistant prepares the formula-based workbook and the Word summary.
Try it with the sample
Before using your own data you can try the sample input in the package. Send this message to the assistant together with the file:
Analyze the files I attached for OTA rate parity. Which rate change is based on a genuine like-for-like comparison under the same selling conditions? Prepare the result as a formula-based Excel file and a one-page Word report we can use in our meeting.
At Kıyı Otel, the rate under the same conditions fell from €150 to €135 (10%).
Sample files
- Sample input
ornek-girdi.xlsx - Expected Excel analysis
analiz.xlsx - Expected Word summary
yonetim-ozeti.docx
The sample files are in Turkish.
Instructions (SKILL.md)
Which rate change is based on a genuine like-for-like comparison under the same selling conditions?
Input and scope
Competitor rate table and offer conditions from two different observation dates.
Use the attached Excel/CSV files as the source. Read each one without modifying it. Identify the sheets, report scope, periods, units and required fields. Match synonymous column headers to the sample. If a missing field affects only a specific metric, still produce the other metrics. If a critical definition can be interpreted in more than one way, ask one focused question. Trace subtotals and duplicates back to the source row. Remove fields containing personal data from the output. Use the sample only when the user wants to try it with the sample data.
Analysis
- Match the two observations on the same stay date, length of stay, channel, room type, number of adults and children's ages. Also compare cancellation policy, board basis, taxes, currency and member/mobile conditions.
- Populate the “Other conditions matched” field only from verified conditions. Leave the difference blank for rooms or conditions whose match is uncertain. Show an offer that is not on sale as a separate status.
- Percentage difference = (current − previous) / previous. If the previous amount is zero, leave the percentage blank. In the Word file, explain both the largest comparable change and why a misleading-looking offer is misleading.
Delivery and checks
On the first sheet of Analiz.xlsx, show the rows that answer the question and the calculated indicators. Keep the sources on a separate sheet with anonymised fields. Write Excel formulas for derived measures. On the Checks sheet, add the date range, column mapping, scope, missing/unmatched records and the reconciliation result. Create the Word file as Yonetim-Ozeti.docx. On one page, write the period, the main result, at most three evidenced findings and the work the responsible team should check. Reopen both files; independently check the numbers, the denominators of the ratios and the source totals. Do not report causes you cannot verify as findings. Deliver both files as downloads.
Visible fields in the Excel analysis: Hotel, Previous €, Current €, Comparison, Change %.
Try it with the sample
Use assets/ornek-girdi.xlsx. The expected Excel and Word examples are in the ornekler/ folder. Check specific to this sample: At Kıyı Otel, the rate under the same conditions fell from €150 to €135 (10%).