- Before
- “Show me the story, not 2,000 flags — and show me why it isn't innocent.” Opened queue entries one booking at a time and searched for the rest by hand.
- Now
- Starts at 8:30 am with what the overnight run found, sees each pattern as one chain with every line cited, and approves, edits or rejects each action with a reason.
Airline revenue integrity, one churn story from overnight flag to signed decision
Corvane Airways runs about 300 aircraft from its Chicago O'Hare hub. On Thursday, October 15, its revenue integrity analyst opens the day the agents prepared overnight. Here is what happens next, screen by screen, in the working solution.
- 018:40 am CT
What needs her, in the agents' order
Dana Whitfield · Revenue Integrity AnalystDana's Today screen shows 12 of the team's 41 stories that need a person, $60,070 at stake in hers. Overnight the agents found 318 stories in 1,862,400 bookings; 1,146 seats went back on sale this week, and 32 stories were cleared by the second look. The top one is a churn on CV 220 ORD–SEA; the second, nine bookings on CV 640 past the TSA Secure Flight 72-hour mark at 6:15 am.
“Distribution feed 3 arrived 41 minutes late; its bookings were read at 3:05 am.”
- 022:00 – 3:12 am
Seven agents, each checking the last
The agentsThe booking reader read every active booking departing in the next 330 days, with its history, from reservations and three distribution feeds. The churn and duplicate finder checked 14,280 chains, the name checker set aside 47 loyalty members as real people, and the segment sweeper cleaned up 236 inactive segments and expired web holds under standing rules R5 and R6. The case builder grouped 2,412 flags into 318 stories; the agency liaison drafted 19 memos and 11 warnings and sent none.
“Anything that touches an agency waits for a person.”
- 03One click
Ten bookings, one name: the churn drawn as a chain
Churn and duplicate finderLakeshore Travel Group, office 7KQ2, booked SMITH/J MR and 13 unnamed seats on CV 220, Fri Nov 6, ten times between Sep 22 and Oct 14. Each booking was canceled just before its 72-hour ticketing limit and rebooked 3 to 9 minutes later. Dana clicks link 3: B2NV6L, canceled Sep 30 at 3:20 pm and rebooked as T8JD4Q 4 minutes later. Fourteen seats in class L have been held for 23 days, never ticketed; class L closed to new sale on Oct 1, and the same seats sell today at $312.
Every sentence of the reading cites the booking line it rests on — 14 seats, 23 days, $592.90 in GDS fees paid, $4,368 at today's fare.
- 04Before she sees it
The innocent explanations, ruled out first
Second-look checkerDid Corvane change the flight? No time, routing or cancellation change for Nov 6 since Aug 4. Is it a group with a contract? None for CV 220. Are these real, named travelers? Thirteen of the 14 seats have never had a name. Could the DOT 24-hour rule explain the cancels? No: they came 2 to 3 days after booking, and no seat was ever ticketed.
The second-look checker clears a story only with a reason, and cannot change a rule.
- 05In conversation
She asks “Why $1,350?” and gets the policy
Dana Whitfield and the agency liaisonThe case builder proposes three actions: cancel the 14 held seats and return them to sale, a $1,350 debit memo to Lakeshore, and a second warning copied to its sales manager. Dana asks why $1,350. The agency liaison answers that policy §4.2 sets $150 for each cancel-and-rebook cycle, there were nine, and Corvane's GDS cost for the same bookings was $592.90 — it can switch the memo to that amount if she prefers.
“I propose three actions. Anything that touches the agency waits for you.”
- 068:51 am
Approved: 14 seats back on sale
Dana Whitfield · Revenue Integrity AnalystDana approves the first proposal with her e-signature. P9XH3D is canceled and the 14 seats are back on sale in class M at $312. Revenue management has the update, and Lakeshore gets a notice with the ten booking lines. The decision is on the audit trail with her name and the time.
Agency liaison: “Done at 8:51 am. P9XH3D is canceled and 14 seats are back on sale in class M at $312.”
- 07The flight
CV 220 shows the seats come back
Case builderOn the A321neo's flight view, economy booked drops from 150 to 136, held without a ticket from 14 to 0, and open to sell rises from 26 to 40, with class M open at $312. Revenue management still forecasts 22 more economy bookings before departure, so the seats are likely to sell — 22 days out, not two.
- 08To Sales Audit
A $1,350 memo with an evidence pack built for a dispute
Elena Ruiz · Sales Audit SpecialistOver $1,000, so the memo goes to review. ADM-26-10-0418 reaches Elena Ruiz with reason code BK-CHURN and a seven-item evidence pack: the ten linked bookings, the first and last booking histories, policy §4.2 and §4.1–§4.7, the distribution billing and the agency file. She issues it through ARC or BSP settlement with her own signature, returns it to the analyst, or changes the amount.
“In the last six months, 26 of 31 disputed churn memos were upheld.”
- 09The agency
The second warning, seen first by the sales manager
Agency liaisonLakeshore Travel Group has 23 stories in 90 days and a churn warning from Mar 12, 2026. The agency liaison drafted the second warning to its branch manager, citing the ten bookings, policy §4.2 and the March warning. Nothing goes until Dana approves it, and Owen Price, Corvane's agency sales manager for Lakeshore, sees it for 4 hours before it is sent.
- 10Later that day
A rule that learns from what people cleared
Marcus Bell · Revenue Integrity ManagerIn September analysts cleared 18 churn stories that were school and tour groups re-sending their name lists. The second-look checker proposes an exception to R1 Churn for bookings under a group contract still before its name-list date. Replayed on the last 90 days: 3,412 stories become 3,394, none of the 18 reach a person, and no story that led to a memo is missed. Only Marcus can approve it.
“Rule changes need the Revenue Integrity Manager.”