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
#226
Join Date: Jun 2008
Location: BDU
Programs: DL:MM, Marriott:LTT
Posts: 8,779
If anyone wants the excruciating detail on Mosaic codes, this 350 pager will do it..
http://www.bgco.org/wp-content/uploa...ons-Detail.pdf
http://www.bgco.org/wp-content/uploa...ons-Detail.pdf
#227
Join Date: May 2012
Location: MSP
Programs: Delta Skymile DM, Marriott Platinum, PC Gold, Avis Chairman's Club, National EE
Posts: 728
DM with a custValSeg of 1 with a mindsetSeg of SS
BTW, the Mosaic code for me is also way off! Shows me as a I30, Stockcars and State Parks.
Considering I am a MBA, Single, White Collar.
I do have 3+ vehicles and live in a small town. That is likely how they categorized me.
BTW, the Mosaic code for me is also way off! Shows me as a I30, Stockcars and State Parks.
Considering I am a MBA, Single, White Collar.
I do have 3+ vehicles and live in a small town. That is likely how they categorized me.
Last edited by Teamstone; Jan 25, 2013 at 8:43 am
#228
FlyerTalk Evangelist & Ambassador: China
Join Date: Aug 2005
Location: DEN
Programs: DL DM/MM, UA 1K, AA Exp, HH Dia, WOH Glob, IHG Plat, Marriott Gold, NA EE, Hertz PC
Posts: 17,412
#230
Join Date: Jul 2006
Location: Chicago
Programs: UA 1K, HH Diamond
Posts: 2,055
I am not sure Delta even cares that we can can see this info..why would they? If it was so sensitive and they didn't want their customers seeing it, there would be security behind it but obviously there is not. I would love Delta to chime in here and discuss the meanings of the mindset and customer value codes...I mean why wouldn't they at this point?
#231
Join Date: Sep 2011
Location: Wherever I happen to be....
Programs: DL EOS...
Posts: 1,111
On one hand, they really don't have much accurate info about me and my households (bi-coastal). Good.
But when I consider how this incorrect (insulting) information could possibly influence day-to-day treatment by DL and/or other businesses - 'leaves me with even more foul taste than the failed website/app, FCM, fewer UG's and recent MQ announcement....
But when I consider how this incorrect (insulting) information could possibly influence day-to-day treatment by DL and/or other businesses - 'leaves me with even more foul taste than the failed website/app, FCM, fewer UG's and recent MQ announcement....
#232
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
Yes I know - we keep being told by some on this board, FlyerTalk is a small subset. However, it tends to be FTers who know how to game the Medallion system. It is FTers who tend to discover MRs - and it is an FTer who discovered this dynamite information.
Despite me being a little frustrated this last week over the tone of some posts - especially in the MQM sticky thread, this site is an absolute gem - and an incredibly valuable resource too. That is why I keep coming back for more and more.
ps I have not figured out my mosaic yet but will do on my home PC when there are not the same download etc restrictions.
Despite me being a little frustrated this last week over the tone of some posts - especially in the MQM sticky thread, this site is an absolute gem - and an incredibly valuable resource too. That is why I keep coming back for more and more.
ps I have not figured out my mosaic yet but will do on my home PC when there are not the same download etc restrictions.
#233
Join Date: Dec 2005
Location: Likely being followed...
Programs: DYKWIA Extraordinaire. TrollSlayer Mega Diamond. [insert esoteric sounding status level(s) here]
Posts: 5,240
Then again, these broad demographic surveys are usually pretty damn accurate when you read the full details. Obviously there are red herrings but...
classic.demographicsnow.com/AllocateOnline.srct?ShowPage=static/MosaicUSA.htm
#234
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
{"actvtyPref":"DT,MT,AA,OP", - This intrigues me since many don't reference it
No Children - have that right
CustValSeg: 34 (Pondering as I see some on this thread with a 1 and some with 31)
Income way off
Discretionary, way off.
Mosaic, they mentioned Nordstrom which is where I shop, and the car I drive. Somewhat a good Friday read
Still unsure on the MindsetSeg of SS, looked at the other links and could not find the info.
No Children - have that right
CustValSeg: 34 (Pondering as I see some on this thread with a 1 and some with 31)
Income way off
Discretionary, way off.
Mosaic, they mentioned Nordstrom which is where I shop, and the car I drive. Somewhat a good Friday read
Still unsure on the MindsetSeg of SS, looked at the other links and could not find the info.
Last edited by Astriker; Jan 25, 2013 at 8:57 am
#236
Join Date: Dec 2005
Location: Likely being followed...
Programs: DYKWIA Extraordinaire. TrollSlayer Mega Diamond. [insert esoteric sounding status level(s) here]
Posts: 5,240
#237
Join Date: Jul 2010
Location: SAV
Programs: Atlanta's hometown airline. A bunch of hotel programs. PetSmart PetPerks.
Posts: 2,531
#238
Join Date: Sep 2009
Location: Hong Kong, Philippines, Alabama
Programs: Delta Skymiles KM (Charter Member)
Posts: 150
#239
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169