You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 14
Next »
This dataset provides information per reservation. It's possible that one reservation contains two or more accommodations, so attributes and metrics of the Accommodation Daily Dataset and Reservation Dataset can't be exchanged.
Attribute | Definition |
|---|
Arrival Date | | Arrival Date | The exact date the customer is arriving | | Arrival Date Day of Week | The day of the week the customer is arriving | | Arrival Date ISO Week | The ISO week in which this date is classified | | Arrival Date ISO Year | The ISO year in which this date is classified | | Arrival Date Month | The month the customer is arriving | | Arrival Date Quarter | The quarter the customer is arriving | | Arrival Date Year | The year the customer is arriving |
|
Customer | | City | City of Origin of the customer | | Country | Country of Origin of the customer |
|
Departure Date | | Departure Date | The exact date the customer is departing | | Departure Date Day of Week | The day of the week the customer is departing | | Departure Date ISO Week | The ISO week in which this date is classified | | Departure Date ISO Year | The ISO year in which this date is classified | | Departure Date Month | The month the customer is departing | | Departure Date Quarter | The quarter the customer is departing | | Departure Date Year | The year the customer is departing |
|
Distribution Channel | | Distribution Channel Brand | If used in MXTS, the brand of the distribution channel | | Distribution Channel Level 1 |
The distribution channel through which the reservation of the resource was made. Level 1 - 5 depends on the tree-structure in MXTS | | Distribution Channel Level 2 | | Distribution Channel Level 3 | | Distribution Channel Level 4 | | Distribution Channel Level 5 | | Distribution Channel Type | Type of the distribution channel (e.g. Direct, Touroperator or Reseller) |
|
Employee | | Employee | Name of the Employee who created the reservation | | Employeegroup | The group to which the employee who created the reservation belongs (e.g. Reservations, Administrators or Internet) |
|
Location | | Location Country | Country in which the accommodation (is relation to the reserved resource) is located | | Location level 1 |
Location level as classified in MXTS tree-structure (1 - 5 is possible)
| | Location level 2 | | Location level 3 | | Location level 4 | | Location level 5 |
|
Reservation | | Reservation | Number of the reservation to which the resource is linked | | Reservation Status | States of the reservation (e.g. Definitive, Pre Booking, Expired or Cancelled) | | Reservationcategory | If used, the categorie of the reservation, for example the source of the reservation (by phone, e-mail or website) | | Source | If used, the source of the reservation (e.g. Social Media, Booked from Website, TripAdvisor or Search Engine) |
|
Reservation Date | | Reservation Date | The exact date the reservation was created | | Reservation Date Day of Week | The day of the week the reservation was created | | Reservation Date ISO Week | The ISO week in which this date is classified | | Reservation Date ISO Year | The ISO year in which this date is classified | | Reservation Date Month | The month the reservation was created | | Reservation Date Quarter | The quarter the reservation was created | | Reservation Date Year | The year the reservation was created |
|
Reservation Duration | | Reservation Duration | The duration of the reservation calculated in days. For example: When the arrival day is Sunday and departure is two weeks later on Sunday, the reservation duration is 14 days | | Reservation Duration Interval 30 Days | The 30-days interval in which a reservation is classified. For example: A reservation duration of 14 days is in this attribute classified in the interval 1 - 30 days | | Reservation Duration Interval 5 Days | The 5-days interval in which a reservation is classified. For example: A reservation duration of 14 days is in this attribute classified in the interval 11 - 15 days | | Reservation Duration Interval 7 Days | The 7-days interval in which a reservation is classified. For example: A reservation duration of 14 days is in this attribute classified in the interval 8 - 14 days |
Example to show that the different types of duration intervals overlap each other: 
|
Reservation Lag | | Reservation Lag | The number of days between the reservation date and arrival date. This way you can see how many days in advance your customers are making a reservation. | | Reservation Lag Interval 30 Days | The 30-days interval in which the reservation lag is classified. For example: A reservation lag of 33 days is in this attribute classified in the interval 31 - 60 days | | Reservation Lag Interval 5 Days | The 5-days interval in which the reservation lag is classified. For example: A reservation lag of 33 days is in this attribute classified in the interval 31 - 35 days | | Reservation Lag Interval 7 Days | The 7-days interval in which the reservation lag is classified. For example: A reservation lag of 33 days is in this attribute classified in the interval 29 - 35 days |
|
Metric | Definition |
|---|
Agent Bill Total | Total bill amount for agent |
Agent Outstanding Amount | Due/outstanding bill amount for agent |
Agent Paid Amount | Bill amount paid by agent |
Customer Bill Total | Total bill amount for customer |
Customer Outstanding Amount | Due/outstanding bill amount for customer |
Customer Paid Amount | Bill amount paid by customer |
Number of Nights | Number of nights for which reservation is made |
Number of Reservations | Number of reservations at particular attribute level |
Paying Customer Bill Total | If used in MXTS, for example when a reservation for a guest (Customer) is made via an agency (Paying Customer): Total bill amount for paying customer |
Paying Customer Outstanding Amount | If used in MXTS, for example when a reservation for a guest (Customer) is made via an agency (Paying Customer): Due/outstanding bill amount for paying customer |
Paying Customer Paid Amount | If used in MXTS, for example when a reservation for a guest (Customer) is made via an agency (Paying Customer): Bill amount paid by paying customer |
Reservation Turnover | Total net turnover of all booked accommodations in this reservation, meaning the gross price of the booked accommodations minus specials and included reserved resources. Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.
|
