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
Jan 25, 2013, 9:12 am
#256
Join Date: Apr 2012
Location: The SkyClub at F/G in MSP
Programs: Delta Diamond, Marriott Platinum
Posts: 92
Updated as of all posts above this one (and some data received via Private Message):
BH from No Status, CustValSeg 0
DW from FO, CustValSeg 0
DW from DM, CustValSeg 20
FL from FO, CustValSeg 1
FL from FO, CustValSeg 2
FL from PM, CustValSeg 1
GT from DM, CustValSeg 0
GT from DM, CustValSeg 2
GT from DM, CustValSeg 27
IN from FO, CustValSeg 0
MM from FO, CustValSeg 0
MM from FO, CustValSeg 0
SS from GM, CustValSeg 2
SS from PM, CustValSeg 11
SS from PM, CustValSeg 5
SS from DM, CustValSeg 3
SS from DM, CustValSeg 6
SS from DM, CustValSeg 12
SS from Unknown Level, CustValSeg 5
BH from No Status, CustValSeg 0
DW from FO, CustValSeg 0
DW from DM, CustValSeg 20
FL from FO, CustValSeg 1
FL from FO, CustValSeg 2
FL from PM, CustValSeg 1
GT from DM, CustValSeg 0
GT from DM, CustValSeg 2
GT from DM, CustValSeg 27
IN from FO, CustValSeg 0
MM from FO, CustValSeg 0
MM from FO, CustValSeg 0
SS from GM, CustValSeg 2
SS from PM, CustValSeg 11
SS from PM, CustValSeg 5
SS from DM, CustValSeg 3
SS from DM, CustValSeg 6
SS from DM, CustValSeg 12
SS from Unknown Level, CustValSeg 5
Here are more!
SS from DM, CustValSeg 24 for me, and FL from GM (gifted), CustValSeg 1 for Mr. Txaggie94.
Jan 25, 2013, 9:12 am
#257
Join Date: Oct 2007
Location: Atlanta, GA (Or on a plane going far away)
Programs: DL: DM / Royal Ambassador /PC:Plat / Hertz:5*
Posts: 617
On the Diamond group in facebook, that also seems "" for most people. I don't have AA status, I am on their advisory group, I thought maybe that was it - I could think of plenty of words to use though! :-)
Jan 25, 2013, 9:14 am
#258
Join Date: Oct 2007
Location: Atlanta, GA (Or on a plane going far away)
Programs: DL: DM / Royal Ambassador /PC:Plat / Hertz:5*
Posts: 617
Jan 25, 2013, 9:15 am
#259
Join Date: Oct 2006
Location: MSP
Programs: DL DM, Marriott Plat, National Exec Elite
Posts: 1,357
if they had any tools at all they already know
Just by Home airport and mining a few posts they should be able to figure most everyone out. This seems way to complex for them to try to find our identities.
Jan 25, 2013, 9:15 am
#260
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
Where's the detailed description of Mosaic segments? I tried clicking on the long list in their brochure (link posted early), but nothing happens. Do I need to download the 350 page document to see this?
Jan 25, 2013, 9:16 am
#261
Join Date: Apr 2009
Location: Naples Florida and San Diego, California
Programs: Delta Diamond, Starwood Platinum
Posts: 73
I find this disturbing. They have my home value correctly but it is at a different address than my mailing address for my Delta account, bank accounts, and tax returns. Who is providing Delta with this information and when did I give them permission to do so? I feel like my privacy has been breached.
Jan 25, 2013, 9:16 am
#262
Join Date: Aug 2010
Location: PIT
Programs: DL, HHonors
Posts: 39
Some more data -
I'm PM, most of my mile are from discount international business fares.
"mindsetSeg":"FL"
"mosaicCd":"C14" < not even close to being a boomer based on age
"custValSeg":"11"
My girlfriend is PM, flies domestic, mostly discount economy fares
"mindsetSeg":"DW"
"mosaicCd":"F22"
"custValSeg":"1"
I'm PM, most of my mile are from discount international business fares.
"mindsetSeg":"FL"
"mosaicCd":"C14" < not even close to being a boomer based on age
"custValSeg":"11"
My girlfriend is PM, flies domestic, mostly discount economy fares
"mindsetSeg":"DW"
"mosaicCd":"F22"
"custValSeg":"1"
Jan 25, 2013, 9:18 am
#264
Join Date: Oct 2006
Location: MSP
Programs: DL DM, Marriott Plat, National Exec Elite
Posts: 1,357
Jan 25, 2013, 9:19 am
#265
Join Date: Sep 2011
Location: Wherever I happen to be....
Programs: DL EOS...
Posts: 1,111
Jan 25, 2013, 9:20 am
#266
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
Jan 25, 2013, 9:20 am
#267
Join Date: Jan 2011
Location: DFW...at the moment
Programs: AA EXP, SPG Plat, Hyatt Diamond, HH gold
Posts: 609
I find this disturbing. They have my home value correctly but it is at a different address than my mailing address for my Delta account, bank accounts, and tax returns. Who is providing Delta with this information and when did I give them permission to do so? I feel like my privacy has been breached.
Jan 25, 2013, 9:24 am
#270
Join Date: Jan 2006
Programs: Skyteam
Posts: 5,759
Just to bring together our few data points on mindsetSeg, so far we've seen the following outputs:
DW from FO, CustValSeg 0
DW from DM, CustValSeg 20
FL from FO, CustValSeg 1
FL from FO, CustValSeg 2
FL from PM, CustValSeg 1
FL from DM, CustValSeg 0
GT from DM, CustValSeg 0
GT from DM, CustValSeg 2
GT from DM, CustValSeg 27
IN from FO, CustValSeg 0
MM from FO, CustValSeg 0
SS from GM, CustValSeg 2
SS from PM, CustValSeg 11
SS from PM, CustValSeg 5
SS from DM, CustValSeg 3
SS from DM, CustValSeg 12
SS from Unknown Level, CustValSeg 5
DW from FO, CustValSeg 0
DW from DM, CustValSeg 20
FL from FO, CustValSeg 1
FL from FO, CustValSeg 2
FL from PM, CustValSeg 1
FL from DM, CustValSeg 0
GT from DM, CustValSeg 0
GT from DM, CustValSeg 2
GT from DM, CustValSeg 27
IN from FO, CustValSeg 0
MM from FO, CustValSeg 0
SS from GM, CustValSeg 2
SS from PM, CustValSeg 11
SS from PM, CustValSeg 5
SS from DM, CustValSeg 3
SS from DM, CustValSeg 12
SS from Unknown Level, CustValSeg 5