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, 9:40 pm
#752
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
Jun 12, 2013, 9:45 pm
#753
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001
I have completed decoding v22. Here's how it works, using "v22":"VER" as an example.
Step 1: Use Key 1 to convert "V" to "D"
Step 2: Use Key 3 to convert "ER" to "16"
Step 3: Combine the two results above ("D" and "16") to form your Mosaic segment: D16
Step 4: Determine your Mosaic segment name using Experian's explanation document: http://www.experian.com/assets/marke...c-brochure.pdf (pages 6-7). D16 = "Settled in Suburbia".
Step 1: Use Key 1 to convert "V" to "D"
Step 2: Use Key 3 to convert "ER" to "16"
Step 3: Combine the two results above ("D" and "16") to form your Mosaic segment: D16
Step 4: Determine your Mosaic segment name using Experian's explanation document: http://www.experian.com/assets/marke...c-brochure.pdf (pages 6-7). D16 = "Settled in Suburbia".
Jun 12, 2013, 9:49 pm
#754
Join Date: Apr 2009
Location: RDU
Programs: AA, EXP. DL, DM 1MM. HHonors, Diamond. Hertz, PC. National, EE.
Posts: 259
Jun 12, 2013, 9:51 pm
#755
Join Date: Nov 2012
Location: ATL
Programs: Bonvoy Ambassador, Hyatt Globalist, Hilton Gold, AA EXP, UA Silver, former DL DM
Posts: 2,001
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, 9:51 pm
#756
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
I have completed decoding v22. Here's how it works, using "v22":"VER" as an example.
Step 1: Use Key 1 to convert "V" to "D"
Step 2: Use Key 3 to convert "ER" to "16"
Step 3: Combine the two results above ("D" and "16") to form your Mosaic segment: D16
Step 4: Determine your Mosaic segment name using Experian's explanation document: http://www.experian.com/assets/marke...c-brochure.pdf (pages 6-7). D16 = "Settled in Suburbia".
Step 1: Use Key 1 to convert "V" to "D"
Step 2: Use Key 3 to convert "ER" to "16"
Step 3: Combine the two results above ("D" and "16") to form your Mosaic segment: D16
Step 4: Determine your Mosaic segment name using Experian's explanation document: http://www.experian.com/assets/marke...c-brochure.pdf (pages 6-7). D16 = "Settled in Suburbia".
Here's a page where you can read a nice long PDF describing your segment in detail.
http://classic.demographicsnow.com/A...FMosaicUSA.htm
Jun 12, 2013, 9:52 pm
#757
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
I have completed decoding v22. Here's how it works, using "v22":"VER" as an example.
Step 1: Use Key 1 to convert "V" to "D"
Step 2: Use Key 3 to convert "ER" to "16"
Step 3: Combine the two results above ("D" and "16") to form your Mosaic segment: D16
Step 4: Determine your Mosaic segment name using Experian's explanation document: http://www.experian.com/assets/marke...c-brochure.pdf (pages 6-7). D16 = "Settled in Suburbia".
Step 1: Use Key 1 to convert "V" to "D"
Step 2: Use Key 3 to convert "ER" to "16"
Step 3: Combine the two results above ("D" and "16") to form your Mosaic segment: D16
Step 4: Determine your Mosaic segment name using Experian's explanation document: http://www.experian.com/assets/marke...c-brochure.pdf (pages 6-7). D16 = "Settled in Suburbia".
Then I read this http://classic.demographicsnow.com/T...n%20Groove.PDF
and it is an absolute total freakin mile off - oh well
Last edited by GRALISTAIR; Jun 12, 2013 at 9:58 pm
Jun 12, 2013, 9:53 pm
#758
Join Date: Mar 2013
Location: PVU, SLC
Programs: DL Pork Medallion, PP, GE
Posts: 1,657
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, 9:53 pm
#759
FlyerTalk Evangelist
Join Date: Jun 2004
Location: MSP
Programs: DL PM, MM, NR; HH Diamond, Bonvoy LT Gold, Hyatt Explorist, IHG Diamond, others
Posts: 12,159
Jun 12, 2013, 9:53 pm
#760
Join Date: Aug 2008
Location: MCO
Programs: DL-DM/1MM, HILTON-DIA, .HYATT-DIA/GLOB , IHG-PLT,HERTZ 5*, NATIONAL ES
Posts: 8,691
I have completed decoding v22. Here's how it works, using "v22":"VER" as an example.
Step 1: Use Key 1 to convert "V" to "D"
Step 2: Use Key 3 to convert "ER" to "16"
Step 3: Combine the two results above ("D" and "16") to form your Mosaic segment: D16
Step 4: Determine your Mosaic segment name using Experian's explanation document: http://www.experian.com/assets/marke...c-brochure.pdf (pages 6-7). D16 = "Settled in Suburbia".
Step 1: Use Key 1 to convert "V" to "D"
Step 2: Use Key 3 to convert "ER" to "16"
Step 3: Combine the two results above ("D" and "16") to form your Mosaic segment: D16
Step 4: Determine your Mosaic segment name using Experian's explanation document: http://www.experian.com/assets/marke...c-brochure.pdf (pages 6-7). D16 = "Settled in Suburbia".
Jun 12, 2013, 9:54 pm
#761
Join Date: Jan 2010
Programs: DL PM, UA Gold
Posts: 363
I have completed decoding v22. Here's how it works, using "v22":"VER" as an example.
Step 1: Use Key 1 to convert "V" to "D"
Step 2: Use Key 3 to convert "ER" to "16"
Step 3: Combine the two results above ("D" and "16") to form your Mosaic segment: D16
Step 4: Determine your Mosaic segment name using Experian's explanation document: http://www.experian.com/assets/marke...c-brochure.pdf (pages 6-7). D16 = "Settled in Suburbia".
Step 1: Use Key 1 to convert "V" to "D"
Step 2: Use Key 3 to convert "ER" to "16"
Step 3: Combine the two results above ("D" and "16") to form your Mosaic segment: D16
Step 4: Determine your Mosaic segment name using Experian's explanation document: http://www.experian.com/assets/marke...c-brochure.pdf (pages 6-7). D16 = "Settled in Suburbia".
Jun 12, 2013, 10:02 pm
#762
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
Could a few more people post their v22? I just need a couple more data points to complete the key. So far I have the following:
CHH
EPB
EPE
EPN
EPK
FEX
IBE
IBR
MKV
MNB
ZHP
EDITED: Decoding complete! See http://www.flyertalk.com/forum/delta...l#post20913445 for explanation.
CHH
EPB
EPE
EPN
EPK
FEX
IBE
IBR
MKV
MNB
ZHP
EDITED: Decoding complete! See http://www.flyertalk.com/forum/delta...l#post20913445 for explanation.
Jun 12, 2013, 10:03 pm
#763
FlyerTalk Evangelist
Join Date: May 2008
Location: CHA, MAN;
Programs: Delta DM 1 MM; Hz PC
Posts: 11,169
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:04 pm
#764
In memoriam, FlyerTalk Evangelist
Join Date: May 2005
Location: PIT
Programs: DM life is over 2MM PM now & NW MillionAir Wyndham Rewards Plat -Hotels.com Silver -Accor Silver
Posts: 15,408
NRX = S69 . . . .
Mostly true . . . . but, "GAMING"?????
Fun stuff! Thanx, LaMont!
Mostly true . . . . but, "GAMING"?????
Fun stuff! Thanx, LaMont!
Jun 12, 2013, 10:04 pm
#765
Join Date: Sep 2010
Location: Summit County UT
Programs: Delta PM Hilton Diamond Bonvoy Ti/LTP Hertz PC
Posts: 636
Great job! They put me at G25, which fits in many ways, though A05 probably fits me best of all the codes. They share a lot of qualitative similarities, just separated by expected age, income, and relationship status. Not surprising DL put me at G25 instead of A05 given that their v15 idea of my income is probably what I reported on my first credit card application 16 years ago -- and in those intervening 16 years I have also become older and less single!