Last edit by: Schmoops
Figured a highly collaborative effort like this needs a wikipost. As items and codes are confirmed, let's centralize them in one place rather than thumb through hundreds of discussion posts.
How to pull your information
Log into your SkyMiles account at Delta.com, then visit this link: https://www.delta.com/databroker/bcdata.action
What the items indicate
v01: Closest airport to home address (encoded using key 1)
v02: Country of residence
v03:
v04: Preferred departure airport/city (encoded using key 2)
v05: Language
v06: discSpndngAmt, in thousands
v07: Skymiles status level
v08: State/province (encoded using key 2)
v09: Pay with Miles eligible
v10: sunTrstInd
v11: prefDestCity
v12: MQS
v13: Hotel loyalty programs stored in DL.com profile (encoded using key 2, see post #829)
v14:
v15: Income, in thousands
v16: Current age + 99
v17: 1/2/3 MM Status
v18: Home value, in thousands
v19:
v20: SkyClub member
v21: SkyMiles account number
v22: Experian Mosaic segment (encoded using keys 1 and 3, see http://www.flyertalk.com/forum/delta...l#post20913445) Description here and Segment Details here
v23: Saved search destination airports (encoded using key 1)
v24: SkyClub renewal date (coded using key 3)
v25: Saved payment information (encoded using key 1) AND SPG status (encoded using key 1, see http://www.flyertalk.com/forum/delta...l#post20913463)
v26: Gender/prefix (1=male/Mr, 2=female/Ms/Mrs, 3=Dr/other) (to be confirmed)
v27:
v28: SkyMiles account number with 3 leading zeros (called "CustID" in previous data)
v29: Logged in (SM account)
v30: Customer Value Score (Questionable, and scale is unknown)
v31: RDM balance
v32: Dream trips from DL.com profile (encoded using key 2)
v33: MQM balance
v34: Activities & Interests from DL.com profile
v35:
v36:
v37:
v38:
v39: ?? Duplicate for Language ??
v40: ?? Duplicate for Country of Residence ??
Encoding
Three different coding keys are used for variables 01, 04, 08, 13, 22, 23, 24, 25, and 32. For full mappings, click here: Keys 1, 2, and 3
How to pull your information
Log into your SkyMiles account at Delta.com, then visit this link: https://www.delta.com/databroker/bcdata.action
What the items indicate
v01: Closest airport to home address (encoded using key 1)
v02: Country of residence
v03:
v04: Preferred departure airport/city (encoded using key 2)
v05: Language
v06: discSpndngAmt, in thousands
v07: Skymiles status level
v08: State/province (encoded using key 2)
v09: Pay with Miles eligible
v10: sunTrstInd
v11: prefDestCity
v12: MQS
v13: Hotel loyalty programs stored in DL.com profile (encoded using key 2, see post #829)
v14:
v15: Income, in thousands
v16: Current age + 99
v17: 1/2/3 MM Status
v18: Home value, in thousands
v19:
v20: SkyClub member
v21: SkyMiles account number
v22: Experian Mosaic segment (encoded using keys 1 and 3, see http://www.flyertalk.com/forum/delta...l#post20913445) Description here and Segment Details here
v23: Saved search destination airports (encoded using key 1)
v24: SkyClub renewal date (coded using key 3)
v25: Saved payment information (encoded using key 1) AND SPG status (encoded using key 1, see http://www.flyertalk.com/forum/delta...l#post20913463)
v26: Gender/prefix (1=male/Mr, 2=female/Ms/Mrs, 3=Dr/other) (to be confirmed)
v27:
v28: SkyMiles account number with 3 leading zeros (called "CustID" in previous data)
v29: Logged in (SM account)
v30: Customer Value Score (Questionable, and scale is unknown)
v31: RDM balance
v32: Dream trips from DL.com profile (encoded using key 2)
v33: MQM balance
v34: Activities & Interests from DL.com profile
v35:
v36:
v37:
v38:
v39: ?? Duplicate for Language ??
v40: ?? Duplicate for Country of Residence ??
Encoding
Three different coding keys are used for variables 01, 04, 08, 13, 22, 23, 24, 25, and 32. For full mappings, click here: Keys 1, 2, and 3
Delta and new DL.com Profiles A Lot About You
#406
Join Date: Apr 2005
Location: MSP
Programs: Delta PM, Hertz Plat
Posts: 1,224
I got to see mine, but there is no way I would publish the info here on a public and archived ("forever") forum. Especially the codes that are not clear what they mean. It could be your felony arrest record for all you know.
This is a very informative episode for most of us who never get to look into the data that is being stored and tracked and analyzed by the 1000's of entities we come in contact with. Next time anyone says "Big Data" to you, you now know what they mean.
This is a very informative episode for most of us who never get to look into the data that is being stored and tracked and analyzed by the 1000's of entities we come in contact with. Next time anyone says "Big Data" to you, you now know what they mean.
#407
Suspended
Join Date: Aug 2008
Location: SE US
Programs: Duke of Bombay, Delta Ham Sandwich tm, Delta's Glitch
Posts: 4,201
#408
Join Date: Jul 2011
Location: Baltimore, MD
Programs: Hilton, United, Delta, Hyatt, YMCA
Posts: 242
#410
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
#412
Join Date: Mar 2012
Location: DCA
Programs: DL SkyMiles Platinum Medallion
Posts: 272
Thanks again, BallardFlyer, for the find and the fun!
Yet another example of DL IT's managerial prowess that it took about 15-ish hours to discover this thread and the treasure URL BallardFlyer posted. Maybe this proves DL IT does not read FT ;-)
Yet another example of DL IT's managerial prowess that it took about 15-ish hours to discover this thread and the treasure URL BallardFlyer posted. Maybe this proves DL IT does not read FT ;-)
#413
Join Date: Sep 2009
Location: Hong Kong, Philippines, Alabama
Programs: Delta Skymiles KM (Charter Member)
Posts: 150
I suppose we of course all knew this was happening, but at the same time I think it's normal to find this a little unsettling. Pay no attention to that man behind the curtain. It would be funny some day if we find out a code ment something like "Man, married with family but has latent homosexual tendicies" - effect - market discount airfare in and out of SFO.
Remember the mini scandal when someone who was logged in was getting different pricing then a "guest"? This is how that happens. Let's say you are a delta score "0" aka "gamer status" and you are searching a flight. I also know that you own your own home worth 400k in a zip code where medium avg home value is 250k. I know your income and age. I therefore know that you can afford to pay more but you are gamer and low value on a revenue per mile basis so, no HOOUS coupon for you. Also, since I know you can pay more, I'm not going to offer you discounts I might offer to another demographic.
In the real world this is much more personal and is a two way street. Example, I currently reside in the Philippines. I am a white, American male. When I go to the fish market I typically see the same fish market sales stall owners. They of course profile me immediately. I will get quoted higher prices and they will be less willing to negotiate down. I know this of course. I am a high value customer to them. I can, and am willing, to pay more for my fish than the standard fish market customer. Why would I be ok with this? Well I'm treated with great respect. I always get the best pick of the litter so to speak. I can make requests like "hey tomorrow could you find me more of those prawns you had last week that are f'n gigantic?" they will of course do this because they know I'm willing to pay just a little bit more than the next guy. In my case, maybe it's 25 pesos or 50 pesos more for that 150 peso fish. So maybe .50 cents to a dollar more my cost to get exactly what I want, when I want it. Fair trade.
This is the 21century way to try to do that on a mass scale - but it loses it's personal touch and has a creepy feel.
Remember the mini scandal when someone who was logged in was getting different pricing then a "guest"? This is how that happens. Let's say you are a delta score "0" aka "gamer status" and you are searching a flight. I also know that you own your own home worth 400k in a zip code where medium avg home value is 250k. I know your income and age. I therefore know that you can afford to pay more but you are gamer and low value on a revenue per mile basis so, no HOOUS coupon for you. Also, since I know you can pay more, I'm not going to offer you discounts I might offer to another demographic.
In the real world this is much more personal and is a two way street. Example, I currently reside in the Philippines. I am a white, American male. When I go to the fish market I typically see the same fish market sales stall owners. They of course profile me immediately. I will get quoted higher prices and they will be less willing to negotiate down. I know this of course. I am a high value customer to them. I can, and am willing, to pay more for my fish than the standard fish market customer. Why would I be ok with this? Well I'm treated with great respect. I always get the best pick of the litter so to speak. I can make requests like "hey tomorrow could you find me more of those prawns you had last week that are f'n gigantic?" they will of course do this because they know I'm willing to pay just a little bit more than the next guy. In my case, maybe it's 25 pesos or 50 pesos more for that 150 peso fish. So maybe .50 cents to a dollar more my cost to get exactly what I want, when I want it. Fair trade.
This is the 21century way to try to do that on a mass scale - but it loses it's personal touch and has a creepy feel.
#414
Join Date: Dec 2008
Location: Mostly living in the basement
Programs: Newly minted free agent; MR LT(!)TE, HH SE, BA SECM, DL MM, UA PS, 2V Fanboi, CBP GE
Posts: 5,105
For those who think this is somehow a Delta specific IT fail, it's an artifact of the design of pretty much every modern web site: Your web browser acts like a client and authenticates to a server as you (thus the part where you had to login to see this data), then your web browser customizes your browsing experience according to the data pulled from the server. (See, eg, AJAX.)
GMail, for example, uses this exact model (assuming you use the web interface), only the data it's pulling is your email instead of your home value. Of course, Google has access to lots of data about you, too, that's how they target ads to you. You just haven't discovered the same "breach" (that isn't really a breach) yet.
If you want to get upset at Delta over this, then you need to get upset with almost every other major corporation in the US at the same time. (If you want to get upset at Delta over your CustValSeg being 0, that's a different issue.)
GMail, for example, uses this exact model (assuming you use the web interface), only the data it's pulling is your email instead of your home value. Of course, Google has access to lots of data about you, too, that's how they target ads to you. You just haven't discovered the same "breach" (that isn't really a breach) yet.
If you want to get upset at Delta over this, then you need to get upset with almost every other major corporation in the US at the same time. (If you want to get upset at Delta over your CustValSeg being 0, that's a different issue.)
#415
Join Date: Dec 2005
Location: Likely being followed...
Programs: DYKWIA Extraordinaire. TrollSlayer Mega Diamond. [insert esoteric sounding status level(s) here]
Posts: 5,240
Also, this should be interesting from DL's perception of FT... If we're all valued at 0/1/2/3... FT is a noisy channel of low spenders. But, it might have also borne the fact that there's not just noisy low spenders here... Some of us care about our PM or DM status-- sure... but we might also be their most valuable customers learning from each other and from DL on FT.
DL listens while we talk, you know that.
Like many companies, Delta uses demographic and other data to help provide a personalized experience for our customers, improve how we communicate with them and design offers customized to their interests. While the data displayed was only available to the specific user, we sincerely regret that this code displayed and the confusion it may have caused for our customers. We worked to resolve the issue promptly upon discovering it.
You sir/ma'am must work in marketing. Big Data is the wave of today not yesterday.
#416
Join Date: Jun 2005
Location: AUS
Programs: AA Exec Platinum/MM, DL Gold/MM, Hilton Diamond, Accor Platinum, Hertz Presidents Circle
Posts: 6,939
So it looks like one can no longer see this. I wish I had seen this thread sooner. Isn't it amazing how quickly DL IT can "fix" something when they want to.
#417
Join Date: Dec 2012
Location: ATL F-Terminal
Programs: Hilton C, Marriott Pt, Delta Pt
Posts: 249
On Orbitz, Mac Users Steered to Pricier Hotels
Remember this story?
What if DL were to use this info to steer you to higher priced tickets or award tickets when cheaper tickets are still available?
Remember this story?
What if DL were to use this info to steer you to higher priced tickets or award tickets when cheaper tickets are still available?
#418
Join Date: Jan 2003
Location: Upper Midwest
Programs: DL, AA
Posts: 1,677
For those who think this is somehow a Delta specific IT fail, it's an artifact of the design of pretty much every modern web site: Your web browser acts like a client and authenticates to a server as you (thus the part where you had to login to see this data), then your web browser customizes your browsing experience according to the data pulled from the server. (See, eg, AJAX.)
GMail, for example, uses this exact model (assuming you use the web interface), only the data it's pulling is your email instead of your home value. Of course, Google has access to lots of data about you, too, that's how they target ads to you. You just haven't discovered the same "breach" (that isn't really a breach) yet.
If you want to get upset at Delta over this, then you need to get upset with almost every other major corporation in the US at the same time. (If you want to get upset at Delta over your CustValSeg being 0, that's a different issue.)
GMail, for example, uses this exact model (assuming you use the web interface), only the data it's pulling is your email instead of your home value. Of course, Google has access to lots of data about you, too, that's how they target ads to you. You just haven't discovered the same "breach" (that isn't really a breach) yet.
If you want to get upset at Delta over this, then you need to get upset with almost every other major corporation in the US at the same time. (If you want to get upset at Delta over your CustValSeg being 0, that's a different issue.)
And I'd expect that Delta's customer evaluation model is quite tame compared to Amazon, for example. (How do you think they produce a "recommended for you" list?)
#419
Join Date: Jan 2013
Location: SYD, SIN, LAX, ATL, CVG
Programs: DL Platinum, QF, VA, AA, UA, US, SQ, EK, Hyatt, Hilton, SPG, Fairmont
Posts: 92
Data mining and profiling is a fact of life. I know that Amazon profiles me and recommends me stuff that it thinks that I may be interested. I don't object to profiling and data mining so long as it is accurate. I monitor my credit report and keep an eye on my FICO scores to get the best rates from financial institutions. That said, I'm sad that DL has closed the gates. I would love to see how my DL scores fluctuate over time.
I am still intrigued about my custValSeg and mindsetSeg scores. I am a recently minted PM. From 1996-2011, I was hovering back and forth between FO and no status because 80% of my flights were LUT leisure trips. From 2011-now, I have a new job that requires regular TPAC flights, hence the jump from FO to GM and now PM. In 2012, TPAC flights accounted for 80% of my flights. All my TPAC flights are LUT per employer policy to fly on the cheapest fares.
I don't have any Amex cards, so Amex isn't sharing data with DL for sure. I earn my miles and status the old-fashioned way, i.e., actual flying.
My custValSeg = 1 and my mindsetSeg= BH (which I think means bargain hunter, if it reflects my traveling patterns on budget fares). Does custvalSeg=1 refer to LUT fares being the predominant fares that I fly on?
I would be interested to see how DL plans to use this data.
I am still intrigued about my custValSeg and mindsetSeg scores. I am a recently minted PM. From 1996-2011, I was hovering back and forth between FO and no status because 80% of my flights were LUT leisure trips. From 2011-now, I have a new job that requires regular TPAC flights, hence the jump from FO to GM and now PM. In 2012, TPAC flights accounted for 80% of my flights. All my TPAC flights are LUT per employer policy to fly on the cheapest fares.
I don't have any Amex cards, so Amex isn't sharing data with DL for sure. I earn my miles and status the old-fashioned way, i.e., actual flying.
My custValSeg = 1 and my mindsetSeg= BH (which I think means bargain hunter, if it reflects my traveling patterns on budget fares). Does custvalSeg=1 refer to LUT fares being the predominant fares that I fly on?
I would be interested to see how DL plans to use this data.
#420
Join Date: Jun 2005
Location: AUS
Programs: AA Exec Platinum/MM, DL Gold/MM, Hilton Diamond, Accor Platinum, Hertz Presidents Circle
Posts: 6,939
On Orbitz, Mac Users Steered to Pricier Hotels
Remember this story?
What if DL were to use this info to steer you to higher priced tickets or award tickets when cheaper tickets are still available?
Remember this story?
What if DL were to use this info to steer you to higher priced tickets or award tickets when cheaper tickets are still available?