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 13, 2013, 9:23 am
#872
Join Date: Aug 2003
Location: Mesilla, NM
Programs: DL DM 4.7 MM MQM Marriott Ambassador Lifetime Titanium AA CK
Posts: 2,714
We have zero kids and never had. I had 1 via x-wife but that was over 15 years ago. She has no kids at all.
Jun 13, 2013, 9:27 am
#876
Join Date: Sep 2010
Location: Summit County UT
Programs: Delta PM Hilton Diamond Bonvoy Ti/LTP Hertz PC
Posts: 636
Maybe we can crack some of the Y/N fields with reference to the prior named list. Pay With Miles Eligible, etc.?
Could v9 be Skymiles Elite? I see it as Y for 2 GMs, and N for plain old FF members. Any FOs (not SM elite) with a value of Y there? (That would disprove the premise...) [Or maybe Skypriority?]
Could v9 be Skymiles Elite? I see it as Y for 2 GMs, and N for plain old FF members. Any FOs (not SM elite) with a value of Y there? (That would disprove the premise...) [Or maybe Skypriority?]
Jun 13, 2013, 9:28 am
#877
Join Date: Aug 2003
Location: Mesilla, NM
Programs: DL DM 4.7 MM MQM Marriott Ambassador Lifetime Titanium AA CK
Posts: 2,714
Jun 13, 2013, 9:31 am
#880
Join Date: Sep 2000
Location: Berlin, Germany
Programs: DL DM/2MM, UA PE, HH Gold
Posts: 1,080
As we have reports from the past that DL.com returns different results/prices for the same search for logged in/not logged members the system must take note of that feature and it might be displayed in the data string here.
Jun 13, 2013, 9:32 am
#881
Join Date: Jan 2010
Location: CT
Programs: DL DM 2MM, MR LTT, Hilton D, Hertz PC. National Emerald Exec, UA Silver(thanks to Marriott)
Posts: 2,026
I believe v29 is "logged in", it is the only one that was N versus Y when I logged out and captured the data.
I love this thread
I love this thread
Jun 13, 2013, 9:35 am
#883
Join Date: Sep 2006
Programs: Delta,Continental,US Air
Posts: 2
Jun 13, 2013, 9:35 am
#884
Join Date: Aug 2003
Location: Mesilla, NM
Programs: DL DM 4.7 MM MQM Marriott Ambassador Lifetime Titanium AA CK
Posts: 2,714