-
Jun 12, 2013, 7:24 pm by SchmoopsFigured 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
#16
goodandclassy , Jan 24, 2013 9:34 pm
probably your income when you first applied for amex - mine is also a third of what it is now gotta love student jobs haha
#17
Mindset seg has to do with the revene mgmt
Customer Centric Revenue Management
hotelprofit.blogspot.com/
Delta airlines recently executed a re-positioning of their brand image and now uses mind set based segmentation of customers.The systematic success of ...
Customer Centric Revenue Management
hotelprofit.blogspot.com/
Delta airlines recently executed a re-positioning of their brand image and now uses mind set based segmentation of customers.The systematic success of ...
#18
flyertalk77 , Jan 24, 2013 9:38 pm
"chldAgeRange":"POC0T3,POC4T6", <- Fairly accurate. My second one never flew DL so I don't know where they got this info.
"cobrandCardCd":"AXCV",
"custValSeg":"2", <- I'm currently GM.
"discSpndngAmt":"xxxxx", <- Interesting.
"drvdGndr":"M", <- Gender?
"homeValueAmt":"xxxxxx", <- A bit off but close.
"incomeAmt":"xxx", <- Really?
"mindsetSeg":"SS",
"mosaicCd":"A03",
"cobrandCardCd":"AXCV",
"custValSeg":"2", <- I'm currently GM.
"discSpndngAmt":"xxxxx", <- Interesting.
"drvdGndr":"M", <- Gender?
"homeValueAmt":"xxxxxx", <- A bit off but close.
"incomeAmt":"xxx", <- Really?
"mindsetSeg":"SS",
"mosaicCd":"A03",
#20
TheMadBrewer , Jan 24, 2013 9:41 pm
Hmmm.
custValSeg":"0" --> about right for "trash" DM
"mindsetSeg":"GT"
"mosaicCd":"E19" --> I see "E" is "Thriving Boomers" and E19 is "Full Pockets -- Empty Nests" --> Bang on, except for the pockets
"discSpndngAmt":"xxxxxx" --> Higher than my DL spend, lower than my Amex spend.
homeValueAmt":"xxxxxx" --> very low, unless it is just my half in which case it's only a bit low
A little disturbing that this is being sent in the clear...
custValSeg":"0" --> about right for "trash" DM
"mindsetSeg":"GT"
"mosaicCd":"E19" --> I see "E" is "Thriving Boomers" and E19 is "Full Pockets -- Empty Nests" --> Bang on, except for the pockets
"discSpndngAmt":"xxxxxx" --> Higher than my DL spend, lower than my Amex spend.
homeValueAmt":"xxxxxx" --> very low, unless it is just my half in which case it's only a bit low
A little disturbing that this is being sent in the clear...
#21
Quote:
"cobrandCardCd":"AXCV",
"custValSeg":"2", <- I'm currently GM.
"discSpndngAmt":"xxxxx", <- Interesting.
"drvdGndr":"M", <- Gender?
"homeValueAmt":"xxxxxx", <- A bit off but close.
"incomeAmt":"xxx", <- Really?
"mindsetSeg":"SS",
"mosaicCd":"A03",
Your mosaic is in the power elite category called kids and CabernetOriginally Posted by flyertalk77
"chldAgeRange":"POC0T3,POC4T6", <- Fairly accurate. My second one never flew DL so I don't know where they got this info."cobrandCardCd":"AXCV",
"custValSeg":"2", <- I'm currently GM.
"discSpndngAmt":"xxxxx", <- Interesting.
"drvdGndr":"M", <- Gender?
"homeValueAmt":"xxxxxx", <- A bit off but close.
"incomeAmt":"xxx", <- Really?
"mindsetSeg":"SS",
"mosaicCd":"A03",
#22
Quote:
custValSeg":"0" --> about right for "trash" DM
"mindsetSeg":"GT"
"mosaicCd":"E19"
"discSpndngAmt":"xxxxxx" --> Higher than my DL spend, lower than my Amex spend.
homeValueAmt":"xxxxxx" --> very low, unless it is just my half in which case it's only a bit low
A little disturbing that this is being sent in the clear...
Mosaic e19 thriving boomers full pockets empty nestsOriginally Posted by TheMadBrewer
Hmmm.custValSeg":"0" --> about right for "trash" DM
"mindsetSeg":"GT"
"mosaicCd":"E19"
"discSpndngAmt":"xxxxxx" --> Higher than my DL spend, lower than my Amex spend.
homeValueAmt":"xxxxxx" --> very low, unless it is just my half in which case it's only a bit low
A little disturbing that this is being sent in the clear...
#25
My score "1"
The spend they have is a touch over 17250 which is a bit over double what I actually spent.
The income was low by about 20%.
The home value is right on.
It appears that I have a child I'm not aware of...I wonder if I can claim the additional credit?
The spend they have is a touch over 17250 which is a bit over double what I actually spent.
The income was low by about 20%.
The home value is right on.
It appears that I have a child I'm not aware of...I wonder if I can claim the additional credit?
#27
Home value is above 6m (I am in SYD QF lounge now using a HK based VPN, the physical location is in Wanchai if it helps)
Income is way too high
Cust type is 2
Disc spend is much higher than my DL spend-according to DL 40% of my (actual) income is discretionary (converted HKD to USD using interbank rates)
Male
Income is way too high
Cust type is 2
Disc spend is much higher than my DL spend-according to DL 40% of my (actual) income is discretionary (converted HKD to USD using interbank rates)
Male
Now THAT is very interesting! I'm a B07, Generational Soup.
Thanks for the link.
My home value was quite accurate but the income amount was a strange number. Customer ValSeg was 1.
Thanks for the link.
My home value was quite accurate but the income amount was a strange number. Customer ValSeg was 1.
#29
flyingspacey , Jan 24, 2013 9:55 pm
custValSeg:"7" --- Guessing that this is the number of segments flown this year
#30
broadbandcowboy , Jan 24, 2013 9:55 pm
Great find.
"custValSeg":"2"
I'm a plat that falls close the MQD threshold but had a few paid F flights in 2012. Maybe that bumps me up to segment 2.
chldAgeRange":"", -- blank but I have 2 kids with skymiles accounts.
"custValSeg":"2"
I'm a plat that falls close the MQD threshold but had a few paid F flights in 2012. Maybe that bumps me up to segment 2.
chldAgeRange":"", -- blank but I have 2 kids with skymiles accounts.