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
Jun 13, 2013, 11:38 am
#916
Suspended
Join Date: Dec 2009
Location: HKG
Programs: DL FO, UA, AA, AsiaMiles, SPG, HHonors
Posts: 7,982
Jun 13, 2013, 11:43 am
#917
Join Date: Dec 2003
Location: St. Paul, MN
Programs: Walmart Super Elite
Posts: 728
Was the IFE in Y or BE?
My v30 is 6, and I had a broken IFE in BE on an international itinerary. I wrote in not to complain but to compliment the FA on how she handled the situation and how pleasant the flight was overall. I specifically asked not to be compensated. They gave me 15K miles anyway, which from what I've read here seems like standard comp for that problem.
FTR I didn't like that because I know they keep track of how much they compensate you and how much you complain and someday I may have a real complaint for which I really want compensation and I want them to take it seriously and not think I complain to them about everything. I frequently send compliments, very rarely complaints... pretty much the opposite of my posting here on FT!
My v30 is 6, and I had a broken IFE in BE on an international itinerary. I wrote in not to complain but to compliment the FA on how she handled the situation and how pleasant the flight was overall. I specifically asked not to be compensated. They gave me 15K miles anyway, which from what I've read here seems like standard comp for that problem.
FTR I didn't like that because I know they keep track of how much they compensate you and how much you complain and someday I may have a real complaint for which I really want compensation and I want them to take it seriously and not think I complain to them about everything. I frequently send compliments, very rarely complaints... pretty much the opposite of my posting here on FT!
Jun 13, 2013, 11:46 am
#918
Join Date: Jun 2009
Location: DTW
Programs: DL Diamond/2.2MM
Posts: 113
Jun 13, 2013, 11:46 am
#919
Join Date: Jul 2010
Location: SUX
Programs: BA Silver; HHonors Gold; SPG Gold; Points but dirt with everyone else
Posts: 8,050
Nope, only male bits here. I reviewed my history in this thread and I had a 3 in the number of children category before, so could that be it? Or else they have some sort of überawareness program going on and are coding gay males and straight males differently.
Jun 13, 2013, 11:51 am
#921
Join Date: Mar 2009
Location: Los Angeles
Programs: Hilton Diamond, IHG Silver
Posts: 477
Jun 13, 2013, 12:26 pm
#924
Join Date: Jan 2007
Posts: 5,679
I have a severe problem with the fact that Experian - who I have no business relationship with - turns my the supposedly confidential income, creditworthiness and personal demographic detail into a marketing tool for big companies like Delta. They have a stranglehold on this information (along with TransUnion and Equifax) and I have no choice but to agree to them having access to my credit and personal financial information. For them to then turn that into a market segmentation service has always rubbed me raw, but it makes me especially mad when I see how this data is being used.
Jun 13, 2013, 12:29 pm
#925
Join Date: Jul 2012
Posts: 1,079
Everything in here is pretty amazingly accurate for me, including most recent financial and other demographic data - so I can only assume that Delta obtained this from my credit report.
Jun 13, 2013, 12:36 pm
#926
Join Date: Dec 2002
Location: Washington, D.C.
Programs: UA Premier 1K: PlAAtinum; DL SM, MM; Marriott Gold; CO Plat Emeritus; NW Plat Emeritus
Posts: 4,776
I have a severe problem with the fact that Experian - who I have no business relationship with - turns my the supposedly confidential income, creditworthiness and personal demographic detail into a marketing tool for big companies like Delta. They have a stranglehold on this information (along with TransUnion and Equifax) and I have no choice but to agree to them having access to my credit and personal financial information. For them to then turn that into a market segmentation service has always rubbed me raw, but it makes me especially mad when I see how this data is being used.
Dang do we need privacy laws in this country. Sorry, OT...
Jun 13, 2013, 12:37 pm
#927
Join Date: Sep 2009
Location: LAX
Programs: Hilton Gold, Hyatt Explorist, Sixt Diamond, Hertz PC, Bonvoy Gold, UA G
Posts: 596
I'm really questioning wether v30 is really the customer value score. My father who flies a ton on Y fares has a 0. Also my dad is Y for V19 my mom is N...both have travelled internationally, have cards on file, have AMEX cards, both are PMs. It may be wether they think you have status with another company but my V19 is N and I have status with UA and WN.
Also I'm laughing at the income projections for my parents projected income is less than half of what their projected discretionary is and both are off (low by the hundreds of thousands).
Also I'm laughing at the income projections for my parents projected income is less than half of what their projected discretionary is and both are off (low by the hundreds of thousands).
Last edited by skyvanman; Jun 13, 2013 at 12:58 pm
Jun 13, 2013, 12:55 pm
#928
A FlyerTalk Posting Legend
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: 100,417
Jun 13, 2013, 1:00 pm
#929
FlyerTalk Evangelist
Join Date: Jun 2008
Programs: Formaldehyde Medallion DL DieMiles
Posts: 12,646
Jun 13, 2013, 1:02 pm
#930
A FlyerTalk Posting Legend
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: 100,417
Was the IFE in Y or BE?
My v30 is 6, and I had a broken IFE in BE on an international itinerary. I wrote in not to complain but to compliment the FA on how she handled the situation and how pleasant the flight was overall. I specifically asked not to be compensated. They gave me 15K miles anyway, which from what I've read here seems like standard comp for that problem.
FTR I didn't like that because I know they keep track of how much they compensate you and how much you complain and someday I may have a real complaint for which I really want compensation and I want them to take it seriously and not think I complain to them about everything. I frequently send compliments, very rarely complaints... pretty much the opposite of my posting here on FT!
My v30 is 6, and I had a broken IFE in BE on an international itinerary. I wrote in not to complain but to compliment the FA on how she handled the situation and how pleasant the flight was overall. I specifically asked not to be compensated. They gave me 15K miles anyway, which from what I've read here seems like standard comp for that problem.
FTR I didn't like that because I know they keep track of how much they compensate you and how much you complain and someday I may have a real complaint for which I really want compensation and I want them to take it seriously and not think I complain to them about everything. I frequently send compliments, very rarely complaints... pretty much the opposite of my posting here on FT!
I'm surprised. I would have expected some data on the types of complaints people file.