Forum

Centralized Look-Up...
 
Share:

Centralized Look-Up Tool for Free Flight Award Rates  

Page 1 / 4
  RSS
Phlee
(@phlee)

We recently launched milez.biz in the hopes of making the flight redemption rates from the various frequent flyer programs more transparent. The motivation for this project stemmed from our own frustration from finding the most optimal award rates for certain routes. We noticed that there are sometimes widely varying rates, depending on the program and destinations.

Milez.biz is very simple: type two city names into the “From” and “To” fields, select from the auto-complete and let the calculator figure out what the rates for return flights between the two selected cities are. The rates in our database correspond to the rates published on the programs’ websites.
You no longer need to figure out which zone a city belongs to, or if it is even part of a program, milez.biz does it all for you. We currently track over 40 programs and will be adding more soon. We track both zones and distance based programs.

________________________________________________________
Philipp Gysling
[email]info@milez.biz[/email]
Visit our cross-program award rate calculator at www.milez.biz

Quote
Posted : January 5, 2012 7:04 pm
Scottrick
(@scottrick)

Since you're assuming people have multiple award accounts in different programs (this is partly a mileage cost-comparison service, right?) then is there a feature now or in the future that will also account for transfer programs? For example, if a certain flight requires XXX airline miles, could it say next to that how many SPG points you would need to transfer?

Check out my blog: TravelCodex.com

ReplyQuote
Posted : January 5, 2012 7:25 pm
Phlee
(@phlee)

Hi Scottrick,

Thanks for the question.

You are right that currently the tool is useful primarily for people w/ multiple accounts. One of the next adjustments we'll make to the tool is to allow people to filter by program. I.e. users will be able to indicate exactly which programs they want to look at.As we add more programs to the calculator this will make it more meaningful.

And also since the majority of the programs don't have a calculator at all the tool will then also be useful to users who are even just members of one program.

We have not looked at the mile transfer logic yet. For now we are still trying to flesh out the data with as many programs as possible. We have made note of this feature though.

ph

________________________________________________________
Philipp Gysling
[email]info@milez.biz[/email]
Visit our cross-program award rate calculator at www.milez.biz

ReplyQuote
Posted : January 5, 2012 7:56 pm
mattsteg
(@mattsteg)

Neat tool.

Out of curiousity, what logic is the site using to select which options to display? Depending on destination, I can get different numbers of e.g. skyteam options to show up. It seems like there are a few holes.

Alaska Airlines would be a great addition, as would the ability to process airport codes like MSP rather than forcing you to choose the autocomplete.

Transfer logic for even just SPG, Amex MR, and Chase UR would be great.

Silver Gold Executive Platinum Classic Plus Exec Elite Platinum Gold Diamond

ReplyQuote
Posted : January 5, 2012 8:55 pm
Phlee
(@phlee)

Hi mattsteg,

The logic is as follows:

1) The application finds all the FFPs that have the 2 cities selected by the user.
2) Then it checks which zones the cities are in
3) Then it checks whether there are rates between the zones
4) If there are rates, it displays them for each program.

Sometimes a program may not have a rate for a route even though they have both cities in their destination list (this is mostly true for the programs in an alliance).
Some programs calculate rates by distance in which case we first compute the distance between the airports and then apply the corresponding rates (this sometimes means adding distance to/from a connecting city as well).

You will get different rates from the individual alliance partners (this is what kind of prompted the project in the first place); every partner in an alliance has its own rates. If you look at the Star Alliance rates they can vary greatly from member to member.

If you can point us to the conversion logic for the programs you mentioned we can have a look at integrating that.

If I remember correctly, the award rates at Alaskan follow a different scheme, no? We could theoretically add them too, but it would defeat the idea of the comparison.

ph

________________________________________________________
Philipp Gysling
[email]info@milez.biz[/email]
Visit our cross-program award rate calculator at www.milez.biz

ReplyQuote
Posted : January 5, 2012 9:32 pm
mattsteg
(@mattsteg)

Phlee wrote: Hi mattsteg,

The logic is as follows:

1) The application finds all the FFPs that have the 2 cities selected by the user.
2) Then it checks which zones the cities are in
3) Then it checks whether there are rates between the zones
4) If there are rates, it displays them for each program.

Sometimes a program may not have a rate for a route even though they have both cities in their destination list (this is mostly true for the programs in an alliance).
Some programs calculate rates by distance in which case we first compute the distance between the airports and then apply the corresponding rates (this sometimes means adding distance to/from a connecting city as well).

