Go Back  FlyerTalk Forums > Miles&Points > Airlines and Mileage Programs > Delta Air Lines | SkyMiles
Reload this Page >

Delta and new DL.com Profiles A Lot About You

Register
Community
Wiki Posts
Today's Posts
Search
Old Jun 12, 2013, 7:24 pm
FlyerTalk Forums Expert How-Tos and Guides
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

Delta and new DL.com Profiles A Lot About You

Thread Tools
 
Search this Thread
 
Old Jan 24, 2013, 11:09 pm
  #91  
 
Join Date: Jan 2011
Location: DFW...at the moment
Programs: AA EXP, SPG Plat, Hyatt Diamond, HH gold
Posts: 609
Originally Posted by Vuelos
Mindset is the big question here....

And you would be a 27.
The custValSeg makes sense to me, and I can understand why I am only a "2" (>50% of my MQM last year were on partners) while a PM family member is "11" (probably quintuple my spending on DL). Funny that my FO mother is a "1", when I spent many times as much on DL last year and she doesn't have an Amex.

That mindset code will drive me crazy until somebody cracks it.
Zomba is offline  
Reply
Old Jan 24, 2013, 11:10 pm
  #92  
 
Join Date: Sep 2007
Location: SJC/SFO
Programs: DL DM MM (fmr NW Plat), BA GGL/CCR, Aegean Gold, WorldClubs Life, SPG Plat, Hyatt Plat, HHonors Dmnd
Posts: 1,409
Here's a listing of Experian mosaic codes... but it doesn't include O which is my code

http://www.experian.com/assets/marke...mosaic-usa.pdf
ifette is offline  
Reply
Old Jan 24, 2013, 11:10 pm
  #93  
 
Join Date: Apr 2001
Location: Indianapolis, IN USA
Posts: 2,066
Originally Posted by ifette
Also, for what it's worth I'm tagged as

"mosaicCd":"O54"

no idea.
Striving Single Scene 1.29%
bowdenj is offline  
Reply
Old Jan 24, 2013, 11:13 pm
  #94  
 
Join Date: Sep 2007
Location: SJC/SFO
Programs: DL DM MM (fmr NW Plat), BA GGL/CCR, Aegean Gold, WorldClubs Life, SPG Plat, Hyatt Plat, HHonors Dmnd
Posts: 1,409
Nevermind, apparently it's been updated. Here's an up to date list.

http://www.experian.com/assets/marke...c-brochure.pdf

O54 is "striving single scene". hah, damn, they do know too much about me. I will fix the single part hopefully...
ifette is offline  
Reply
Old Jan 24, 2013, 11:13 pm
  #95  
 
Join Date: Feb 2008
Location: CMH
Programs: Delta Gold Medallion
Posts: 628
Originally Posted by ifette
Here's a listing of Experian mosaic codes... but it doesn't include O which is my code

http://www.experian.com/assets/marke...mosaic-usa.pdf
Here's a full list, including descriptors of the Experian Mosaic codes.
n301dp is offline  
Reply
Old Jan 24, 2013, 11:13 pm
  #96  
FlyerTalk Evangelist
 
Join Date: Apr 2009
Location: Bye Delta
Programs: AA EXP, HH Diamond, IHG Plat, Hyatt Plat, Marriott Plat, Nat'l Exec Elite, Avis Presidents Club
Posts: 16,273
Originally Posted by ifette
Here's a listing of Experian mosaic codes... but it doesn't include O which is my code

http://www.experian.com/assets/marke...mosaic-usa.pdf
http://classic.demographicsnow.com/A.../MosaicUSA.htm
javabytes is offline  
Reply
Old Jan 24, 2013, 11:17 pm
  #97  
FlyerTalk Evangelist & Ambassador: China
 
Join Date: Aug 2005
Location: DEN
Programs: DL DM/MM, UA 1K, AA Exp, HH Dia, WOH Glob, IHG Plat, Marriott Gold, NA EE, Hertz PC
Posts: 17,421
Originally Posted by bowdenj
Although some google searches bring up some items but not much. (p.s. impressed how quickly this thread is already indexed on google.com).
+1. And I vote this one of the most fun threads on the DL forum for 2013. This one for sure is going to hit the Talkmail!
mnredfox is offline  
Reply
Old Jan 24, 2013, 11:17 pm
  #98  
 
