---
name: rezervasyon-iptal-orani
description: "Use when a reservation cancellation rate by agency analysis is requested from creation date, anonymised reservation ID, channel and status at the cut-off date. Produce a formula-based Excel file and a Word summary."
---

# Reservation cancellation rate by agency

Within the same reservation cohort, which channel has the highest cancellation rate, and where do most of the total cancellations come from?

## Input and scope

Creation date, anonymised reservation ID, channel and status at the cut-off date.

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

1. Use the same creation period and status cut-off date. Do not mix denominators taken by stay date or by cancellation date. Verify the original reservation universe, including reservations that have since been cancelled.

2. Deduplicate the IDs. Separate full cancellation, partial cancellation, modification and no-show statuses. Build both the numerator and the denominator on reservation count. If a room-night-based rate is requested, produce a separate table.

3. Channel rate = full cancellations / unique reservations created. Calculate the hotel rate as total cancellations / total reservations. In Word, note small channel volumes and open reservations that may still change.

## 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: Channel, Reservations, Full cancellations, No-show, Cancellation rate.

## 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: OTA B has the highest cancellation rate at 25%. The most cancellations, however, are at Agency A with 18 reservations.
