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:34 pm   #61
 
Join Date: Dec 2011
Programs: DL DM
Posts: 922
Quote:
Originally Posted by jrkmsp View Post
Wow. My mosaic code of 051 makes me a digital dependent. That couldn't be any more true. Though it gave my wife the same code and she, is not. They have a lot less data on her, though.
They got me totally wrong. C11: aging of aquarius:

Upscale boomer-aged couples living in city and close-in suburbs
2.34% 3.26%


which is weird because they *know* I'm younger than that! And 50% of the characteristics are totally wrong, with a couple more a bit dubious.

Still I have a custvalseg of 6 which is ... good?
NotHamSarnie is offline   Reply With Quote
Old Jan 24, 13, 10:36 pm   #62
 
Join Date: Apr 2001
Location: Indianapolis, IN USA
Posts: 1,819
Haven't cracked:

1. "custValSeg"
2. "mindsetSeg"

Although some google searches bring up some items but not much. (p.s. impressed how quickly this thread is already indexed on google.com).
bowdenj is offline   Reply With Quote
Old Jan 24, 13, 10:40 pm   #63
 
Join Date: Dec 2005
Location: Likely being followed...
Programs: DYKWIA Extraordinaire. TrollSlayer Mega Diamond. [insert esoteric sounding status level(s) here]
Posts: 5,162
Quote:
Originally Posted by amejr999 View Post
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?
My strong assumption is that this is from DL:
custValSeg":"0",
__________________
Loyalty Programs Should Be Loyal.
Why do you stick with Delta?
Vuelos is offline   Reply With Quote
Old Jan 24, 13, 10:41 pm   #64
FlyerTalk Evangelist & Ambassador: China
 
Join Date: Aug 2005
Location: MSP/PVG/SFO
Programs: DL KM, HH Diamond, IC Amb, Hyatt Diamond, NA EE
Posts: 15,114
Anyone know what these mean:

"actvtyPref":
"bcInd":
"chldAgeRange":
"isPwmElig":
"isSmCust":
"mindsetSeg":
"poCd":
"skyClubFtrCntrctInd":
"smAmexCntrnInd":
"smAmexInd":
"smSunTrstInd":
"stProvCd":
mnredfox is online now   Reply With Quote
Old Jan 24, 13, 10:41 pm   #65
 
Join Date: Nov 2007
Location: "Nowhere!!!" your honor my client is in the witness protection program.
Programs: Spoiled by Skywards
Posts: 1,307
I found my personal "incomeAmt": to be concurrent with what I answer on all surveys as my fictional number, wonder if that's where they arrived at that number.
Ysitincoach is offline   Reply With Quote
Old Jan 24, 13, 10:43 pm   #66
FlyerTalk Evangelist
 
Join Date: Apr 2009
Location: Anywhere I can hide from Delta's "enhancements"
Programs: DL PM Kryptonium Ham Sandwich GAMER, UA Plat, US, PC Plat, IHG Amb., SPG Gold, HH Gold, Nat'l Exec
Posts: 10,900
This is laughable. Income... wrong. Home value amount... wrong. Mosaic... wrong.

No idea what discSpndngAmt is, but I'm sure it's not what I spent on DL. I would venture a guess that it comes from AmEx.
__________________
SkyMiles Devaluation Alert: RTW Awards Killed Effective 1/1/2015. See: http://www.flyertalk.com/forum/delta...oing-away.html
javabytes is offline   Reply With Quote
Old Jan 24, 13, 10:45 pm   #67
 
Join Date: Jul 2010
Location: MKE
Programs: DL-MM-Diamond HH-Diamond
Posts: 3,215
Quote:
Originally Posted by mnredfox View Post
Anyone know what these mean:

"actvtyPref":
"bcInd":
"chldAgeRange": how old are you kids
"isPwmElig": pay with miles
"isSmCust": skymiles customer
"mindsetSeg":
"poCd":
"skyClubFtrCntrctInd":
"smAmexCntrnInd": centurian
"smAmexInd": skymiles amex?
"smSunTrstInd": suntrust card
"stProvCd":
state
MR_MAMA is offline   Reply With Quote
Old Jan 24, 13, 10:45 pm   #68
 
Join Date: Apr 2010
Location: NYC / Chelsea
Programs: Delta Platinum
Posts: 1,094
Delta, thank you for identifying me as a G25: Younger, up-and-coming singles living big city lifestyles located within top CBSA markets. That is right - I'm a Young City Solo and proud of it.
__________________
ready for Hillary in 2016!
dgxoxo is offline   Reply With Quote
Old Jan 24, 13, 10:45 pm   #69
 
Join Date: Dec 2005
Location: Likely being followed...
Programs: DYKWIA Extraordinaire. TrollSlayer Mega Diamond. [insert esoteric sounding status level(s) here]
Posts: 5,162
Quote:
Originally Posted by mnredfox View Post
Anyone know what these mean:

