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 24, 2013, 10:53 pm
#76
Join Date: Apr 2001
Location: Indianapolis, IN USA
Posts: 2,066
Thanks for logging in to all these - interesting to see the different ranges for this value.
Jan 24, 2013, 10:55 pm
#77
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
mindset is not experianl Mosaic is.
I think it is how DL deals with you when you have issues
Mindset is
MINDset = Focus on the person’s MINDset—their motivations, interest, needs and desires. (page 4) http://www.delta.com/content/dam/del...letter2012.pdf
I think it is how DL deals with you when you have issues
Mindset is
MINDset = Focus on the person’s MINDset—their motivations, interest, needs and desires. (page 4) http://www.delta.com/content/dam/del...letter2012.pdf
Can anyone tell us what was in it? What do the mindset codes mean?
Jan 24, 2013, 10:59 pm
#78
FlyerTalk Evangelist
Join Date: Apr 2009
Location: Bye Delta
Programs: AA EXP, HH Diamond, IHG Plat, Hyatt Plat, Marriott Plat, Nat'l Exec Elite, Avis Presidents Club
Posts: 16,269
mindset is not experianl Mosaic is.
I think it is how DL deals with you when you have issues
Mindset is
MINDset = Focus on the person’s MINDset—their motivations, interest, needs and desires. (page 4) http://www.delta.com/content/dam/del...letter2012.pdf
I think it is how DL deals with you when you have issues
Mindset is
MINDset = Focus on the person’s MINDset—their motivations, interest, needs and desires. (page 4) http://www.delta.com/content/dam/del...letter2012.pdf
Jan 24, 2013, 10:59 pm
#79
Join Date: Jul 2008
Location: Redmond, OR
Programs: AS MVP Gold, HHonors Silver, Marriott Titanium (Lifetime Platinum), UA Silver, OW Sapphire
Posts: 709
LOL, I am a "True Grit American".
custValSeg = 3 (I'm a PM and will requal PM in March and DM in May).
Discretionary spend = 20% of what they think my income is, which I suppose is more or less correct.
Dave
custValSeg = 3 (I'm a PM and will requal PM in March and DM in May).
Discretionary spend = 20% of what they think my income is, which I suppose is more or less correct.
Dave
Jan 24, 2013, 11:00 pm
#80
Join Date: Jul 2010
Location: MKE
Programs: DL-MM-Diamond HH-Diamond
Posts: 3,218
Jan 24, 2013, 11:00 pm
#81
Join Date: Nov 2007
Location: SJC (formerly CHI and STL)
Programs: AS, DL, AA, UA, WN
Posts: 1,013
Jan 24, 2013, 11:01 pm
#83
Join Date: Jun 2005
Location: SDF
Programs: Delta PM, IC Ambassador, Marriott Gold
Posts: 1,195
My Customer Value is a 5.
My disc Spending is listed at over 26K, but I have no idea where that came from. I do most of my flying in the last 4 months of the year and spent about 7-8K in that time period.
My income amount is way under. Like, what I made while working part time in college under.
Mindset SS.
Mosaic K40. Searching google I found this description of my K40. It might have others. http://classic.demographicsnow.com/T...n%20Groove.PDF They haven't hit me at all. In fact, I feel somewhat insulted.
My disc Spending is listed at over 26K, but I have no idea where that came from. I do most of my flying in the last 4 months of the year and spent about 7-8K in that time period.
My income amount is way under. Like, what I made while working part time in college under.
Mindset SS.
Mosaic K40. Searching google I found this description of my K40. It might have others. http://classic.demographicsnow.com/T...n%20Groove.PDF They haven't hit me at all. In fact, I feel somewhat insulted.
Last edited by SomeGuy; Jan 24, 2013 at 11:11 pm Reason: Added link
Jan 24, 2013, 11:03 pm
#84
Join Date: Sep 2007
Location: SJC/SFO
Programs: DL DM MM (fmr NW Plat), BA GGL/CCR, Aegean Gold, WorldClubs Life, SPG Plat, Hyatt Plat, HHonors Dmnd
Posts: 1,409
Interesting snippets from mine:
"custValSeg":"27" (is 27 good or bad?)
"discSpndngAmt":"27751" (is this how much they think I spend on "discretionary" travel or something?)
"mindsetSeg":"GT" (global traveler? or what?)
"smBalance":"1116830","smMqmBal":"552579"
I know what these are...
"custValSeg":"27" (is 27 good or bad?)
"discSpndngAmt":"27751" (is this how much they think I spend on "discretionary" travel or something?)
"mindsetSeg":"GT" (global traveler? or what?)
"smBalance":"1116830","smMqmBal":"552579"
I know what these are...
Jan 24, 2013, 11:04 pm
#85
FlyerTalk Evangelist
Join Date: Apr 2009
Location: Bye Delta
Programs: AA EXP, HH Diamond, IHG Plat, Hyatt Plat, Marriott Plat, Nat'l Exec Elite, Avis Presidents Club
Posts: 16,269
Jan 24, 2013, 11:04 pm
#86
Join Date: Dec 2005
Location: Likely being followed...
Programs: DYKWIA Extraordinaire. TrollSlayer Mega Diamond. [insert esoteric sounding status level(s) here]
Posts: 5,240
Interesting snippets from mine:
"custValSeg":"27" (is 27 good or bad?)
"discSpndngAmt":"27751" (is this how much they think I spend on "discretionary" travel or something?)
"mindsetSeg":"GT" (global traveler? or what?)
"smBalance":"1116830","smMqmBal":"552579" I know what these are...
"custValSeg":"27" (is 27 good or bad?)
"discSpndngAmt":"27751" (is this how much they think I spend on "discretionary" travel or something?)
"mindsetSeg":"GT" (global traveler? or what?)
"smBalance":"1116830","smMqmBal":"552579"
I know what these are...And you would be a 27.
Jan 24, 2013, 11:06 pm
#87
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,419
Thanks to all you sluethers out there.
"chldAgeRange":"POC10T12,POC13T18" I don't have kids, should I be worried?
How do you interpret this?
"isPwmElig": You guys are spot on, I have blue Amex
"skyClubFtrCntrctInd": If this shows, SC status, why have this: "skyClubMbr"
Still can't crack these:
"actvtyPref":
"bcInd":
"mindsetSeg":
"chldAgeRange":"POC10T12,POC13T18" I don't have kids, should I be worried?
How do you interpret this? "isPwmElig": You guys are spot on, I have blue Amex
"skyClubFtrCntrctInd": If this shows, SC status, why have this: "skyClubMbr"
Still can't crack these:
"actvtyPref":
"bcInd":
"mindsetSeg":
Jan 24, 2013, 11:09 pm
#89
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,419