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 12, 2013, 2:29 pm
#571
Join Date: Oct 2007
Programs: Now just a lowly DL PM/1MM. This industry needs some competition. It's just not enjoyable anymore.
Posts: 3,543
Jun 12, 2013, 2:30 pm
#572
Join Date: Mar 2011
Programs: Marriott LT Platinum+Titanium Elite, Hyatt Globalist, AA EXP, Delta Plat, United Silver, AX Biz Cent
Posts: 705
For me, v15=31, v06=43.
How could discretionary be higher than income?
Never-mind both of these values are way lower than reality.
v26=1
v30=0
If this is true, I guess I'm not terribly surprised, I'm a comped DL Plat from AX Centurion, and don't even fly enough for FO, and generally on cheap tickets -- though sometimes expensive coach, and rarely (but sometimes) paid FC.
How could discretionary be higher than income?
Never-mind both of these values are way lower than reality.
v26=1
v30=0
If this is true, I guess I'm not terribly surprised, I'm a comped DL Plat from AX Centurion, and don't even fly enough for FO, and generally on cheap tickets -- though sometimes expensive coach, and rarely (but sometimes) paid FC.
Jun 12, 2013, 2:30 pm
#573
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,413
Jun 12, 2013, 2:34 pm
#574
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
V30 is CSV (customer score value)
V12, indeed- segments (MQS)
V17- MM status
V31,33- SM balance and year MQM, respectively
V12, indeed- segments (MQS)
V17- MM status
V31,33- SM balance and year MQM, respectively
Last edited by DLroads; Jun 12, 2013 at 2:40 pm
Jun 12, 2013, 2:35 pm
#575
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001
Jun 12, 2013, 2:39 pm
#576
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
Jun 12, 2013, 2:42 pm
#577
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,413
Jun 12, 2013, 2:45 pm
#578
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
For me, v15=31, v06=43.
How could discretionary be higher than income?
Never-mind both of these values are way lower than reality.
v26=1
v30=0
If this is true, I guess I'm not terribly surprised, I'm a comped DL Plat from AX Centurion, and don't even fly enough for FO, and generally on cheap tickets -- though sometimes expensive coach, and rarely (but sometimes) paid FC.
How could discretionary be higher than income?
Never-mind both of these values are way lower than reality.
v26=1
v30=0
If this is true, I guess I'm not terribly surprised, I'm a comped DL Plat from AX Centurion, and don't even fly enough for FO, and generally on cheap tickets -- though sometimes expensive coach, and rarely (but sometimes) paid FC.
And if 30 is customer value, then I'm a good ol' 0, just like everyone else who has posted.
Jun 12, 2013, 2:48 pm
#580
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
Jun 12, 2013, 2:48 pm
#581
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
Then it could be, since GRALISTAIR reported 37 segments and high milage due to frequent TATL, and that merited a 2. I can see how exclusively international BE can garner a high customer value. I just find it (sadly) humorous that so many of us are a big fat zero...
Jun 12, 2013, 2:49 pm
#582
Join Date: Feb 2007
Location: DCA
Programs: DL (ex-NW) Plat pining for self-serve WC's and real cheese
Posts: 715
Jun 12, 2013, 2:51 pm
#584
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
Jun 12, 2013, 2:53 pm
#585
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
V25 for me is IKBL,NORT so if we believe this to be stored credit cards, I am almost certain I have only got 1 credit card stored on DL.com and that is a North American issued DL Platinum Amex. So that would mean that IKBL,NORT means DL Plat Amex, USA Bank issued.