It would be great but unfortunately anything with connection statistics according to AS is too hard on the system. It would (if memory serves correct) require 1000s of queries to generate 1 statistic...
well, the information should be here, since we are doing intelining, the only difference is to show it instead of hiding it (I gess...)
and if the info isn’t here, it would means that interlining is a smoke screen and nothing realy happen…
The information exists in the database for the database to do its job. Just because data is in the database, doesn't mean it is readily accessible to users. If that were the case, people such as myself who are database administrators would be out of a job.
I have a very good idea on the money an IL costs me and in turn generates for me. the. again, I don’t sign hundreds of interlining agreements but a chosen few…
well, the information should be here, since we are doing intelining, the only difference is to show it instead of hiding it (I gess...)
and if the info isn’t here, it would means that interlining is a smoke screen and nothing realy happen…
Hi,
if I am correct, the ORS booking system checks all possible routes (direct, internal transfer or IL transfer) and then books the passengers on their respective flights. But the data base does not keep track of origin and final destination of any passengers. After an airport calculates it's demand, these passengers become the number of bookings on a flight.
What Jan said. The connecting passengers exist only at the time of demand calculations, they are booked and disappear. What is left, is the number of seats booked on the individual flights.
I'm not sure if having an Interlining really help as you only see your money to go away without any statistics added.
I can have 3 IL with the same country and maybe only 1 is being used and the others a waste of money.
I would like to know at least the amount of creeps that came from the IL on a weekly basis and the % that it shares with the other IL by country or with all of it.
You can see your external transfers (in/out) with flight stats and office stats. You can do rough calculations and profit margins in excel. Would require typing in routes, prices, costs, or profit margins, etc. and you can calculate this yourself. Of course there are many routes/cities where you may have multiple interlining partners. There, it will not be so precise and easy to see who contributes what. But again, that's why there are statistics. Check departure/arrival times for your flights and for those of your partners. You can statistically assume the probability of the transfer happening. You can extrapolate data. You can come to conclusions from statistical data sets. Of course, this is for those who consider this a business simulation. Some prefer this just being a game. For example, one of my airlines, I received an interline offer from one of the biggest airlines on the server. I ran some numbers and even with 60% of transit pax on that flight and average 30% margin, I would still be losing about 30% of interline cost. But for the sake of the game, I signed the interline contract. Was this economically reasonable thing to do? Absolutely not. But for a mere 30-50,000 per week "loss" from such interline, is it worth for me to say "no" to one of the biggest airline on the server and somebody I have been transacting before (terminals, planes, sold me stock in one of my competitors, etc.)..it is not. As the saying goes, you must lose some to win some more.
My advise to you would be to consider interline on global basis. Calculate how any pax are transferred in/out and how much they contribute. Finding margins and prices is easy, just multiply the numbers. Of course you may find that some interlines really do not bring you pax (see flight stats and office stats) and such interlines you could terminate. But for others, for those where you cannot see exact numbers because of multiple routes or partners, just consider it globally. And of course, if you arrive/depart at 10 am and your interline has all flights ate 8 pm, you are not getting any pax in/out from him so you can cancel interline. So you must put some time and effort into this. How much time and effort, depends… myself I have a big airline and most of the interline costs are just a drop in the bucket of total revenue. For a small airline, the cost may be more proportional to your revenue, but as a small airline you can run more precise statistics.
well, the information should be here, since we are doing intelining, the only difference is to show it instead of hiding it (I gess...)
and if the info isn’t here, it would means that interlining is a smoke screen and nothing realy happen…
I'm not sure if having an Interlining really help as you only see your money to go away without any statistics added.
I can have 3 IL with the same country and maybe only 1 is being used and the others a waste of money.
Something must really be happening because approximately half (and sometimes more) of my passengers come from my interlining connections. IL's can be vital, especially in a low-margin country like Madagascar. They are key to my airline remaining profitable.
The key is having the right IL connections; as the two of you gain some experience with the game, I expect that you will see the truth in this.
Rewaking an old thread, as I also miss this feature :)
Being a coder myself, just an idea on implementing this: wouldn't it be possible to simply keep counters for interlining agreements and increase them when a PAX is using it during a flight booking, and during your weekly stats generations you just save the count for the last week and start from 0. You could maybe even keep the counters per station or similar, and I'm quite sure it wouldn't add up too much load to database or application server.
Just a thought, I don't know your database design and code.
Being a coder myself, just an idea on implementing this: wouldn't it be possible to simply keep counters for interlining agreements and increase them when a PAX is using it during a flight booking, and during your weekly stats generations you just save the count for the last week and start from 0. You could maybe even keep the counters per station or similar, and I'm quite sure it wouldn't add up too much load to database or application server.
Would of course be possible, but wouldn't provide you with all that much new insight, IMO. You wouldn't know how much revenue they generated and which flights/routes they passengers were booked on.
Well, in the flights we already see the number of PAX from/to external connections (as well as internal connections).
But just an example: I currently have 6 interlining agreements, 5 of them are present at my hub. Those interlining agreements also cost me different amounts of money every week, and it would be nice to see if the more expensive ones actually yield a higher number of transfers or if I really just waste money here. Also it would be nice to see if numbers change over time (e.g. for a few weeks, I'm getting quite a lot PAX from one of the interlining agreements, but the other player for some reason changes the schedule (e.g. uses a different a/c with different turn around time, and the once good connection now is impossible).
Right now, all we see is how many PAX we have from interlining on individual flights, without any information from where they're coming or to which airline they're going. Statistics on an interlining agreement (maybe broken down to which airports) definitly would be a benefit information-wise in my eyes.
Would of course be possible, but wouldn't provide you with all that much new insight, IMO. You wouldn't know how much revenue they generated and which flights/routes they passengers were booked on.
No need for knowing exact revenue generated, some calculations can be done by working with average revenue per transfer pax..