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, 4:41 pm
#632
Join Date: Apr 2012
Location: NY/CT
Programs: DL PM, Marriott PM
Posts: 263
I'm going to guess that v11 corresponds to the original prefDestCity ...
I might be a coincidence, but (9) 3 character codes on old and new is hard to miss
"prefDestCity":"AMS,BKK,SVO,LIM,BOI,ANC,CDG,IST,YV R"
"v11":"IQN,TMM,NDE,HJQ,TEJ,IXB,BVZ,JNW,UDR",
I have not updated my preferred destinat cities in my delta profile since before this thread came about. And BKK > TMM ... both are in position 2 and both have double letters.
I might be a coincidence, but (9) 3 character codes on old and new is hard to miss
"prefDestCity":"AMS,BKK,SVO,LIM,BOI,ANC,CDG,IST,YV R"
"v11":"IQN,TMM,NDE,HJQ,TEJ,IXB,BVZ,JNW,UDR",
I have not updated my preferred destinat cities in my delta profile since before this thread came about. And BKK > TMM ... both are in position 2 and both have double letters.
Jun 12, 2013, 4:44 pm
#634
Join Date: Oct 2009
Location: Parma, Italy
Programs: DL Silver/1MM - EK Platinum - HH Gold
Posts: 295
Okay here is what I have so far. Anything that multiple people have suggested and potentially confirmed has a question mark. Anything without a description is either unconfirmed or in dispute.
{
"v01":"NHB",
"v02":"US", country of residence
"v03":"Y",
"v04":"CPJ",
"v05":"en", language
"v06":"32", discretionary spending
"v07":"FO", elite status level
"v08":"VR",
"v09":"N",
"v10":"N",
"v11":"",
"v12":"6", segments
"v13":"",
"v14":"N",
"v15":"133", income
"v16":"121",
"v17":"", MM status
"v18":"261", home value in 1,000s???
"v19":"N",
"v20":"N",
"v21":"XXXXXXXXXX", SM number
"v22":"EPE",
"v23":"IBB",
"v24":"",
"v25":"", stored payment? IKBL=AMex PL?
"v26":"1",
"v27":"Y",
"v28":"000XXXXXXXXXX", SM number w/ 3 zeros
"v29":"Y",
"v30":"0", customer value
"v31":"XXXXX", RDM balance
"v32":"",
"v33":"XXXXX", MQM balance
"v34":"",
"v35":"N",
"v36":"N",
"v37":""}
Corrections and suggestions welcome. I tried to alter any personal identifiers.
{
"v01":"NHB",
"v02":"US", country of residence
"v03":"Y",
"v04":"CPJ",
"v05":"en", language
"v06":"32", discretionary spending
"v07":"FO", elite status level
"v08":"VR",
"v09":"N",
"v10":"N",
"v11":"",
"v12":"6", segments
"v13":"",
"v14":"N",
"v15":"133", income
"v16":"121",
"v17":"", MM status
"v18":"261", home value in 1,000s???
"v19":"N",
"v20":"N",
"v21":"XXXXXXXXXX", SM number
"v22":"EPE",
"v23":"IBB",
"v24":"",
"v25":"", stored payment? IKBL=AMex PL?
"v26":"1",
"v27":"Y",
"v28":"000XXXXXXXXXX", SM number w/ 3 zeros
"v29":"Y",
"v30":"0", customer value
"v31":"XXXXX", RDM balance
"v32":"",
"v33":"XXXXX", MQM balance
"v34":"",
"v35":"N",
"v36":"N",
"v37":""}
Corrections and suggestions welcome. I tried to alter any personal identifiers.
v20 = SkyClub Member ???
Jun 12, 2013, 4:53 pm
#639
Join Date: Sep 2006
Location: LAX
Programs: Fallen DL DM (PM) 2MM
Posts: 4,783
Recent & Saved: LHR, DUS, FRA, ATL, DSM
V23: IWH, VSN, CRI, VNQ, XSF
Looking for patterns: I have two cities starting with "D" and two codes starting with "V". I have a city each starting and ending with "L" and also starting and ending with "A" but only one code with such (I) so it may not be a straight substitution transformation.
Added: I see you also have one each starting and ending with "A" and one code each starting and ending with "I"
Jun 12, 2013, 4:56 pm
#641
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
Maybe something to this -- I have 5 different cities in my "Recent and Saved Searches" and 5 codes in V23
Recent & Saved: LHR, DUS, FRA, ATL, DSM
V23: IWH, VSN, CRI, VNQ, XSF
Looking for patterns: I have two cities starting with "D" and two codes starting with "V". I have a city each starting and ending with "L" and also starting and ending with "A" but only one code with such (I) so it may not be a straight substitution transformation.
Added: I see you also have one each starting and ending with "A" and one code each starting and ending with "I"
Recent & Saved: LHR, DUS, FRA, ATL, DSM
V23: IWH, VSN, CRI, VNQ, XSF
Looking for patterns: I have two cities starting with "D" and two codes starting with "V". I have a city each starting and ending with "L" and also starting and ending with "A" but only one code with such (I) so it may not be a straight substitution transformation.
Added: I see you also have one each starting and ending with "A" and one code each starting and ending with "I"
Jun 12, 2013, 5:04 pm
#644
Join Date: May 2009
Location: PHL
Programs: AA EXP, DL DM HH Gold, Marriot Titanium
Posts: 1,298
I believe these are from profile customization on DL.com - activities and interests:
from yours
TS - Tours
CP - Skip the line & City Pass
AA - Air Adventures
SP - Spa & Relaxation
ED - Eat & Drink
SF - Shopping & Fasion.
others from mine
AT - Attractions
DT - Day Trips & Excursions
SC - Specialty Cruises
OP - Off the Beaten Path
Others from DL.com
Shows & Events
Multi-Day Tours
Outdoor Activities
I've got HBEHEEBP - no clue.
from yours
TS - Tours
CP - Skip the line & City Pass
AA - Air Adventures
SP - Spa & Relaxation
ED - Eat & Drink
SF - Shopping & Fasion.
others from mine
AT - Attractions
DT - Day Trips & Excursions
SC - Specialty Cruises
OP - Off the Beaten Path
Others from DL.com
Shows & Events
Multi-Day Tours
Outdoor Activities
I've got HBEHEEBP - no clue.
Jun 12, 2013, 5:07 pm
#645
Join Date: Apr 2012
Location: NY/CT
Programs: DL PM, Marriott PM
Posts: 263
I'm fairly certain it's not... I tried for 15 minutes to identify any type of pattern, but came up empty. They could have just had someone come up with random codes to mask the ITA codes ...
Which reminds me ... one time, on bring your daughter to work day, I went to work with my uncle (who at the time was a VP at Brooks Brothers) ... and I got to name the colors for the upcoming seasons women's line. Sure enough a few months later, my uncle brought me to a store and showed me a blazer in one of the colors that I named ... we scanned it for the color number, took out the book, and there was my list of colors with the associated color numbers. It's too bad I can't remember the color names I came up with ...
Which reminds me ... one time, on bring your daughter to work day, I went to work with my uncle (who at the time was a VP at Brooks Brothers) ... and I got to name the colors for the upcoming seasons women's line. Sure enough a few months later, my uncle brought me to a store and showed me a blazer in one of the colors that I named ... we scanned it for the color number, took out the book, and there was my list of colors with the associated color numbers. It's too bad I can't remember the color names I came up with ...