Creating PDF

Interactive Airline Intelligence

Proven, route-level Airline Analytics

⬇ Export to Excel

Formatted QSI Sample Data

One (1) CouponTwo(2+) CouponsCode ShareFrequency Counts Day of Week(1 Cpn 2+ Cpns)Total Frequency By Coupon
YYYYMMCountry PairAirport PairdopralmmktalblnkJetWJetReg JetTurboON(G)ON(P)ON(Dbl)InterCnx1Cpn2+Cpnsblnk.1MonTueWedThrFriSatSun1 Cpn2+CpnsOD Total
202306NZ-AUAKLSYDD7 27000000000 3\03\04\05\05\03\04\027027
202306NZ-AUAKLSYDD7 27000000000 3\03\04\05\05\03\04\027027
202306NZ-AUAKLSYDJQQF 3200055000300 4\126\104\125\155\154\94\123285117
202306NZ-AUAKLSYDJQQF 3200055000300 4\126\104\125\155\154\94\123285117
202306NZ-AUAKLSYDLAMH/QF 300000000600 4\84\84\85\105\104\84\8306090
202306NZ-AUAKLSYDLAMH/QF 300000000600 4\84\84\85\105\104\84\8306090
202306NZ-AUAKLSYDNZAS/NH/OZ 57570063000900 15\1915\1816\2418\2718\2814\2118\16114153267
202306NZ-AUAKLSYDNZAS/NH/OZ 57570063000900 15\1915\1816\2418\2718\2814\2118\16114153267
202306NZ-AUAKLSYDQFAA/CZ/MU/TN 151000530003550 20\5622\5618\5225\7028\7016\4822\56151408559
202306NZ-AUAKLSYDQFAA/CZ/MU/TN 151000530003550 20\5622\5618\5225\7028\7016\4822\56151408559
202306US-USDCAMSPAA 030300108370000 8\248\168\2010\2810\278\98\2160145205
202306US-USDCAMSPAC 000030300000 0\80\80\80\100\100\80\806060
202306US-USDCAMSPDL 60900016700000 20\2820\2820\2825\2825\2820\620\21150167317
202306US-USDCAMSPUA 000014800000 0\250\250\250\240\240\70\180148148
202306US-USDCAMSPWN 240015900000 0\310\320\321\321\320\04\06159165
202306US-GBJFKLHRAAAY/B6/BA/IB/QR/UL 12000000006900 16\9216\9216\9220\11520\11516\9216\92120690810
202306US-GBJFKLHRB6 06000000000 8\08\08\010\010\08\08\060060
202306US-GBJFKLHRBAAA/AY/IB 23700000007110 32\9632\9632\9639\11740\12031\9331\93237711948
202306US-GBJFKLHRDLAF/KL/VS 6000000001500 8\208\208\2010\2510\258\208\2060150210
202306US-GBJFKLHRVSAF/DL/KL 17100000005130 23\6922\6623\6928\8429\8723\6923\69171513684
202306GB-USLHRJFKAAAY/B6/BA/IB/QR/UL 12000000006300 16\8416\8416\8420\10520\10516\8416\84120630750
202306GB-USLHRJFKB6 06000000000 8\08\08\010\010\08\08\060060
202306GB-USLHRJFKBAAA/AY/IB 23700000007110 32\9632\9632\9639\11740\12031\9331\93237711948
202306GB-USLHRJFKDLAF/KL/VS 6000000001800 8\248\248\2410\3010\308\248\2460180240
202306GB-USLHRJFKVSAF/DL/KL 17300000005190 23\6924\7222\6629\8729\8723\6923\69173519692
202306US-USMSPDCAAA 03030022800000 8\338\328\3210\4110\418\208\2960228288
202306US-USMSPDCAAC 00003000000 0\40\40\40\50\50\40\403030
202306US-USMSPDCAB6 00001400000 0\20\20\20\20\20\20\201414
202306US-USMSPDCADL 60900011800000 20\2420\1220\1325\2425\2520\420\16150118268
202306US-USMSPDCAUA 000014100000 0\220\220\220\230\260\130\130141141
202306US-USMSPDCAWN 300012000000 0\240\240\240\240\243\00\03120123
202306AU-NZSYDAKLD7 27000000000 3\03\04\05\05\03\04\027027
202306AU-NZSYDAKLJQQF 3100029000280 8\126\74\85\100\58\110\4315788
202306AU-NZSYDAKLLAMH/QF 300000000600 4\84\84\85\105\104\84\8306090
202306AU-NZSYDAKLNZNH 3480000000300 15\415\416\418\518\514\418\411430144
202306AU-NZSYDAKLQFAA/CZ/MU/TN 15200000005000 20\6820\6821\6525\8528\8816\5622\70152500652