"actvtyPref":
"bcInd":
"chldAgeRange": --> Age of your kids
"isPwmElig": --> Pay with Miles Eligible
"isSmCust": --> Is a Skymiles customer
"mindsetSeg": --> Some sort of Experian thing
"poCd":
"skyClubFtrCntrctInd": --> Do you have a SkyClub Membership
"smAmexCntrnInd":
"smAmexInd":
"smSunTrstInd": --> Do you have a Suntrust Card
"stProvCd": State / Province
Some of them are easily answered.

Quote:
Originally Posted by javabytes View Post
This is laughable. Income... wrong. Home value amount... wrong. Mosaic... wrong.

No idea what discSpndngAmt is, but I'm sure it's not what I spent on DL. I would venture a guess that it comes from AmEx.
Discretionary Spending as assumed by an algorithm (likely from the ad sales partner)
__________________
Loyalty Programs Should Be Loyal.
Why do you stick with Delta?
Vuelos is offline   Reply With Quote
Old Jan 24, 13, 10:45 pm   #70
FlyerTalk Evangelist
 
Join Date: Apr 2009
Location: Anywhere I can hide from Delta's "enhancements"
Programs: DL PM Kryptonium Ham Sandwich GAMER, UA Plat, US, PC Plat, IHG Amb., SPG Gold, HH Gold, Nat'l Exec
Posts: 10,900
Quote:
Originally Posted by mnredfox View Post
Anyone know what these mean:

"chldAgeRange": Your childrens' age range
"isPwmElig": Is Pay With Miles eligible
"isSmCust": Is SkyMiles customer
"poCd": Postal Code
"smAmexCntrnInd": (Guessing) AmEx Centurion Cardmember
"stProvCd": State/Province Code
__________________
SkyMiles Devaluation Alert: RTW Awards Killed Effective 1/1/2015. See: http://www.flyertalk.com/forum/delta...oing-away.html
javabytes is offline   Reply With Quote
Old Jan 24, 13, 10:46 pm   #71
 
Join Date: Jan 2011
Location: ORD, MCI, PVG
Programs: So many
Posts: 603
Well, certainly interesting. I checked on all 5 medallions in my family (Dad: PM, Me: DM, Mom: FO, Wife: GM gifted, Sis: FO).

"custValSeg": I'm a 2 as a DM, Dad's an 11 as a PM, Mom's a 1, sis and wife are "0"
"incomeAmt": shows as 250 for me, Dad, and Mom (all at one address); 250 for sis, "" for wife. If that is 250k, it is way high for me and sis, and way low for parents
"mosaicCd": A02 "Platinum Prosperity", WAY above my paygrade and my sister's. Fits somewhat for the parents (they should be A01). I wonder if this isn't primarily zip-code driven. I live overseas, but have my account address as my parents home.
"discSpndngAmt": 54003 for dad, mom, sis and me. Don't know what that number represents.
"mindsetSeg": No idea what this means. Sis is "DW", mom "FL", dad is "SS", I am "GT"

I wonder if the home value date comes from having a mortgage and/or mortgage payments. That would explain why my parents don't show as owning a home. Interesting that the whole biological family has the same spending amount.
Zomba is offline   Reply With Quote
Old Jan 24, 13, 10:48 pm   #72
 
Join Date: Jul 2010
Location: MKE
Programs: DL-MM-Diamond HH-Diamond
Posts: 3,215
mindset is not experianl Mosaic is.

I think it is how DL deals with you when you have issues

Mindset is
MINDset = Focus on the personís MINDsetótheir motivations, interest, needs and desires. (page 4) http://www.delta.com/content/dam/del...letter2012.pdf
MR_MAMA is offline   Reply With Quote
Old Jan 24, 13, 10:48 pm   #73
 
Join Date: Apr 2001
Location: Indianapolis, IN USA
Posts: 1,819
Duplicate
bowdenj is offline   Reply With Quote
Old Jan 24, 13, 10:50 pm   #74
 
Join Date: Apr 2001
Location: Indianapolis, IN USA
Posts: 1,819
Quote:
Originally Posted by mnredfox View Post
Anyone know what these mean:
"chldAgeRange":
Looks like its child age range.
"poCd":
At least for USA its the long format zip code (i.e. 20500-0003)
"smAmexInd":
Yes/no field if the person has a Delta AMEX
"smSunTrstInd":
Yes/no field if the person has a SunTrust debit card.
"stProvCd":
At least for USA its the two digit state code (i.e DC)
bowdenj is offline   Reply With Quote
Old Jan 24, 13, 10:52 pm   #75
 
Join Date: Jan 2008
Location: From MCI, now living in DFW
Programs: AA cAAptive, DL GM, DL SC
Posts: 501
Quote:
Originally Posted by dgxoxo View Post
Delta, thank you for identifying me as a G25: Younger, up-and-coming singles living big city lifestyles located within top CBSA markets. That is right - I'm a Young City Solo and proud of it.
They have me pegged as a Q65, despite not being old enough to rent a car
captaink 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 5:08 am.