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, 9:11 pm
#736
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001
Could a few more people post their v22? I just need a couple more data points to complete the key. So far I have the following:
CHH
EPB
EPE
EPN
EPK
FEX
IBE
IBR
MKV
MNB
ZHP
EDITED: Decoding complete! See http://www.flyertalk.com/forum/delta...l#post20913445 for explanation.
CHH
EPB
EPE
EPN
EPK
FEX
IBE
IBR
MKV
MNB
ZHP
EDITED: Decoding complete! See http://www.flyertalk.com/forum/delta...l#post20913445 for explanation.
Last edited by lamont2718; Jun 12, 2013 at 9:56 pm
Jun 12, 2013, 9:11 pm
#737
Join Date: Jul 2008
Location: Redmond, OR
Programs: AS MVP Gold, HHonors Silver, Marriott Titanium (Lifetime Platinum), UA Silver, OW Sapphire
Posts: 709
Here's my shtuff:
{"v01":"RVQ", - RDM is my closest airport
"v02":"US",
"v03":"Y",
"v04":"WNS", - RDM is my preferred airport
"v05":"en",
"v06":"22",
"v07":"PM", - accurate
"v08":"MW", - OR is my state
"v09":"Y",
"v10":"N",
"v11":"",
"v12":"42", - MQS, Accurate
"v13":"",
"v14":"N",
"v15":"XXX", -the number here is eerily accurate
"v16":"149",
"v17":"",
"v18":"",
"v19":"Y",
"v20":"N",
"v21":"XXXXXXXXXX", - accurate SM number, obfuscated here
"v22":"XNR",
"v23":"ZRS,ZJZ", - GRU, GIG are saved airports
"v24":"",
"v25":"IKBD", - Accurate, DL Reseve
"v26":"1",
"v27":"Y",
"v28":"XXXXXXXXXXXXX", accurate SM number + leading zeroes
"v29":"Y",
"v30":"3", Value score is same as it was last time
"v31":"173099", - Correct RDM
"v32":"",
"v33":"94151", - Correct MQM
"v34":"",
"v35":"Y",
"v36":"N",
"v37":""}
{"v01":"RVQ", - RDM is my closest airport
"v02":"US",
"v03":"Y",
"v04":"WNS", - RDM is my preferred airport
"v05":"en",
"v06":"22",
"v07":"PM", - accurate
"v08":"MW", - OR is my state
"v09":"Y",
"v10":"N",
"v11":"",
"v12":"42", - MQS, Accurate
"v13":"",
"v14":"N",
"v15":"XXX", -the number here is eerily accurate
"v16":"149",
"v17":"",
"v18":"",
"v19":"Y",
"v20":"N",
"v21":"XXXXXXXXXX", - accurate SM number, obfuscated here
"v22":"XNR",
"v23":"ZRS,ZJZ", - GRU, GIG are saved airports
"v24":"",
"v25":"IKBD", - Accurate, DL Reseve
"v26":"1",
"v27":"Y",
"v28":"XXXXXXXXXXXXX", accurate SM number + leading zeroes
"v29":"Y",
"v30":"3", Value score is same as it was last time
"v31":"173099", - Correct RDM
"v32":"",
"v33":"94151", - Correct MQM
"v34":"",
"v35":"Y",
"v36":"N",
"v37":""}
Jun 12, 2013, 9:15 pm
#739
In memoriam, FlyerTalk Evangelist
Join Date: May 2005
Location: PIT
Programs: DM life is over 2MM PM now & NW MillionAir Wyndham Rewards Plat -Hotels.com Silver -Accor Silver
Posts: 15,408
I understand the NSA has a vacancy in their HNL office, for anyone here who wants to apply!
Jun 12, 2013, 9:16 pm
#740
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
yes V23 is definitely saved destination airport and key 1 makes sense. I wondered why I had NXX, QIX, QIX which is SNN and MAN - then I checked and saw I had MAN down twice - one as trip home and the other as UK home. So defnitely makes sense.
Jun 12, 2013, 9:18 pm
#741
In memoriam, FlyerTalk Evangelist
Join Date: May 2005
Location: PIT
Programs: DM life is over 2MM PM now & NW MillionAir Wyndham Rewards Plat -Hotels.com Silver -Accor Silver
Posts: 15,408
Jun 12, 2013, 9:19 pm
#742
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,273
Jun 12, 2013, 9:22 pm
#743
Join Date: Aug 2003
Location: Washington,DC
Posts: 1,822
$32K seems low for annual spend, so it probably relates more to $ and fare types than just dollars spent. Wish I knew if 32 was good. Maybe Delta corp guy will tell us the ranking :-)
Jun 12, 2013, 9:22 pm
#744
Join Date: Jul 2008
Location: Redmond, OR
Programs: AS MVP Gold, HHonors Silver, Marriott Titanium (Lifetime Platinum), UA Silver, OW Sapphire
Posts: 709
Dave
Jun 12, 2013, 9:27 pm
#745
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
Jun 12, 2013, 9:27 pm
#746
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,273
I thought it was on a 0.0 to 4.0 scale... so 32 would represent a 3.2.
Jun 12, 2013, 9:33 pm
#748
Join Date: Sep 2010
Location: Summit County UT
Programs: Delta PM Hilton Diamond Bonvoy Ti/LTP Hertz PC
Posts: 636
[QUOTE=DLGrkItalNY;20911849]
This thread is moving fast enough that I'm a few pages behind but wanted to post quickly about this field. And btw great job everyone, JFC this is good stuff and fun/fascinating to read in real time...
v22 for me is NORL. I have no DL credit cards, and no airline CCs at all. I have also never bought a flight directly on delta.com. Only through my corp travel site, on my corp amex. So NORL may be a Corporate Platinum Amex
v22 for me is NORL. I have no DL credit cards, and no airline CCs at all. I have also never bought a flight directly on delta.com. Only through my corp travel site, on my corp amex. So NORL may be a Corporate Platinum Amex