QSI Fair Market Share

Explain these tables here. This section shows normalized market share values per service type and day of week.

One(1) CouponTwo(2+) CouponsCode ShareQSI "Fair" Market Share by DOW and True O&DQSI "Fair" MarketShare by DOW and True O&DTotal Frequency By Coupon
YYYYMMCountry PairAirport PairdopralmmktalblnkJetWJetRegJetTurboOnScnx(G)OnScnx(P)ON(Dbl)InterCnx1Cpn2+CpnsMonTueWedThrFriSatSunMonTueWedThrFriSatSunScoreShare
202306NZ-AUAKLSYDD7 0.07120000000000.111111114018270.111111114018270.148194968895740.185138360076860.185138360076860.111111114018270.148194968895740.122143837530330.11473069930.164062108505860.16078347200030.153652832364140.136019889394280.1486071609050856.20050.0712
202306NZ-AUAKLSYDD7 0.07120000000000.111111114018270.111111114018270.148194968895740.185138360076860.185138360076860.111111114018270.148194968895740.122143837530330.11473069930.164062108505860.16078347200030.153652832364140.136019889394280.1486071609050856.20050.0712
202306NZ-AUAKLSYDJQQF 0.058740000.00324000000.127519382489330.17338500994440.127519382489330.159431523587060.159431523587060.125193795413480.127519382489330.138470050361570.176895025004340.139493462721370.136705798627730.130642987928580.151439752379670.1263529229767461.09650.0774
202306NZ-AUAKLSYDJQQF 0.058740000.00324000000.127519382489330.17338500994440.127519382489330.159431523587060.159431523587060.125193795413480.127519382489330.138470050361570.176895025004340.139493462721370.136705798627730.130642987928580.151439752379670.1263529229767461.09650.0774
202306NZ-AUAKLSYDLAMH/QF 0.055070000000000.133310047919790.133310047919790.133310047919790.166724880200520.166724880200520.133310047919790.133310047919790.144853432318510.136062013553390.145924028953690.143007853668090.136665559555370.161309403241290.1321777087096667.8120.08591
202306NZ-AUAKLSYDLAMH/QF 0.055070000000000.133310047919790.133310047919790.133310047919790.166724880200520.166724880200520.133310047919790.133310047919790.144853432318510.136062013553390.145924028953690.143007853668090.136665559555370.161309403241290.1321777087096667.8120.08591
202306NZ-AUAKLSYDNZAS/NH/OZ 0.128670000.00371000000.131122220014420.132298872607920.138954260760410.159545516771440.162560678768830.124797760267130.150720690809860.142433449066190.134989002899720.152057424637290.136879549334230.133270494243740.15097365672490.14939642309393214.6760.27196
202306NZ-AUAKLSYDNZAS/NH/OZ 0.128670000.00371000000.131122220014420.132298872607920.138954260760410.159545516771440.162560678768830.124797760267130.150720690809860.142433449066190.134989002899720.152057424637290.136879549334230.133270494243740.15097365672490.14939642309393214.6760.27196
202306NZ-AUAKLSYDQFAA/CZ/MU/TN 0.301220000.00312000000.133646709394360.14292661774470.122036717047830.16705839806510.180978230398210.11042670960510.14292661774470.146414325583320.147080962592050.134689095788630.144548853482250.149652425169570.13473224090150.14288209648267389.5750.49353
202306NZ-AUAKLSYDQFAA/CZ/MU/TN 0.301220000.00312000000.133646709394360.14292661774470.122036717047830.16705839806510.180978230398210.11042670960510.14292661774470.146414325583320.147080962592050.134689095788630.144548853482250.149652425169570.13473224090150.14288209648267389.5750.49353
202306US-USDCAMSPAA 00000.015160.0021900000.135108302476830.132987366609260.134070398942450.168140792841630.16787003685970.127481947345740.134341154924380.141381728425890.139456940337250.140333468319440.142961208884320.142586954401390.14741224593580.1458674536959161.01210.2216
202306US-USDCAMSPAC 00000.004310.0013900000.131118883235950.131118883235950.131118883235950.167832164843360.167832164843360.139860137369470.131118883235950.136503175051090.136808672769360.136571143608930.142982440765340.142835074690110.162625063019310.141674430095861.5710.00571
202306US-USDCAMSPDL 0.315770000.02687000000.134602541502770.134602541502770.134602541502770.166694494706750.166694494706750.129759518970540.133043867107630.140734264099710.141049229102060.140804339167490.141626540672140.141480567713850.149936868529970.14436819071477197.8370.71856
202306US-USDCAMSPUA 00000.02302000000.165798610396180.165798610396180.165798610396180.158420142623620.168402776681260.0512152786944660.12456597081210.174621341906080.175012151959120.174708298451590.135620906640590.144117369629290.0597983528313080.136121578582026.3380.02302
202306US-USDCAMSPWN 0.001750000.02685000000.168434582956080.173577633026450.173577633026450.20186434854060.201864348540600.0806814539098010.181385968764370.187656177771510.187330355647880.176848446586670.1766661799295100.0901128713000678.56650.03111
202306US-GBJFKLHRAAAY/B6/BA/IB/QR/UL 0.080530000000000.133326989207920.133326989207920.133326989207920.166682526980190.166682526980190.133326989207920.133326989207920.14179889327970.143696364217840.14179889327970.144469647635810.141425403131550.143696364217840.14311443423758453.8130.21017
202306US-GBJFKLHRB6 00000000000.133291612256950.133291612256950.133291612256950.166770969357620.166770969357620.133291612256950.133291612256950.141798894746450.143696367691320.141798894746450.144469652156880.141425392054590.143696367691320.14311443091299690.03196
202306US-GBJFKLHRBAAA/AY/IB 0.20240000000000.135042966182630.135042966182630.135042966182630.164044041575120.168796987900670.130290009853610.131740062122720.143616791543880.145538586818110.143616791543880.142193290297380.143238509691590.140405591309870.14139043879529804.1080.37241
202306US-GBJFKLHRDLAF/KL/VS 0.057840000000000.133326553706410.133326553706410.133326553706410.166683615733970.166683615733970.133326553706410.133326553706410.141798892933610.143696369388320.141798892933610.144469646276130.141425400965340.143696369388320.14311442811467212.310.09833
202306US-GBJFKLHRVSAF/DL/KL 0.156060000000000.134568504371050.128404260712930.134568504371050.163578739072380.16974298273050.134568504371050.134568504371050.143126671806180.138383876578130.143126671806180.141806116376910.144060236402790.145041904235710.1444545227941619.9990.28714
202306GB-USLHRJFKAAAY/B6/BA/IB/QR/UL 0.079220000000000.133336741249580.133336741249580.133336741249580.166658146876050.166658146876050.133336741249580.133336741249580.142288187207330.140457110087080.144167648657540.14340993569170.141918168914180.144167648657540.14359130078465429.4710.19566
202306GB-USLHRJFKB6 00000000000.133312121026070.133312121026070.133312121026070.166719697434820.166719697434820.133312121026070.133312121026070.142288190812030.140457109381550.14416764790440.143409937440860.141918162699810.14416764790440.14359130385696690.03144
202306GB-USLHRJFKBAAA/AY/IB 0.207750000000000.13496756149590.13496756149590.13496756149590.164163872000410.168715988963140.130415444533160.13180201001560.144036238442960.142182652851770.145938776965360.141244083958640.143661663887190.141003250236330.14193333365776839.0220.38225
202306GB-USLHRJFKDLAF/KL/VS 0.05690000000000.133333335705370.133333335705370.133333335705370.166666660736560.166666660736560.133333335705370.133333335705370.142288194805760.140457111766350.144167642662510.143409937355770.141918170408770.144167642662510.14359130033833229.7940.10469
202306GB-USLHRJFKVSAF/DL/KL 0.155410000000000.132920690608050.1390404269290.126835919593550.167680790826650.167680790826650.132920690608050.132920690608050.141940548510330.146545756575770.1372136768580.144372956329530.1428711677050.143815415962110.14324047805925627.6590.28596
202306US-USMSPDCAAA 00000.03283000000.134521611338360.133806965743050.133806965743050.168236082986050.168236082986050.128720358187250.132671933016190.14088814637760.142443742099050.142263979798120.143172427657260.142596187974480.142130797684270.1465047184092165.2370.23789
202306US-USMSPDCAAC 00000.00334000000.132530119636990.132530119636990.132530119636990.168674700907520.168674700907520.132530119636990.132530119636990.139505770231090.141797383248110.141618437962910.141711132198240.141140775844580.147114285947320.147112214567760.9150.00334
202306US-USMSPDCAB6 00000.00237000000.142857142857140.142857142857140.142857142857140.142857142857140.142857142857140.142857142857140.142857142857140.147870890175860.150299906647340.150110226929940.120166781340410.119683138218110.155935629201050.155933427487290.6510.00237
202306US-USMSPDCADL 0.317030000.01628000000.135046153354250.132189894825230.132429088734310.167618751095820.16785794500490.131233108705750.133625058279730.141381392434390.140657440784750.14073347037740.142601554232160.142229764853850.144878059143290.14751831817416194.9060.71073
202306US-USMSPDCAUA 00000.02268000000.15689731265830.15689731265830.15689731265830.163948869201410.186425737749380.0894667275371540.0894667275371540.16527443027560.167989333459430.167777341445590.140715255858240.159288189159610.0994784276040950.099477022197436.22050.02268
202306US-USMSPDCAWN 0.002640000.02035000000.177033491175430.177033491175430.177033491175430.177033491175430.177033491175430.1148325441228300.187329304558770.190406494602650.190166200049030.152232534865110.151619828778640.128245637145806.30450.02299
202306AU-NZSYDAKLD7 0.068310000000000.111111112625970.111111112625970.148148145623380.185185185437660.185185185437660.111111112625970.148148145623380.113911610506940.118599527926810.157265602597820.160240735686520.164703458876270.127383382815760.1578956815898956.20050.06831
202306AU-NZSYDAKLJQQF 0.05460000.00164000000.260708170699910.18146773829070.13192460848850.164905767259130.00399771569835540.253712161683160.00328383788023720.25659592602350.185938254696110.134490176246280.137034457738860.00344496412156360.279193649736310.003302571437379457.62710.07005
202306AU-NZSYDAKLLAMH/QF 0.052840000000000.133325245978240.133325245978240.133325245978240.16668688505440.16668688505440.133325245978240.133325245978240.135613317425150.141194340714110.140420133670090.143076581392590.147061272345060.151651649441410.140982705011667.8120.08243
202306AU-NZSYDAKLNZNH 0.082950000000000.131145265334850.131145265334850.137626144370920.159059342295010.159059342295010.124664386298770.157300254070590.133089992727630.138567166983110.144606913707810.136257472662620.140052258409570.141486479496520.16593971601274177.7250.21603
202306AU-NZSYDAKLQFAA/CZ/MU/TN 0.290780000000000.133667148722840.133667148722840.134164317108050.167083925981610.179086981832170.110655373792150.141675103840340.136510747112670.142128702295690.141878640934110.144023396829160.158674378450560.126368354230680.15041578014712463.3250.56318

