Community
Wiki Posts
Search

Impact Analysis from a Data Geek

Thread Tools
 
Search this Thread
 
Old Feb 19, 2015 | 7:40 am
  #1  
Original Poster
 
Join Date: Jul 2012
Location: Western Wisconsin
Programs: DL DM, HH Devalued Diamond, Hertz President's Club
Posts: 799
Impact Analysis from a Data Geek

My frequent traveler programs are part prize, part game to me. I keep crazy spreadsheets that track just about everything under the sun related to them.

A new addition to my 2015 SkyMiles sheet has calculations for RDM differences on the new program.

I fly fairly cheap as I generally know where I am going well enough in advance and my employer adheres pretty tightly to 14 day advance purchase to which I hold to right at that mark usually.

5 RTs, MSP based and my RDM deficit from the 2014 program is already -13,109 miles.

Even reductions in the award chart will not account for this kind of loss.

Anyone else tracking this on a trip by trip basis?
orr333 is offline  
Old Feb 19, 2015 | 8:15 am
  #2  
10 Countries Visited
20 Countries Visited
30 Countries Visited
10 Years on Site
 
Join Date: Jan 2013
Location: midwest
Programs: DL Gold (after 11 yrs at PM)
Posts: 949
Originally Posted by orr333
Even reductions in the award chart will not account for this kind of loss.
Award chart, what's that?
RaflW is offline  
Old Feb 19, 2015 | 8:47 am
  #3  
TTT
FlyerTalk Evangelist
30 Countries Visited1M20 Years on Site
 
Join Date: Nov 2004
Location: 45 North
Programs: AS Gold 75K, DL GM/MM
Posts: 10,205
Originally Posted by orr333
Anyone else tracking this on a trip by trip basis?
I track it on a trip by trip basis. I have a column for 2014 miles earned and 2015 miles earned.

So far I am down based on what the trips would have earned under the 2014 scheme. That said, there are some trips that have earned more. It really just depends on any given week.
TTT is offline  
Old Feb 19, 2015 | 9:18 am
  #4  
10 Countries Visited20 Countries Visited30 Countries Visited10 Years on Site
 
Join Date: Mar 2011
Programs: Delta Skymiles
Posts: 2,009
I've bought a few Fc fares last minute. A change for me. So I have some fares under and others over. Wish there was still class of service bonus.
cfabar1 is offline  
Old Feb 19, 2015 | 9:24 am
  #5  
 
Join Date: Dec 2009
Location: MSP
Programs: DL GM, AMEX Business Platinum, AMEX Delta Reserve, DL SkyClub Member, Choice PM
Posts: 2,218
Originally Posted by orr333

5 RTs, MSP based and my RDM deficit from the 2014 program is already -13,109 miles.

Even reductions in the award chart will not account for this kind of loss.

Anyone else tracking this on a trip by trip basis?
My RDM deficit from the 2014 program to 2015 Program is already > -13,109 miles from 1 One Way .....

enuff said!
dd1612 is offline  
Old Feb 19, 2015 | 10:33 am
  #6  
 
