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.
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:
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
Wow. My mosaic code of 051 makes me a digital dependent. That couldn't be any more true. Though it gave my wife the same code and she, is not. They have a lot less data on her, though.
They got me totally wrong. C11: aging of aquarius:
Upscale boomer-aged couples living in city and close-in suburbs
2.34% 3.26%
which is weird because they *know* I'm younger than that! And 50% of the characteristics are totally wrong, with a couple more a bit dubious.
Programs: Status w/DL, AA, Hyatt, Hilton, SPG, Club Carlson, National, & PC
Posts: 4,843
Quote:
Originally Posted by amejr999
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?
My strong assumption is that this is from DL:
custValSeg":"0",
Location: "Nowhere!!!" your honor my client is in the witness protection program.
Programs: Spoiled by Skywards
Posts: 1,056
I found my personal "incomeAmt": to be concurrent with what I answer on all surveys as my fictional number, wonder if that's where they arrived at that number.
"actvtyPref":
"bcInd":
"chldAgeRange": how old are you kids
"isPwmElig": pay with miles
"isSmCust": skymiles customer
"mindsetSeg":
"poCd":
"skyClubFtrCntrctInd":
"smAmexCntrnInd": centurian
"smAmexInd": skymiles amex?
"smSunTrstInd": suntrust card
"stProvCd":
Delta, thank you for identifying me as a G25: Younger, up-and-coming singles living big city lifestyles located within top CBSA markets. That is right - I'm a Young City Solo and proud of it.
Programs: Status w/DL, AA, Hyatt, Hilton, SPG, Club Carlson, National, & PC
Posts: 4,843
Quote:
Originally Posted by mnredfox
Anyone know what these mean:
"actvtyPref":
"bcInd":
"chldAgeRange": --> Age of your kids
"isPwmElig": --> Pay with Miles Eligible
"isSmCust": --> Is a Skymiles customer
"mindsetSeg": --> Some sort of Experian thing
"poCd":
"skyClubFtrCntrctInd": --> Do you have a SkyClub Membership
"smAmexCntrnInd":
"smAmexInd":
"smSunTrstInd": --> Do you have a Suntrust Card
"stProvCd": State / Province
Some of them are easily answered.
Quote:
Originally Posted by javabytes
This is laughable. Income... wrong. Home value amount... wrong. Mosaic... wrong.
No idea what discSpndngAmt is, but I'm sure it's not what I spent on DL. I would venture a guess that it comes from AmEx.
Discretionary Spending as assumed by an algorithm (likely from the ad sales partner)
Programs: DL PM Kryptonium Ham Sandwich GAMER, CO Plat, UA 1P, US, PC Plat, SPG Gold, HH Silver, Nat'l Exec
Posts: 7,874
Quote:
Originally Posted by mnredfox
Anyone know what these mean:
"chldAgeRange": Your childrens' age range
"isPwmElig": Is Pay With Miles eligible
"isSmCust": Is SkyMiles customer
"poCd": Postal Code
"smAmexCntrnInd": (Guessing) AmEx Centurion Cardmember
"stProvCd": State/Province Code
__________________
. <--- Grain of salt. Take with post as necessary.
Well, certainly interesting. I checked on all 5 medallions in my family (Dad: PM, Me: DM, Mom: FO, Wife: GM gifted, Sis: FO).
"custValSeg": I'm a 2 as a DM, Dad's an 11 as a PM, Mom's a 1, sis and wife are "0"
"incomeAmt": shows as 250 for me, Dad, and Mom (all at one address); 250 for sis, "" for wife. If that is 250k, it is way high for me and sis, and way low for parents
"mosaicCd": A02 "Platinum Prosperity", WAY above my paygrade and my sister's. Fits somewhat for the parents (they should be A01). I wonder if this isn't primarily zip-code driven. I live overseas, but have my account address as my parents home.
"discSpndngAmt": 54003 for dad, mom, sis and me. Don't know what that number represents.
"mindsetSeg": No idea what this means. Sis is "DW", mom "FL", dad is "SS", I am "GT"
I wonder if the home value date comes from having a mortgage and/or mortgage payments. That would explain why my parents don't show as owning a home. Interesting that the whole biological family has the same spending amount.
"chldAgeRange":
Looks like its child age range.
"poCd":
At least for USA its the long format zip code (i.e. 20500-0003)
"smAmexInd":
Yes/no field if the person has a Delta AMEX
"smSunTrstInd":
Yes/no field if the person has a SunTrust debit card.
"stProvCd":
At least for USA its the two digit state code (i.e DC)
Delta, thank you for identifying me as a G25: Younger, up-and-coming singles living big city lifestyles located within top CBSA markets. That is right - I'm a Young City Solo and proud of it.
They have me pegged as a Q65, despite not being old enough to rent a car
