Go Back   FlyerTalk Forums > Miles&Points > Airlines and Mileage Programs > Delta Air Lines | SkyMiles
Sign in using an external account

    Hide Wikipost
Old Nov 25, 13, 8:02 am   -   Wikipost
FlyerTalk Forums Thread Wiki: Delta and new DL.com Profiles A Lot About You
Please read: this is a community-maintained wiki post containing the most important information from this thread.
 
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

Print Wikipost

Reply
 
Thread Tools Search this Thread
Old Jan 24, 13, 10:09 pm   #46
 
Join Date: Apr 2001
Location: Indianapolis, IN USA
Posts: 1,801
BallardFlyer:

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",

Last edited by bowdenj; Jan 25, 13 at 1:19 pm. Reason: editted to get rid of empty/deleted.
bowdenj is offline   Reply With Quote
Old Jan 24, 13, 10:09 pm   #47
 
Join Date: Jul 2010
Location: MKE
Programs: DL-MM-Diamond HH-Diamond
Posts: 3,214
I will buy a F tomorrow and see if that number changes


Just thinking how pissed Delta is going to be tomorrow. LOL
MR_MAMA is offline   Reply With Quote
Old Jan 24, 13, 10:10 pm   #48
FlyerTalk Evangelist
 
Join Date: Oct 2011
Location: Anywhere I need to be.
Programs: OW Emerald, *A Gold, NEXUS, GE, ABTC/APEC, South Korea SES, some other CCs
Posts: 13,820
Quote:
Originally Posted by steex View Post
  • "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.
My income to DL is also much higher than my real income.
__________________
RIP AA. 1934-9 Dec 2013.
AA_EXP09 is offline   Reply With Quote
Old Jan 24, 13, 10:11 pm   #49
FlyerTalk Evangelist
 
Join Date: Oct 2011
Location: Anywhere I need to be.
Programs: OW Emerald, *A Gold, NEXUS, GE, ABTC/APEC, South Korea SES, some other CCs
Posts: 13,820
Quote:
Originally Posted by MR_MAMA View Post
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?
__________________
RIP AA. 1934-9 Dec 2013.
AA_EXP09 is offline   Reply With Quote
Old Jan 24, 13, 10:13 pm   #50
 
Join Date: Jul 2010
Location: MKE
Programs: DL-MM-Diamond HH-Diamond
Posts: 3,214
Quote:
Originally Posted by AA_EXP09 View Post

And refund shortly after?
hmm let me buy now l see if my number changes..
MR_MAMA is offline   Reply With Quote
Old Jan 24, 13, 10:15 pm   #51
FlyerTalk Evangelist
 
Join Date: Oct 2011
Location: Anywhere I need to be.
Programs: OW Emerald, *A Gold, NEXUS, GE, ABTC/APEC, South Korea SES, some other CCs
Posts: 13,820
Quote:
Originally Posted by MR_MAMA View Post
hmm let me buy now l see if my number changes..
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.
__________________
RIP AA. 1934-9 Dec 2013.
AA_EXP09 is offline   Reply With Quote
Old Jan 24, 13, 10:15 pm   #52
 
Join Date: Aug 2004
Programs: Delta GM, UA Silver, Marriott Plat, Former JetBlue Crewmember
Posts: 794
Pretty interesting... they think I make 3 times my actual income though. I guess a good problem to have? :-) My cust value segment is 0.

Last edited by amejr999; Jan 24, 13 at 10:33 pm.
amejr999 is offline   Reply With Quote
Old Jan 24, 13, 10:16 pm   #53
 
Join Date: Jan 2010
Location: ATL
Programs: DM, KM,
Posts: 161
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
Miniflyer is offline   Reply With Quote
Old Jan 24, 13, 10:19 pm   #54
 
Join Date: Dec 2010
Location: MSP
Programs: DL PM, A3 Gold, TK Elite, SPG Plat, HH Diamond, Hyatt Plat, National EE
Posts: 958
Quote:
Originally Posted by steex View Post
[*] "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 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.
mattsteg is offline   Reply With Quote
Old Jan 24, 13, 10:20 pm   #55
 
Join Date: Jul 2010
Location: MKE
Programs: DL-MM-Diamond HH-Diamond
Posts: 3,214
Quote:
Originally Posted by AA_EXP09 View Post
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
MR_MAMA is offline   Reply With Quote
Old Jan 24, 13, 10:29 pm   #56
 
Join Date: Dec 2005
Location: Analyzing Game Theory and Uncertainty. Also. DL Charter DM, 2.004MM
Programs: DYKWIA Extraordinaire. TrollSlayer Mega Diamond. [insert esoteric sounding status level(s) here]
Posts: 5,153
This data is both accurate and inaccurate.

Nice to finally see my mythical score.
__________________
Loyalty Programs Should Be Loyal.
Why do you stick with Delta?
Vuelos is offline   Reply With Quote
Old Jan 24, 13, 10:30 pm   #57
 
Join Date: Mar 2012
Location: DCA
Programs: Delta SkyMiles - Gold Medallion
Posts: 82
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?

Last edited by dtwtransport; Jan 24, 13 at 10:39 pm.
dtwtransport is offline   Reply With Quote
Old Jan 24, 13, 10:32 pm   #58
 
Join Date: Aug 2004
Programs: Delta GM, UA Silver, Marriott Plat, Former JetBlue Crewmember
Posts: 794
Quote:
Originally Posted by Vuelos View Post
Nice to finally see my mythical score.
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?
amejr999 is offline   Reply With Quote
Old Jan 24, 13, 10:33 pm   #59
 
Join Date: May 2008
Location: CNX
Programs: TK Elite (*G), DL SM (MM)
Posts: 84
Nothing in my profile that DL wouldn't have in my SkyMiles profile. I don't have their AmEx card and none of the income or mosaic-type values are filled in.
ovenman is online now   Reply With Quote
Old Jan 24, 13, 10:34 pm   #60
FlyerTalk Evangelist & Ambassador: China
 
Join Date: Aug 2005
Location: MSP/PVG/SFO
Programs: DL KM, HH Diamond, IC Amb, Hyatt Diamond, NA EE
Posts: 14,940
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?
mnredfox is offline   Reply With Quote
 
 
Reply

Bookmarks


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off
Forum Jump


All times are GMT -6. The time now is 2:49 am.