FAQ - FREQUENTLY ASKED QUESTIONS
HUB ROUTINGS REPORT
2) HOW IS THE DATA CALCULATED?
3) HOW DO YOU READ THE REPORT?
4) ARE INTL ROUTINGS INCLUDED? WHY NOT?
5) HOW ARE THE RATINGS CALCULATED?
6) WHY ONLY CERTAIN AIRLINES, NO LCCS?
7) THE HUB AIRLINES DOESN'T FLY THAT ROUTING?
9) WHAT IS THE PURPOSE OF THIS REPORT?
1) I CAN'T SEE THE DATA?
The ROUTE SPROUTS REPORT is available to INTL TIER and above.
2) HOW IS THE DATA CALCULATED?
The data comes from DOT DB1B O&D data and is only available for domestic as a result of citizenship restrictions on that data. There are no other sources available to add international at this time. The data shown is actual flown based on airline reporting, not projected.
3) HOW DO YOU READ THE REPORT?
The columns are: AIRPORT#1 and AIRPORT #2 are interchangeable. They are the airports on either side of a routing connecting through the hub. If a passenger flew Washington DCA to Dallas DFW to Albuquerque (ABQ). AIRPORT #1 would be ABQ because it is alphabetically before DCA. DCA would be AIRPORT #2. Only routings connecting via the specified hub on the airline featured would be included. CONNECT HUB is the airport where passengers are connecting. Local passengers only traveling to and from the hub are not included in this report. HUB AIRLINE is the airline operating a hub at the CONNECT HUB and is specified. If more than one airline hub at the airport only the HUB AIRLINE is included. Passengers changing airlines follow normal DOT rules where the operator of the longest leg is considered the airline of record. PAX PDEW is daily passengers in each direction. 5 PDEW means 5 passengers traveling DFW-ABQ each day and also 5 traveling ABQ-DFW each day. Thes directions are averaged together. TRIP DIST is the distance of the routing via the hub. DIST CIRC is the % out of the way going via the hub is. 17% would mean the routing via the hub is 17% longer in distance than flying non-stop. Obviously there is the additional issue of the connect time which makes a connection additionally unattractive, but this ratio only covers the increased distance. TRIP FARE is the tax free one way fare. REVENUE QUALITY is a rating based on the stage adjusted fare for the routing where fares 30+% below the stage adjusted average are rated POOR, 15-30% below average are rated WEAK, 15% below average to 15% above average are rated FAIR, 15-30% above average are rated GOOD, and more than 30% above average are rated GREAT.
4) ARE INTL ROUTINGS INCLUDED? WHY NOT?
The data comes from DOT DB1B O&D data and is only available for domestic as a result of citizenship restrictions on that data. There are no other sources available to add international at this time.
6) WHY ONLY CERTAIN AIRLINES, NO LCCS?
LCCs generally don't have hubs, but if the data is reported and the carrier has a hub it can be presented.
7) THE HUB AIRLINES DOESN'T FLY THAT ROUTING?
If more than one airline hub at the airport only the HUB AIRLINE is included. Passengers changing airlines follow normal DOT rules where the operator of the longest leg is considered the airline of record. There may also be code shares that are reported as the operating airline.
8) I DON'T BELIEVE THE DATA?
The data is reported by the airlines to DOT and does sometimes have errors.
9) WHAT IS THE PURPOSE OF THIS REPORT?
This is a tool to answer two questions. 1) What routes might work that presently generate a lot of connect traffic. 2) How incremental is a route for an airline. Incremental refers to how many passengers would be gained by an airline adding a route. A new route might carry 100 passengers, but if 70 already flew on a connecting routing in the same airline, then the airline only gained 30 by adding a non-stop. This reports help you see where that risk exists for airlines.
10) WHAT IS REVENUE AND TRAFFIC SORT?
TRAFFIC SORT is simply the connecting routings with the most traffic first. REVENUE SORT is distance adjusted fare multiplied by traffic as a sorting mechanism. This is to prevent simply the longest routes from appearing first. Essentially it is Revenue Quality multiplied by traffic.
11) WHAT ROUTES ARE ON THE MAP?
The GREAT and GOOD categories are shown on the map without the stop at the hub for clarity.