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, 4:22 am
#811
Join Date: Sep 2000
Location: Berlin, Germany
Programs: DL DM/2MM, UA PE, HH Gold
Posts: 1,080
Question on
v01: Closest airport to home address and
v04: Preferred departure airport/city
Should be the same for most i guess? In my case v01 is the closest airport DL flies into with their own metal as they don't fly into my v04 (TXL).
v01: Closest airport to home address and
v04: Preferred departure airport/city
Should be the same for most i guess? In my case v01 is the closest airport DL flies into with their own metal as they don't fly into my v04 (TXL).
Jun 13, 2013, 5:48 am
#813
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, 5:48 am
#814
Join Date: Oct 2002
Location: LAS
Programs: PA FT, TW Gold, NW/CO PE, VK Eagleflyer
Posts: 7,173
Jun 13, 2013, 5:55 am
#815
FlyerTalk Evangelist
Join Date: Sep 2007
Location: BOS
Programs: DL DM 2MM, Marriott LT Titanium, Hertz PC, Avis PC
Posts: 15,206
This is part of the whole new data mining and sharing crap for the new airline booking system where they are going to give us different prices based on all of that data.
Jun 13, 2013, 6:07 am
#816
Suspended
Join Date: Dec 2009
Location: HKG
Programs: DL FO, UA, AA, AsiaMiles, SPG, HHonors
Posts: 7,982
Yup. When that actually starts happening I will clear all my cookies an prevent them from setting new ones.
Jun 13, 2013, 6:12 am
#817
Join Date: Aug 2008
Location: MCO
Programs: DL-DM/1MM, HILTON-DIA, .HYATT-DIA/GLOB , IHG-PLT,HERTZ 5*, NATIONAL ES
Posts: 8,691
Jun 13, 2013, 6:17 am
#818
Join Date: May 2009
Location: PHL
Programs: AA EXP, DL DM HH Gold, Marriot Titanium
Posts: 1,298
Yeah - who really knows what the CustValSeg really means. For all we know it's some coded customer profile (1 - suckers). As for me, I'm an FO with a Custvalseg of 1. I typically fly sLUTVX fares - and I occasionally MR. I do have a mix of higher fares for work-related events, though.
As for the experian mosiac codes, it appears to me that these have little to do with your demographics or the perceived house value/income/discretionary spending. I believe that based on some information from experian that it's almost all zip code.
As for the experian mosiac codes, it appears to me that these have little to do with your demographics or the perceived house value/income/discretionary spending. I believe that based on some information from experian that it's almost all zip code.
Jun 13, 2013, 6:18 am
#819
Join Date: Sep 2006
Location: LAX
Programs: Fallen DL DM (PM) 2MM
Posts: 4,783
As for V24 -- mine is HBEHEEK which is 2012113 -- in the Jan dump that was "skyClubRnlDt" -- It makes sense that it would be 3/1/2012 for DM who don't have a paid membership. I do, so mine is different.
Can you see somebody at Delta saying "Hey, we'll fool them -- we'll encode everything and they won't be able to figure it out."
Jun 13, 2013, 6:35 am
#820
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
Jun 13, 2013, 6:43 am
#821
Join Date: Nov 2010
Location: BOS
Programs: DL PM, Hertz Gold Plus, SPG Gold
Posts: 1,049
v13 appears to be the hotel loyalty programs stored in your DL.com profile. Mine returns "XXJ, CXW", which decodes into "SHR, HHC" using Key 2. My two stored hotel loyalty programs are Starwood Preferred Guest (Starwood Hotels and Resorts = SHR) and Hilton Hotels (Hilton HHonors Club= HHC).
Jun 13, 2013, 6:47 am
#822
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,417
Jun 13, 2013, 6:50 am
#823
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,417
v13 appears to be the hotel loyalty programs stored in your DL.com profile. Mine returns "XXJ, CXW", which decodes into "SHR, HHC" using Key 2. My two stored hotel loyalty programs are Starwood Preferred Guest (Starwood Hotels and Resorts = SHR) and Hilton Hotels (Hilton HHonors Club= HHC).
Jun 13, 2013, 6:53 am
#824
Join Date: May 2009
Location: PHL
Programs: AA EXP, DL DM HH Gold, Marriot Titanium
Posts: 1,298