Recipe 1 - The Segmentation Risk Read: Turn Raw Numbers Into a Story You Can Defend
Turn Raw Numbers Into a Story You Can Defend
From The Spiral Sales Office Recipe Vault | By Paul Woodley
Every month, a segmentation report lands in a DOSM's inbox. Most of the time, it gets glanced at, summarised loosely in a narrative field, and presented in the critique with language like the mix remained relatively stable or group outperformed transient this period.
That is not analysis. That is restating the table in slightly different words.
Recipe 1 takes your segmentation data and converts it into something genuinely useful: a risk read, an opportunity flag, and a one-paragraph mix-shift plan with a direction you can actually act on next month.
What This Recipe Makes
A plain-language segmentation analysis that tells you where the risk is, where the opportunity is, and which segment to push or protect next month, written in language you can say out loud in a GM meeting.
- Head Chef: DOSM, with Revenue Manager data
- When to Cook It: Monthly, immediately after the segmentation report is available and before any narrative is written
- Ingredients: Segmentation source report, monthly and year-to-date, Budget vs Actual vs Last Year, current year and prior year, both Transient and Group
The Five Outputs This Prompt Returns
When you paste your segmentation data and run this prompt, you get five specific, usable outputs.
- A Three-Sentence Risk Summary - A plain read on where the hotel is overexposed by segment or channel, written in language you can say out loud in your next GM conversation without reading from a screen
- The Segment Most at Risk - The single segment showing the most concerning trend, with the evidence behind that call and what is driving the movement
- The Hidden Opportunity - The segment or sub-segment showing demand or growth that is not yet being actively pursued, including what a realistic push would look like
- The Mix-Shift Plan - One paragraph identifying which segment to push next month and which to protect, based on the numbers, not instinct
- The GM Sentence - One sentence you can say out loud in a meeting to summarise the mix story cleanly and confidently
Why This Comes After Recipe 35
Before you run a segmentation analysis, the codes underneath the numbers need to be clean. Recipe 35, The Data Integrity Pre-Check, confirms that your rate and market codes are correctly mapped and that what the report shows is what actually happened. Running Recipe 1 on dirty data produces a confident-sounding analysis of a fiction.
The sequence is: clean the data with Recipe 35, then read it with Recipe 1.
The Difference Between Reporting and Reading
A segmentation report is a description of what happened. Recipe 1 produces a read on what it means, which is a different skill and a different conversation.
The read answers three questions the report does not:
- Where is this hotel genuinely exposed in the next thirty to sixty days?
- Where is there upside that is not being worked?
- What should the team be doing differently next month as a direct result of these numbers?
A DOSM who can answer those three questions in the monthly critique, backed by the data, builds credibility with the GM and with ownership faster than almost anything else they can do.
Where the Output Goes
The segmentation narrative field in your month-end workbook. Agenda item two of the monthly critique. The mix-shift plan becomes next month's prospecting emphasis and feeds the segment action plan in Recipe 20.
The Mirror
After you run this prompt, ask yourself whether the mix-shift direction it produces matches what you have been telling your team to prioritise this month. If the data says push corporate transient and your team has been working leisure accounts all quarter, that gap is worth a conversation.
A Note on Data Handling
Confirm what your employer, owner, brand, and management company permit before pasting property data into any AI platform. Rate data, account production, and revenue by segment may be commercially sensitive. When in doubt, aggregate, anonymise, or ask. Every output is a starting position. The judgment and the decisions still belong to you.
Your Next Step
Pull your segmentation report the moment it is available this month. Do not write the narrative first. Run Recipe 1, read the output, and then write the narrative from evidence rather than from the story you were already planning to tell.
The segmentation report is not just a table. It is the month telling you something. Recipe 1 is how you learn to hear it.
Paul Woodley | The Spiral Sales Office
