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
The custValSeg makes sense to me, and I can understand why I am only a "2" (>50% of my MQM last year were on partners) while a PM family member is "11" (probably quintuple my spending on DL). Funny that my FO mother is a "1", when I spent many times as much on DL last year and she doesn't have an Amex.
That mindset code will drive me crazy until somebody cracks it.
Now I'm getting very curious. The Mosaic program is run by Experian, and I believe that under the Fair Credit Reporting Act, I should be entitled to get a copy of the data the have on me (I've gotten a similar disclosure from LexisNexis in the past). But I don't see anywhere to do that on the Experian website. Am I barking up the wrong tree?
Yes, you are entitled to the data...but it is your Experian credit report. The segmentation models and model results are not subject to the FCRA. You have a right to free access to the data annually from annualcreditreport.com. If Amex/Delta were to make a decision to deny you credit (credit limit or product) based on this data, the FRCA applies.
My guess is that if one were to opt out of affiliate sharing with Amex, Delta would not be able to get most of the financial information. Has anyone done this? Is the Mosaic field empty?