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 got tagged as an O54, despite a number of inaccurate assumptions.
Probably the largest discrepancy between DL's data and reality is my income, which they have tagged as about 1/3 what it really is (perhaps reflecting my previous salary as a resident???)
Here are my data (trimmed of course). FO, been flying DL exclusively for the past 2 years.
"discSpndngAmt":"No idea where this number comes from",
"homeValueAmt":"0", (correct - I am a renter)
"mosaicCd":"O54", - maybe I got stuck here due to incorrect income and because i live inter-city?
I really hope this info remains visible. Given that I haven't been on a DL flight since Nov. 30, have nothing booked, and this year will likely travel considerably less than half what I've averaged the past three, my "impressive" CusVal of 31 should plummet!
Most of elements are empty values, but some of note. Also, on the mindset question, I'm living abroad in Ireland and have "IN" so seems to validate that theory. Seems silly to categorize everyone in "IN" if they really use this data for something... Would prefer to be "SS" it sounds like
"cobrandCardCd":"AX,AXCG", (Have DL Gold AX and AX Platinum/Personal)
,"mosaicCd":"" (boo, was hoping they'd tell me something about myself!)
Not sure how to parse this one:
I'm automatically a SC member based on DM status... Weird they'd lump Million Miler into the SC elements, if that's what this indicates (I am not an MM):
Programs: DL Diam MM, former NW Plat, HH Gold, PC Gold, Marriott Gold, Hyatt Plat
Thanks for this, very much.
If the spend is accurate -- and I haven't really tracked that too well myself then I may not have to worry to much about the MQD, I'm about there depending on whether or not taxes are included in this calculation.
Income estimate is way off -- less than half of actual last year.
My cust val is 2
It is good to have an end to journey towards, but it is the journey that matters in the end.
--Ursula K. LeGuin
Thanks for posting
I got SS
I'm a C11 - Upscale boomer-aged couples living in city and close-in suburbs - I guess that's right.
CustValSeg - 8
smMqmBal was my rollover amount
Home value amount was the recent appraisal from last years refinance - too low.
Income was correct from last years return - perhaps they got that info from the refinance?