Jun 12, 2013, 7:24 pm
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
Feb 24, 2013, 5:27 pm
#526
FlyerTalk Evangelist
Join Date: Apr 2009
Location: Bye Delta
Programs: AA EXP, HH Diamond, IHG Plat, Hyatt Plat, Marriott Plat, Nat'l Exec Elite, Avis Presidents Club
Posts: 16,276
Mar 4, 2013, 4:22 pm
#527
Join Date: Oct 2004
Location: PDX
Posts: 2,284
We knew it was coming
An editorial in the New York Times yesterday. Looks like this is how this website data may be used:
Frequent Fliers, Prepare to Pay More
Frequent Fliers, Prepare to Pay More
Originally Posted by New York Times
The new standard, which was agreed to at a meeting of the International Air Transport Association in October, will allow airlines to ask customers searching for airfares through travel agents or Web sites to first provide their names, frequent flier numbers, contact details and other information before presenting them with prices. A few airlines are expected to test this approach this year, and it could be widely adopted in a few years, according to the trade group. A majority of the group’s 240 members, which include most American airlines though not Southwest, voted for the standard.
Mar 4, 2013, 4:25 pm
#528
FlyerTalk Evangelist
Join Date: Oct 2011
Location: Anywhere I need to be.
Programs: OW Emerald, *A Gold, NEXUS, GE, ABTC/APEC, South Korea SES, eIACS, PP, Hyatt Diamond
Posts: 16,046
An editorial in the New York Times yesterday. Looks like this is how this website data may be used:
Frequent Fliers, Prepare to Pay More
Frequent Fliers, Prepare to Pay More
Better yet, simply use another carrier for the ticketing carrier so that they have no control over it.
Besides, I don't see TAs being a big fan of this either-more work for them.
Mar 4, 2013, 4:28 pm
#530
FlyerTalk Evangelist
Join Date: Oct 2011
Location: Anywhere I need to be.
Programs: OW Emerald, *A Gold, NEXUS, GE, ABTC/APEC, South Korea SES, eIACS, PP, Hyatt Diamond
Posts: 16,046
The government should make that illegal-pricing items differently due to past purchasing behavior.
Mar 4, 2013, 4:41 pm
#531
FlyerTalk Evangelist
Join Date: Jun 2004
Location: MSP
Programs: DL PM, MM, NR; HH Diamond, Bonvoy LT Gold, Hyatt Explorist, IHG Diamond, others
Posts: 12,159
Mar 4, 2013, 4:56 pm
#532
Join Date: Oct 2004
Location: PDX
Posts: 2,284
Showing you a different price list than they show others, from which your discount is based, simply due to your perceived ability to pay more or from past experience as a customer, should be illegal.
Mar 4, 2013, 5:22 pm
#533
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001
This is interesting news...
^ As long as this remains true, I don't think there should be a problem.
They also say customers will still have the option of shopping anonymously for basic fares if they choose not to provide any information about themselves.
Mar 4, 2013, 5:34 pm
#534
Join Date: Oct 2004
Location: PDX
Posts: 2,284
Airlines will also have a big incentive to present much higher basic prices when customers shop anonymously to encourage them to provide more information about themselves in order to see “special deals.”
Mar 5, 2013, 5:29 am
#536
FlyerTalk Evangelist
Join Date: Sep 2007
Location: BOS
Programs: DL DM 2MM, Marriott LT Titanium, Hertz PC, Avis PC
Posts: 15,202
Here is another interesting article... and note the focus on NDC. That is likely the thing which DL was/is using to mine and store personal and demographic info about us.
http://atwonline.com/it-distribution...+Daily+News%29
http://atwonline.com/it-distribution...+Daily+News%29
IATA says its NDC project aims to enable airlines to create personalized offers for travel shoppers based on demographic information, loyalty status, history with the airline and other factors.
Mar 5, 2013, 9:13 am
#537
FlyerTalk Evangelist
Join Date: Jun 2004
Location: MSP
Programs: DL PM, MM, NR; HH Diamond, Bonvoy LT Gold, Hyatt Explorist, IHG Diamond, others
Posts: 12,159
What about, say, showing me the same price list, but with a note saying "Because you're a Preferred Customer, you get 10% off"? What about them sending me a coupon for 10% off because I bought stuff before? What about them offering me free upgrades because I bought stuff before?
Jun 12, 2013, 1:02 pm
#538
Join Date: Feb 2008
Location: JFK,ATL,LGA (the rest of the world follows)
Programs: DL KM/DM/2MM (NH Plat emeritus, CO Plat emeritus, and no place like home)
Posts: 3,190
Bringing this one from the deep archives... If you will run the script in post #1 again you will get to see alot of the stuff again. Yes, it is marked as V01 to V37 instead of the previous code. The order of variables has slightly changed, and some of the data is replaced with codes, but you can figure out most of it.
Jun 12, 2013, 1:30 pm
#539
Join Date: Mar 2011
Programs: Marriott LT Platinum+Titanium Elite, Hyatt Globalist, AA EXP, Delta Plat, United Silver, AX Biz Cent
Posts: 705
This is the first time I'm seeing this thread. If anyone can post explanations of what they have figured out with what the various fields mean, I am very curious. I suspect it would be a lot easier to figure out what fields mean what if you have seen this data before the obfuscation was added, but the value by themselves don't really stand out as having any meaning to me.
Jun 12, 2013, 1:34 pm
#540
Join Date: Jun 2006
Location: NYC
Programs: DL PM MM SC; GE; Bonvoy Titanium; IHG Diamond
Posts: 2,310
Most of what I see is pretty indecipherable to me, other than my status and SM number. And a lot of the fields are empty - I'm seeing lots of " " with nothing there. No clue what HBEHBXBE and IK,IKTL,NORI mean.