Most hotel segmentation reports are built to answer one question: What happened? They are descriptive by design — a table of room nights, ADR, and revenue broken out by demand type, Budget versus Actual versus Last Year, for the month and year-to-date.
That's useful. But it's not enough.
The DOSM who walks into the GM meeting armed only with "what happened" is always one question behind. The GM, the asset manager, and ownership aren't satisfied with the numbers — they want to know why the number moved, and what's going to happen next. That's a completely different skill, and it starts with reading segmentation not as a scorecard — but as a risk map.
Segmentation Is a Risk Map, Not a Scorecard
Two hotels can hit the identical revenue number and be completely different assets.
A hotel that makes budget on Discount and OTA-driven E-Commerce business is fragile: that demand is price-elastic, unowned, and disappears in a downturn.
A hotel that makes the same number on Corporate Negotiated and Association Group is durable: that demand is contracted, relationship-based, and books further out.
Ownership and asset managers read segmentation to judge rate integrity, brand-standard compliance, and downturn exposure. The GM reads it to know which lever to pull. The DOSM should read it first, before anyone asks — because it is the first question that gets asked when the number moves.
For a new DOSM specifically: segmentation is where you learn what hotel you actually took over. Pull twenty-four months of it in your first week. The mix tells you more about the property, the market, and your predecessor's strategy than any handover conversation will.
What the Standard Full-Service Segmentation Breakout Looks Like
The segmentation report covers room nights, ADR, and revenue broken out by demand type, shown Budget versus Actual versus Last Year, for the month and year-to-date, expressed as a percentage mix of total room nights. The standard full-service breakout:
- Transient: Rack, Corporate/Negotiated, Government, Discount, Transient FIT, E-Commerce
- Group: Corporate, Government, SMERF, Association, Tour/Travel/Motorcoach
- Other: Crew/Contract, Complimentary, Part-Day, House Use, Adjustments
Each of those buckets tells a different story about the health and sustainability of your revenue base. The Segmentation Risk Read is the framework that extracts that story quickly — and turns it into a decision.
The Standard Operating Procedure
Run this process monthly, immediately after the segmentation report is available and before any narrative is written:
- Pull the segmentation source report for the closed month — both monthly and year-to-date, Budget and Actual columns, current year and prior year.
- Confirm the report's segment definitions match your workbook's segment definitions. They frequently do not. Document the mapping once and reuse it — this is the single most common source of month-over-month inconsistency in a new DOSM's reporting.
- Calculate the actual room-night mix percentage by segment if the report does not.
- Identify the two segments driving the largest dollar variance to budget, in both directions.
- Run Prompt #1.
- Write the segmentation narrative comment (2–3 sentences) into the workbook.
- Carry the condensed finding forward to Prompt #10 (narrative) and Prompt #11 (critique).
Done means: you can name, without looking, the two segments that moved the number — and say in one sentence whether the mix got safer or riskier this month.
Prompt #1 — The Segmentation Risk Read
Purpose: Convert a table of segment numbers into a plain-language risk read and a one-paragraph mix-shift plan you can act on next month.
Who Runs It: DOSM (with RM data)
When to Run It: Monthly, immediately after the segmentation report is available and before any narrative is written.
Report Inputs: Segmentation source report — monthly and YTD, Budget and Actual, current year and prior year, both Transient and Group.
The Prompt (Paste-Ready)
You are a hotel revenue strategy analyst. I'm going to paste my Market Segmentation data below — room nights, ADR, and revenue by segment, shown as Budget vs. Actual vs. Last Year, for both Transient and Group. Analyze it and give me:
- A 3-sentence read on where this month's revenue really came from (plain language, no jargon)
- The two segments most responsible for any variance to budget — name them and the dollar impact
- A concentration-risk flag: is this month's number over-reliant on any single segment (especially Discount, E-Commerce, or one Group sub-segment)?
- A one-paragraph mix-shift plan for next month — which segment I should push and which I should protect
- One sentence I could say out loud in a GM meeting to summarize the mix story
Here is my segmentation data: [PASTE YOUR SEGMENTATION TAB DATA HERE]
My hotel context: [brand, comp set, peak season, current competitive index position vs. comp set]
Why This Works
Most hotel segmentation source reports — market-segment flash reports, market-code statistics reports, rate-plan production reports — are built to answer "what happened." They are descriptive by design. This prompt adds the next layer: evidence before assumption, so you walk into the GM meeting with the "why," not just the numbers.
The concentration-risk question in particular is the one an asset manager will ask — and a new DOSM rarely anticipates. When your number is over-indexed to a single price-elastic segment, you are one market disruption away from a revenue gap you cannot explain and cannot quickly fill.
What to Paste
The full segmentation table for the reporting month: every row from Rack through Tour/Travel/Motorcoach, Budget and Actual columns, and the actual room-night mix percentage column if you have it. Include year-to-date if you want the trend read as well as the month read.
Where the Output Goes
- The segmentation narrative field in your month-end workbook
- Agenda item 2 of the monthly critique (Prompt #11)
- The mix-shift plan becomes next month's prospecting emphasis in Section 4
Cautions
- Do not compare segments across systems without confirming the mapping. A "Corporate" bucket in one system may include negotiated transient; in another it may mean corporate group only. Establish the mapping once, in writing, and hand it to your successor.
- A hypothesis is not a finding. The prompt produces hypotheses from patterns in data. Confirm them before repeating them upward.
- Watch for accounts that are flat in room nights but down in revenue. That is a rate problem, not a volume problem — and it is often invisible if you sort only by room nights.
The Bottom Line
The value of the Segmentation Risk Read is not that it produces a better-looking report. It is that it removes the blank page — the place where the hour actually goes — and replaces guesswork with a structured analysis you can defend in any room.
A DOSM who can name the two segments that moved the number, explain the concentration risk, and hand leadership a one-paragraph plan for next month isn't just reporting. They're operating.
That's the difference between a scorecard and a strategy.
