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, 6:43 pm
#676
Join Date: Apr 2012
Location: NY/CT
Programs: DL PM, Marriott PM
Posts: 263
Awesome. I leave for an hour and already you've put together this list. I had started an alphabetical decoder list, since I doubted we would be able to get all 50 states to chime in and figure out what two letter pairs equal which state. But this list makes it easier for me, instead of having to hunt down each post in the thread. ^
JR = CT (schmoops)
AU = IN (azeckel)
FP = ?? (elkapong)
MW = ?? (davew-krdm)
SM = MO (timmy83, GRAILSTAR)
DZ = GA (pivate message, 18sas)
JZ = CA (TheMadBrewer)
VR = UT (brocklee9000)
UJ = NC (mcmitchell, komalkks, planeluvr)
SU = MN (MSPeconomist, Bago'peanuts, zeebanker, txaggie94)
FP = FL (cmd320)
SZ = MA (beefman003)
U = N
J = C
S = M
R = T
Z = A
Last edited by Schmoops; Jun 12, 2013 at 7:01 pm
Jun 12, 2013, 6:55 pm
#681
Join Date: Apr 2012
Location: NY/CT
Programs: DL PM, Marriott PM
Posts: 263
All these posts and I realized I never shared mine!
v01: OLX
v02: US (country)
v03: Y
v04: PDZ
v05: en (language)
v06: 18 (DiscSPend)
v07: GM (Medallion Level)
v08: JR (State/Province)
v09: N
v10: N
v11: IQN, TMM, NDE, HJQ, TEJ, IXB, BVZ, JNW, UDR (saved destinations)
v12: 32
v13: " "
v14: N
v15: 62 (6years out of date, does correlate with my income when i opened my non-delta amex)
v16: 126 (home value x 1000 ... i've only owned one home, my current home, and that is not even close)
v17: " "
v18: " "
v19: N
v20: N (no skyclub for me)
v21: 930XXXXXXX
v22: EPB
v23: NXI, LOK, IXB (saved searches)
v24: " "
v25: NORI
v26: 2
v27: Y
v28: 000930XXXXXXX
v29: Y
v30: 2
v31: 169157
v32: " "
v33: 73215
v34: " "
v35: Y
v36: N
v37: " "
When comparing this list to the previous one a few months ago, I noted that Gender, Zipcode and DOB are no longer on the list.
v01: OLX
v02: US (country)
v03: Y
v04: PDZ
v05: en (language)
v06: 18 (DiscSPend)
v07: GM (Medallion Level)
v08: JR (State/Province)
v09: N
v10: N
v11: IQN, TMM, NDE, HJQ, TEJ, IXB, BVZ, JNW, UDR (saved destinations)
v12: 32
v13: " "
v14: N
v15: 62 (6years out of date, does correlate with my income when i opened my non-delta amex)
v16: 126 (home value x 1000 ... i've only owned one home, my current home, and that is not even close)
v17: " "
v18: " "
v19: N
v20: N (no skyclub for me)
v21: 930XXXXXXX
v22: EPB
v23: NXI, LOK, IXB (saved searches)
v24: " "
v25: NORI
v26: 2
v27: Y
v28: 000930XXXXXXX
v29: Y
v30: 2
v31: 169157
v32: " "
v33: 73215
v34: " "
v35: Y
v36: N
v37: " "
When comparing this list to the previous one a few months ago, I noted that Gender, Zipcode and DOB are no longer on the list.
Last edited by Schmoops; Jun 12, 2013 at 7:14 pm
Jun 12, 2013, 6:57 pm
#682
Join Date: Apr 2012
Location: NY/CT
Programs: DL PM, Marriott PM
Posts: 263
Jun 12, 2013, 6:59 pm
#683
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
Jun 12, 2013, 6:59 pm
#684
Join Date: Jul 2011
Location: Washington, DC
Programs: DL DM; UA Gold; SPG Titanium
Posts: 31
here's the update (post #654 also current)
JJR = CT (schmoops)
AU = IN (azeckel)
FP = ?? (elkapong)
MW = ?? (davew-krdm)
SM = MO (timmy83, GRAILSTAR)
DZ = GA (pivate message, 18sas)
JZ = CA (TheMadBrewer)
VR = UT (brocklee9000)
UJ = NC (mcmitchell, komalkks, planeluvr)
SU = MN (MSPeconomist, Bago'peanuts, zeebanker, txaggie94)
FP = FL (cmd320)
U = N
J = C
S = M
R = T
Z = A
JJR = CT (schmoops)
AU = IN (azeckel)
FP = ?? (elkapong)
MW = ?? (davew-krdm)
SM = MO (timmy83, GRAILSTAR)
DZ = GA (pivate message, 18sas)
JZ = CA (TheMadBrewer)
VR = UT (brocklee9000)
UJ = NC (mcmitchell, komalkks, planeluvr)
SU = MN (MSPeconomist, Bago'peanuts, zeebanker, txaggie94)
FP = FL (cmd320)
U = N
J = C
S = M
R = T
Z = A
Jun 12, 2013, 7:04 pm
#686
Join Date: Apr 2012
Location: NY/CT
Programs: DL PM, Marriott PM
Posts: 263
Jun 12, 2013, 7:09 pm
#687
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001
v04 is your departure airport/city, encoded using a different mapping from what v01 uses.
v01, v23, and v25 use the same letter key. v04 and v08 use a second letter key. I'm still figuring out the keys for v13 and v22.
v01, v23, and v25 use the same letter key. v04 and v08 use a second letter key. I'm still figuring out the keys for v13 and v22.
Jun 12, 2013, 7:12 pm
#688
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,277
Could any of those mishmashed strings of codes have to do with other airlines, such as known FF programs?
I also am not convinced about the home value. I live in an apartment, and it's a 500 unit complex; it's mostly owned by central management but some units are individually owned/leased, so maybe that's why they have a value associated to them? That's the only way I could see it being listed as 261.
I also am not convinced about the home value. I live in an apartment, and it's a 500 unit complex; it's mostly owned by central management but some units are individually owned/leased, so maybe that's why they have a value associated to them? That's the only way I could see it being listed as 261.
Jun 12, 2013, 7:13 pm
#689
Join Date: Apr 2012
Location: NY/CT
Programs: DL PM, Marriott PM
Posts: 263
Jun 12, 2013, 7:21 pm
#690
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
I'm 22. And no, it would only be a fraction of my parents' home. I'll chalk it up to erroneous numbers, as many have reported that the number do/don't reflect their salary, home value, etc.