Go Back  FlyerTalk Forums > Miles&Points > Airlines and Mileage Programs > Delta Air Lines | SkyMiles
Reload this Page >

Delta and new DL.com Profiles A Lot About You

Register
Community
Wiki Posts
Today's Posts
Search
Old Jun 12, 2013, 7:24 pm
FlyerTalk Forums Expert How-Tos and Guides
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
Print Wikipost

Delta and new DL.com Profiles A Lot About You

Thread Tools
 
Search this Thread
 
Old Jun 12, 2013, 5:33 pm
  #661  
 
Join Date: Dec 2004
Location: LHR / BHX / MAN / ATL
Programs: DL DM 2MM - IHG Diamond
Posts: 4,053
Originally Posted by GRALISTAIR
V20 is Y for me - I am a paid Skyclub member - so this looks increasingly possible.
I am not a SkyClub member and V20 for me is N
ecaarch is offline  
Reply
Old Jun 12, 2013, 5:33 pm
  #662  
 
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
Originally Posted by DLItaly
checked 3 account (2 with Skyclub, 1 without SkyClub) the only y/n difference is on v20.

v20 = SkyClub Member ???
Originally Posted by GRALISTAIR
V20 is Y for me - I am a paid Skyclub member - so this looks increasingly possible.
edit:So 2 from DLItaly for v20=Y and 1 v20=N, 1 from GRALISTAIR v=20, 1 from ecaarch v20=N. GRALISTAIR specifically mentioned a paid SC membership; any assumptions as to whether this would be lumped into general SC memberships, or a standalone value?
Last edited by brocklee9000; Jun 12, 2013 at 5:38 pm
brocklee9000 is offline  
Reply
Old Jun 12, 2013, 5:35 pm
  #663  
 
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
Originally Posted by GRALISTAIR
Completely off topic, but I just love this pooled FT resource in full investigation and problem solving mode. ^
Right now my list has 16/37 values identified (either confirmed or reasonably likely). Now we just need to make a separate matrix as a decoder for the airport codes.
brocklee9000 is offline  
Reply
Old Jun 12, 2013, 5:35 pm
  #664  
 
Join Date: Apr 2009
Location: RDU
Programs: AA, EXP. DL, DM 1MM. HHonors, Diamond. Hertz, PC. National, EE.
Posts: 259
My v08 = UJ
I'm in NC, RDU based.
mcmitchell is offline  
Reply
Old Jun 12, 2013, 5:36 pm
  #665  
 
Join Date: Jan 2008
Location: KATL
Programs: DL DM/2MM
Posts: 2,034
Originally Posted by Schmoops

If anyone reading these has the same code, and lives in the same state - let me know.

v08 = State

JR = CT (schmoops)
AU = ?? (azeckel)
FP = ?? (elkapong)
MW = ?? (davew-krdm)
SM = MO (timmy83, GRAILSTAR)
DZ = GA
JZ = CA (TheMadBrewer)
VR = UT (brocklee9000)
My V08 code is DZ, so DZ=GA fits.

I only wish V18 x $1,000 were my home value.
Last edited by 18sas; Jun 12, 2013 at 6:04 pm
18sas is offline  
Reply
Old Jun 12, 2013, 5:42 pm
  #666  
 
Join Date: Sep 2006
Location: LAX
Programs: Fallen DL DM (PM) 2MM
Posts: 4,783
Originally Posted by brocklee9000
edit:So 2 from DLItaly for v20=Y and 1 v20=N, 1 from GRALISTAIR v=20, 1 from ecaarch v20=N. GRALISTAIR specifically mentioned a paid SC membership; any assumptions as to whether this would be lumped into general SC memberships, or a standalone value?
I am a DM but have a paid SC membership "on hold" and have V20 =Y

Somebody upthread said they were a Centurion Card holder -- do you have either V10 or V36 as "Y" -- if so, that is probably that flag. Ditto for anybody who as the SM SunTrust card.
TheMadBrewer is offline  
Reply
Old Jun 12, 2013, 5:45 pm
  #667  
 
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
Originally Posted by TheMadBrewer
I am a DM but have a paid SC membership "on hold" and have V20 =Y

Somebody upthread said they were a Centurion Card holder -- do you have either V10 or V36 as "Y" -- if so, that is probably that flag. Ditto for anybody who as the SM SunTrust card.
Okay. Just wasn't sure if there was a difference between paid SC/complimentary DM skyclub/amex reserve access.
brocklee9000 is offline  
Reply
Old Jun 12, 2013, 6:08 pm
  #668  
 
