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
#826
Formerly known as fsa_ea
Join Date: Dec 2004
Location: Up in the Air
Programs: UA GS/1MM,AS 75k,NK GLD,AA 2MM,DL 2MM,LH FT,AY PLT,IC RA,FMT LT PLT,HYT GLB,HLT DIA,MRT GLD,HRTZ PC
Posts: 2,229
This is pretty amusing:
1) My income is 7x higher than DL shows
2) The home values for my partner and I (we share the same address) differ by 6x
3) DL thinks I am an "Asian Achiever". I'm about as white as they come...
4) DL thinks my partner is a "Latin Flair". He is African Ameircan.
Oh, and let's not forget that we are apparently worth 0 to DL. Nice, I guess than $20k we spend each year is worthless?
Where do they get this crap?
1) My income is 7x higher than DL shows
2) The home values for my partner and I (we share the same address) differ by 6x
3) DL thinks I am an "Asian Achiever". I'm about as white as they come...
4) DL thinks my partner is a "Latin Flair". He is African Ameircan.
Oh, and let's not forget that we are apparently worth 0 to DL. Nice, I guess than $20k we spend each year is worthless?
Where do they get this crap?
#828
Join Date: May 2009
Location: PHL
Programs: AA EXP, DL DM HH Gold, Marriot Titanium
Posts: 1,298
I am very curious to know who at DL can see this data and what it's used for. I don't care about inaccuracies if it's simply used for targeted ads, but if CSAs see this when I call, I'd like to ensure it's right.
That said, it's not. Income is far off, and my mosiac code is only correct in that I live in a city center in the midwest (otherwise I'm not low-income, a minority, nor do I only have an associates or entry-level bachelor's degree). I'm sure that, just like when this was previously uncovered, DwayneSkyMiles or DLCorpGuy will provide meaningful insight.
That said, it's not. Income is far off, and my mosiac code is only correct in that I live in a city center in the midwest (otherwise I'm not low-income, a minority, nor do I only have an associates or entry-level bachelor's degree). I'm sure that, just like when this was previously uncovered, DwayneSkyMiles or DLCorpGuy will provide meaningful insight.
#829
Join Date: Feb 2008
Location: JFK,ATL,LGA (the rest of the world follows)
Programs: DL KM/DM/2MM (NH Plat emeritus, CO Plat emeritus, and no place like home)
Posts: 3,190
Same data, new coding... now that we found it, we may get in a short while a new code, yet again-it would contain the same data. *tired*
Still, the Customer Score value is of most interest, as well as the empty fields. One of them would be the MQD at some point. Another has to be some spending/flexibility indicator (aka- more waivers, less waivers, etc.) We'll wait and see.
Still, the Customer Score value is of most interest, as well as the empty fields. One of them would be the MQD at some point. Another has to be some spending/flexibility indicator (aka- more waivers, less waivers, etc.) We'll wait and see.
#830
Join Date: Dec 2003
Location: St. Paul, MN
Programs: Walmart Super Elite
Posts: 728
It would be interesting to see if there are correlations between v30 (customer value score) and compensation for various complaints -- perhaps v30 scores could be included in posts in the 2013 Compensation Thread. For example, my v30 is 3 and for a recent four segment international itinerary with two missing special meals and one broken IFE, I received only 7500 SkyPesos after filing a complaint.
#831
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
So where there are null fields "" would be the very likely place for this. I have quite a few so can not narrow down too much.
#832
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
If this is the case then I have valuable data points - I do not nor have never had Suntrust. I have Y in V03, V27, V29, V35 and the only N I have is V10. So if your theory is correct V10 would be for Suntrust.
#833
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
"v24":"HBEKBHBX", SkyClub renewal date 20130209 correct
I renewed early February for the 14 months rather than 12 months promotion - mine expires April 2014 - so this is correct.
I renewed early February for the 14 months rather than 12 months promotion - mine expires April 2014 - so this is correct.
#834
Join Date: Mar 2011
Posts: 647
any thoughts on V16? Could it be age related? I see many 143s of professionals the same age, a 141 of another professional slightly younger, and a 163 of someone about 20 years older.
Edited to thank Lamont2718 for the amazing work with the coding key!
Edited to thank Lamont2718 for the amazing work with the coding key!
Last edited by flyerwma; Jun 13, 2013 at 8:35 am
#835
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
I am V16 = 155 - I am 56 years old, research scientist - but this makes my Experian K40 even more weird - lowish income, not well educated possibly some college?