Revenue management
Hotel market segmentation: a practical room-night analysis
Build hotel market segmentation with separate purpose, channel and group records, a room-night example and a monthly checklist for Azerbaijan hotels.

The short answer
Hotel market segmentation groups stays using consistent definitions so managers can compare demand. Start with one purpose per stay: business, leisure, other or unknown. Record booking channel and group status separately. Calculate each purpose's share of sold room-nights for the same stay dates, then use the results to test a specific operational or sales decision.
Hotel market segmentation helps a small hotel understand which stays fill its rooms and when. A Baku property might investigate weak midweek demand; a regional hotel might examine weekend stays. These are questions to test with records.
SiteMinder’s segmentation guide presents segmentation as a structured view of customer data. Categories differ between providers, so check definitions before comparing results. The workflow below is a proposed internal method for a small team.
Keep purpose, channel and group status separate
A guest travelling for work can book through an online travel agency, or OTA. A leisure guest can book directly. Neither booking channel proves the purpose of the stay. Likewise, a group can consist of business travellers or holidaymakers. Combining “business”, “OTA” and “group” in one list makes overlapping totals likely.
Use three separate columns. For the purpose column, assign exactly one of these four values to each stay:
| Purpose | Working definition |
|---|---|
| Business | The guest confirms work as the main purpose. |
| Leisure | The guest confirms a holiday or recreation as the main purpose. |
| Other | A different main purpose is confirmed; no sensitive detail is needed. |
| Unknown | The purpose is missing, declined or unclear. |
For mixed trips, ask for the main purpose once. If it remains unclear, use unknown. Keep the channel, such as direct, OTA or agency, in its own column. Add a separate group flag with yes, no or unknown, using your hotel’s documented group definition. The group reservation guide explains the operational records behind a coordinated booking.
Collect a small, consistent dataset
A controlled worksheet can contain booking reference, occupied room reference, stay night, purpose, channel and group flag. Add room revenue only if you intend to analyse it. Limit access, identify the owner and maintain one current version. A booking reference is usually enough for analysis; copying names, passport details or contact information creates unnecessary duplication.
Ask an optional, neutral question about the main purpose. Do not infer it from names, language, nationality, appearance or sensitive personal traits. Keep unknown visible; do not redistribute it across other categories.
Record purpose for this stay. A returning business traveller may next visit on holiday. See the guest database guide.
Calculate shares using matching stay dates
Consider a hypothetical month with 400 sold room-nights. One room occupied for three nights contributes three room-nights, regardless of whether one or two people stay in it. Ten rooms occupied for two nights contribute twenty. Count only nights inside the selected month, including the relevant portion of stays crossing the month boundary.
| Main purpose | Sold room-nights / Share |
|---|---|
| Business | 160 / 40% |
| Leisure | 180 / 45% |
| Other | 20 / 5% |
| Unknown | 40 / 10% |
| Total | 400 / 100% |
The formula is segment room-nights ÷ total sold room-nights × 100. Here, leisure contributes 180 ÷ 400 × 100 = 45%. This is a share of sold room-nights, not hotel occupancy or a share of individual guests. Exclude cancelled bookings and no-shows from stayed room-nights. Use a separate report for future reservations.
If group-flagged stays account for 80 room-nights, the group share is 20%. Those nights already belong to the purpose categories. Do not add another 20% to the table. Channel comparisons likewise describe the same inventory.
Turn the comparison into one decision
Review comparable periods before changing an offer. Match weekdays and account for holidays. A large booking can distort monthly percentages. Investigate whether changes reflect demand, missing labels or one exceptional stay.
For example, a persistent leisure gap on Sunday nights could justify testing a clearly priced Sunday extension. Track the resulting sold nights and revenue against comparable dates. Do not promise that segmentation itself will raise occupancy. If comparing ADR, divide each segment’s room revenue by its sold room-nights, using matching dates and the same revenue basis. Consult the ADR and occupancy guide.
Monthly checklist
- Keep the four purpose definitions unchanged and record any revision date.
- Reconcile total room-nights to the hotel’s stay records.
- Check duplicates, month boundaries and the unknown share.
- Review channel and group status as separate dimensions.
- Choose one action, an owner and a review date.
Frequently asked questions
Is OTA a guest purpose? No. It identifies the booking channel; the purpose may be business, leisure, other or unknown.
Should unknown stays be excluded? Keep them in the denominator and show their share. Exclusion can make the known categories appear larger than they are.
Does BirOtel automatically create guest segments? A dedicated segmentation dashboard, custom segment fields and automated profiling are not confirmed. Use a controlled worksheet when needed and verify the workflow in a demonstration.
BirOtel supports reservations with source and guest records, occupancy and income reporting, ADR and Excel report export. Request a reporting demonstration with your sample month to check which available exports can support this analysis.
These guides are published by BirOtel. General methods, illustrative examples and current product capabilities are identified separately. Sources appear beside the relevant explanations.
[email protected]Explore these workflows for your own hotel
Use your room inventory and daily tasks to assess whether BirOtel fits your hotel in a live demo.

