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, 2:55 pm
#586
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,399
Check your stored credit cards. It should be one code per card.
Jun 12, 2013, 2:57 pm
#587
Join Date: Feb 2010
Location: SFO
Programs: DL GM, HH Gold
Posts: 120
Jun 12, 2013, 3:00 pm
#589
Join Date: Mar 2011
Posts: 647
v06, v15, and v18 are the same for me and my wife. So must be household-based. (i.e. household income (however accurate/inaccurate) for v15).
v16 was not the same in the household, but not too far off.
Other letter values were the same in the household (v01=OLX) but I have only commented on numbered values.
In response to MSPeconomist, v26 is not the same in the household.
v16 was not the same in the household, but not too far off.
Other letter values were the same in the household (v01=OLX) but I have only commented on numbered values.
In response to MSPeconomist, v26 is not the same in the household.
Jun 12, 2013, 3:01 pm
#590
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001
Jun 12, 2013, 3:03 pm
#592
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,399
In the former version, there were some demographic variables like mean income or mean home value by zip code IIRC.
I also remember some educational level data from before and IIRC information on children in the household.
I also remember some educational level data from before and IIRC information on children in the household.
Jun 12, 2013, 3:06 pm
#593
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
Jun 12, 2013, 3:06 pm
#594
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
homeownership
departure/destination preferences
children
education
skyclub memberships/renewal dates
skypriorty
anything specifically related to skmiles credit cards/AMex
Jun 12, 2013, 3:08 pm
#595
Join Date: Nov 2008
Programs: DL PM, MM; Marriott Plat
Posts: 458
I missed the first go round but some more data. V26=3, V30=4, I mostly fly in mediurm economy fare buckets, more than L, less than M, domesticly. I have no forms of payment and nothing in that field. Income is high but reasonable. V1=LNB and v24=HBEBEEEH.
Jun 12, 2013, 3:13 pm
#598
Join Date: Jan 2008
Location: SAN
Programs: Delta Silver; 0.75MM: AA; Alaska; Southwest
Posts: 1,155
Jun 12, 2013, 3:16 pm
#600
Join Date: Jan 2008
Location: SAN
Programs: Delta Silver; 0.75MM: AA; Alaska; Southwest
Posts: 1,155
I have the exact same values in 26 and 30. Also, if the income and discretionary spend are v15 and v6 then I agree they are way off. I'm just a college student, so all of these values are laughable. I make peanuts and have to pay it all back for school fees and whatnot, for the most part.
And if 30 is customer value, then I'm a good ol' 0, just like everyone else who has posted.
And if 30 is customer value, then I'm a good ol' 0, just like everyone else who has posted.
