-
FlyerTalk Forums Expert How-Tos and Guides
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
#46
Apr 14, 2024BallardFlyer:
Great find! Here's me - interesting stuff. Perhaps a note to Delta.com is in order to find out what this is.
[editted to get rid of empty stuff/deleted stuff]
"actvtyPref":"",
"custValSeg":"5",
"discSpndngAmt":"5473",
"mindsetSeg":"SS",
"mosaicCd":"S69",
Great find! Here's me - interesting stuff. Perhaps a note to Delta.com is in order to find out what this is.
[editted to get rid of empty stuff/deleted stuff]
"actvtyPref":"",
"custValSeg":"5",
"discSpndngAmt":"5473",
"mindsetSeg":"SS",
"mosaicCd":"S69",
#48
Quote:
I'm mostly in the same boat.
My income to DL is also much higher than my real income.Originally Posted by steex
- "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.
#49
Quote:
Just thinking how pissed Delta is going to be tomorrow. LOL
Originally Posted by MR_MAMA
I will buy a F tomorrow and see if that number changes Just thinking how pissed Delta is going to be tomorrow. LOL
And refund shortly after?
#51
Quote:
What route are you looking at?Originally Posted by MR_MAMA
hmm let me buy now l see if my number changes..
(You don't have to tell me exactly and you can code it-I'm not bad with them. Alternately you could PM me.)
This should be really interesting for me to do as an analysis of an application of marketing.
#53
home value--spot on
income--dead wrong
spending amt--shocking if I really spent that much on flights! My calc. is half.
Mosaic--A01, American Royalty--really? This from a true earth mother, although I do enjoy watching Downton Abbey.
Cust value=7
income--dead wrong
spending amt--shocking if I really spent that much on flights! My calc. is half.
Mosaic--A01, American Royalty--really? This from a true earth mother, although I do enjoy watching Downton Abbey.
Cust value=7
#54
Quote:
I think the discretionary spending could be from the Mosaic stuff as well, as that's part of that profile. Mine was greater than my delta spend by a reasonable amount.Originally Posted by steex
[*] "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.
#55
Quote:
(You don't have to tell me exactly and you can code it-I'm not bad with them. Alternately you could PM me.)
This should be really interesting for me to do as an analysis of an application of marketing.
Originally Posted by AA_EXP09
What route are you looking at?(You don't have to tell me exactly and you can code it-I'm not bad with them. Alternately you could PM me.)
This should be really interesting for me to do as an analysis of an application of marketing.
It did not change. bought an A fare. logged out and back in, and number still stayed the same. it could be after flown. I am actually going to buy this fare, because it is only $300 but need to fix the times.
MKE-MSP
#57
dtwtransport , Jan 24, 2013 10:30 pm
Wow -- almost creepy! My profile is accurate other than my income is showing a little under half of what I actually make. I've made the same salary with only small increases for at least four years. My Mosaic (O54) is accurate for the most part excepting the income assumptions and I am two years out of my 20s (I think I'm more G25).
custValSeg: 1. I'm an FO, frequently fly between DCA and DTW, travel to LAS 2x/year, travel to LAX and SFO at least once, travel to CHI 3x/year (oh how I wish there was a DL or partner connection between WAS and CHI -- a DL hole between two large and domestic markets... ugh).
Anyone able to crack "custValSeg" yet?
custValSeg: 1. I'm an FO, frequently fly between DCA and DTW, travel to LAS 2x/year, travel to LAX and SFO at least once, travel to CHI 3x/year (oh how I wish there was a DL or partner connection between WAS and CHI -- a DL hole between two large and domestic markets... ugh).
Anyone able to crack "custValSeg" yet?
#58
Quote:
Now I'm getting very curious. The Mosaic program is run by Experian, and I believe that under the Fair Credit Reporting Act, I should be entitled to get a copy of the data the have on me (I've gotten a similar disclosure from LexisNexis in the past). But I don't see anywhere to do that on the Experian website. Am I barking up the wrong tree?Originally Posted by Vuelos
Nice to finally see my mythical score.
#60
Creepy for me as well. More or less accurate on:
- Income
- Mosaic id - LOL
Not so sure on...
- Home value - not, I have no clue what this means
- Cust value - I'm 3. Not sure what that means
- Disc spending - is this how much we actually spend on DL?
- Income
- Mosaic id - LOL
Not so sure on...
- Home value - not, I have no clue what this means
- Cust value - I'm 3. Not sure what that means
- Disc spending - is this how much we actually spend on DL?