You will get different rates from the individual alliance partners (this is what kind of prompted the project in the first place); every partner in an alliance has its own rates. If you look at the Star Alliance rates they can vary greatly from member to member.

If you can point us to the conversion logic for the programs you mentioned we can have a look at integrating that.

If I remember correctly, the award rates at Alaskan follow a different scheme, no? We could theoretically add them too, but it would defeat the idea of the comparison.

ph

There are some holes in the logic, I think. Different domestic US destinations return different skyteam partners when the programs in question have the us as a zone. Some redemptions that I know exist weren't showing up. Alitalia and Korean in particular I noticed right away. Step 1 may be culling too much(It's unclear what you mean by an FFP "having" a destination. Maybe the alliance stuff isn't working properly), or there may be a glitch in the zone logic.

Sorry about the lack of detail - on my mobile at the moment.

Spg's partner transfer options are listed at http://www.starwoodhotels.com/preferredguest/account/starpoints/transfer/airline_partner_list . The others I don't have a list handy. The biggest value in comparing rates is when you can choose which to spend, and the big transfer programs ans their partners offer the best chance at that.

Silver Gold Executive Platinum Classic Plus Exec Elite Platinum Gold Diamond

ReplyQuote
Posted : January 6, 2012 5:19 am
HaveMilesWillTravel
(@havemileswilltravel)

Nice clean look and feel. Some random thoughts based on 1 search...

The results seem to be sorted alphabetically. Ordered by number of miles would seem more useful.

Can you figure out fuel surcharges? With some programs that would be a key factor.

Auto-complete seem to have some issues (try FRA).

I don't always drink beer, but when I do I will certainly NOT drink Bud Light.

ReplyQuote
Posted : January 6, 2012 5:39 am
James Elkins
(@james-elkins)

It would be great to explicitly put the standard rates next to the saver (or low/mid/high, depending on the carrier) rates for a comparison (when available).

The nomenclature of "return flight" is confusing. Why don't you use "Round trip" ?

In your algorithm, you say you compute the distance between the two airports (for programs like ANA or BA). How do you do this efficiently? Do you have some table with the distances between all routes for those particular programs?

Also, how do you deal with the fact that some mileage programs have different zone classifications? For example:
http://www.aa.com/i18n/disclaimers/free-ticket-award-chart.jsp has North America as a grouping when going to China. So you could go from the Bahamas to China. But http://www.united.com/ual/asset/United_Star_Chart_eff_after_6_15.pdf separates the Caribbean out. Do you simply have a different zone classification for each program?

+1 for being able to order by # of miles.

Great job!

ReplyQuote
Posted : January 6, 2012 9:05 am
Titans26
(@titans26)
Silver

Great start!

I don't feel you are assuming users have multiple accounts. It's a great tool to help users decide which FF program is best for them.

If the user plugs in several dates and destinations they can see which program has the best award availability for their travel needs.

Its a valuable tool for most frequent and non frequent flyers. There are new passengers everyday trying to decide which FF program is best.

We all can purchase miles, transfer miles from hotel programs, shopping, dining, status match, elite challenge for most FF programs. We can instantly start a new account and switch our flying to suit our award redemption needs.

Good Luck!

ReplyQuote
Posted : January 6, 2012 10:50 am
Phlee
(@phlee)

Hi again mattsteg,

Thanks for looking at this again.

- Could you give me an example of the US destinations issues you saw? That way we can try to figure it out. I do think, though, that it is a data issue, not a logic issue.

- The way we fill the db is by entering the destinations, zones and rates per program. So the alliance programs fill out gradually as we add more of the partners. The Star Alliance one is currently the most complete and the oneworld the least complete.

- For MilleMiglia only the Alitalia rates are in the system right now; same is true for Korean (only Korean Air). Our next data update should include SkyTeam rates for both of these programs. Adding the alliance rates is sometimes complicated bc they conflict with the program's regular rates.

- We have found the Alaskan rates, we'll try to include those soon as well.

- Thanks for the transfer options link. We'll do some analysis to see if we could integrate them.

ph

________________________________________________________
Philipp Gysling
[email]info@milez.biz[/email]
Visit our cross-program award rate calculator at www.milez.biz

ReplyQuote
Posted : January 6, 2012 1:36 pm
iolaire
(@iolaire)

So my first three or so searches failed because I entered BKK and DCA, then BKK and JFK. It turns out you will not return results from a three letter search, instead you have to select the airport from the Ajax popup then it tells you it is searching for BKK -> DCA.

Travel folks get savvy quickly, please let us use three letter codes directly.

Various trip reports related to traveling with dialysis and experiencing in center dialysis treatments at Traveling and in center hemodialysis

