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, 1:36 pm
#541
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
Yeah, I can't really figure anything out. There were a few more variables in the OP than in the new data set, and yes they are ordered differently. I can figure out a few. I'm guessing:
en=language (for website/ad targeting, I guess)
US=where I live
I see my SM number twice. Once as the 10 digit number, and second with a couple extra zeros at the front.
I see my status
Lots of "Y" and "N" and blank values, no idea what for or why.
en=language (for website/ad targeting, I guess)
US=where I live
I see my SM number twice. Once as the 10 digit number, and second with a couple extra zeros at the front.
I see my status
Lots of "Y" and "N" and blank values, no idea what for or why.
Jun 12, 2013, 1:37 pm
#542
Join Date: Feb 2006
Location: New York, NY
Programs: Delta, SPG
Posts: 547
Jun 12, 2013, 1:41 pm
#543
Suspended
Join Date: Dec 2009
Location: HKG
Programs: DL FO, UA, AA, AsiaMiles, SPG, HHonors
Posts: 7,982
IKTL=Is A Kettle?
NORI=Japanese dried seaweed
HBEHBXBE=The only fare class from which it is still possible to SDC.
Jun 12, 2013, 1:46 pm
#546
Join Date: May 2009
Location: PHL
Programs: AA EXP, DL DM HH Gold, Marriot Titanium
Posts: 1,298
Struggling a bit to figure these values out...
Old
"custValSeg":"1",
"discSpndngAmt":"No idea where this number comes from",
"homeValueAmt":"0", (correct - I am a renter)
"incomeAmt":"?????",
"mindsetSeg":"FL",
"mosaicCd":"O54", - maybe I got stuck here due to incorrect income and because i live inter-city?
"smTierLvl":"FO"
New
"v01":"NWH"
"v02":"US"
"v03":"Y"
"v04":"CRP" -
"v05":"en"
"v06":"16" Could this be the old discretionary spending?
"v07":"FO"
"v08":"SM"
"v09":"Y"
"v10":"N"
"v11":""
"v12":"MQS to date"
"v13":"XXX,CXW"
"v14":"N"
"v15":"57" - I think this is what DL thinks my income is in thousands?
"v16":"128"
"v17":""
"v18":""
"v19":"Y"
"v20":"Y"
"v21":"MySM#"
"v22":"EPN"
"v23":"TEN,LOH"
"v24":"HBEHEEBP"
"v25":"IK,IK,NORZ,IKBL"
"v26":"1"
"v27":"Y"
"v28":"MySM#withthree0s"
"v29":"Y"
"v30":"1"
"v31":"MySMBalance"
"v32":"SL"
"v33":"MQM balance"
"v34":"AT,DT,AA,SC,ED,OP"
"v35":"N"
"v36":"N"
"v37":"
Old
"custValSeg":"1",
"discSpndngAmt":"No idea where this number comes from",
"homeValueAmt":"0", (correct - I am a renter)
"incomeAmt":"?????",
"mindsetSeg":"FL",
"mosaicCd":"O54", - maybe I got stuck here due to incorrect income and because i live inter-city?
"smTierLvl":"FO"
New
"v01":"NWH"
"v02":"US"
"v03":"Y"
"v04":"CRP" -
"v05":"en"
"v06":"16" Could this be the old discretionary spending?
"v07":"FO"
"v08":"SM"
"v09":"Y"
"v10":"N"
"v11":""
"v12":"MQS to date"
"v13":"XXX,CXW"
"v14":"N"
"v15":"57" - I think this is what DL thinks my income is in thousands?
"v16":"128"
"v17":""
"v18":""
"v19":"Y"
"v20":"Y"
"v21":"MySM#"
"v22":"EPN"
"v23":"TEN,LOH"
"v24":"HBEHEEBP"
"v25":"IK,IK,NORZ,IKBL"
"v26":"1"
"v27":"Y"
"v28":"MySM#withthree0s"
"v29":"Y"
"v30":"1"
"v31":"MySMBalance"
"v32":"SL"
"v33":"MQM balance"
"v34":"AT,DT,AA,SC,ED,OP"
"v35":"N"
"v36":"N"
"v37":"
Last edited by timmy83; Jun 12, 2013 at 1:55 pm
Jun 12, 2013, 1:48 pm
#548
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,413
Here's what I can figure out:
v02 residence country
v05 language
v07 elite status level
v17 MM status
v21 FF number
v28 FF number again preceded by three zeroes
v31 RDM balance
v33 MQM balance
ADDED: v12 might be MQS
v02 residence country
v05 language
v07 elite status level
v17 MM status
v21 FF number
v28 FF number again preceded by three zeroes
v31 RDM balance
v33 MQM balance
ADDED: v12 might be MQS
Last edited by MSPeconomist; Jun 12, 2013 at 1:58 pm
Jun 12, 2013, 1:49 pm
#549
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
Old
"custValSeg":"1",
"discSpndngAmt":"No idea where this number comes from",
"homeValueAmt":"0", (correct - I am a renter)
"incomeAmt":"?????",
"mindsetSeg":"FL",
"mosaicCd":"O54", - maybe I got stuck here due to incorrect income and because i live inter-city?
"smTierLvl":"FO"
New
"v01":"NWH"
"v02":"US"
"v03":"Y"
"v04":"CRP"
"v05":"en"
"v06":"16"
"v07":"FO"
"v08":"SM"
"v09":"Y"
"v10":"N"
"v11":""
"v12":"24"
"v13":"XXX,CXW"
"v14":"N"
"v15":"57"
"v16":"128"
"v17":""
"v18":""
"v19":"Y"
"v20":"Y"
"v21":"MySM#"
"v22":"EPN"
"v23":"TEN,LOH"
"v24":"HBEHEEBP"
"v25":"IK,IK,NORZ,IKBL"
"v26":"1"
"v27":"Y"
"v28":"MySM#withthree0s"
"v29":"Y"
"v30":"1"
"v31":"MySMBalance"
"v32":"SL"
"v33":"MQM balance"
"v34":"AT,DT,AA,SC,ED,OP"
"v35":"N"
"v36":"N"
"v37":"
"custValSeg":"1",
"discSpndngAmt":"No idea where this number comes from",
"homeValueAmt":"0", (correct - I am a renter)
"incomeAmt":"?????",
"mindsetSeg":"FL",
"mosaicCd":"O54", - maybe I got stuck here due to incorrect income and because i live inter-city?
"smTierLvl":"FO"
New
"v01":"NWH"
"v02":"US"
"v03":"Y"
"v04":"CRP"
"v05":"en"
"v06":"16"
"v07":"FO"
"v08":"SM"
"v09":"Y"
"v10":"N"
"v11":""
"v12":"24"
"v13":"XXX,CXW"
"v14":"N"
"v15":"57"
"v16":"128"
"v17":""
"v18":""
"v19":"Y"
"v20":"Y"
"v21":"MySM#"
"v22":"EPN"
"v23":"TEN,LOH"
"v24":"HBEHEEBP"
"v25":"IK,IK,NORZ,IKBL"
"v26":"1"
"v27":"Y"
"v28":"MySM#withthree0s"
"v29":"Y"
"v30":"1"
"v31":"MySMBalance"
"v32":"SL"
"v33":"MQM balance"
"v34":"AT,DT,AA,SC,ED,OP"
"v35":"N"
"v36":"N"
"v37":"
v12 could be segments?
I'm really curious what v1, 4, 6, and 8 stand for.
Jun 12, 2013, 1:58 pm
#553
Join Date: May 2009
Location: PHL
Programs: AA EXP, DL DM HH Gold, Marriot Titanium
Posts: 1,298
If I remember correctly, v15 is what delta had listed as my income previously - so it could be that. In recalling this discussion previously, this was largely erroneous.
I suspect (but have no means of validating) that v06 is the old discretionary spending number.... any thoughts?
I suspect (but have no means of validating) that v06 is the old discretionary spending number.... any thoughts?
Jun 12, 2013, 1:58 pm
#554
Join Date: May 2006
Location: GA
Programs: VA-PLT, QF-GLD, DL-GM, UA-ex1K, AA-exPLT, HH-DM, IHG-PLT, MR-GLD
Posts: 8,242
Jun 12, 2013, 1:59 pm
#555
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
v25 is blank for me. I have stored payment info, but it's not an Amex or DL branded card. I assumed that one of the many blank spaces I have could have been for payment methods, AMex cards, a skyclub membership perhaps, who knows. I'm making a note for each value in my txt document as we find them.