What the items indicate
v01: Closest airport to home address (encoded using key 1)
v02: Country of residence
v04: Preferred departure airport/city (encoded using key 2)
v06: discSpndngAmt, in thousands
v07: Skymiles status level
v08: State/province (encoded using key 2)
v09: Pay with Miles eligible
v13: Hotel loyalty programs stored in DL.com profile (encoded using key 2, see post #829)
v15: Income, in thousands
v16: Current age + 99
v17: 1/2/3 MM Status
v18: Home value, in thousands
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)
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
v39: ?? Duplicate for Language ??
v40: ?? Duplicate for Country of Residence ??
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
I suspect all the income/Mosaic info comes from Amex, as it is the same for me, my wife, and my 3 year-old. However, the custValSeg is definitely different. My GM 3-year-old is a 0, while my DM wife is a 1, and I (a DM/MM) am a 9. No idea how high the scale goes....
Actually, I suspect it's not a bad guess. Perhaps the number of segments where DL thought you were "Valuable" (e.g., paid F, full Y, etc.) in the past XX mos/years/etc. That would be consistent for my family's data, anyway.
"custValSeg":"0" - That seems correct, I'm a low value FO.
"mindsetSeg":"MM" - Don't know.
"mosaicCd":"H29" - Eh, sort of. I guess they're partly right.
"incomeAmt":"$$", - This is a surprisingly inaccurate number for me. If we assume this represents your annual income divided by 1000, this amount is less than a third of my current income, and actually less than half of the lowest income I've ever had since leaving college (and less than half what I made when I got my AmEx).
"homeValueAmt":"$$$$$$", - This one was pretty accurate.
"discSpndngAmt":"$$$$$", - For me, this was considerably higher than my spend on DL flights this year, so I would think that's not the key. The part that makes me really curious is that, assuming we've pegged the "incomeAmt" calculation correctly, DL feels my discretionary spending is 82% of my total income despite having correctly identified my home value and therefore presumably having an idea of at least what my mortgage must be.
Originally Posted by MR_MAMA
The sad thing is Delta really has me all wrong, wrong income, wrong discretionary income, way wrong my mosaic category.