ReplyQuote
Posted : January 6, 2012 1:52 pm
Phlee
(@phlee)

Hi Titans26,

- The results are order alphabetically by program and then by points (ascending) within the program. I think it's best to keep the results per program together, no? If we order purely by points the results page would somehwat unruly.

- The auto-complete is something we are looking at; people in this forum may know most airport codes so that "FRA" should automatically jump to Frankfurt. But normal people would then not know how to find Toronto, Rome, Osaka, Bucharest, Moscow to name just a few big ones. Let alone Caribbean islands or Indian cities.
The auto-complete actually works on airport code, city name, airport name and country (for those islands). So someone could enter "toronto", "pearson", "yyz" or even "canada" to find toronto. We're trying to make this as user-friendly as possible so we're trying different things.

- Some surcharges are already added (Qantas domestic taxes) and in some cases where they can be covered by points they are in the description (topbonus). Adding all the surcharges that can be covered by points will require some more research.

ph

________________________________________________________
Philipp Gysling
[email]info@milez.biz[/email]
Visit our cross-program award rate calculator at www.milez.biz

ReplyQuote
Posted : January 6, 2012 1:54 pm
Phlee
(@phlee)

Hi James,

- Wording has been changed to "round trip".
- We have GPS coordinates for the airports in the db and then measure distance for the segments flown if the rate calculation requires it.
- Yes, we have different zones in every program (that seems to be the main difference w/ the programs, i.e. how places are zoned determines the cost of an award ticket).
- We've built the logic so that a destination can be in multiple zones within the same program, the calculator will just show the best rate.
- And some programs have two entries in the db bc they have conflicting rates (cf. SAA Voyager vs SAA Voyager Star Alliance if you enter JNB to GBE).

ph

________________________________________________________
Philipp Gysling
[email]info@milez.biz[/email]
Visit our cross-program award rate calculator at www.milez.biz

ReplyQuote
Posted : January 6, 2012 2:07 pm
Phlee
(@phlee)

iolaire, post: 1109593 wrote: So my first three or so searches failed because I entered BKK and DCA, then BKK and JFK. It turns out you will not return results from a three letter search, instead you have to select the airport from the Ajax popup then it tells you it is searching for BKK -> DCA.

Travel folks get savvy quickly, please let us use three letter codes directly.

Hi iolaire,

Understood about the airport code (see post above) ...
We actually originally only had the codes, but that is not really usable unless you know all codes. Most people probably know a few codes; we currently have over 1,500 active airports on the system.

ph

________________________________________________________
Philipp Gysling
[email]info@milez.biz[/email]
Visit our cross-program award rate calculator at www.milez.biz

ReplyQuote
Posted : January 6, 2012 2:18 pm
mattsteg
(@mattsteg)

Phlee, post: 1109649 wrote: Hi iolaire,

Understood about the airport code (see post above) ...
We actually originally only had the codes, but that is not really usable unless you know all codes. Most people probably know a few codes; we currently have over 1,500 active airports on the system.

ph

It would be nice if you could still use the codes, without fighting with the autocomplete. On forms like this, my preference is to fill in one text box, press tab to go go to the next, fill it in, etc. If I do that with this page, empty results are returned. While few would argue that the autocomplete is not very helpful to new users, it'd be nice to not be forced to wait for it to populate.

The specific issues I had with skyteam were alitalia and korean not showing up (you explained why above) and GOL showing up for some US domestic routes but not others. Specifically, gol doesn't appear to show up for routes where delta (regional) is the only airline serving the destination - eg MSL, HIB, INL, DLH. DLH also doesn't show any star options, although United (express) flies dlh-ord. MSP-CMX gives only skyteam options (dl, kl,CI) but is currently served only by UA. MSP-TOL gives AA and skyteam options (including GOL) when I believe only AA serves TOL. MSP-CLL returns results from AA and GOL (I think GOL got miscategorized as oneworld in domestic US?), and is missing star alliance results (co flies there from HOU). On another note, GOL correctly shows up for flights to RUN, served only by skyteam.

Admittedly I picked out marginally-served corner-case destinations to test with, and in many cases service to a few of these destinations is in flux. It looks like GOL is an easy fix. I don't know if a better source of data for who flies where is available. I imagine the coverage data is "good enough" for most purposes as it is. These airports are small and poorly-served for a reason. With that said, I imagine there are others who seek out the obscure as well.

Silver Gold Executive Platinum Classic Plus Exec Elite Platinum Gold Diamond

ReplyQuote
Posted : January 6, 2012 3:18 pm
Page 1 / 4