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 25, 2013, 10:54 am
#301
Join Date: Dec 2010
Location: MSP
Programs: AA EXP, DL PM (FO soon), A3 Gold, TK Classic Plus, SPG Plat, HH Gold, Hyatt Diamond, National EE
Posts: 1,003
Jan 25, 2013, 10:55 am
#302
A FlyerTalk Posting Legend
Join Date: Sep 2009
Location: Minneapolis: DL DM charter 2.3MM
Programs: A3*Gold, SPG Plat, HyattDiamond, MarriottPP, LHW exAccess, ICI, Raffles Amb, NW PE MM, TWA Gold MM
Posts: 100,417
I'm starting to guess that mindset has something to do with tendency to stick with DL as well as spend, so it could summarize not only whether a customer is valuable but also whether they're likely to leave if they're not treated well.
Jan 25, 2013, 10:56 am
#303
A FlyerTalk Posting Legend
Join Date: Sep 2009
Location: Minneapolis: DL DM charter 2.3MM
Programs: A3*Gold, SPG Plat, HyattDiamond, MarriottPP, LHW exAccess, ICI, Raffles Amb, NW PE MM, TWA Gold MM
Posts: 100,417
Jan 25, 2013, 10:59 am
#304
Join Date: Dec 2010
Location: MSP
Programs: AA EXP, DL PM (FO soon), A3 Gold, TK Classic Plus, SPG Plat, HH Gold, Hyatt Diamond, National EE
Posts: 1,003
A01 - American Royalty. It's pretty clear they just needed to use my zip code to determine this based on their overall summary. I'm guessing 99 percent of this ranking is based on where you live.
They had my home value correct and income about 10-15 % low.
Can't figure out mindset: IA.
They had my home value correct and income about 10-15 % low.
Can't figure out mindset: IA.
Jan 25, 2013, 11:04 am
#306
Join Date: Oct 2003
Location: DTW
Programs: DM MM
Posts: 184
Here is mine:
"smTierLvl":"DM"
"mindsetSeg":"SS"
"custValSeg":"17"
I am predicting next week we will get someone posting on the DYKWIA thread - just saw a guy yelling at a GA, I am a Cust Val Seg xx, you need to .....
BallardFlyer ^^^^ thanks.
"smTierLvl":"DM"
"mindsetSeg":"SS"
"custValSeg":"17"
I am predicting next week we will get someone posting on the DYKWIA thread - just saw a guy yelling at a GA, I am a Cust Val Seg xx, you need to .....
BallardFlyer ^^^^ thanks.
Jan 25, 2013, 11:05 am
#308
Join Date: Dec 2010
Location: MSP
Programs: AA EXP, DL PM (FO soon), A3 Gold, TK Classic Plus, SPG Plat, HH Gold, Hyatt Diamond, National EE
Posts: 1,003
On the extreme side, for sure, but not impossible. The issue is more the apparent wild miss on income than anything else.
Also, income may well be as reported by Experian, without direct factoring of delta spend. In any case, if the primary input data for income estimation is bad enough for the output to be off by a factor of 15, there's little hope for a sane output of any sort.
Also, income may well be as reported by Experian, without direct factoring of delta spend. In any case, if the primary input data for income estimation is bad enough for the output to be off by a factor of 15, there's little hope for a sane output of any sort.
Jan 25, 2013, 11:07 am
#309
Join Date: Apr 2003
Location: Seattle, WA
Programs: DL DM/1MM, Natl Exec Elite, Bonvoy Plat, Hyatt Glob, Hilton Diam
Posts: 382
status matched GM (although I still flew 30k last year on Delta, a good bit booked in First or paid gate upgrades)- "custValSeg":"0"
homeValueAmt- Exact purchase price, had to have been pulled from NYC's real estate records
incomeAmt- Very close to being accurate including things like stock and other bonuses that I wouldn't normally include
mosiacCd: A06 (Jet Set Urbanite) Very accurate except I'm 25
mindsetSeg: NB (New business since I just status matched?)
homeValueAmt- Exact purchase price, had to have been pulled from NYC's real estate records
incomeAmt- Very close to being accurate including things like stock and other bonuses that I wouldn't normally include
mosiacCd: A06 (Jet Set Urbanite) Very accurate except I'm 25
mindsetSeg: NB (New business since I just status matched?)
Jan 25, 2013, 11:07 am
#310
A FlyerTalk Posting Legend
Join Date: Sep 2009
Location: Minneapolis: DL DM charter 2.3MM
Programs: A3*Gold, SPG Plat, HyattDiamond, MarriottPP, LHW exAccess, ICI, Raffles Amb, NW PE MM, TWA Gold MM
Posts: 100,417
On the extreme side, for sure, but not impossible. The issue is more the apparent wild miss on income than anything else.
Also, income may well be as reported by Experian, without direct factoring of delta spend. In any case, if the primary input data for income estimation is bad enough for the output to be off by a factor of 15, there's little hope for a sane output of any sort.
Also, income may well be as reported by Experian, without direct factoring of delta spend. In any case, if the primary input data for income estimation is bad enough for the output to be off by a factor of 15, there's little hope for a sane output of any sort.
Jan 25, 2013, 11:08 am
#311
Join Date: May 2006
Location: GA
Programs: VA-PLT, QF-GLD, DL-GM, UA-ex1K, AA-exPLT, HH-DM, IHG-PLT, MR-GLD
Posts: 8,242
Jan 25, 2013, 11:08 am
#312
Join Date: Jan 2007
Posts: 5,679
Jan 25, 2013, 11:11 am
#314
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001