Insights & Anomalies
bookings analyzed Data Anomalies
Ghost Rows (Summary Totals Leaked)
2 rows without status contain
84769774 PVP and
35749849 Benefit.
These are summary/total rows that should be excluded from aggregations.
Benefit on Cancelled Bookings = 32795119
cancelled bookings show positive benefit (PVP - SupplierNet).
In cancellations, benefit should be 0 or reflect cancellation costs. This inflates total benefit by
46%.
85 Bookings with Supplier Net = 0 but PVP > 0
100% margin bookings totaling 103401 PVP.
Mostly from
Receptivo Vecisa via BCO New Generation. Possible pricing error or special agreement.
OK Bookings with Negative Benefit
Total losses: -281282.
Top offenders: GBN TRAVEL in Dominican Republic (Dreams Dominicus, Iberostar) and Iran market via BCO/Expedia.
Lead Time vs Cancellation Rate
Cancel Rate by Booking Lead Time
Key Insight
7x More Cancellations for Far-Out Bookings
Same-day bookings: 6.5% cancel rate
31-60 days out: 41.6% cancel rate
The further the checkin date, the more likely the cancellation. Consider stricter policies for bookings >30 days out.
31-60 days out: 41.6% cancel rate
The further the checkin date, the more likely the cancellation. Consider stricter policies for bookings >30 days out.
Weekday vs Weekend
Weekday bookings: 28.2% cancel
Weekend bookings: 23.4% cancel
Weekend bookers are more committed.
Weekend bookings: 23.4% cancel
Weekend bookers are more committed.
Market Risk Heatmap
Cancel Rate & Margin by Market (min 100 bookings)
| Market | Bookings | Cancel Rate | Margin % | Losses | Loss Rate | Risk |
|---|---|---|---|---|---|---|
| ES | 24,0% | 6,03% | 313 | 1,2% | ||
| GB | 25,1% | 5,59% | 332 | 1,4% | ||
| US | 31,3% | 5,73% | 148 | 0,9% | MED CANCEL | |
| IT | 20,8% | 5,85% | 55 | 0,9% | ||
| DE | 18,9% | 6,29% | 41 | 0,7% | ||
| PT | 15,3% | 4,00% | 60 | 1,0% | ||
| AE | 35,9% | 5,78% | 52 | 1,2% | MED CANCEL | |
| IN | 51,1% | 4,18% | 61 | 1,9% | HIGH CANCEL | |
| FR | 19,5% | 7,39% | 13 | 0,4% | ||
| CN | 31,8% | 2,63% | 48 | 2,0% | MED CANCEL | |
| MX | 33,0% | 5,39% | 41 | 2,2% | MED CANCEL HIGH LOSS | |
| BR | 38,9% | 5,82% | 18 | 1,3% | MED CANCEL | |
| TH | 40,9% | 5,56% | 21 | 1,9% | HIGH CANCEL | |
| RU | 22,0% | 3,51% | 26 | 1,9% | ||
| ID | 12,7% | 3,18% | 13 | 0,9% | ||
| SA | 11,6% | 5,64% | 6 | 0,8% | ||
| AR | 44,8% | 3,81% | 5 | 1,2% | HIGH CANCEL | |
| IL | 35,6% | 6,26% | 13 | 2,7% | MED CANCEL HIGH LOSS | |
| TR | 34,2% | 6,40% | 9 | 1,9% | MED CANCEL | |
| TN | 21,4% | 5,11% | 1 | 0,2% | ||
| IE | 16,9% | 5,09% | 2 | 0,5% | ||
| CA | 34,9% | 5,73% | 1 | 0,4% | MED CANCEL | |
| NL | 17,6% | 5,47% | 7 | 2,5% | HIGH LOSS | |
| AU | 28,6% | 6,16% | 1 | 0,4% | ||
| CO | 36,3% | 4,95% | 0 | 0,0% | MED CANCEL | |
| IR | 11,1% | -2,32% | 12 | 4,3% | NEG MARGIN HIGH LOSS | |
| GR | 35,5% | 6,04% | 0 | 0,0% | MED CANCEL | |
| PL | 29,2% | 5,77% | 0 | 0,0% | ||
| EG | 38,8% | 6,16% | 7 | 4,8% | MED CANCEL HIGH LOSS | |
| RO | 28,7% | 6,18% | 1 | 0,6% | ||
| SE | 17,3% | 6,34% | 4 | 2,5% | HIGH LOSS | |
| KZ | 38,1% | 5,48% | 1 | 0,9% | MED CANCEL | |
| IQ | 25,3% | 5,39% | 1 | 0,8% | ||
| MA | 44,6% | 6,21% | 0 | 0,0% | HIGH CANCEL | |
| KW | 24,7% | 6,50% | 3 | 2,7% | HIGH LOSS | |
| KR | 37,3% | 4,09% | 6 | 6,7% | MED CANCEL HIGH LOSS | |
| JP | 33,1% | 4,11% | 4 | 4,5% | MED CANCEL HIGH LOSS | |
| DK | 15,4% | 6,65% | 0 | 0,0% | ||
| MY | 21,7% | 4,40% | 0 | 0,0% | ||
| JO | 33,6% | 4,46% | 2 | 2,4% | MED CANCEL HIGH LOSS | |
| DZ | 26,5% | 5,04% | 0 | 0,0% | ||
| BE | 21,1% | 4,50% | 3 | 3,3% | HIGH LOSS | |
| OM | 35,1% | 4,01% | 2 | 2,7% | MED CANCEL HIGH LOSS | |
| AZ | 54,5% | 2,62% | 1 | 2,0% | HIGH CANCEL | |
| PH | 60,6% | 5,28% | 0 | 0,0% | HIGH CANCEL |
Problem Clients (Cancel Rate > 30%)
Clients with Highest Cancel Rates (min 20 bookings)
| Client | Bookings | Cancels | Cancel % | PVP Lost |
|---|---|---|---|---|
Hotelbeds |
32,0% | 5016297 | ||
Agoda |
17,2% | 1581778 | ||
Webbeds Group |
32,7% | 1072992 | ||
Ostrovok |
43,1% | 1509866 | ||
Go Global Group |
44,8% | 1651614 | ||
trip.com |
40,6% | 515949 | ||
Rezlive |
53,4% | 713459 | ||
TBO Group |
39,4% | 1011759 | ||
World2Meet |
27,9% | 666380 | ||
We Love Holidays |
8,3% | 623458 | ||
Veturis |
39,3% | 706119 | ||
Stayforlong |
19,9% | 474224 | ||
Ottila |
47,7% | 792253 | ||
Grupo Avoris |
31,1% | 535549 | ||
Restel |
27,2% | 323736 | ||
lastminute.com Group |
12,4% | 387926 | ||
AMADEUS |
14,5% | 187058 | ||
Akbar Group |
40,5% | 639363 | ||
MakeMyTrip |
52,7% | 381476 | ||
Juan Toselli |
68,2% | 783192 | ||
Bookingagora |
50,2% | 514427 | ||
CIT |
24,8% | 220895 | ||
Zumata |
31,1% | 238862 | ||
Holisto (Splitty-Traveluro) |
33,8% | 180534 | ||
Nuitee |
35,4% | 122765 |
PVP Lost by Top Cancelling Clients
Supplier Performance
Highest Cancel Rate Suppliers (min 50 bookings)
| Supplier | Total | Cancel % | Margin % |
|---|---|---|---|
| BCO New Generation | 27,9% | 6,65% | |
| SiteMinder | 22,8% | 6,61% | |
| Expedia Downstream Package | 27,4% | 4,82% | |
| Expedia Rapid Retail | 29,6% | 4,77% | |
| DERBYSOFT-HILTON | 25,2% | 6,00% | |
| MTS ES - Dubai | 19,3% | 5,17% | |
| Agoda | 28,7% | 5,38% | |
| MTS UK - Dubai | 27,9% | 4,42% | |
| PEAK POINT TRAVEL | 33,2% | 4,26% | |
| Hotelbeds DMCC Retail | 30,1% | 4,56% | |
| Accor Hotels Gekko | 22,0% | 3,18% | |
| Omnibees | 30,0% | 6,23% | |
| Rate Tiger | 15,9% | 4,87% | |
| Expedia Downstream Hotel | 31,4% | 6,05% | |
| HOT2B2B (Restel-Hotusa) | 36,5% | 3,97% | |
| World 2 Meet | 31,9% | 4,83% | |
| Expedia Rapid Package | 33,3% | 4,58% | |
| Sunhotels B2B | 33,1% | 5,11% | |
| Marriott Hotels & Resorts | 39,7% | 7,11% | |
| Dingus Push | 25,9% | 6,29% | |
| ItalCamel | 21,2% | 6,24% | |
| Hotelbeds Global Market DMCC | 21,8% | 4,63% | |
| Hotelbeds Retail Travel Agencies | 27,0% | 4,45% | |
| Destinations of the world v3 | 29,6% | 7,57% | |
| Vertical Booking | 21,5% | 6,54% |
Negative Margin Suppliers (Losses)
| Supplier | Market | Bookings | Margin | Total Benefit |
|---|---|---|---|---|
| Expedia | PT | 8 | -132,57% | -11926 |
| BCO New Generation | PY | 15 | -32,03% | -5543 |
| EXPEDIA RAPID HOTEL ONLY | IT | 8 | -55,22% | -3006 |
| Expedia | IN | 6 | -156,74% | -2999 |
| BCO New Generation | IR | 67 | -6,16% | -2794 |
| Veturis | IN | 7 | -54,34% | -2777 |
| Nirvana | SA | 19 | -42,86% | -2696 |
| Expedia | RU | 7 | -75,39% | -2570 |
| Illusions | CN | 7 | -53,38% | -2233 |
| Expedia | AE | 20 | -25,61% | -1712 |
| Expedia | GB | 52 | -5,77% | -1595 |
| Expedia Rapid Retail | CN | 7 | -56,80% | -1579 |
| TBO Holidays | US | 9 | -24,34% | -1510 |
| NordBeds Spain | RU | 5 | -26,88% | -1507 |
| World 2 Meet | IN | 13 | -27,39% | -1457 |
| World 2 Meet | AE | 46 | -4,98% | -1321 |
| Travel Destinations Solutions B2B | GB | 37 | -4,37% | -1319 |
| Tourmind B2C | CN | 23 | -27,79% | -1161 |
| Siteminder Pull | CN | 113 | -8,54% | -1093 |
| MIKI B2B | ES | 45 | -5,69% | -1040 |
Problem Hotels
Hotels with Extreme Cancel Rates (min 20 bookings)
| Hotel | Country | Bookings | Cancel % | Margin % | Losses | Flags |
|---|---|---|---|---|---|---|
| Gevora Hotel | Emiratos Arabes | 633 | 35,5% | 5,93% | 0 | |
| Hotel Sansi Barcelona | España | 500 | 42,4% | 5,81% | 0 | |
| Alambique Hotel Resort & Spa | Portugal | 892 | 21,2% | 5,53% | 0 | |
| Grand Excelsior Hotel Al Barsha | Emiratos Arabes | 485 | 32,6% | 5,70% | 0 | |
| The Tower Plaza Hotel Dubai | Emiratos Arabes | 346 | 39,6% | 5,85% | 4 | LOSSES |
| Yotel New York Times Square | EE.UU. | 318 | 34,9% | 5,62% | 0 | |
| The Chicago Hotel Collection Magnificent Mil… | EE.UU. | 215 | 51,2% | 10,15% | 0 | |
| Royal Ascot Hotel | Emiratos Arabes | 200 | 50,0% | 5,01% | 3 | |
| Hotel Ilunion Barcelona | España | 168 | 51,8% | 3,87% | 7 | LOSSES |
| Pearl Swiss Hotel | Emiratos Arabes | 171 | 50,3% | 5,21% | 0 | |
| Sunny Days El Palacio Resort & Spa - Familie… | Egipto | 235 | 36,2% | 8,33% | 0 | |
| Trevi Collection Hotel | Italia | 271 | 29,5% | -3,74% | 6 | NEG MARGIN LOSSES |
| Domocenter Apartamentos Turísticos | España | 455 | 17,1% | 6,76% | 0 | |
| Flamingo Las Vegas - Hotel & Casino | EE.UU. | 234 | 32,5% | 12,66% | 0 | |
| Royal National Hotel | Reino Unido | 283 | 26,1% | 3,31% | 3 | |
| Hotel Derby Sevilla | España | 108 | 67,6% | 9,70% | 0 | CRITICAL |
| Citymax Hotel Bur Dubai | Emiratos Arabes | 117 | 60,7% | 4,42% | 1 | CRITICAL |
| Clinton Hotel South Beach | EE.UU. | 76 | 89,5% | 4,58% | 0 | CRITICAL |
| Rewaya Inn Resort | Egipto | 231 | 29,4% | 4,59% | 3 | |
| Fortune Grand Deira | Emiratos Arabes | 73 | 89,0% | 6,78% | 0 | CRITICAL |
| Park Inn By Radisson Berlin Alexanderplatz | Alemania | 438 | 14,8% | 5,19% | 0 | |
| Riu Plaza London The Westminster | Reino Unido | 174 | 37,4% | 5,67% | 0 | |
| Sunny Days Palma De Mirette Resort & Spa | Egipto | 135 | 48,1% | 5,74% | 0 | |
| The Orleans Hotel & Casino | EE.UU. | 136 | 44,9% | 6,46% | 0 | |
| Hotel Cram Barcelona | España | 185 | 32,4% | 5,88% | 0 | |
| Park Hotel Barcelona | España | 214 | 28,0% | 5,92% | 0 | |
| Steigenberger Nile Palace Luxor | Egipto | 140 | 42,9% | 5,96% | 0 | |
| Novotel Mexico City World Trade Center | México | 61 | 93,4% | 2,35% | 0 | CRITICAL |
| Westgate Las Vegas Resort & Casino | EE.UU. | 297 | 18,9% | 8,22% | 0 | |
| Palazzo Viridis | Italia | 181 | 30,4% | 6,64% | 0 |
Platform Errors (Confirmations)
Error Code Distribution
Platforms with Worst %KO (Latest Week)
| Platform | Week | %OK | %KO | Severity |
|---|---|---|---|---|
ELEVECI |
16 Mar | 14,3% | 85,7% | CRITICAL |
GVELASMX |
23 Mar | 25,0% | 75,0% | CRITICAL |
DSTL |
16 Mar | 33,3% | 66,7% | CRITICAL |
DTHMY |
16 Mar | 33,3% | 66,7% | CRITICAL |
GTRM2 |
09 Mar | 33,3% | 66,7% | CRITICAL |
AVHTRAV |
23 Mar | 37,5% | 62,5% | CRITICAL |
ELEVECI |
23 Mar | 40,0% | 60,0% | CRITICAL |
ALLBRTA |
09 Mar | 50,0% | 50,0% | HIGH |
BONS |
23 Mar | 50,0% | 50,0% | HIGH |
GTRM2RTA |
16 Mar | 50,0% | 50,0% | HIGH |
CNN2 |
16 Mar | 52,2% | 47,8% | HIGH |
BDSCTWR |
16 Mar | 62,5% | 37,5% | HIGH |
BDSCTWR |
09 Mar | 64,7% | 35,3% | HIGH |
AIC |
23 Mar | 66,7% | 33,3% | HIGH |
ASATUK |
23 Mar | 66,7% | 33,3% | HIGH |
GTRM2RTA |
09 Mar | 66,7% | 33,3% | HIGH |
ALLBRTA |
16 Mar | 69,2% | 30,8% | HIGH |
ESC2 |
23 Mar | 69,2% | 30,8% | HIGH |
BONS |
16 Mar | 70,0% | 30,0% | HIGH |
AVRTVECI |
09 Mar | 72,2% | 27,8% | HIGH |
Country Risk Analysis
Cancel Rate vs Margin by Country (bubble = volume)
Highest Risk Countries
| Country | Cancel% | Margin% |
|---|---|---|
| Maldivas | 63,0% | 5,13% |
| Noruega | 53,8% | 3,09% |
| Japón | 50,6% | 5,90% |
| Nueva Zelanda | 48,5% | 3,96% |
| Rusia | 45,7% | 4,55% |
| Jamaica | 45,6% | 5,59% |
| Sudáfrica | 44,2% | 3,79% |
| Corea del Sur | 43,9% | 4,27% |
| Sri Lanka | 43,6% | 4,57% |
| Seychelles | 43,0% | 6,12% |
| Grecia | 42,9% | 4,93% |
| Australia | 42,3% | 5,00% |
| Suiza | 40,8% | 4,90% |
| República Dominicana | 39,4% | 2,84% |
| Filipinas | 39,1% | 5,03% |
| Curaçao | 38,2% | 12,16% |
| Finlandia | 38,1% | 6,90% |
| Argentina | 37,5% | 6,24% |
| Mauricio | 37,3% | 6,06% |
| Canadá | 36,3% | 4,73% |