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, 10:48 pm
  #781  
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,369
Originally Posted by lamont2718
It looks like you are using Key 2 as the index. You should use the first column as the index instead; the Key 2 column is relevant only for v04 and v08.
No, I'm using Key 1 to translate the first letter E to the letter O. Then I'm looking at Key 3 to translate the second and third letters, namely P and something, to numbers. On Chart 3, the letter P becomes 3, not 5. (The letter L would become 5, but I'm looking at codes that are EPsomething, not ELsomething.)
MSPeconomist is offline  
Reply
Old Jun 12, 2013, 10:54 pm
  #782  
FlyerTalk Evangelist
 
Join Date: May 2012
Location: MCO
Programs: AA, B6, DL, EK, EY, QR, SQ, UA, Amex Plat, Marriott Tit, HHonors Gold
Posts: 12,809
Originally Posted by MSPeconomist
No, I'm using Key 1 to translate the first letter E to the letter O. Then I'm looking at Key 3 to translate the second and third letters, namely P and something, to numbers. On Chart 3, the letter P becomes 3, not 5. (The letter L would become 5, but I'm looking at codes that are EPsomething, not ELsomething.)
After determining the first letter, then forget the second two columns all together. Use column 1 on the far left which is the index and match the P from there across the row to key 3 and you should come up with 5. By the same logic, K from the index should be matching up with the 3 in the third key, L shouldn't be anything in key 3.
cmd320 is offline  
Reply
Old Jun 12, 2013, 11:01 pm
  #783  
 
Join Date: Nov 2010
Location: BDL/HPN/JFK/FLL
Programs: DL Diamond Ham Sandwich
Posts: 1,051
Originally Posted by twohundredfifty
Yeah, my profile is that of an old guy.I'll get there eventually.
Ha! I looked up the longer description of the J33 "Aging in Place" that I was assigned!

"In their carintensive communities, they still like smooth-cruising vehicles that can handle the interstates - brands like Cadillac and Lincoln." and the key traits include "Social Conservative", and "Charitable donors".

I have a Cadillac- which they would know.
I fiscally supported a local Republican, and I do give to charity, which they would know...

But my Cadillac has 556hp and a 6 speed manual transmission, the Republican was at risk of losing their Senate seat for supporting gay marriage, and I don't do it because I fear G-d...

It's amazing how a little bad data can cause a whole slew of other data to be misinterpreted.
mother- is offline  
Reply
Old Jun 12, 2013, 11:02 pm
  #784  
 
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001
Originally Posted by MSPeconomist
No, I'm using Key 1 to translate the first letter E to the letter O. Then I'm looking at Key 3 to translate the second and third letters, namely P and something, to numbers. On Chart 3, the letter P becomes 3, not 5. (The letter L would become 5, but I'm looking at codes that are EPsomething, not ELsomething.)
MSPeconomist, for the purposes of decoding the second and third characters in v22, just pretend that the columns in between "Index" and "Key 3" don't exist. You will see that after finding "P" in the "Index" column, the number "5" appears in the same row in the "Key 3" column.

As another example, "B" in the "Index" column corresponds to "0" in the "Key 3" column.

Edit: Apologies to cmd320 -- did not see your post above in time.
lamont2718 is offline  
Reply
Old Jun 12, 2013, 11:03 pm
  #785  
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,369
Originally Posted by cmd320
After determining the first letter, then forget the second two columns all together. Use column 1 on the far left which is the index and match the P from there across the row to key 3 and you should come up with 5. By the same logic, K from the index should be matching up with the 3 in the third key, L shouldn't be anything in key 3.
I see what I was apparently doing: looking first for a translated letter (treating input as output) and then translating it into a number. Thanks.
MSPeconomist is offline  
Reply
Old Jun 12, 2013, 11:05 pm
  #786  
 
Join Date: Nov 2009
Location: Yellow Springs
Programs: AS 75k
Posts: 1,523
v24, the 8 character field translates to a date using key 3. i.e. HBEHBKBE = 20120301
flymonthly is offline  
Reply
Old Jun 12, 2013, 11:24 pm
  #787  
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,369
Originally Posted by flymonthly
v24, the 8 character field translates to a date using key 3. i.e. HBEHBKBE = 20120301
Could this be related to elite status or SC expiration, which would be March 1 for most DMs?
MSPeconomist is offline  
Reply
Old Jun 12, 2013, 11:26 pm
  #788  
 
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001
Originally Posted by flymonthly
v24, the 8 character field translates to a date using key 3. i.e. HBEHBKBE = 20120301
Nice find. Some people have blanks for v24. Any thoughts on what the date represents? The examples posted have been either blank or scattered throughout the last few years.
lamont2718 is offline  
Reply
Old Jun 12, 2013, 11:54 pm
  #789  
 
Join Date: Nov 2009
Location: Yellow Springs
Programs: AS 75k
Posts: 1,523
Originally Posted by MSPeconomist
Could this be related to elite status or SC expiration, which would be March 1 for most DMs?
Originally Posted by lamont2718
Nice find. Some people have blanks for v24. Any thoughts on what the date represents? The examples posted have been either blank or scattered throughout the last few years.
Dunno, but figuring it out may rest with timmy83 who had v24=HBEHEEBP (20121105) or those who have dates other than 201x0301.
flymonthly is offline  
Reply
Old Jun 12, 2013, 11:58 pm
  #790  
 
Join Date: Sep 2009
Location: LAX
Programs: Hilton Gold, Hyatt Explorist, Sixt Diamond, Hertz PC, Bonvoy Gold, UA G
Posts: 596
LMAO at the data Delta has. House value is way off (is there a max cap on this? i noticed the Experian breakdowns don't go over 750,000 my DL data shows 755) , my Mosaic data is wrong as well. The only thing that would make sense would be v06 standing for my overall travel discretionary spend.
Last edited by skyvanman; Jun 13, 2013 at 12:15 am
skyvanman is offline  
Reply
Old Jun 12, 2013, 11:58 pm
  #791  
 
Join Date: Sep 2009
Location: LAX
Programs: Hilton Gold, Hyatt Explorist, Sixt Diamond, Hertz PC, Bonvoy Gold, UA G
Posts: 596
Originally Posted by lamont2718
Nice find. Some people have blanks for v24. Any thoughts on what the date represents? The examples posted have been either blank or scattered throughout the last few years.
My v24 is blank and I don't have a SkyClub membership, no future flights booked either. Not sure if that helps at all.
skyvanman is offline  
Reply
Old Jun 13, 2013, 12:06 am
  #792  
 
Join Date: Sep 2009
Location: LAX
Programs: Hilton Gold, Hyatt Explorist, Sixt Diamond, Hertz PC, Bonvoy Gold, UA G
Posts: 596
Originally Posted by MSPeconomist
My v06 just says - and DL should have data on the money I spent. I don't think v06 can be money spent on DL.
Not sure, but I have a 6 but I'm a weird customer. I mileage run sometimes but also last year would do anything to fly Delta, no matter the price difference, and multiple occasions paid over 1k for a domestic Y ticket.
skyvanman is offline  
Reply
Old Jun 13, 2013, 12:18 am
  #793  
 
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
Originally Posted by skyvanman
Not sure, but I have a 6 but I'm a weird customer. I mileage run sometimes but also last year would do anything to fly Delta, no matter the price difference, and multiple occasions paid over 1k for a domestic Y ticket.
Mine is 32. I know for a fact that I did not spend $32000 last year on air travel. That's more than I have in my savings account. That's more than I make doing part-time minimum wage. Incidentally, it's more than I'll spend for undergraduate tuition. I know most peoples' data supports most of our hypotheses, but v06 is one I'm still skeptical of.
brocklee9000 is offline  
Reply
Old Jun 13, 2013, 12:30 am
  #794  
 
Join Date: Sep 2009
Location: LAX
Programs: Hilton Gold, Hyatt Explorist, Sixt Diamond, Hertz PC, Bonvoy Gold, UA G
Posts: 596
Originally Posted by brocklee9000
Mine is 32. I know for a fact that I did not spend $32000 last year on air travel. That's more than I have in my savings account. That's more than I make doing part-time minimum wage. Incidentally, it's more than I'll spend for undergraduate tuition. I know most peoples' data supports most of our hypotheses, but v06 is one I'm still skeptical of.
I dont think the numbers are necessarily direct numerical correlations. I think they may meet up with a chart that Delta has because if you look at the original time this data became available it was under "custValSeg" which makes me believe they've segmented the various customers in to pods based on how much value they have to them, but the question is can we find any way in which the numbers match up with our spend, status, segments, etc.
skyvanman is offline  
Reply
Old Jun 13, 2013, 12:36 am
  #795  
Suspended
 
Join Date: Dec 2009
Location: HKG
Programs: DL FO, UA, AA, AsiaMiles, SPG, HHonors
Posts: 7,982
Most of my fields are blanks. I think it's harder to gather this information on people living outside the US and/or DL doesn't bother.

Only interesting thing is my Customer Value Score. It's 6. I wonder what that means.
HongKonger 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.