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


Reply
 
Thread Tools Search this Thread
Old Jan 25, 13, 2:57 am   #151
 
Join Date: Jan 2013
Location: SYD, SIN, LAX, ATL, CVG
Programs: DL Platinum, QF, VA, AA, UA, US, SQ, EK, Hyatt, Hilton, SPG, Fairmont
Posts: 89
I am a PM with

"custValSeg":"1" <- bad customer?
"mindsetSeg":"BH"
"mosaicCd":"G24" <-- nice try, I have family and kids :-)
jykt is offline   Reply With Quote
Old Jan 25, 13, 3:00 am   #152
 
Join Date: Jun 2008
Location: BER-ish (loving TXL)
Programs: uh, I have that gold airline card, that black hotel thing and some more plastic
Posts: 522
Quote:
Originally Posted by MR_MAMA View Post
hmm you are in Moscow and you have IN. anyone else International with that code?
Yes. My data is old and mostly unpopulated. I also have the IN mindset.
__________________
http://openflights.org/user/hs
El_Duderito is offline   Reply With Quote
Old Jan 25, 13, 3:35 am   #153
 
Join Date: Aug 2003
Location: St. Paul, MN
Programs: DL DM 3.4M MQM , Marriott Lifetime PL, Hertz President Club
Posts: 1,856
custValSeg":"13"
"mindsetSeg":"SS"
"mosaicCd":"B09" Get real. 54 2nd marriage no kids.

House prices I think are based on home address and Zillow.
__________________
NW Gold 88-94 Plat 95-09 3M MQM, DL DM, Marriott PP and Lifetime PL
hnewman is offline   Reply With Quote
Old Jan 25, 13, 4:12 am   #154
 
Join Date: Oct 2011
Location: ATL
Programs: DL DM 1.7MM
Posts: 118
DM

custValSeg = 31
mindsetSeg = GT

Most of my miles are international so supports GlobalTraveler.

Pretty spot on, except they don't seem to know about my kids, and Mosaic of A02 "Platinum Prosperity" is laughable - more like "Platinum Preposterous".
cmaas is offline   Reply With Quote
Old Jan 25, 13, 4:19 am   #155
 
Join Date: Aug 2003
Location: St. Paul, MN
Programs: DL DM 3.4M MQM , Marriott Lifetime PL, Hertz President Club
Posts: 1,856
Quote:
Originally Posted by cmaas View Post
DM

custValSeg = 31
mindsetSeg = GT

Most of my miles are international so supports GlobalTraveler.

Pretty spot on, except they don't seem to know about my kids, and Mosaic of A02 "Platinum Prosperity" is laughable - more like "Platinum Preposterous".
Highest customer value yet. You fly J or coach international?
__________________
NW Gold 88-94 Plat 95-09 3M MQM, DL DM, Marriott PP and Lifetime PL
hnewman is offline   Reply With Quote
Old Jan 25, 13, 4:59 am   #156
 
Join Date: Oct 2011
Location: ATL
Programs: DL DM 1.7MM
Posts: 118
Quote:
Originally Posted by hnewman View Post
Highest customer value yet. You fly J or coach international?
70/30 coach. Lots of 'M' fares, upgraded with SWU's until I run out. BE is almost always on discounted fares; I, S.
cmaas is offline   Reply With Quote
Old Jan 25, 13, 5:00 am   #157
 
Join Date: Aug 2003
Location: St. Paul, MN
Programs: DL DM 3.4M MQM , Marriott Lifetime PL, Hertz President Club
Posts: 1,856
Quote:
Originally Posted by cmaas View Post
70/30 coach. Lots of 'M' fares, upgraded with SWU's until I run out. BE is almost always on discounted fares; I, S.
My fares are all domestic so we can now see where the weighting is.
__________________
NW Gold 88-94 Plat 95-09 3M MQM, DL DM, Marriott PP and Lifetime PL
hnewman is offline   Reply With Quote
Old Jan 25, 13, 5:09 am   #158
 
Join Date: May 2009
Location: STL
Programs: DL PM, United M+, Hilton Gold, SPG Gold
Posts: 1,155
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"

Last edited by timmy83; Jan 25, 13 at 5:41 am..
timmy83 is offline   Reply With Quote
Old Jan 25, 13, 5:11 am   #159
 
Join Date: Jun 2008
Location: ATL
Programs: DL:DM, Marriott:PP/LTP, Hilton:G, NatCar:EE+, Hertz:PC
Posts: 4,593
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.
CJKatl is offline   Reply With Quote
Old Jan 25, 13, 5:16 am   #160
 
Join Date: Oct 2011
Location: ATL
Programs: DL DM 1.7MM
Posts: 118
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!
cmaas is offline   Reply With Quote
Old Jan 25, 13, 5:46 am   #161
 
Join Date: Apr 2003
Location: Seattle, WA
Programs: DL PM, SPG Plat, National EC Exec
Posts: 258
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"
doubleA is offline   Reply With Quote
Old Jan 25, 13, 5:48 am   #162
 
Join Date: Jun 2011
Location: AL
Programs: All of the Above
Posts: 1,205
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, 13 at 7:43 am..
DavidAL is online now   Reply With Quote
Old Jan 25, 13, 5:54 am   #163
 
Join Date: May 2009
Location: STL
Programs: DL PM, United M+, Hilton Gold, SPG Gold
Posts: 1,155
Quote:
Originally Posted by doubleA View Post
Not sure how to parse this one:
,"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)
timmy83 is offline   Reply With Quote
Old Jan 25, 13, 5:58 am   #164
 
Join Date: Dec 2002
Location: Washington, DC
Programs: DL Diam MM, former NW Plat, HH Gold, PC Gold, Marriott Gold, Hyatt Plat
Posts: 3,458
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
__________________

It is good to have an end to journey towards, but it is the journey that matters in the end.
--Ursula K. LeGuin
mot29 is offline   Reply With Quote
Old Jan 25, 13, 6:03 am   #165
 
Join Date: Jan 2000
Location: ATL - DL DM/2.2MM - HH Diamond - Marriott Gold -*wood Plat
Posts: 2,476
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?

Last edited by Tomphot; Jan 25, 13 at 6:12 am..
Tomphot 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 9:46 am.




SEO by vBSEO ©2011, Crawlability, Inc.