Jun 12, 2013, 7:24 pm
Last edit by: Schmoops
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.
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
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
Delta and new DL.com Profiles A Lot About You
gotta love student jobs haha
Jan 24, 2013, 9:38 pm
#17
Join Date: Jul 2010
Location: MKE
Programs: DL-MM-Diamond HH-Diamond
Posts: 3,218
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 ...
Jan 24, 2013, 9:38 pm
#18
Join Date: Dec 2012
Location: ATL F-Terminal
Programs: Hilton C, Marriott Pt, Delta Pt
Posts: 249
"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",
Jan 24, 2013, 9:41 pm
#20
Join Date: Sep 2006
Location: LAX
Programs: Fallen DL DM (PM) 2MM
Posts: 4,783
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...
Jan 24, 2013, 9:41 pm
#21
Join Date: Jul 2010
Location: MKE
Programs: DL-MM-Diamond HH-Diamond
Posts: 3,218
"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",
Jan 24, 2013, 9:43 pm
#22
Join Date: Jul 2010
Location: MKE
Programs: DL-MM-Diamond HH-Diamond
Posts: 3,218
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...
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...
Jan 24, 2013, 9:44 pm
#23
Join Date: Sep 2011
Programs: DL DM & 1MM
Posts: 618
Jan 24, 2013, 9:47 pm
#25
Join Date: Dec 2009
Location: SAN
Posts: 4,923
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?
Jan 24, 2013, 9:49 pm
#26
Join Date: Feb 2009
Location: BER, SAT, AUS
Programs: Feels like FO (AA EXP)
Posts: 1,611
It is true: 
"incomeAmt":"8"
My mosaic translates to "Young, multi-ethnic singles living in Midwest and Southern city centers". Aha. Hopefully my better half and BER don't mind.
"incomeAmt":"8"
My mosaic translates to "Young, multi-ethnic singles living in Midwest and Southern city centers". Aha. Hopefully my better half and BER don't mind.
Last edited by c_d; Jan 24, 2013 at 9:58 pm
Jan 24, 2013, 9:53 pm
#27
FlyerTalk Evangelist
Join Date: Oct 2011
Location: Anywhere I need to be.
Programs: OW Emerald, *A Gold, NEXUS, GE, ABTC/APEC, South Korea SES, eIACS, PP, Hyatt Diamond
Posts: 16,046
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
Jan 24, 2013, 9:53 pm
#28
Join Date: Mar 2004
Programs: DL PM, DL MM, Hilton Gold, Marriott Gold, SPG
Posts: 804
Thanks for the link.
My home value was quite accurate but the income amount was a strange number. Customer ValSeg was 1.
Jan 24, 2013, 9:55 pm
#30
Join Date: Nov 2011
Location: WY
Programs: Delta PM, SPG Gold, Hyatt Diamond
Posts: 17
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.