Join Date: Sep 2012
Programs: DL DM
Posts: 88
You guys are gluttons for punishment. I track what I should earn to keep Delta honest. I doubt they are going back anytime soon (I hope I'm wrong) so why wallow?
SATXFlyer is offline  
Old Feb 19, 2015 | 10:59 am
  #7  
1M
40 Countries Visited
All eyes on you!
15 Years on Site
 
Join Date: May 2009
Location: Seattle, WA
Programs: Alaska Titanium, DL Diamond 1.9MM, Bonvoy Platinum, Hertz PC
Posts: 3,996
Due to the distances involved, 2015 SkyMiles is spectacularly bad for international travel flying economy - or really even domestic travel for anyone west of the Mississippi unless they're commuting on short regional hops. For example:

(All 1 week adv purchase fares are actual quotes from Delta.com for round trip flights departing Monday March 2nd as of Feb 19th. Historical data is from faremeasure.com. Both actual fares overestimate earnings because they include taxes.)

SEA-NRT - Breakeven $1900 for general member, $1950 for Diamond; 1 week adv purchase $1123
SEA-AMS - Breakeven $1950 for general member, $2000 for Diamond; 1 week adv purchase $1456
SEA-ATL - Breakeven $875 for general member, $900 for Diamond; Average fare $547; 1 week adv purchase $668
MSP-LAX - Breakeven $625 for general member, $650 for Diamond; Average fare $515; 1 week adv purchase $398
SEA-LAX - Breakeven $400 for general member, $400 for Diamond; Average fare $315; 1 week adv purchase $247
SEA-PDX - Breakeven $200 for general member, $200 for Diamond; Average fare $251; 1 week adv purchase $224
SFO-LAX - Breakeven $200 for general member, $200 for Diamond; Average fare $262; 1 week adv purchase $148

Note the real breakeven values are actually worse, because these calculations assume nonstops: in many cases a real itinerary would involve connections on these routes, which would increase the 2014 earnings.

So, yeah. Unless you're flying SEA-PDX, or booking very last minute fares, or flying F, you're not coming out ahead on any of these routes in almost all cases.
BenA is offline  
Old Feb 19, 2015 | 11:13 am
  #8  
TTT
FlyerTalk Evangelist
30 Countries Visited1M20 Years on Site
 
Join Date: Nov 2004
Location: 45 North
Programs: AS Gold 75K, DL GM/MM
Posts: 10,205
Originally Posted by BenA
So, yeah. Unless you're flying SEA-PDX, or booking very last minute fares, or flying F, you're not coming out ahead on any of these routes in almost all cases.
Even some of the discounted F fares yield lower earnings under SM2015.
TTT is offline  
Old Feb 19, 2015 | 11:53 am
  #9  
2M
50 Countries Visited
All eyes on you!
15 Years on Site
 
Join Date: Jan 2008
Location: NYC, NJ, Long Island
Programs: DL DM, 1.6MM, UA Silver, NEXUS, SkyClub & AdmiralsClub Lifetime, Bonvoy Titanium
Posts: 6,652
I track way too much detail, only an excerpt of data points shown here. I'm at ~25% of Old RDM's. My 6 segments over the next 2 weeks will be about the same.

SuperG1955 is offline  
Old Feb 19, 2015 | 1:23 pm
  #10  
All eyes on you!
10 Years on Site
 
Join Date: Jun 2011
Location: USA
Posts: 1,399
Originally Posted by SuperG1955
I track way too much detail, only an excerpt of data points shown here. I'm at ~25% of Old RDM's. My 6 segments over the next 2 weeks will be about the same.

Holy cow! Your MQD's are crazy low. Unfortunately, you are exactly who Delta was targeting with the changes.
emrdoc is offline  
Old Feb 19, 2015 | 1:36 pm
  #11  
15 Years on Site
 
Join Date: Sep 2005
Location: Columbia, SC
Programs: AA Plat, SPG/Marriot Gold, HHonors Diamond, Hyatt Expl
Posts: 2,363
I did my own tracking all last year, as soon as DL announced earning rules for 2015. This was an ongoing indicator that I need to shift my paid travel away from DL, as I don't plunk thousands of dollars on airfare.

My 2014 stats:
Segments: 45
MQMs: 78,156
MQD: $4,391
RDMs: 132,696

With the Amex waiver, I made Platinum Medallion for 2015 (again), so I used the PM level earning for comparison.

Under the 2015 rules, I would have earned 49,330 RDMs, which is a difference of -63%.

Effectively (assuming mythical formerly-known-as-low can be found) I earned one int'l r/t BE award last year. Assuming same flying pattern, I wouldn't earn enough for even a one-way.

My paid tickets are on 001 stock now.
akcae is offline  
Old Feb 19, 2015 | 2:10 pm
  #12  
2M
50 Countries Visited
All eyes on you!
15 Years on Site
 
Join Date: Jan 2008
Location: NYC, NJ, Long Island
Programs: DL DM, 1.6MM, UA Silver, NEXUS, SkyClub & AdmiralsClub Lifetime, Bonvoy Titanium
Posts: 6,652
Originally Posted by emrdoc
Holy cow! Your MQD's are crazy low. Unfortunately, you are exactly who Delta was targeting with the changes.
Thank you, I work hard at accomplishing that.

2014 I flew 60 segments, 82707 BIS MQM and MQD's were $6121 for an average of .074 cpMQD. There were 2 last minute business trips and a very overpriced AZ fare to avoid an Italian ATC strike that added over $1000 MQD and .01 cpm to my average.

I'll be doing between 60 and 75K BIS MQM this year and hope to keep it under .06 cpMQD and thank you AMEX Waiver.

As an aside, note the UG % as well.

I realize that we get screwed on BIS RDM's but my wife and I (she's also a PM) each get 90K+ from our DL Reserve cards, which combined with our measly allotment from BIS and a little carryover gives us each enough for a TATL J every year. We have no trouble finding Low since we book early. We have JFK-MAD-CDG-JFK booked late Aug through mid-Sept at 125K each in J.
SuperG1955 is offline  
Old Feb 19, 2015 | 3:32 pm
  #13  