Join Date: Jul 2010
Location: MKE
Programs: DL-MM-Diamond HH-Diamond
Posts: 3,218
it seems there are only 4 mindset codes so far DW, FL, SS and GT

I want to crack this before Delta discovers this in the morning. You know they will be logging in first thing
MR_MAMA is offline  
Reply
Old Jan 24, 2013, 11:18 pm
  #99  
 
Join Date: Feb 2011
Programs: UA 1K, Delta Plat
Posts: 92
Originally Posted by amejr999
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?
Yes, you are entitled to the data...but it is your Experian credit report. The segmentation models and model results are not subject to the FCRA. You have a right to free access to the data annually from annualcreditreport.com. If Amex/Delta were to make a decision to deny you credit (credit limit or product) based on this data, the FRCA applies.

My guess is that if one were to opt out of affiliate sharing with Amex, Delta would not be able to get most of the financial information. Has anyone done this? Is the Mosaic field empty?
DL0620 is offline  
Reply
Old Jan 24, 2013, 11:19 pm
  #100  
FlyerTalk Evangelist & Ambassador: China
 
Join Date: Aug 2005
Location: DEN
Programs: DL DM/MM, UA 1K, AA Exp, HH Dia, WOH Glob, IHG Plat, Marriott Gold, NA EE, Hertz PC
Posts: 17,421
Originally Posted by MR_MAMA
it seems there are only 4 mindset codes so far DW, FL, SS and GT

I want to crack this before Delta discovers this in the morning. You know they will be logging in first thing
I got SS as well.
mnredfox is offline  
Reply
Old Jan 24, 2013, 11:20 pm
  #101  
 
Join Date: Apr 2001
Location: Indianapolis, IN USA
Posts: 2,066
So its 112a EST on a Thursday night / Friday morning in Atlanta.

Any thoughts on if anyone from delta.com IT staff have been alerted to this thread (94 replies in 2 hours) yet?

What's Delta's response? Someone from delta.com going to have a conference call 01/25/13 at 800a to discuss this??

This morning (Friday) - does this website ( https://www.delta.com/databroker/bcdata.action ) suddenly get disabled / removed from delta.com?

I also see some twitter messages have already been sent on this topic.

I bet its going to be an interesting Friday morning at the delta.com office!
bowdenj is offline  
Reply
Old Jan 24, 2013, 11:20 pm
  #102  
A FlyerTalk Posting Legend
 
Join Date: Sep 2009
Location: Minneapolis: DL DM charter 2.3MM
Programs: A3*Gold, SPG Plat, HyattDiamond, MarriottPP, LHW exAccess, ICI, Raffles Amb, NW PE MM, TWA Gold MM
Posts: 100,404
Originally Posted by ifette
Also, for what it's worth I'm tagged as

"mosaicCd":"O54"

no idea.
O54 = striving single scene
MSPeconomist is offline  
Reply
Old Jan 24, 2013, 11:22 pm
  #103  
 
Join Date: May 2006
Location: Moscow
Programs: DL GM and so on
Posts: 1,200
Originally Posted by MR_MAMA
it seems there are only 4 mindset codes so far DW, FL, SS and GT
Here's another one: IN (international?)
paulmoscow is offline  
Reply
Old Jan 24, 2013, 11:25 pm
  #104  
 
Join Date: Jul 2010
Location: MKE
Programs: DL-MM-Diamond HH-Diamond
Posts: 3,218
WTH why are people tweeting about this really?? geez and its not a website. It is a secure file that is only seen by YOU when YOU login. no one else
MR_MAMA is offline  
Reply
Old Jan 24, 2013, 11:25 pm
  #105  
 
Join Date: Jan 2011
Location: DFW...at the moment
Programs: AA EXP, SPG Plat, Hyatt Diamond, HH gold
Posts: 609
GT - I live overseas and fly mostly TPAC. Global Traveler? Gin and Tonic drinker?
SS - ??
FL - They've apparantly identified my mom as a future Florida bluehair
DW - ??
IN - ??
Zomba is offline  
Reply



Advanced Search
Reply Closed Thread Share
Forum Jump

Contact Us - Manage Preferences - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.