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
Jun 12, 2013, 10:05 pm
#766
Join Date: Jan 2013
Location: SLC
Programs: Delta Diamond, Marriott Platinum, Avis FIRST
Posts: 43
Anybody else get an inaccurate v22?
Mine shows HNH, which I translated to L42 (Rooted Flower Power). That demographic on Experian shows mid-scale baby boomer singles and couples established in suburban communities and approaching retirement.
Actually, I'm a 31yr old guy that's moved 4 times in the past four years and no where near approaching retirement. Guess that's advertising doesn't work on me I guess.
Mine shows HNH, which I translated to L42 (Rooted Flower Power). That demographic on Experian shows mid-scale baby boomer singles and couples established in suburban communities and approaching retirement.
Actually, I'm a 31yr old guy that's moved 4 times in the past four years and no where near approaching retirement. Guess that's advertising doesn't work on me I guess.
Jun 12, 2013, 10:05 pm
#767
FlyerTalk Evangelist
Join Date: Oct 2011
Location: Anywhere I need to be.
Programs: OW Emerald, *A Gold, NEXUS, GE, ABTC/APEC, South Korea SES, eIACS, PP, Hyatt Diamond
Posts: 16,046
Jun 12, 2013, 10:08 pm
#768
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,393
On the Mosaic categories, a lot of us have EPsomething, which should translate as O3something, but on the experian chart, one sees only O5somethings, namely O50 through O55.
Jun 12, 2013, 10:10 pm
#769
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,393
I have also figured out "NORZ" and "NORL" for v25. Using key 1, these become "SHRG" and "SHRP", respectively. These in turn represent Starwood Hotels & Resorts Gold and Starwood Hotels & Resorts Platinum, respectively. Presumably this will only appear for people who have set up SPG Crossover Rewards.
Jun 12, 2013, 10:11 pm
#770
FlyerTalk Evangelist
Join Date: Oct 2011
Location: Anywhere I need to be.
Programs: OW Emerald, *A Gold, NEXUS, GE, ABTC/APEC, South Korea SES, eIACS, PP, Hyatt Diamond
Posts: 16,046
They got mine totally wrong-K37.
'Without children, these households have plenty of discretionary income to spend on the latest fashions and consumer electronics - and spend they do. Fans of
conspicuous consumption, they like to buy designer fashion at department stores such as Nordstrom and Macy's. '
I won't waste money on clothes-I would estimate that I spend $100USD MAX on clothes every year.
As for electronics I have only purchased a new phone and a TV that I resold in order to earn (tax free) interest.
(Unless of course parallel trading counts in which case I have purchased thousands of dollars, for immediate resale.)
'Without children, these households have plenty of discretionary income to spend on the latest fashions and consumer electronics - and spend they do. Fans of
conspicuous consumption, they like to buy designer fashion at department stores such as Nordstrom and Macy's. '
I won't waste money on clothes-I would estimate that I spend $100USD MAX on clothes every year.
As for electronics I have only purchased a new phone and a TV that I resold in order to earn (tax free) interest.
(Unless of course parallel trading counts in which case I have purchased thousands of dollars, for immediate resale.)
Jun 12, 2013, 10:11 pm
#771
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
Absolutely - K40 Bohemian Groove - I am divorced (I am NOT)- I have low income (err I do not think so), I drive a modest car (true). I have a low education (total mile off I have a Masters with Distinction and two seperate Bachelor degrees and prof qualifications too). I sit in my apartment listening to music (FALSE), I do not take to new technology and am not internet savvy (Technology and Science are my business). All wrong
Jun 12, 2013, 10:11 pm
#772
FlyerTalk Evangelist
Join Date: Oct 2011
Location: Anywhere I need to be.
Programs: OW Emerald, *A Gold, NEXUS, GE, ABTC/APEC, South Korea SES, eIACS, PP, Hyatt Diamond
Posts: 16,046
Jun 12, 2013, 10:13 pm
#774
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001
Jun 12, 2013, 10:14 pm
#775
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,393
Jun 12, 2013, 10:16 pm
#776
FlyerTalk Evangelist
Join Date: Oct 2011
Location: Anywhere I need to be.
Programs: OW Emerald, *A Gold, NEXUS, GE, ABTC/APEC, South Korea SES, eIACS, PP, Hyatt Diamond
Posts: 16,046
Displays a value, yes.
Describes you, absolutely not.
'advocating recycling and demanding that companies act ethically'
Not true.
'With many still in the dating scene, they patronize
bars, nightclubs and casual restaurants such as Chili's and TGI Friday's.'
Not true either-I usually like preparing my own meals and/or buying cheap Groupons/Groupbuyer meals.
Not true either.
Certain parts are, though, like
'In fact, the only time they are accessible to advertisers is
when they can't escape them: at a bus shelter or train platform.'
'They travel frequently for business and pleasure'
Describes you, absolutely not.
'advocating recycling and demanding that companies act ethically'
Not true.
'With many still in the dating scene, they patronize
bars, nightclubs and casual restaurants such as Chili's and TGI Friday's.'
Not true either-I usually like preparing my own meals and/or buying cheap Groupons/Groupbuyer meals.
Not true either.
Certain parts are, though, like
'In fact, the only time they are accessible to advertisers is
when they can't escape them: at a bus shelter or train platform.'
'They travel frequently for business and pleasure'
Jun 12, 2013, 10:16 pm
#777
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001
Jun 12, 2013, 10:28 pm
#779
Join Date: Nov 2010
Location: BDL/HPN/JFK/FLL
Programs: DL Diamond Ham Sandwich
Posts: 1,051
"v06":"XX", 2 digit amount that is too low if in thousands for overall discretionary, at least 50% high for DL spend though.
"v15":"XX", Number off by more than an order of magnitude if in $k
"v16":"XXX", Number about 10x v15
"v18":"XXX", Close to home value in $k
"v22":"YKN", ROFLMAO About as close as the income! ("Autumn Years - Aging in place")
"v25":"IKBD,NORT", DL Reserve?
"v30":"3", I suck, owell.
FWIW 30s, unmarried, mix of cheapest fares (range up to B) for work, and usually -UP fares for personal travel.
So while they get all the data I explicitly have told them correct, most of the rest is horribly horribly wrong. (Zillow = close, Experian = smoking something)
"v15":"XX", Number off by more than an order of magnitude if in $k
"v16":"XXX", Number about 10x v15
"v18":"XXX", Close to home value in $k
"v22":"YKN", ROFLMAO About as close as the income! ("Autumn Years - Aging in place")
"v25":"IKBD,NORT", DL Reserve?
"v30":"3", I suck, owell.
FWIW 30s, unmarried, mix of cheapest fares (range up to B) for work, and usually -UP fares for personal travel.
So while they get all the data I explicitly have told them correct, most of the rest is horribly horribly wrong. (Zillow = close, Experian = smoking something)
Jun 12, 2013, 10:31 pm
#780
Join Date: Jan 2010
Programs: DL PM, UA Gold
Posts: 363
Anybody else get an inaccurate v22?
Mine shows HNH, which I translated to L42 (Rooted Flower Power). That demographic on Experian shows mid-scale baby boomer singles and couples established in suburban communities and approaching retirement.
Actually, I'm a 31yr old guy that's moved 4 times in the past four years and no where near approaching retirement. Guess that's advertising doesn't work on me I guess.
Mine shows HNH, which I translated to L42 (Rooted Flower Power). That demographic on Experian shows mid-scale baby boomer singles and couples established in suburban communities and approaching retirement.
Actually, I'm a 31yr old guy that's moved 4 times in the past four years and no where near approaching retirement. Guess that's advertising doesn't work on me I guess.