Jun 12, 2013, 7:24 pm
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
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
Delta and new DL.com Profiles A Lot About You
Jan 24, 2013, 10:34 pm
#61
Join Date: Dec 2011
Programs: DL DM PM
Posts: 2,033
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?
Jan 24, 2013, 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,240
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?
custValSeg":"0",
Jan 24, 2013, 10:41 pm
#64
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,418
Anyone know what these mean:
"actvtyPref":
"bcInd":
"chldAgeRange":
"isPwmElig":
"isSmCust":
"mindsetSeg":
"poCd":
"skyClubFtrCntrctInd":
"smAmexCntrnInd":
"smAmexInd":
"smSunTrstInd":
"stProvCd":
"actvtyPref":
"bcInd":
"chldAgeRange":
"isPwmElig":
"isSmCust":
"mindsetSeg":
"poCd":
"skyClubFtrCntrctInd":
"smAmexCntrnInd":
"smAmexInd":
"smSunTrstInd":
"stProvCd":
Jan 24, 2013, 10:43 pm
#66
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,256
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.
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.
Jan 24, 2013, 10:45 pm
#67
Join Date: Jul 2010
Location: MKE
Programs: DL-MM-Diamond HH-Diamond
Posts: 3,218
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":
"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":
Jan 24, 2013, 10:45 pm
#68
Join Date: Apr 2010
Location: NYC / Chelsea
Programs: Delta, Avios, Chase
Posts: 1,099
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.
Jan 24, 2013, 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,240
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
"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
Discretionary Spending as assumed by an algorithm (likely from the ad sales partner)
Jan 24, 2013, 10:45 pm
#70
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,256
Jan 24, 2013, 10:46 pm
#71
Join Date: Jan 2011
Location: DFW...at the moment
Programs: AA EXP, SPG Plat, Hyatt Diamond, HH gold
Posts: 609
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.
"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.
Jan 24, 2013, 10:48 pm
#72
Join Date: Jul 2010
Location: MKE
Programs: DL-MM-Diamond HH-Diamond
Posts: 3,218
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
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
Jan 24, 2013, 10:50 pm
#74
Join Date: Apr 2001
Location: Indianapolis, IN USA
Posts: 2,065
"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)
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)
Jan 24, 2013, 10:52 pm
#75
Join Date: Jan 2008
Location: SLC
Programs: DL PM, Hilton/Marriott Gold
Posts: 971
