-
Jun 12, 2013, 7:24 pm by SchmoopsFigured 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
#151
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"
#152
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.
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!
#154
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"
#156
Quote:
,"skyClubFtrCntrctInd":"N"
I believe that's a future skyclub contract (i.e. - a 3 year contract or if you bought one with the diamond discount while still on contract with status)Originally Posted by doubleA
Not sure how to parse this one:,"skyClubFtrCntrctInd":"N"
#157
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
#158
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?
#159
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.
Quote:
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
I'm a PM, listed as DW.Originally Posted by steex
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
#162
Quote:
It's like the 1 in math, it's just understood.Originally Posted by cmh flyer
Where is the Ham Sandwich category?
Although this CustSegVal could indicate approximately how many ham sandwiches each customer is worth. Sorry all of you 0's....
#163
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.
#164
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.
#165
Quote:
They are only 2 letter codes, DW is short for DykWia Originally Posted by cmh flyer
I'm a PM, listed as DW.
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".