Join Date: Feb 2010
Location: WLG / WAS
Programs: DL PM, QF, UA, HH Gold, SPG
Posts: 135
Originally Posted by Schmoops
v08 ... does everyone have two (2) alphabetic characters for v08?
Nope. Mine is blank, but if it's state (which it seems to be), that fits since I have an overseas address (NZ).
LabCat is offline  
Reply
Old Jun 12, 2013, 6:15 pm
  #669  
 
Join Date: Oct 2009
Location: GSO
Programs: Delta Skymiles - Diamond; HH - Diamond; Priority Club - Platinum;
Posts: 136
Originally Posted by mcmitchell
My v08 = UJ
I'm in NC, RDU based.
Mine too and I live in GSO (NC)
komalkks is offline  
Reply
Old Jun 12, 2013, 6:18 pm
  #670  
 
Join Date: Oct 2009
Location: IND
Programs: DL DM, SPG AMB, National EE
Posts: 1,301
Originally Posted by Schmoops

I'm gonna bet this is the state you live in. let me know what your two letters are, and the state you live in and perhaps someone else can verify if they live in the same state... (I'll try to keep this post updated - and feel free to edit your previous post if you dont want to add another one)

If anyone reading these has the same code, and lives in the same state - let me know.

v08 = State

JR = CT (schmoops)
AU = ?? (azeckel)
FP = ?? (elkapong)
MW = ?? (davew-krdm)
SM = MO (timmy83, GRAILSTAR)
DZ = GA (pivate message, 18sas)
JZ = CA (TheMadBrewer)
VR = UT (brocklee9000)
UJ = NC (mcmitchell)
I'm in IN ... and if you look at UJ = NC so U=N. This is fun! It's like a decoder puzzle.

As for V20 - I'm a DM non-paid SC member and I have a Y
azeckel is offline  
Reply
Old Jun 12, 2013, 6:22 pm
  #671  
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
For v08, SU = MN
MSPeconomist is offline  
Reply
Old Jun 12, 2013, 6:28 pm
  #672  
 
Join Date: Dec 2003
Location: St. Paul, MN
Programs: Walmart Super Elite
Posts: 727
Originally Posted by MSPeconomist
For v08, SU = MN
Same here.
Bago'peanuts is offline  
Reply
Old Jun 12, 2013, 6:29 pm
  #673  
 
Join Date: Jul 2003
Location: MSP
Posts: 185
V08 = SU
I live in MN as well.

My other values:
v01 :QNL
v02 :US
v03 :Y
v04 :""
v05 :en
v06 :32
v07 :GM
v08 :SU
v09 :Y
v10 :N
v11 :""
v12 :8
v13 :""
v14 :N
v15 :1xx (which is wrong or old)
v16 :139
v17 :""
v18 :363 (I wish)
v19 :Y
v20 :N
v21 :695xxxxxx
v22 :CHH
v23 :QNL,NJX
v24 :""
v25 :IKBL
v26 :1
v27 :Y
v28 :000695xxxxx
v29 :Y
v30 :5
v31 :17,xxx
v32 :""
v33 :18,xxx
v34 :""
v35 :Y
v36 :N
v37 :""
Last edited by zeebanker; Jun 12, 2013 at 6:36 pm Reason: Added more info
zeebanker is offline  
Reply
Old Jun 12, 2013, 6:36 pm
  #674  
 
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
Originally Posted by Schmoops

I'm gonna bet this is the state you live in. let me know what your two letters are, and the state you live in and perhaps someone else can verify if they live in the same state... (I'll try to keep this post updated - and feel free to edit your previous post if you dont want to add another one)

If anyone reading these has the same code, and lives in the same state - let me know.

v08 = State

JR = CT (schmoops)
AU = ?? (azeckel)
FP = ?? (elkapong)
MW = ?? (davew-krdm)
SM = MO (timmy83, GRAILSTAR)
DZ = GA (pivate message, 18sas)
JZ = CA (TheMadBrewer)
VR = UT (brocklee9000)
UJ = NC (mcmitchell)
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. ^
brocklee9000 is offline  
Reply
Old Jun 12, 2013, 6:40 pm
  #675  
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
Don't forget SU = MN, which initially scared me as I don't want DL to think that I'm an Aeroflot FFer.
MSPeconomist is offline  
Reply



Advanced Search
Reply Closed Thread Share
Forum Jump

Contact Us - Manage Preferences - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.