All eyes on you!
10 Years on Site
 
Join Date: Jun 2013
Programs: AA Plat Pro, ex DL Plat, Hilton Diamond, Marriott Plat, IHG Plat
Posts: 1,448
Originally Posted by TTT
Even some of the discounted F fares yield lower earnings under SM2015.
As with full Y fares. Which I discovered last month on a last minute purchase that still netted fewer miles.
Zeeb is offline  
Old Feb 19, 2015 | 8:16 pm
  #14  
A FlyerTalk Posting Legend
40 Countries Visited
60 Nights
5M
15 Years on Site
 
Join Date: Sep 2009
Location: Minneapolis: DL DM charter 2.3MM
Programs: A3*Gold, SPG Plat, HyattDiamond, MarriottPP, LHW exAccess, ICI, Raffles Amb, NW PE MM, TWA Gold MM
Posts: 102,617
Originally Posted by BenA
Due to the distances involved, 2015 SkyMiles is spectacularly bad for international travel flying economy - or really even domestic travel for anyone west of the Mississippi unless they're commuting on short regional hops. For example:

(All 1 week adv purchase fares are actual quotes from Delta.com for round trip flights departing Monday March 2nd as of Feb 19th. Historical data is from faremeasure.com. Both actual fares overestimate earnings because they include taxes.)

SEA-NRT - Breakeven $1900 for general member, $1950 for Diamond; 1 week adv purchase $1123
SEA-AMS - Breakeven $1950 for general member, $2000 for Diamond; 1 week adv purchase $1456
SEA-ATL - Breakeven $875 for general member, $900 for Diamond; Average fare $547; 1 week adv purchase $668
MSP-LAX - Breakeven $625 for general member, $650 for Diamond; Average fare $515; 1 week adv purchase $398
SEA-LAX - Breakeven $400 for general member, $400 for Diamond; Average fare $315; 1 week adv purchase $247
SEA-PDX - Breakeven $200 for general member, $200 for Diamond; Average fare $251; 1 week adv purchase $224
SFO-LAX - Breakeven $200 for general member, $200 for Diamond; Average fare $262; 1 week adv purchase $148

Note the real breakeven values are actually worse, because these calculations assume nonstops: in many cases a real itinerary would involve connections on these routes, which would increase the 2014 earnings.

So, yeah. Unless you're flying SEA-PDX, or booking very last minute fares, or flying F, you're not coming out ahead on any of these routes in almost all cases.
You seem to be complaining that DL fares on these routes are too low.
MSPeconomist is offline  
Old Feb 19, 2015 | 8:43 pm
  #15  
FlyerTalk Evangelist
All eyes on you!
10 Years on Site
 
Join Date: Oct 2011
Location: ATL
Programs: DL Scattered Smothered Covered Medallion, Some hotel & car stuff, Kroger Plus Card
Posts: 10,805
Originally Posted by BenA
Unless you're flying SEA-PDX, or booking very last minute fares, or flying F, you're not coming out ahead on any of these routes in almost all cases.
Or ATL-IAD/DCA/BWI/PHL/LGA in coach booked 3+ weeks out. That's what I've been doing and I seem to be either breaking even or coming out slightly ahead.

Originally Posted by emrdoc
Holy cow! Your MQD's are crazy low. Unfortunately, you are exactly who Delta was targeting with the changes.
On the contrary, I'd say people with MQDs that low are the people DL wants to stop targeting.

(Yes, I know it's just a turn of language and we're saying the same thing.)

Originally Posted by MSPeconomist
You seem to be complaining that DL fares on these routes are too low.
+1. Also, do we really need another thread comparing 2014 to 2015? There are already multiple threads with people throughout both generalizations and specific comparisons, and as someone else said, continuing to track the comparison serves little purpose other than to give you heartburn if you're on the losing end.
gooselee is offline  


Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.