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, 5:09 am
#151
Join Date: May 2009
Location: PHL
Programs: AA EXP, DL DM HH Gold, Marriot Titanium
Posts: 1,298
I got tagged as an O54, despite a number of inaccurate assumptions.
Probably the largest discrepancy between DL's data and reality is my income, which they have tagged as about 1/3 what it really is (perhaps reflecting my previous salary as a resident???)
Here are my data (trimmed of course). FO, been flying DL exclusively for the past 2 years.
"custValSeg":"1",
"discSpndngAmt":"No idea where this number comes from",
"homeValueAmt":"0", (correct - I am a renter)
"incomeAmt":"?????",
"mindsetSeg":"FL",
"mosaicCd":"O54", - maybe I got stuck here due to incorrect income and because i live inter-city?
"smTierLvl":"FO"
Probably the largest discrepancy between DL's data and reality is my income, which they have tagged as about 1/3 what it really is (perhaps reflecting my previous salary as a resident???)
Here are my data (trimmed of course). FO, been flying DL exclusively for the past 2 years.
"custValSeg":"1",
"discSpndngAmt":"No idea where this number comes from",
"homeValueAmt":"0", (correct - I am a renter)
"incomeAmt":"?????",
"mindsetSeg":"FL",
"mosaicCd":"O54", - maybe I got stuck here due to incorrect income and because i live inter-city?
"smTierLvl":"FO"
Last edited by timmy83; Jan 25, 2013 at 5:41 am
Jan 25, 2013, 5:11 am
#152
Join Date: Jun 2008
Location: BDU
Programs: DL:MM, Marriott:LTT
Posts: 8,779
SS from PM, CustValSeg 6
Income appears to be very old. Disposable income seems to correspond to my DL spend. Home value is not the Zillow value for my house, but may actually be the value of another property I own.
Income appears to be very old. Disposable income seems to correspond to my DL spend. Home value is not the Zillow value for my house, but may actually be the value of another property I own.
Jan 25, 2013, 5:16 am
#153
Join Date: Oct 2011
Location: ATL
Programs: DL DM 1.7MM
Posts: 134
I really hope this info remains visible. Given that I haven't been on a DL flight since Nov. 30, have nothing booked, and this year will likely travel considerably less than half what I've averaged the past three, my "impressive" CusVal of 31 should plummet!
Jan 25, 2013, 5:46 am
#154
Join Date: Apr 2003
Location: Seattle, WA
Programs: DL DM/1MM, Natl Exec Elite, Bonvoy Plat, Hyatt Glob, Hilton Diam
Posts: 382
Most of elements are empty values, but some of note. Also, on the mindset question, I'm living abroad in Ireland and have "IN" so seems to validate that theory. Seems silly to categorize everyone in "IN" if they really use this data for something... Would prefer to be "SS" it sounds like 
,"custValSeg":"3"
"cobrandCardCd":"AX,AXCG", (Have DL Gold AX and AX Platinum/Personal)
,"mindsetSeg":"IN"
,"mosaicCd":"" (boo, was hoping they'd tell me something about myself!)
Not sure how to parse this one:
,"skyClubFtrCntrctInd":"N"
I'm automatically a SC member based on DM status... Weird they'd lump Million Miler into the SC elements, if that's what this indicates (I am not an MM):
,"skyClubMMSts":""
,"skyClubMbr":"Y"
,"custValSeg":"3"
"cobrandCardCd":"AX,AXCG", (Have DL Gold AX and AX Platinum/Personal)
,"mindsetSeg":"IN"
,"mosaicCd":"" (boo, was hoping they'd tell me something about myself!)
Not sure how to parse this one:
,"skyClubFtrCntrctInd":"N"
I'm automatically a SC member based on DM status... Weird they'd lump Million Miler into the SC elements, if that's what this indicates (I am not an MM):
,"skyClubMMSts":""
,"skyClubMbr":"Y"
Jan 25, 2013, 5:48 am
#155
Join Date: Jun 2011
Location: AL
Programs: All of the Above
Posts: 1,374
It's gotta be the higher the custvalseg the more important to DL. I'm a 6, FL and my FO wife is a 0 custvalseg. She has spent a grand total of $0.00 on DL this year. Only award tickets.
Last edited by DavidAL; Jan 25, 2013 at 7:43 am
Jan 25, 2013, 5:54 am
#156
Join Date: May 2009
Location: PHL
Programs: AA EXP, DL DM HH Gold, Marriot Titanium
Posts: 1,298
Jan 25, 2013, 5:58 am
#157
Join Date: Dec 2002
Location: Washington, DC, Chapel Hill, NC (RDU)
Programs: DL Plat (won't hit DM again) 2MM (2.5), HH Gold, PC Gold, Hyatt Plat
Posts: 5,626
Thanks for this, very much.
If the spend is accurate -- and I haven't really tracked that too well myself then I may not have to worry to much about the MQD, I'm about there depending on whether or not taxes are included in this calculation.
Income estimate is way off -- less than half of actual last year.
My cust val is 2
If the spend is accurate -- and I haven't really tracked that too well myself then I may not have to worry to much about the MQD, I'm about there depending on whether or not taxes are included in this calculation.
Income estimate is way off -- less than half of actual last year.
My cust val is 2
Jan 25, 2013, 6:03 am
#158
Join Date: Jan 2000
Location: ATL - DL DM/3MM - HH Lifetime Diamond - Marriott Lifetime Plat
Posts: 3,117
Thanks for posting
I got SS
I'm a C11 - Upscale boomer-aged couples living in city and close-in suburbs - I guess that's right.
CustValSeg - 8
smMqmBal was my rollover amount
Home value amount was the recent appraisal from last years refinance - too low.
Income was correct from last years return - perhaps they got that info from the refinance?
I got SS
I'm a C11 - Upscale boomer-aged couples living in city and close-in suburbs - I guess that's right.
CustValSeg - 8
smMqmBal was my rollover amount
Home value amount was the recent appraisal from last years refinance - too low.
Income was correct from last years return - perhaps they got that info from the refinance?
Last edited by Tomphot; Jan 25, 2013 at 6:12 am
Jan 25, 2013, 6:04 am
#159
Join Date: Sep 2011
Location: Wherever I happen to be....
Programs: DL EOS...
Posts: 1,111
I guess this probably explains why the website is so slow? They're more interested in pushing BS data about me than providing a portal to purchase their product. Way to go big D!!!
FWIW - PM, FL, 0-value
Mosaic is very weird but I would rather not say here....
I think my future pattern with this company is gonna be scorched earth. Take every single benefit I've been promised while moving my business elsewhere.
FWIW - PM, FL, 0-value
Mosaic is very weird but I would rather not say here....
I think my future pattern with this company is gonna be scorched earth. Take every single benefit I've been promised while moving my business elsewhere.
Jan 25, 2013, 6:18 am
#161
Join Date: Mar 2004
Programs: DL PM, DL MM, Hilton Gold, Marriott Gold, SPG
Posts: 804
Updated as of all posts above this one (and some data received via Private Message):
BH from No Status, CustValSeg 0
DW from FO, CustValSeg 0
DW from DM, CustValSeg 20
FL from FO, CustValSeg 1
FL from FO, CustValSeg 2
FL from PM, CustValSeg 1
GT from DM, CustValSeg 0
GT from DM, CustValSeg 2
GT from DM, CustValSeg 27
IN from FO, CustValSeg 0
MM from FO, CustValSeg 0
MM from FO, CustValSeg 0
SS from GM, CustValSeg 2
SS from PM, CustValSeg 11
SS from PM, CustValSeg 5
SS from DM, CustValSeg 3
SS from DM, CustValSeg 6
SS from DM, CustValSeg 12
SS from Unknown Level, CustValSeg 5
BH from No Status, CustValSeg 0
DW from FO, CustValSeg 0
DW from DM, CustValSeg 20
FL from FO, CustValSeg 1
FL from FO, CustValSeg 2
FL from PM, CustValSeg 1
GT from DM, CustValSeg 0
GT from DM, CustValSeg 2
GT from DM, CustValSeg 27
IN from FO, CustValSeg 0
MM from FO, CustValSeg 0
MM from FO, CustValSeg 0
SS from GM, CustValSeg 2
SS from PM, CustValSeg 11
SS from PM, CustValSeg 5
SS from DM, CustValSeg 3
SS from DM, CustValSeg 6
SS from DM, CustValSeg 12
SS from Unknown Level, CustValSeg 5
Jan 25, 2013, 6:21 am
#162
Join Date: May 2009
Location: PHL
Programs: AA EXP, DL DM HH Gold, Marriot Titanium
Posts: 1,298
Jan 25, 2013, 6:25 am
#163
Join Date: Jul 2010
Location: SUX
Programs: BA Silver; HHonors Gold; SPG Gold; Points but dirt with everyone else
Posts: 8,050
PM with a mindset of GT and value segment of 1. From the second half of 2010 through 2012, most of my travel was international, as I was LHR-based. I'm now back in the US. This supports the "Global Traveller" theory.
I'm also in the phantom kids group (apparently I have three, despite not having the sorts of attractions that can create kids by accident). My income amount is way off (assuming we're taking it to be in thousands), but on the high side. I've never claimed to make that much to AmEx, so the data can't be coming (exclusively) from there.
I'm also in the phantom kids group (apparently I have three, despite not having the sorts of attractions that can create kids by accident). My income amount is way off (assuming we're taking it to be in thousands), but on the high side. I've never claimed to make that much to AmEx, so the data can't be coming (exclusively) from there.
Jan 25, 2013, 6:29 am
#164
FlyerTalk Evangelist
Join Date: Sep 2002
Location: IND
Programs: DL PM & 2MM™, Lifetime HHonors Diamond
Posts: 20,889
What the hell, I will add my data points.
custValSeg":"6"
"mindsetSeg":"SS"
"mosaicCd":"N46" (True Grit American, not very accurate)
I hope my house is worth as much as they think it is. Income way low but close. It is even lower than when I applied for AMEX.
custValSeg":"6"
"mindsetSeg":"SS"
"mosaicCd":"N46" (True Grit American, not very accurate)
I hope my house is worth as much as they think it is. Income way low but close. It is even lower than when I applied for AMEX.
Jan 25, 2013, 6:32 am
#165
Join Date: Jun 2004
Location: ATL
Programs: Delta PlM, 1M
Posts: 6,363
They are only 2 letter codes, DW is short for DykWia 
For me I am a FL/GM/1 which I would guess makes me worthless except for my plastic.
They have my income at about 1/3 the real value. Just a guess, could be the last time I filled out a full Amex application (whcih was so long ago I do not remember).
Have no clue where they came up with disp. inc., it is way high for DL spend and way low for anything else (including CC data). Could be close to my DL spend from 2011.
G24? Considiring they have my birthday correct, should be something like "silly old fart who thinks he's still a kid".
For me I am a FL/GM/1 which I would guess makes me worthless except for my plastic.
They have my income at about 1/3 the real value. Just a guess, could be the last time I filled out a full Amex application (whcih was so long ago I do not remember).
Have no clue where they came up with disp. inc., it is way high for DL spend and way low for anything else (including CC data). Could be close to my DL spend from 2011.
G24? Considiring they have my birthday correct, should be something like "silly old fart who thinks he's still a kid".