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 Dec 11, 2013, 11:47 am
  #1231  
 
Join Date: Sep 2013
Location: CHI
Posts: 501
Looks like a lot of the values have been cut. DL finally wised up.
CabinCaptive is offline  
Reply
Old Dec 11, 2013, 1:20 pm
  #1232  
 
Join Date: Apr 2011
Location: A hotel near a major airport
Programs: SPG Platinum . Hyatt Diamond . Delta Diamond . All kinds of car rental statuses
Posts: 464
Originally Posted by InsUW2
Last week I looked at the data and it was there and now it is missing alot of data.
alot isn't a word . you're welcome
pointy is offline  
Reply
Old Dec 11, 2013, 3:16 pm
  #1233  
 
Join Date: Aug 2012
Location: SLC
Programs: DL FO, KM, & 1.7MM; UA nothing; HH♦; National EE
Posts: 6,344
Originally Posted by pointy
alot isn't a word . you're welcome
If you're going to play the role of grammar police, you should at least use proper capitalization and punctuation.
Howste is offline  
Reply
Old Dec 11, 2013, 5:03 pm
  #1234  
FlyerTalk Evangelist
 
Join Date: Oct 2011
Location: Anywhere I need to be.
Programs: OW Emerald, *A Gold, NEXUS, GE, ABTC/APEC, South Korea SES, eIACS, PP, Hyatt Diamond
Posts: 16,046
Originally Posted by Howste
If you're going to play the role of grammar police, you should at least use proper capitalization and punctuation.
+1
AA_EXP09 is offline  
Reply
Old Dec 21, 2013, 1:13 pm
  #1235  
 
Join Date: Jan 2010
Location: Twin Cities
Programs: Delta DM MM, IHG Plat, Hilton DM, Marriott SE, Emerald EE, Oakdale Gun Club, NRA & GOA Life Member
Posts: 3,870
Originally Posted by mondo
I just noticed field V38 as well. Same format #LL#LL using your schema. I also checked 2 other accounts I had access to, this field was not populated for them.
From your handle, I suspect the last two letters for us was the same. Perhaps only the numbers matter.
I have data in V38 as well. Has anyone figure out what it means yet?
yohanson is offline  
Reply
Old Dec 21, 2013, 1:53 pm
  #1236  
 
Join Date: Jul 2012
Posts: 1,079
V19 I am yes, but others in family who are not frequent flyers are N. V20 we are all N. V27 all Y. V38, I have two of those 6 character strings separated by a comma. Hmm. Fun to try to decode but not enough data or samples.
flyerslc is offline  
Reply
Old Dec 21, 2013, 1:59 pm
  #1237  
 
Join Date: Nov 2006
Location: SLC & NYC
Programs: Diamond Medallion, Delta Million Miler, Hyatt Globalist
Posts: 674
looks like delta may have modified the information because now when I pull it most of the fields are missing. Just a few left.
sdadept is offline  
Reply
Old Dec 24, 2013, 12:24 pm
  #1238  
 
Join Date: Jul 2006
Programs: DL DM/MM
Posts: 2,272
Originally Posted by sdadept
looks like delta may have modified the information because now when I pull it most of the fields are missing. Just a few left.
Just checked too -- a lot of fields are missing. Anyone figure out what V38 means? I've got some random characters in that particular field.
UVAhoo06 is offline  
Reply
Old Dec 24, 2013, 1:42 pm
  #1239  
 
Join Date: Feb 2010
Location: WLG / WAS
Programs: DL PM, QF, UA, HH Gold, SPG
Posts: 135
Originally Posted by UVAhoo06
Just checked too -- a lot of fields are missing. Anyone figure out what V38 means? I've got some random characters in that particular field.
Ditto - a lot of missing fields.

V38 for me is LLL#LL. I thought maybe it corresponded to my last DL confirmation #, but that was LLL##L. However, the last flight that was credited was actually a VS flight, and that booking confirmation was LLL#LL, which matches the pattern in V38. It doesn't work out with any of the current keys, though.
LabCat is offline  
Reply
Old Jan 22, 2014, 6:47 pm
  #1240  
 
Join Date: Apr 2009
Posts: 220
Looks like they have reduced the amount of information being captured here, well actually most likely moved it to another location.

I did find it interesting how off some of it was.
boatnfish is offline  
Reply
Old Jan 22, 2014, 7:31 pm
  #1241  
 
Join Date: Mar 2004
Location: San Diego, CA
Programs: AA ex-EXP, 2MM (ex DL, ex TWA)
Posts: 1,427
Did anyone ever explain what V10 - sunTrstInd is about/means?
Wexflyer is offline  
Reply
Old Jan 22, 2014, 7:32 pm
  #1242  
FlyerTalk Evangelist
 
Join Date: Jun 2008
Programs: Formaldehyde Medallion DL DieMiles
Posts: 12,646
Perhaps the data is now being managed under a contract with the NSA.

After all, I once discovered that they (DL) were storing info on my DL-related Google searches.
StayingHomeIsBetter is offline  
Reply
Old Feb 11, 2014, 1:19 am
  #1243  
 
Join Date: Feb 2011
Location: Somewhere above the Mason-Dixon
Programs: DL Ham Samich
Posts: 1,660
Originally Posted by Wexflyer
Did anyone ever explain what V10 - sunTrstInd is about/means?
My gut feeling is it has something to do with having the sun trust debit card
RFDMinnesota is offline  
Reply
Old Apr 19, 2014, 1:38 pm
  #1244  
 
Join Date: Jun 2013
Programs: DL Plat, Hilton Diamond, Marriott Plat, IHG Plat, Hertz Prez Circle, National Exec
Posts: 1,357
Anybody ever figure out where they moved this data? Gotta think it is still being tracked.
Zeeb is offline  
Reply
Old Apr 19, 2014, 1:43 pm
  #1245  
 
Join Date: Sep 2006
Location: LAX
Programs: Fallen DL DM (PM) 2MM
Posts: 4,783
Originally Posted by Zeeb
Anybody ever figure out where they moved this data? Gotta think it is still being tracked.
Some of it still there, but not the interesting stuff.
TheMadBrewer 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.