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
Jan 24, 2013, 9:55 pm
#31
Join Date: Jul 2010
Location: MKE
Programs: DL-MM-Diamond HH-Diamond
Posts: 3,218
MINDset = Focus on the person’s MINDset—their motivations, interest, needs and desires. (page 4) http://www.delta.com/content/dam/del...letter2012.pdf
still trying to figure out their categories.
still trying to figure out their categories.
Jan 24, 2013, 9:55 pm
#32
Join Date: Dec 2012
Location: ATL F-Terminal
Programs: Hilton C, Marriott Pt, Delta Pt
Posts: 249
Jan 24, 2013, 9:56 pm
#33
Join Date: Jan 2008
Location: Upstate, NY
Posts: 3,359
Which is......G24 Status Seeking Singles
Kinda interesting.... some info is very close....but other info is very off (old?)
Jan 24, 2013, 9:57 pm
#34
Join Date: Jul 2012
Location: MSP
Programs: Delta PM, Hyatt Discoverist, Hertz PC
Posts: 2,303
Jan 24, 2013, 9:57 pm
#35
Join Date: Jun 2001
Location: SAN
Programs: AS 100K, DL MM, AA PLT
Posts: 2,934
I suspect all the income/Mosaic info comes from Amex, as it is the same for me, my wife, and my 3 year-old. However, the custValSeg is definitely different. My GM 3-year-old is a 0, while my DM wife is a 1, and I (a DM/MM) am a 9. No idea how high the scale goes....
Jan 24, 2013, 10:00 pm
#38
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
On Chrome logged out
Try clicking
Inspect element
Scripts
If you can understand it then it can help decode how they get the results.
My full script result yielded more than 299,000 characters
Inspect element
Scripts
If you can understand it then it can help decode how they get the results.
My full script result yielded more than 299,000 characters
Jan 24, 2013, 10:00 pm
#39
Join Date: Jun 2001
Location: SAN
Programs: AS 100K, DL MM, AA PLT
Posts: 2,934
Jan 24, 2013, 10:02 pm
#41
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
My result is 673
(This amount is more than 30% my income in HKD from last year)
Jan 24, 2013, 10:06 pm
#43
Join Date: Nov 2007
Location: SJC (formerly CHI and STL)
Programs: AS, DL, AA, UA, WN
Posts: 1,013
- "custValSeg":"0" - That seems correct, I'm a low value FO.
- "mindsetSeg":"MM" - Don't know.
- "mosaicCd":"H29" - Eh, sort of. I guess they're partly right.
- "incomeAmt":"$$", - This is a surprisingly inaccurate number for me. If we assume this represents your annual income divided by 1000, this amount is less than a third of my current income, and actually less than half of the lowest income I've ever had since leaving college (and less than half what I made when I got my AmEx).
- "homeValueAmt":"$$$$$$", - This one was pretty accurate.
- "discSpndngAmt":"$$$$$", - For me, this was considerably higher than my spend on DL flights this year, so I would think that's not the key. The part that makes me really curious is that, assuming we've pegged the "incomeAmt" calculation correctly, DL feels my discretionary spending is 82% of my total income despite having correctly identified my home value and therefore presumably having an idea of at least what my mortgage must be.
I'm mostly in the same boat.