QSI Market Size

Explain these tables here. This section shows absolute market size metrics per service type and day of week.

Market Size by Service TypeMarket Size by Day of Week
YYYYMMCountry PairAirport Pairdopralmmktalblnk1Cpn1CpnShr2+CpnsOn2+CpnsShr2+CpnsIntblnkMonTueWedThrFriSatSunAVGSTDEV
202306NZ-AUAKLSYDD7 5080.20000 588.1615.3836.4811.8804.9609.3814.4725.7114.4
202306NZ-AUAKLSYDD7 5080.20000 588.1615.3836.4811.8804.9609.3814.4725.7114.4
202306NZ-AUAKLSYDJQQF 2385.459236.3610.70 342.5406331.2426.4445.7347.5392.6384.644.7
202306NZ-AUAKLSYDJQQF 2385.459236.3610.70 342.5406331.2426.4445.7347.5392.6384.644.7
202306NZ-AUAKLSYDLAMH/QF 1944.73117000 261.5273248.6342.2364.5266.3305.1294.544.2
202306NZ-AUAKLSYDLAMH/QF 1944.73117000 261.5273248.6342.2364.5266.3305.1294.544.2
202306NZ-AUAKLSYDNZAS/NH/OZ 9667.44199109.137.428.4 139414341465.81431.41413.71121.31781.51434.5192.2
202306NZ-AUAKLSYDNZAS/NH/OZ 9667.44199109.137.428.4 139414341465.81431.41413.71121.31781.51434.5192.2
202306NZ-AUAKLSYDQFAA/CZ/MU/TN 7213.667891.0214.356.8 10151069.3958.41310.11377.31013.61309.71150.5174.6
202306NZ-AUAKLSYDQFAA/CZ/MU/TN 7213.667891.0214.356.8 10151069.3958.41310.11377.31013.61309.71150.5174.6
202306US-USDCAMSPAA 2712.70464.800 338.2518.9532.3497.4500392.1398.6453.976
202306US-USDCAMSPAC 0018.500 1.72.53.82.12.13.82.52.60.8
202306US-USDCAMSPDL 12270.20306.5900.3 1693.81975.51854.61885.21888.61619.91659.41796.7136.8
202306US-USDCAMSPUA 00181.2500 25.544.128.422.122.113.625.525.99.3
202306US-USDCAMSPWN 67.601016.3900 183.370.1196.2231.7244.147.9110.5154.978.5
202306US-GBJFKLHRAAAY/B6/BA/IB/QR/UL 10591.35668162.3631.6127.9 21162234.92306.22619.12522.92204.12477.62354.4186.9
202306US-GBJFKLHRB6 5835.2301590.29 822.4812.4780.4861.7910.5835.6836.4837.140.9
202306US-GBJFKLHRBAAA/AY/IB 20241.15436083.4927.57 3257.434813635.24152.83942.33404.33915.23684327.5
202306US-GBJFKLHRDLAF/KL/VS 7134.26258194.42102.0937.59 1438.71301.91407.71448.11474.6141114671421.358.4
202306US-GBJFKLHRVSAF/DL/KL 18998.97234014.982.59 3795.93435.23714.23820.83890.73722.93870.83750.1154.2
202306GB-USLHRJFKAAAY/B6/BA/IB/QR/UL 7023.56339414.418.790 1692.61425.31424.21418.714761340.21673.71493136
202306GB-USLHRJFKB6 4085.2906.0900 610.3562.9580.4617.9598.4523598.4584.532.7
202306GB-USLHRJFKBAAA/AY/IB 20887.9569002.411.2 43563618.83603.835613735.83404.64311.93798.8378.6
202306GB-USLHRJFKDLAF/KL/VS 3855.23133917.1232.913.81 765.6733.3754.6775.8765.7679.9783.6751.235.3
202306GB-USLHRJFKVSAF/DL/KL 17886.66539002.7 3556.53406.73505.73604.13557.23158.336403489.8164.2
202306US-USMSPDCAAA 2914.40319.3901.1 534.5404.9405.8414.3443.3542.2489.8462.159.9
202306US-USMSPDCAAC 006.800 0.81.60.80.81.60.40.810.5
202306US-USMSPDCAB6 0012.73.80 6.81.91.51.510.53.42.42.2
202306US-USMSPDCADL 12177.30243.7201.2 1911.31933.51831.21731.11754.61444.71815.81774.6163.3
202306US-USMSPDCAUA 00161.0900 23.425.530.729.922.117.811.7236.7
202306US-USMSPDCAWN 28.80588.500 131.510760.969.868.9146.33388.241
202306AU-NZSYDAKLD7 4599.60000 554.5526.4716.6726.1756.8540.7778.4657.1111.1
202306AU-NZSYDAKLJQQF 2285.68125250.436.32.76 520.3434.6358.3313.9313.7388.5371385.772.8
202306AU-NZSYDAKLLAMH/QF 1948.44199000 363.5321.5284.8244.7316.5230.1386.8306.858
202306AU-NZSYDAKLNZNH 9573.758914.5916.8922.91 1316.11141.814001390.914371190.81840.21388.1227.9
202306AU-NZSYDAKLQFAA/CZ/MU/TN 7672.993637.45.744.32 1472.11295.61175.4978.31280.2965.81528.81242.3219.8

Do you want 10 free searches?

Create an account and login today * business emails only